[sqlalchemy] Re: engine.contextual_connect() vs session.connection()

2006-11-07 Thread Michael Bayer
heres the source to session.connection() def connection(self, mapper, **kwargs): returns a Connection corresponding to the given mapper. used by the execute() method which performs select operations for Mapper and Query. if this Session is transactional, the

[sqlalchemy] Re: Execute via my cursor (or Oracle Functions)

2006-11-07 Thread Michael Bayer
if you dont mind relying upon garbage collection to close connections then you dont have to worry about closing anything. otherwise youd need to call close() on the connection. the closest thing to the old behavior of execute() is the _execute_raw method on Connection: conn = engine.connect()

[sqlalchemy] how to get list of tables

2006-11-07 Thread stburns
Hello, Is there a db independent way to reflect the list of existing tables? With mssql, I can do engine.execute('exec sp_tables')...is there a portable way to do it? Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the

[sqlalchemy] Re: how to get list of tables

2006-11-07 Thread Michael Bayer
theres not, but if someone wants to submit a patch that works for all the db engines (or most of them), id commit it. On Nov 7, 2006, at 10:46 AM, stburns wrote: Hello, Is there a db independent way to reflect the list of existing tables? With mssql, I can do engine.execute('exec

[sqlalchemy] Re: convert_unicode=True results in double encoding

2006-11-07 Thread Shannon -jj Behrens
The following results in correct data going into and coming out of the database, but the data in the database itself looks double encoded: import MySQLdb connection = MySQLdb.connect(host=fmapp03, user=foxmarks, passwd='ChunkyBacon', db=users) cursor =

[sqlalchemy] Re: convert_unicode=True results in double encoding

2006-11-07 Thread Shannon -jj Behrens
On 11/7/06, Michael Bayer [EMAIL PROTECTED] wrote: yeah, or use introspection to consume the args, i thought of that too. i guess we can do that. of course i dont like having to go there but i guess not a big deal. as far as kwargs collisions, yeah, thats a potential issue too. but the

[sqlalchemy] Re: convert_unicode=True results in double encoding

2006-11-07 Thread Michael Bayer
ugh, well i fixed that one. random doc bugs you can file tickets for, or ill just give you commit access if you want to knock some out yourself. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy

[sqlalchemy] Re: polymorphic_identity determination

2006-11-07 Thread Randall Smith
I worked on this some more and found that the queries are correct as they are. The problem is in the mapping. A Chemical Engineer is an Engineer, who is an Employee. So the employees selectable should return all employees and the engineer selectable should return all engineers, not just

[sqlalchemy] General Inheritance Questions

2006-11-07 Thread Randall Smith
As I've been experimenting with inheritance, I think my hang ups are largely due to my lack of understanding of how SA accomplishes it. So here are some simple questions. 1. What does it mean for a mapper to inherit from another mapper? What does it inherit from that mapper and how does