python轻量级ORM---peewee

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: