[sqlalchemy] Re: SQLAlchemy, SQLite: ordering case insensitive

2006-12-18 Thread ragnar

Ah, that explains it. Thanks for the answer


--~--~-~--~~~---~--~~
 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 options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---



[sqlalchemy] Re: SQLAlchemy, SQLite: ordering case insensitive

2006-12-17 Thread ragnar

func.lower() was indeed very nice. Thank you for the reply.

I seem to have missed the sqlalchemy.func package entirely before and
it seems to be rather sparingly documented and it isn't listed in
package contents when I do help(sqlalchemy). Is there anywhere where I
can read more about the available functions in sqlalchemy.func?


--~--~-~--~~~---~--~~
 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 options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---



[sqlalchemy] Re: SQLAlchemy, SQLite: ordering case insensitive

2006-12-17 Thread Michael Bayer

func is just a catchall, whatever attribute you call off of it gets
sent to __getattr__ and becomes a function call.  its designed to allow
any random database-specific call or custom stored procedure.

however, it does have some extra tricks going on, in that it will
de-parenthesize certain ANSI calls that are known to not want
parenthesis, like CURRENT_TIMESTAMP.

the docs are here:
http://www.sqlalchemy.org/docs/sqlconstruction.myt#sql_whereclause_functions

which you probably found, and it does need a good amount more
explanation.  a. that you can call whatever name you want, and it
becomes a function b. that it knows about certain ANSI calls and c.
that you can create selectables out of functions now, which is useful
for calling stored procedures that return result sets.

its not in the generated docs because its just an instance variable,
that points to an instance of _FunctionGenerator which is private.


--~--~-~--~~~---~--~~
 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 options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---