Skip to content

Latest commit

 

History

History
54 lines (31 loc) · 1.34 KB

SchemaGen.md

File metadata and controls

54 lines (31 loc) · 1.34 KB

Schema generator CLI usage

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.)