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 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
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.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 89042a0fffa48894234b5d3cfe5fbefed341fcc5a97434b41363b1685a193ac4 |
|
MD5 | 06ea68752d4c49083964abc02854f62c |
|
BLAKE2b-256 | beb1d94a3759156d01672800f609637d59dc27fa168871419e0b1098d322547a |