Schema generator CLI usage ========================== ```sh dbschemagen -d mysql -s test_db -z 1e9 -t 5 -- --escape-backslash > gen.sh sh gen.sh ``` Common options -------------- * `-d «DIALECT»`, `--dialect «DIALECT»` Choose the SQL dialect of the generated schema files. This mainly controls the data type names. * `-s «NAME»`, `--schema-name «NAME»` The qualified schema name. * `-z «SIZE»`, `--size «SIZE»` The estimated total size of the generated data file. * `-t «N»`, `--tables-count «N»` Number of tables to generate. Note that `dbschemagen` will *not* uniformly distribute the same size to every file; rather, they're assigned following to Lomax distribution to simulate the size of real-world databases. * `-- «args»...` Any extra arguments will be passed to the `dbgen` invocations. More options ------------ * `-n «N»`, `--inserts-count «N»` Number of INSERT statements per file. * `-r «N»`, `--rows-count «N»` Number of rows per INSERT statement. * `--seed «SEED»` Provide a 64-digit hex number to seed the random number generator, so that the output becomes reproducible. If not specified, the seed will be obtained from the system entropy. (Note: There is no guarantee that the same seed will produce the same output across major versions of `dbschemagen`.)