Dear all,
I would like to search in mysql like
select * from table1 where column1 regexp patten;
How can I do it in alsqlchemy?
Thank you
Ting
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To
e = sqlalchemy.create_engine(mssql://xxx:[EMAIL
PROTECTED]:1433/xx?driver=TDSodbc_options='TDS_Version=8.0')
here is a patch to mssql.py that makes above line work.
805c805,808
connectors.append(keys.pop('odbc_options'))
---
odbc_options=keys.pop('odbc_options')
Hi,
I've a problem to do a many to many relationship mapper declaration.
I will try to explain this with an example:
person_table(per_id, name, ...)
per_per_table(id, per_orig_id, per_dest_id)
per_orig_id = foreign key, reference to person_table.per_id
per_dest_id = foreign key, reference to
On Apr 22, 2008, at 10:45 AM, maxi wrote:
Hi,
I've a problem to do a many to many relationship mapper declaration.
I will try to explain this with an example:
person_table(per_id, name, ...)
per_per_table(id, per_orig_id, per_dest_id)
per_orig_id = foreign key, reference to
seems like you've found a very very old tutorial on the web somewhere
(and by old I mean, about two years out of date). The official SA ORM
tutorial is here: http://www.sqlalchemy.org/docs/04/ormtutorial.html
I'm reading too many docs at once lol :)
Anyway at last I've figured out how to
Hello again,
So now that I have mssql connection ready and data filtered out and
processed I need to save it to a different database.
mssql - process data - save to mysql
I am wondering how should I create a second database connection? In
second database I will create a table and populate the
On Tuesday 22 April 2008 19:54:16 Lukasz Szybalski wrote:
Hello again,
So now that I have mssql connection ready and data filtered out and
processed I need to save it to a different database.
mssql - process data - save to mysql
I am wondering how should I create a second database
On Tue, Apr 22, 2008 at 6:00 PM, [EMAIL PROTECTED] wrote:
On Tuesday 22 April 2008 19:54:16 Lukasz Szybalski wrote:
Hello again,
So now that I have mssql connection ready and data filtered out and
processed I need to save it to a different database.
mssql - process data - save
On Apr 22, 2008, at 8:57 PM, David Gardner wrote:
Thanks for your response, I ended up deciding that it was OK if leaf
nodes show up as regular nodes. So I dropped my qry_node query, and
kept
the qry_leaf query, and it is working now.
I should have mentioned as a side note, that my SA
column.op('regexp')(...)
i.e.
table1.select(table1.c.column1.op('regexp')('pattern'))
I think that should work.
On Apr 22, 5:28 am, coomteng [EMAIL PROTECTED] wrote:
Dear all,
I would like to search in mysql like
select * from table1 where column1 regexp patten;
How can I do it in
10 matches
Mail list logo