Python-сообщество

class Patient(Base):
    lastname = Column(Unicode)

patients = self.session.query(Patient)

lastname = unicode(self.lastname_entry.get_text())
if lastname:
     patients = patients.filter(Patient.lastname.like(u"%%%s%%" % lastname))

SELECT * FROM patients WHERE lastname LIKE "%иванов%"

con=sqlite.connect(database)
con.create_function('myLower',1,lambda x:x.lower())
db=con.cursor()
db.execute('select * from content where myLower(article) like ?')

In [28]: p.lastname
Out[28]: u'\u0413\u0430\u043f\u0447\u0443\u043a'

In [29]: patients.filter(Patient.lastname.ilike(u"%%%s%%" % l.decode('utf-8'))).count()

2011-01-20 21:20:30,950 INFO sqlalchemy.engine.base.Engine.0x...1250 SELECT count(1) AS count_1 
FROM patients 
WHERE lower(patients.lastname) LIKE lower(?)
2011-01-20 21:20:30,950 INFO sqlalchemy.engine.base.Engine.0x...1250 (u'%\u0433\u0430\u043f\u0447\u0443\u043a%',)
Out[29]: 0