初始化数据库并设计模型
class 模型名称(Model) -> 一个class就是一张表
from peewee import SqliteDatabase
from peewee import Model
from peewee import CharField,DateField,ForeignKeyField
db = SqliteDatabase('people.db')
class Person(Model):
name = CharField()
birthday = DateField()
class Meta:
database = db
设计两个表:Person和Pet
from peewee import SqliteDatabase
from peewee import Model
from peewee import CharField,DateField,ForeignKeyField
db = SqliteDatabase('people.db')
class Person(Model):
name = CharField()
birthday = DateField()
class Meta:
database = db
class Pet(Model):
owner = ForeignKeyField(Person,backref='pets')
name = CharField()
animal_type = CharField()
class Meta:
database = db
生成数据库文件
db.connect() -> 连接数据库
db.create_tables([类1, 类2, …]) -> 创建表
from peewee import SqliteDatabase
from peewee import Model
from peewee import CharField,DateField,ForeignKeyField
db = SqliteDatabase('people.db')
class Person(Model):
name = CharField()
birthday = DateField()
class Meta:
database = db
class Pet(Model):
owner = ForeignKeyField(Person,