Re: [sqlalchemy] Entity name - multiple schema - relationship

2014-05-17 Thread Richard Kuesters
hi! sorry for bringing this up so late - sometimes we just have no time to get in sync with all threads :) this is a subject that interests me. i mean, let me explain my current condition: i have a set of declarative classes that i get by calling a function, passing it's declarative base as

[sqlalchemy] polymorphic query - anon_1, anon_2 ... can they be used?

2010-08-04 Thread Richard Kuesters
hi all, in a polymorphic query, after a 'print' command i realized that SA generates some columns named 'anon_X', which can be helpful for me. the question is: 1. is it safe to use those anon_X columns to refine my query? --- regarding this, my concern is that once the polymorphic query is done

Re: [sqlalchemy] polymorphic query - anon_1, anon_2 ... can they be used?

2010-08-04 Thread Richard Kuesters
with multiple relationships. On Wed, Aug 4, 2010 at 12:29 PM, Michael Bayer mike...@zzzcomputing.comwrote: On Aug 4, 2010, at 10:07 AM, Richard Kuesters wrote: hi all, in a polymorphic query, after a 'print' command i realized that SA generates some columns named 'anon_X', which can be helpful

[sqlalchemy] map one class against multiple tables (in different schemas)

2010-06-30 Thread Richard Kuesters
hi all, i was wondering if its is possible to map one single class (let's say, Person) against multiple schemas (taking mysql, for example) with the same table structure. i know it can be done with sharding, but what troubles me is the fact that one schema will have the app data, and the other

Re: [sqlalchemy] Polymorphic on another table?

2010-05-20 Thread Richard Kuesters
Hi Timmy and Michael, I was wandering here about the same problem. I have a table that defines keys and value type (ie: key 'username', type 'unicode max 60' - that it is a constant). Then, I have the values table, which is polymorphic on value type and also has a fk to keys table. I think it is

[sqlalchemy] how to get the polymorphic identity from an third table?

2010-04-07 Thread Richard Kuesters
Hello all, I've been reading SQLALchemy docs and examples for quite some time now, and made a functional model of entities that ressembles the way OO works in concept - but it may be very early to say that, it's just a simple concept. The objective is to have: * a main table, that defines