数据分析师：2.1peewee模块写入数据库

初始化数据库并设计模型
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,