🐙❄️ Spawnflake

Spawnflake generates random data and/or based on patterns for relational databases.

what's new (v0.2.3)

I dropped the Postgres implementation for the time being so I can get back to the project and focus in one database at a time. There is still a branch with the postgres implementation
Updated Syntax to be 1.66+ compatible

known limitations

In the cases of handling cyclic dependencies I am not currently updating the keys retrospectively. This is planned for a future version
if a foreign key is unique, less records will be inserted on that table (I do not support unique foreign key values yet)

support

db support
- mysql
supports the following types and functionality:

| Datastore | Data type | ----------- | ----------- | Mysql | varchar | Mysql | int | Mysql | unsigned int | Mysql | smallint | Mysql | unsigned smallint | Mysql | 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 | Random Data Generator | Pattern Based Generator | |----------- | ----------- | | ✔️ | ✔️ | | ✔️ | ✔️ | | ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | tinyint/unsigned tinyint | ✔️ | ❌ | | ✔️ | ❌ |
| ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | ✔️ | ❌ | | ❌ | ✔️ |

(+) works but not necessary with expected outcome

breaking changes

0.2.3 postgres no longer supported
0.2.0 was completely refactored, configuration stayed the same

deprecations

0.1.0 to 0.1.5 is going to be yanked

cli

a pre release version is available/ check cli/readme.md for usage

Running the example

Running the example requires to run docker-compose inside the test folder. Obviously you need * docker * an sql client/ or a way to access the mysql cli (so as to see the generated records) * cargo run --example generate_mysql

Contributing

You are more than welcome. All you need to do is a pull request