You mean something like this?
K
---
# Running a SQL Statement using SQLAlchemy
from sqlalchemy import *
dsn = 'mysql://root:[EMAIL PROTECTED]:3306/tester'
# Create a database engine
db = create_engine(dsn)
# Do some SQL
text("INSERT INTO insertable SELECT NULL,txt FROM test_table;",
engine=db).execute()
On May 27, 1:18 pm, SamDonaldson <[EMAIL PROTECTED]> wrote:
> I'd like to be able to run a custom query without having to use any of
> the ORM stuff. I'd like to pass in a sql query string to some API
> that returns back to me instances (it'd be great), or tuples. How do
> I do this?
>
> Thanks.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
