you can have a look in the sqlalchemy docs, to do queries
using 'like' instead of equal.
something like User.query.filter(User.name.like('Joe')).first()
good luck,
Erik
On Jan 15, 2008 3:52 PM, David Wolever <[EMAIL PROTECTED]> wrote:
>
> Is it possible to somehow get case-insensitive columns? For example:
> class User(Entitiy):
> has_field('name', Unicode(), primary_key = True)
>
> And I want 'name' to be unique, regardless of case (ie,
> User.get_by(name='joe') == User.get_by(name='Joe')).
>
> Now, I realize there are unicode issues (ie, what does it really mean
> to be lower case?), but pretending that the name will always be 8 bit
> ASCII.
>
> (ps: sorry about the double post -- hit tab then space by accident)
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SQLElixir" 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/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---
