Select
--- page_q = session.query(model.Page).all() for page in page_q: print page.title
—
Session.query(Summit).limit(10)
—
page = session.query(model.Page).first() print page.title
—
page_q = session.query(model.page) page_q[2:5]
equal to =>
SELECT page.id AS page_id, page.content AS page_content, page.posted AS page_posted, page.title AS page_title, page.heading AS page_heading
FROM page
LIMIT 3 OFFSET 2
—
page_q.get(1)
—
page = session.query(model.Page).get(1)
—
titles1 = [page.title for page in page_q.filter(model.Page.id==1)]
—
titles2 = [page.title for page in page_q.filter_by(id=1)]
—
filtered_page_q = page_q.filter(model.page_table.c.title.like(u'%page%')) page = filtered_page_q.first()
—
from sqlalchemy.sql import and_, or_, func, not_ page = page_q.filter( and_(model.Page.title.like(u'%page%'), model.page_table.c.id==1)).first() SELECT page.id AS page_id, page.content AS page_content, page.posted AS page_posted, page.title AS page_title, page.heading AS page_heading FROM page WHERE page.title LIKE ? AND page.id = ? LIMIT 1 OFFSET 0
—
http://pylonsbook.com/en/1.1/introducing-the-model-and-sqlalchemy.html#queries