peewee是一个轻量级的ORM。用的是大名鼎鼎的sqlalchemy内核,采用纯python编写,显得十分轻便。为了后续方便查看,在这里简单记录下~~
peewee不仅轻量级,还提供了多种数据库的访问,如SqliteDatabase(file or memory)、MYSQLDatabase、PostgresqlDatabase;
接下来就从API上路吧~~~
1. class fn---To express functions in peewee, use the fn object。
For example:
Peewee expression | Equivalent SQL |
---|---|
fn.Count(Tweet.id).alias('count') | Count(t1."id") AS count |
fn.Lower(fn.Substr(User.username, 1, 1)) | Lower(Substr(t1."username", 1, 1)) |
fn.Rand().alias('random') | Rand() AS random |
fn.Stddev(Employee.salary).alias('sdv') | Stddev(t1."salary") AS sdv |
Functions can be used as any part of a query: select where group_by order_by having update query insert query
# user's username starts with a 'g' or a 'G': fn.Lower(fn.Substr(User.username, 1, 1)) == 'g'
2.表达式支持的操作符
a: