SQLAlchemy Seeder
Project description
sqlalchemyseed
Sqlalchemy seeder that supports nested relationships.
Supported file types
- json
- yaml
- csv
Installation
Default installation
pip install sqlalchemyseed
Quickstart
main.py
from sqlalchemyseed import load_entities_from_json
from sqlalchemyseed import Seeder
from db import session
# load entities
entities = load_entities_from_json('data.json')
# Initializing Seeder
seeder = Seeder(session)
# Seeding
seeder.seed(entities)
# Committing
session.commit() # or seeder.session.commit()
data.json
{
"model": "models.Person",
"data": [
{
"name": "John March",
"age": 23
},
{
"name": "Juan Dela Cruz",
"age": 21
}
]
}
Documentation
https://sqlalchemyseed.readthedocs.io/
Found Bug?
Report here in this link: https://github.com/jedymatt/sqlalchemyseed/issues
Want to contribute?
First, Clone this repository.
Install dev dependencies
Inside the folder, paste this in the terminal to install necessary dependencies:
pip install -r requirements.txt -r docs/requirements.txt
Note: make sure you have the virtual environment and enabled, or if you are using vs code and docker then you can simply re-open this as container.
Run tests
Before running tests, make sure that the package is installed as editable:
python setup.py develop --user
Then run the test:
pytest tests
Run test with coverage
coverage run -m pytest
Autobuild documentation
sphinx-autobuild docs docs/_build/html
Project details
Release history Release notifications | RSS feed
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 sqlalchemyseed-1.0.7-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1d447779a9c1b31c8e55d3f1339e105325179e50345c1ac9767e5ffd03848368 |
|
MD5 | b02f954c2450c230c7c6c8723b577bbd |
|
BLAKE2b-256 | 676bf0f5460763b61a48e8998c20914fa07b93ef141b4b3f2028bef04bf87f1d |