I'm going through the wiki cookbook
http://docs.pythonweb.org/display/pylonscookbook/SQLAlchemy+for+people+in+a+hurry
and I'm discovering that even though 'model.class.c.column_name.like'
is available it doesn't perform a LIKE in the query.
from 'paster shell'
In [20]:
model.Accounting.select(model.Accounting.c.usr.like('TSmith'))
Out[21]:
[<syslogsql.models.Accounting object at 0x2626d70>,
<syslogsql.models.Accounting object at 0x2626ad0>,
<syslogsql.models.Accounting object at 0x2626910>]
In [22]: model.Accounting.select(model.Accounting.c.usr.like('Smith'))
Out[22]: []
...BUT...
In [23]: model.Accounting.select(model.Accounting.c.usr.like('%Smith
%'))
Out[27]:
[<syslogsql.models.Accounting object at 0x262d670>,
<syslogsql.models.Accounting object at 0x2626d70>,
<syslogsql.models.Accounting object at 0x2626ad0>,
<syslogsql.models.Accounting object at 0x262d770>,
<syslogsql.models.Accounting object at 0x262d790>,
<syslogsql.models.Accounting object at 0x262d7b0>,
<syslogsql.models.Accounting object at 0x2626910>]
Should I have to add the '%' around the string?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
