Tool for generating demo SQLite databases
Project description
sqlite-generate
Tool for generating demo SQLite databases
Installation
Install this plugin using pip
:
$ pip install sqlite-generate
Usage
To generate a SQLite database file called data.db
with 10 randomly named tables in it, run the following:
sqlite-generate data.db
You can see a demo of the database generated using this command running in Datasette at https://sqlite-generate-demo.datasette.io/
You can use the --tables
option to generate a different number of tables:
sqlite-generate data.db --tables 20
By default each table will contain a random number of rows between 0 and 200. You can customize this with the --rows
option:
sqlite-generate data.db --rows 20
This will insert 20 rows into each table.
sqlite-generate data.db --tables 500,2000
This inserts a random number of rows between 500 and 2000 into each table.
Each table will have 5 columns. You can change this using --columns
:
sqlite-generate data.db --columns 10
You can control the random number seed used with the --seed
option. This will result in the exact same database file being created by multiple runs of the tool:
sqlite-generate data.db --seed=myseed
By default each table will contain between 0 and 2 foreign key columns to other tables. You can control this using the --fks
option, with either a single number or a range:
sqlite-generate data.db --columns=20 --fks=5,15
Development
To contribute to this tool, first checkout the code. Then create a new virtual environment:
cd sqlite-generate
python -mvenv venv
source venv/bin/activate
Or if you are using pipenv
:
pipenv shell
Now install the dependencies and tests:
pip install -e '.[test]'
To run the tests:
pytest
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for sqlite_generate-0.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a30a30b3781d0d4c9643b4dc160de7d3c410faf692f7dae3bdd8284d749913bc |
|
MD5 | c2a7e62242b115da05452cd2bc737fbe |
|
BLAKE2b-256 | a4910b7c41ae0299b7cdc865a2a3a24b234b4d3a22d9e17f4975bcd60236ec56 |