peewee-seed 0.1.8

Description:

peeweeseed 0.1.8

# peewee_seedpeewee_seed is a seed library which provides initial data to database using peewee.With reference to the [Django fixture](https://docs.djangoproject.com/en/2.1/howto/initial-data/)[](https://circleci.com/gh/takehaya/peewee_seeds)[](https://badge.fury.io/py/peewee-seed)## usage### simple seeds- file envs```/myapp __init__.py seeds_entry.py models.py /fixtures accounts.yaml`````` yaml# accounts.yaml- model : myapp.models.Account id: 1 fields: first_name: John last_name: Smith age: 20``````python# models.pyfrom peewee import CharFieldfrom peewee import IntegerFieldfrom peewee import Modelfrom peewee import SqliteDatabasedatabase = SqliteDatabase(":memory:", pragmas={"foregin_keys": 1})class BaseModel(Model): class Meta(object): database = databaseclass Account(BaseModel): first_name = CharField(null=False) last_name = CharField(null=False) age = IntegerField(null=True)```- seeds entry file``` python# seeds_entry.pyfrom peewee_seeds import PeeweeSeedfrom myapp.models import databasedef main(): path = '/path/to/fixtures' # seeds instance seeds = PeeweeSeed(database, path, ['accounts.yaml']) # load fixture for create table seeds.create_table_all() # load fixture for db input seeds.db_data_input()if __name__ == '__main__': main()```- Run command```python seeds_entroy.py```### other example```pythonfrom peewee_seed import PeeweeSeedfrom myapp.models import database# seeds instanceseeds = PeeweeSeed()# set pathseeds.set_path('/path/to/fixtures')# set use fixture nameseeds.set_fixture_files(['accounts.yaml', 'pictures.yaml'])# loading fixture file datafixtures_row_data = seeds.load_fixture_files()# fixture purificationfields, models_namelist = seeds.load_fixture(fixtures_row_data[0])# fixtures purificationfields, models_namelist = seeds.load_fixtures(fixtures_row_data)# set database sessionseeds.set_database(database)# base on fixtures, create tablesseeds.create_table_all()# fixtures data to db inputseeds.db_data_input(fixtures_row_data)# base on fixtures, drop tables seeds.drop_table_all()```### direct inputdata seed``` python# body is dict data# create & seedseed = PeeweeSeed(db)_, models = seed.load_fixtures([body])seed.create_table_all(models)seed.db_data_input([body])# body is modelpath(same to fixtures)# dropseed = PeeweeSeed(db)models = body["models"]seed.drop_table_all(models)```#### error: Foreign key constraint```python# seedseed.db_data_input([body], foreign_key_checks=True)# db dropseed.drop_table_all(models, foreign_key_checks=True)```