peewee_sqlite_person_pet_models_with_crud_operations.py

1from peewee import *
2
3db = SqliteDatabase('people.db')
4
5class Person(Model):
6    name = CharField()
7    birthday = DateField()
8
9    class Meta:
10        database = db # This model uses the "people.db" database.
11
12class Pet(Model):
13    owner = ForeignKeyField(Person, backref='pets')
14    name = CharField()
15    animal_type = CharField()
16
17    class Meta:
18        database = db # this model uses the "people.db" database
19
20db.connect()
21db.create_tables([Person, Pet])
22
23from datetime import date
24uncle_bob = Person(name='Bob', birthday=date(1960, 1, 15))
25uncle_bob.save() # bob is now stored in the database
26
27# Returns 1 (the number of rows modified).
28# grandma = Person.create(name='Grandma', birthday=date(1935, 3, 1))
29
30# herb = Person.create(name='Herb', birthday=date(1950, 5, 5))
31# herb.name = 'Herbie'
32# herb.save()
33
34# bob_pet = Pet.create(owner=uncle_bob, name='Kitty', animal_type='cat')
35# herb_pet = Pet.create(owner=herb, name='Fido', animal_type='dog')