Хабр Курсы для всех
РЕКЛАМА
Практикум, Хекслет, SkyPro, авторские курсы — собрали всех и попросили скидки. Осталось выбрать!
User.find(:first, :conditions => {:name => «Маша'})
session.query(User).filter_by(name=u»Маша").first()
session.query(User).filter_by(name=u»Маша").first():zoo = Zoo.first(:name => 'Luke')
map.connect ("startpage", "/", controller="main", action="index")
map.connect ("orderlist", "/orders", controller="order", action="list")
# Заявки
map.connect ("order", "/order/{id}", controller="order", action="view", requirements = {'id': '\d+'})
map.connect (None, "/order/{id}/{action}", controller="order", requirements = {'id': '\d+'})
class Model(models.Model):
...blah...
class Model(Base):
...blah...
в pylons нельзя использовать raw sql запросы, что иногда создает большие трудности.
>>> from sqlalchemy.sql import text
>>> s = text("""SELECT users.fullname || ', ' || addresses.email_address AS title
... FROM users, addresses
... WHERE users.id = addresses.user_id AND users.name BETWEEN :x AND :y AND
... (addresses.email_address LIKE :e1 OR addresses.email_address LIKE :e2)
... """)
sql>>> print conn.execute(s, x='m', y='z', e1='%@aol.com', e2='%@msn.com').fetchall()
>>>session.query(User.name).group_by(User.name).count() SELECT count(1) AS count_1 FROM (SELECT users.name AS users_name FROM users GROUP BY users.name) AS anon_1 ()
>>> s = select([addresses.c.email_address, addresses.c.id]).distinct().\ ... order_by(addresses.c.email_address.desc(), addresses.c.id) >>> conn.execute(s).fetchall() SELECT DISTINCT addresses.email_address, addresses.id FROM addresses ORDER BY addresses.email_address DESC, addresses.id ()
Pylons Framework