[sqlalchemy] Re: How to explicit name aliased classes in joins of orm.query

Hello Michael, thanks a lot again, sorry for not extracting the right parts...I'll try to do that better next time. The mentioned approach: lc1 = aliased(LookupSubclassOne) lc2 = aliased(LookupSubclassTwo) query(Building).\ join(Building.condition,aliased=True).\ join(lc1,

Re: [sqlalchemy] Re: How to explicit name aliased classes in joins of orm.query

On Jul 5, 2011, at 4:25 AM, Michael Tils wrote: Hello Michael, thanks a lot again, sorry for not extracting the right parts...I'll try to do that better next time. bc1 = aliased(BuildingCondition) bc2 = aliased(BuildingCondition) lc1 = aliased(LookupSubclassOne) lc2 =

[sqlalchemy] Re: EOFError while querying

Hi Michael thanks for the reply. there is a PickleType in the query (the one that i have mentioned as BLOB data type). I have given a test program to the customer and waiting for the response. thanks again On Jul 4, 8:01 pm, Michael Bayer mike...@zzzcomputing.com wrote: loads() implies you're

[sqlalchemy] ImportError: DLL load failed: The specified module could not be found

Hi all, I am trying to write some plugin for Tiddlyspace[1], Which is using sqlalchemy for Data Access. Currently it's support MySQL. But now I am trying to use it with Oracle. So I've installed oracle driver for windows [2]. I've tried out some samples without sqlalchemy and with sqlalchemy.

Aw: Re: [sqlalchemy] Re: How to explicit name aliased classes in joins of orm.query

Thanks a lot, I'm happy now :-) -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/JIjX-ysYSVYJ. To post to this group, send email to sqlalchemy@googlegroups.com.

[sqlalchemy] Managing one-to-one relation?

Hi. I have a situation where I have X data models, and while each has its own properties, they all share a set of fields with common meaning, like id, title, description, and some others. What way would you recommend to approach this problem? If I wasn't using SQLAlchemy, I'd have one main

Re: [sqlalchemy] Managing one-to-one relation?

On 07/05/2011 03:09 PM, Vlad K. wrote: Hi. I have a situation where I have X data models, and while each has its own properties, they all share a set of fields with common meaning, like id, title, description, and some others. What way would you recommend to approach this problem? If I

Re: [sqlalchemy] Managing one-to-one relation?

Many thanks, that's exactly what I need! .oO V Oo. On 07/05/2011 10:13 PM, Conor wrote: SQLAlchemy can model this via joined table inheritance: http://www.sqlalchemy.org/docs/orm/inheritance.html#joined-table-inheritance. You are still responsible for setting up the tables in the way you

[sqlalchemy] Re: confused on avoiding sql injections using ORM

Say I create an instance of a mapped class and then attach some values to it. And want to do session.add. If you're worried about something like this: user = User() user.name = ;DROP TABLE users; session.add(user) then don't be, there is no possibility of SQL injection here,