[sqlalchemy] Re: SQLAlchemy, SQLite: ordering case insensitive
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
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
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 -~--~~~~--~~--~--~---