was not aware that metadata.reflect() was doing views in 0.5, and this
feature is fine if someone has time to work on it. (trac ticket is a good
start)
Below is a tiny diff that allows for reflection of views (so that our
0.5.7-version based unit test passes without changes again).
Hi
I am using sqlalchemy in my TurboGears application.
some of my classes has columns with Pickletype dataType.
these get converted to BLOB dataType in the database.
I was using mySql till recently and everything was working fine.
Now i am shifting to oracle. Tables are getting created properly.
Hi,
I read the documentation about scoped sessions but l'm not sure to
understand
well what can be shared between threads and what cannot be.
Can we share a ScopedSession instance between threads ?
Do we have to share only the sessionmaker and re-create a
ScoppedSession in each threads ?
I have
On Wed, May 5, 2010 at 7:42 AM, dhanil anupurath
dhanilanupur...@gmail.comwrote:
Hi
I am using sqlalchemy in my TurboGears application.
some of my classes has columns with Pickletype dataType.
these get converted to BLOB dataType in the database.
I was using mySql till recently and
I am new to Sqlalchemy and ORM in general. I also have a slightly odd
use case. My existing database is a set of very simple tables. Each
table has the exact same layout/columns just different names, for
different collections of information. So I looked through the
Documentation and it seems to
On May 5, 2010, at 4:20 AM, fv wrote:
Hi,
I read the documentation about scoped sessions but l'm not sure to
understand
well what can be shared between threads and what cannot be.
Can we share a ScopedSession instance between threads ?
Do we have to share only the sessionmaker and
i have 4 tables, a, b, c, d.
a has one-to-many relation with b, b with one-to-one relationship with c, c
is a polymorphic on a.type, with d being one of the polymorphic types.
is there a way to implement this?
details:
this is what im trying to do in sqlalchemy:
a = Table('a', metadata,
On May 5, 2010, at 4:43 PM, Chris Angove wrote:
I am new to Sqlalchemy and ORM in general. I also have a slightly odd
use case. My existing database is a set of very simple tables. Each
table has the exact same layout/columns just different names, for
different collections of information.
On May 5, 2010, at 5:01 PM, Timmy Chan wrote:
i have 4 tables, a, b, c, d.
a has one-to-many relation with b, b with one-to-one relationship with c, c
is a polymorphic on a.type, with d being one of the polymorphic types.
is there a way to implement this?
details:
this is what im
thx, is there a way to set that up, or something similar?
after giving it thought, maybe polymorphic_on isn't what i need. in some
sense, table A is similar to a generic container, and i want to constrain
the type of C depending on A's type column. is there a way to do this?
On Wed, May 5,
what query do you want to see when you select C and D objects ?
On May 5, 2010, at 5:26 PM, Timmy Chan wrote:
thx, is there a way to set that up, or something similar?
after giving it thought, maybe polymorphic_on isn't what i need. in some
sense, table A is similar to a generic
C/D objects doesn't exist without A and B? maybe walk up the graph:
C.b.a.type
im not sure this schema is sensible, if it's really bad, please advise, im
not attached to it!
thax!
On Wed, May 5, 2010 at 5:28 PM, Michael Bayer mike...@zzzcomputing.comwrote:
what query do you want to see when
I meant SQL.if you want to do polymorphic_on based on a.type it would at
the very least need to issue:
SELECT c.*, a.type JOIN b ON c.b_id = b.id JOIN a ON b.a_id=a
which is an expensive way to get to where you're going. It can be done of
course but not through relation().
On May 5,
thx, that is what i am wondering. they are one-to-one, maybe thats good
enough for performance. so there's no easy way to do this.
On Wed, May 5, 2010 at 5:44 PM, Michael Bayer mike...@zzzcomputing.comwrote:
I meant SQL.if you want to do polymorphic_on based on a.type it would
at the
I was just considering something similar. Were you able to get far with
this?
On 04/07/2010 03:10 PM, Kyle Schaffrick wrote:
On Wed, 7 Apr 2010 10:15:14 -0400
Michael Bayermike...@zzzcomputing.com wrote:
Kyle Schaffrick wrote:
Greetings,
I'm looking into using PostgreSQL's
On Wed, 5 May 2010 15:01:08 -0700
David Gardner dgard...@creatureshop.com wrote:
I was just considering something similar. Were you able to get far
with this?
Yes, actually I've got a pretty good start on it. The only obvious
thing missing right now is a Comparator implementation so that the
16 matches
Mail list logo