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.6-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7f2539fb62c519ab82b10e7d26118bd2a5c59f9f7f21f96347113c839d4ed92c |
|
MD5 | 722126b20b538da1ced73fdc03cc2e7d |
|
BLAKE2b-256 | f004418bd83a03eebf9012b299d2c22c69590a5a7e8441cae1fa5ea466bad237 |