modelhaiku.py

modelhaiku.py

from sqlalchemy import *

class Haiku(Model):
    id    = Column(Integer, primary_key=True)
    ctime = Column(DateTime, default=func.now())
    line1 = Column(Text())
    line2 = Column(Text())
    line3 = Column(Text())

query = (Session.query(Haiku)
    .filter(Haiku.line1.endswith('love') or
            Haiku.line2.endswith('love') or
            Haiku.line3.endswith('love') )
    .order_by(Haiku.ctime.desc())[0:10]     )