[sqlalchemy] lower / upper case

I have a users table and I want to query the usernames column. I want my query to ignore the upper/lower casing. So the following searches should all match John: john, jOhn, johN, JOhn, and so on. My query at the moment is a follows: names = queryselect(users.c.username.startswith(john))

[sqlalchemy] sqlalchemy limit by clause

I am defining my result list the following way: result = queryobject.select(mytable.c.columnname == columnname, limit = maxResults, offset = 0) maxResults is the number of records I want returned. In case I want all the records, I am setting maxResults as -1. However, this is not working for

[sqlalchemy] Re: sqlalchemy.orm.attributes.InstrumentedList

@svilen Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For

[sqlalchemy] Re: order_by

@ml Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more

[sqlalchemy] Re: sqlalchemy.orm.attributes.InstrumentedList

Thanks. 'if isinstance(your_object, sqlalchemy.orm.attributes.InstrumentedList):' was helpful to me. Now I want to check if the given list is either a list of elements or a list of lists. Example: list1 = ['a', 'b', 'c'] list2 = [['a', 'b'], ['c', 'd'], ['e']] How can I check for lists within

[sqlalchemy] query for a subset of the object's columns

I hava a table called mytable (defined in the model as mytable_def) with the following columns: name, surname, age, address, idcard, sex, mobilenumber I want to query its name and surname columns only, so I am using a query such as the following:

[sqlalchemy] remove duplicates - DISTINCT constraint

I need to populate a table with author names for example the table name is author and it has a field authorname of type text. authorname has the following values: W. Shakespear J. Smith W. Shakespear R. Williams K. Winslet ... and so on. Then I want SQLAlchemy to remove the duplicates, so that