peewee是一个轻量级的pythoORM库。内建对SQLite、MySQL和PostgreSQL的支持。支持Pytho2.6+和Pytho3.2+。
pip安装：pipistallpeewee
示例代码：
from peewee import *db = SqliteDatabase('people.db')class Perso(Model): ame = CharField() birthday = DateField() is_relative = BooleaField() class Meta: database = db # This model uses the "people.db" database.>>> from datetime import date>>> ucle_bob = Perso(ame='Bob', birthday=date(1960, 1, 15), is_relative=True)>>> ucle_bob.save() # bob is ow stored i the database1>>> gradma = Perso.select().where(Perso.ame == 'Gradma L.').get()>>> gradma = Perso.get(Perso.ame == 'Gradma L.')>>> for perso i Perso.select():... prit perso.ame, perso.is_relative...Bob TrueGradma L. TrueHerb False高级用法：
import peeweefrom peewee import *db = MySQLDatabase('johydb', user='joh',passwd='megajohy')class Book(peewee.Model): author = peewee.CharField() title = peewee.TextField() class Meta: database = dbBook.create_table()book = Book(author="me", title='Peewee is cool')book.save()for book i Book.filter(author="me"): prit book.titlePeewee is cool
评论