Hello, My application needs to run against Oracle and SQLite. I'd like to have a query that uses a regexp in a select statement. For Oracle this is fine, as it supports regular expressions natively. For raw SQLite I can do:
connection.create_function("regexp", 2, regexp) where regexp is defined as: def regexp(expr, item): r = re.compile(expr) return r.match(item) is not None If I create an SQLAlchemy engine, and then create a connection object I can no longer use the create_function to build the regexp: db = create_engine(database) connection = db.connect() connection.create_function("regexp", 2, self.regexp) results in "'Connection' object has no attribute 'create_function'" Is it possible to access the underlying SQLite connection, and use that to create my regexp function? Cheers Simon --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---