peewee.md

PEEWEE 简单而轻量级的orm

• github链接

• 官方文档

• 示例

  from peewee import * from playhouse.sqlite_ext import SqliteExtDatabase import datetime db = SqliteExtDatabase('test.db')

  class BaseModel(Model): class Meta: database = db

  class User(BaseModel): username = CharField(unique=True)

  class Tweet(BaseModel): user = ForeignKeyField(User, related_name='tweets') message = TextField() created_date = DateTimeField(default=datetime.datetime.now) is_published = BooleanField(default=True)

  db.connect() db.create_tables([User, Tweet])

  charlie = User.create(username='charlie') huey = User(username='huey') huey.save()

• 返回

Model

• get_or_create

• filter

  Model.filter(Model.name.contains('test'))

• delete_instance 删除数据