[sqlalchemy] Re: Query generation in 0.3.8 is broken?

2007-06-07 Thread Dmitry Zuikov
Hi, the queries generated in 0.3.6 and 0.3.8 are identical except for an anonymous alias name. they are also both incorrect, and its only because 0.3.6 is less accurate about targeting Column objects in result sets that it works. Are they incorrect because of how they constructed, or it's

[sqlalchemy] Re: In Turbogears, using the same transaction for mapped objects and direct operations

2007-06-07 Thread Sanjay
So, cherrypy.request.sa_transaction.connection should work. I had tries that. But it says Exceptions :'function' object has no attribute 'execute' Don't know why. Sanjay --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[sqlalchemy] Re: SA and pyodbc connections

2007-06-07 Thread scurra
On 7 Jun, 00:00, Paul Johnston [EMAIL PROTECTED] wrote: Hi, If you could mail the output off list to both myself and Rick Morrison, that would be magic. Well, the summary is: FAILED (failures=20, errors=245) Looks like making this solid on Unix would be a mammoth task. Not one I'm

[sqlalchemy] Re: SA and pyodbc connections

2007-06-07 Thread Paul Johnston
Hi, I am no ODBC expert but I suspect that the problem with connecting Un*x to SQL Server has to do with the limitations of the Un*x odbc drivers. Yes, this is likely. Still on the issue of unicode support, FreeTDS does claim to support utf-8, so I'd be hopeful that it could be made to work,

[sqlalchemy] Re: group_by and column labels

2007-06-07 Thread Huy Do
Michael Bayer wrote: put strings into group_by: group_by = [client_code, client_name, ...] Hi Michael, Sorry I'm not sure what you are suggesting. I don't really want to retype my column names again in the group_by clause. My intention was to be able to reuse the actual column list in

[sqlalchemy] Re: Query generation in 0.3.8 is broken?

2007-06-07 Thread Michael Bayer
On Jun 7, 2007, at 2:25 AM, Dmitry Zuikov wrote: Hi, the queries generated in 0.3.6 and 0.3.8 are identical except for an anonymous alias name. they are also both incorrect, and its only because 0.3.6 is less accurate about targeting Column objects in result sets that it works. Are

[sqlalchemy] Re: Postgres MD Auth

2007-06-07 Thread Techniq
On Jun 7, 3:10 am, Karsten Hilbert [EMAIL PROTECTED] wrote: On Thu, Jun 07, 2007 at 12:20:46AM -, Techniq wrote: Any reason why I can auth with psql and not the sqlachemy.dburi in Pylons? Yes, likely. I can see that the user, password, host, port are all passed correctly. These

[sqlalchemy] Re: SA and pyodbc connections

2007-06-07 Thread Rick Morrison
pymssql does better, but as the underlying dbLib does not support unicode, most of the unicode-based unit tests fail. For me, at least, solid and passes all tests are not necessarily the same thing The issue I think likes more with the test suite than with MSSQL or any of its connectors, and

[sqlalchemy] Experimenting with more than one level of inheritance.

2007-06-07 Thread Daniele Varrazzo
Hello, i'm trying to generalize the examples in the documentation about multiple table inheritance, namely adding a `Boss` subclassing `Manger`:: class Boss(Manager): pass In the db i'd add a:: boss = Table('boss', metadata, Column('person_id', Integer,

[sqlalchemy] Re: Experimenting with more than one level of inheritance.

2007-06-07 Thread svilen
what is your hierarchy? why Boss' mapper inherits from person's one, and not from manager's one? On Thursday 07 June 2007 19:56:30 Daniele Varrazzo wrote: Hello, i'm trying to generalize the examples in the documentation about multiple table inheritance, namely adding a `Boss` subclassing

[sqlalchemy] Re: Experimenting with more than one level of inheritance.

2007-06-07 Thread Michael Bayer
On Jun 7, 2007, at 6:36 PM, Daniele Varrazzo wrote: a polymorphic fetch ses.query(Employee).select() correctly returns objects of all the classes, and the query ses.query(Boss).select() works fine as well. But while i expected ses.query(Manager).select() to fetch bosses too, an exception

[sqlalchemy] Re: Experimenting with more than one level of inheritance.

2007-06-07 Thread Daniele Varrazzo
when was that raised...when defining mappers ? this is all very hard to follow without an attachment of the full code. Yes: things diverged a bit from the starting example. Below a self contained test case. It fails fetching classes neither root nor leaf in an inheritance tree. Am i doing

[sqlalchemy] Strange UnicodeDecodeError in SA 0.3.7

2007-06-07 Thread Max Ischenko
Hello, After recent upgrade of my Pylons app I have been seeing the errors like this one: sqlalchemy.exceptions.SQLError: (UnicodeDecodeError) 'utf8' codec can't decode byte 0x96 in position 718: unexpected code byte u'SELECT jobad_posts.post_status AS jobad_posts_post_status,