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-2.0.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 67cc2f43e02c1d187224e04eaf0be897160f8ab5138a901273b8d4cf93ef4068 |
|
MD5 | 5f8da243ef44f9805368dc7bb129f8c5 |
|
BLAKE2b-256 | e826396a6e85cc5ab3580f4cdc5cec2779eb90b9c99c4cb74b4b479afcf42157 |