peewee 轻量级的python ORM

peewee 是一个轻量级的 python ORM 库。内建对 SQLite、MySQL 和 PostgreSQL 的支持。支持 Python 2.6+ 和 Python 3.2+。

pip 安装：pip install peewee

示例代码：

frompeeweeimport*db=SqliteDatabase('people.db')classPerson(Model):name=CharField()birthday=DateField()is_relative=BooleanField()classMeta:database=db#Thismodelusesthe"people.db"database.>>>fromdatetimeimportdate>>>uncle_bob=Person(name='Bob',birthday=date(1960,1,15),is_relative=True)>>>uncle_bob.save()#bobisnowstoredinthedatabase1>>>grandma=Person.select().where(Person.name=='GrandmaL.').get()>>>grandma=Person.get(Person.name=='GrandmaL.')>>>forpersoninPerson.select():...printperson.name,person.is_relative...BobTrueGrandmaL.TrueHerbFalse

高级用法：

importpeeweefrompeeweeimport*db=MySQLDatabase('jonhydb',user='john',passwd='megajonhy')classBook(peewee.Model):author=peewee.CharField()title=peewee.TextField()classMeta:database=dbBook.create_table()book=Book(author="me",title='Peeweeiscool')book.save()forbookinBook.filter(author="me"):printbook.titlePeeweeiscool