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
-~----------~----~----~----~------~----~------~--~---
