Spawnflake 
Spawnflake is a schema agnostic, random and/or patterns based data generator, for MySQL databases.
what's new
See CHANGELOG for updates and new features.
known limitations
- When handling cyclic dependencies, keys are not currently updated retrospectively. This feature is planned for a future version
- If a foreign key is unique, fewer records will be inserted into that table. Unique foreign key values are not supported yet.
- In certain cases, number validation in the configuration is not performed, so the db can throw errors for out of range values.
support
Database support
MySQL
- supported data types and generators:
| Datastore | Data type | Random | Pattern |
|---|---|---|---|
| Mysql | varchar | ✔️ | ✔️ |
| Mysql | int | ✔️ | ✔️ |
| Mysql | unsigned int | ✔️ | ✔️ |
| Mysql | smallint | ✔️ | ✔️ |
| Mysql | unsigned smallint | ✔️ | ✔️ |
| Mysql | tinyint/unsigned tinyint | ✔️ | ✔️ |
| Mysql | mediumint | ✔️ | ✔️ |
| Mysql | bigint | ✔️ | ✔️ |
| Mysql | unsigned bigint | ✔️ | ✔️ |
| Mysql | decimal | ✔️ | ✔️ |
| Mysql | float | ✔️ | ✔️ |
| Mysql | double | ✔️ | ✔️ |
| Mysql | bit | ✔️ | ❌ |
| Mysql | time | ✔️ | ❌ |
| Mysql | timestamp | ✔️ | ❌ |
| Mysql | date | ✔️ | ❌ |
| Mysql | year | ✔️ | ❌ |
| Mysql | char | ✔️ | ❌ |
| Mysql | binary | ✔️ | ❌ |
| Mysql | text | ✔️ | ❌ |
| Mysql | longtext | ✔️ | ❌ |
| Mysql | blob/longblob | ✔️ | ❌ |
| Mysql | enum | ❌ | ✔️ |
CLI
The main project in this repository is a library, but there is also a CLI version available published in crates.io.
The code for the CLI is available at ./cli. Check README for usage and more information.
Running the example
Running the example requires running docker-compose inside the test folder. Make sure you have
- Docker
- An SQL client/ or a way to access the MySQL cli to view the generated records
To run the example execute
Contributing
You are more than welcome. All you need to do is a pull request