[sqlalchemy] Re: (solved) Joined Table Inheritance and One-to-One headache

2007-11-14 Thread Alexandre Conrad
Hi list, Here is my solution (thanks to jek from IRC). # Mappers channel_mapper = mapper(Channel, channel_table, properties = { playlists:relation(PlaylistChannel, backref=channel, primaryjoin=and_(channel_table.c.id==

[sqlalchemy] Re: FYI: SQLAutocode 0.4.1 and 0.5 released

2007-11-14 Thread Simon Pamies
Hi, On Nov 14, 12:44 am, m h [EMAIL PROTECTED] wrote: On Nov 13, 2007 5:14 AM, Simon Pamies [EMAIL PROTECTED] wrote: Hey Simon, I found your code today and started to hack on it to do db migrations. Since it is out of the scope of your project, I'll probably just write my own. But before

[sqlalchemy] 0.4 does not work with wierd table/column names - regression or pebkac?

2007-11-14 Thread Felix Schwarz
Hi, I tried to migrate to SQLAlchemy 0.4 but unfortunately, 0.4 does not seem to work with the weird table and column names I have in my legacy database. I believe this behavior is a regression because the script below worked for me with 0.3.10. I got something horribly wrong (still learning

[sqlalchemy] features: database drivers and ssl

2007-11-14 Thread Marco Mariani
I need to evaluate a third-party application, that will be integrated with others by one of my programs. My integration app runs on linux with SA 0.4, and I will strive to use the latest stable release. I need to write a couple of requirements to choose the third-party application. Will I

[sqlalchemy] Re: trunk's new anon_N labeled subqueries break some eagerloading queries

2007-11-14 Thread Michael Bayer
On Nov 13, 2007, at 9:17 PM, Chris M wrote: I didn't see any tickets about this on the trac, so I thought I'd bring it to everyones attention. Since it's a development version I wasn't sure if this mattered (or was known about), so if it does I can draft up a quick test case. thanks for

[sqlalchemy] spam

2007-11-14 Thread Florent Aide
Hi moderators, Could we ban this Riaz M. from sending any more emails to this group? He also tried to send a lot of spam in TurboGears group and I moderated and banned him again there. Regards, Florent. --~--~-~--~~~---~--~~ You received this message because you

[sqlalchemy] Re: trunk's new anon_N labeled subqueries break some eagerloading queries

2007-11-14 Thread Michael Bayer
On Nov 14, 2007, at 11:07 AM, Chris M wrote: It's quite simple actually, there is absolutely no need for 99% of my code to know these values after they have been set. I view the criterion of a SELECT as being the values I actually use in my application and the values of the key fields are

[sqlalchemy] Re: trunk's new anon_N labeled subqueries break some eagerloading queries

2007-11-14 Thread Chris M
It's quite simple actually, there is absolutely no need for 99% of my code to know these values after they have been set. I view the criterion of a SELECT as being the values I actually use in my application and the values of the key fields are only used inside the query itself to specify which

[sqlalchemy] Re: 0.4 does not work with wierd table/column names - regression or pebkac?

2007-11-14 Thread Felix Schwarz
Michael Bayer schrieb: great news, that regex is gone in the trunk. try out the SVN trunk. Thank you very much - trunk fixes my problems :-) also yeah those column names are super wacky. :) I'm happy already if they don't contain broken umlauts characters or spaces :-) fs

[sqlalchemy] Re: trunk's new anon_N labeled subqueries break some eagerloading queries

2007-11-14 Thread Chris M
not entirely true... we need to know those values in sqlalchemy - we couldn't issue lazy loads Not true at all. Maybe in the current implementation, but it isn't necessary whatsoever. Let's say you have class Thing, which is many to one to class Owner. If you want to lazyload relation owner

[sqlalchemy] Re: trunk's new anon_N labeled subqueries break some eagerloading queries

2007-11-14 Thread Chris M
not entirely true... we need to know those values in sqlalchemy - we couldn't issue lazy loads Not true at all. Maybe in the current implementation, but it isn't necessary whatsoever. Let's say you have class Thing, which is many to one to class Owner. If you want to lazyload relation owner

[sqlalchemy] Re: trunk's new anon_N labeled subqueries break some eagerloading queries

2007-11-14 Thread Michael Bayer
On Nov 14, 2007, at 11:44 AM, Chris M wrote: not entirely true... we need to know those values in sqlalchemy - we couldn't issue lazy loads Not true at all. Maybe in the current implementation, but it isn't necessary whatsoever. Let's say you have class Thing, which is many to one to

[sqlalchemy] Re: trunk's new anon_N labeled subqueries break some eagerloading queries

2007-11-14 Thread Chris M
Understandable - there is no reason to change how it works as long as its possible to eagerload with deferred keys. Someone who is doing my pattern of access isn't going to be lazyloading much anyway. Not asking for any radical change, just discussing. On Nov 14, 12:23 pm, Michael Bayer [EMAIL

[sqlalchemy] Re: features: database drivers and ssl

2007-11-14 Thread Rick Morrison
Hi Marco, There is a DB2 driver in the works, but I haven't heard much noise about it lately, so I don't know what kind of progress is being made. As for supported drivers, the three engines you mention are all supported, I think that PG is probably has better test coverage than either Oracle or

[sqlalchemy] Re: Object Init Bug?

2007-11-14 Thread Koen Bok
Yep. That was it. Stupid me... On Nov 13, 4:10 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Nov 13, 2007, at 8:25 AM, Koen Bok wrote: Hi, I have this strange bug or problem... I have a basic class like this mapped to a table with the same name. Metatype is a relation to the metatype

[sqlalchemy] mysql unicode issues

2007-11-14 Thread david
Hi, I can see that this has been discussed before, but I am totally baffled as to what is happening. I. ubuntu mysql version 5.0.38 with : MySQL_python-1.2.2 SQLAlchemy-03.10 python-2.5 Using SA, I can insert and select unicode data with no problem. All the mysql stuff looks like it is set to

[sqlalchemy] Re: mysql unicode issues

2007-11-14 Thread jason kirtland
david wrote: Hi, I can see that this has been discussed before, but I am totally baffled as to what is happening. I. ubuntu mysql version 5.0.38 with : MySQL_python-1.2.2 SQLAlchemy-03.10 python-2.5 Using SA, I can insert and select unicode data with no problem. All the mysql