1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
| >>> q = session.query(User.id, User.name)
>>> q.all()
[(1, u'aaa'), (2, u'ccc'), (3, u'ed'), (4, u'zxwer'), (5, u'fake'), (6, u'dc'), (7, u'dc'), (8, u'dc')]
>>> q1 = session.query(func.sum(User.id))
>>> q1.all()
2015-11-11 22:06:24,312 INFO sqlalchemy.engine.base.Engine SELECT sum(users.id) AS sum_1
FROM users
2015-11-11 22:06:24,312 INFO sqlalchemy.engine.base.Engine ()
[(36,)]
>>> q1 = session.query(func.sum(User.id*2))
>>> q1.all()
2015-11-11 22:06:55,466 INFO sqlalchemy.engine.base.Engine SELECT sum(users.id * ?) AS sum_1
FROM users
2015-11-11 22:06:55,466 INFO sqlalchemy.engine.base.Engine (2,)
[(72,)]
>>>
|