peewee

peewee

ORM框架，

Usage

pip install peewee

from peewee import SqliteDatabase
db = SqliteDatabase('my_database.db')


from peewee import Model, CharField, IntegerField

class Person(Model):
    name = CharField()
    age = IntegerField()

    class Meta:
        database = db  # 将模型与特定数据库连接关联


# 创建并插入新记录
person = Person.create(name='Alice', age=30)
# 或者
person = Person()
person.name = 'Bob'
person.age = 25
person.save()

# 查询所有记录
people = Person.select()
# 条件查询
young_people = Person.select().where(Person.age < 30)

# 更新记录
person = Person.get(Person.name == 'Alice')
person.age = 31
person.save()

# 删除记录
person = Person.get(Person.name == 'Bob')
person.delete_instance()


# 数据迁移
peewee migrations