[sqlalchemy] Re: Inspect and __init__ of a mapped class

2007-02-04 Thread sdobrev
I'm trying to create a mapped object where I don't know what the exact constructor arguments of the object might be. I was trying to use the inspect module to get the right arguments, but it looks like the mapper is redefining the original class __init__. Any thoughts as to how I might

[sqlalchemy] Re: sqlalchemy lost connection?

2007-02-04 Thread Jorge Godoy
iain duncan [EMAIL PROTECTED] writes: ridiculous but at least it works. I suppose in the case of a web app the cron job could even be on any old server using wget. I'd put the cron job on the same server as the app... :-) The load is ridiculous and there's no need to have an extra machine

[sqlalchemy] Re: Assign mapper many-to-many with extra columns

2007-02-04 Thread Jorge Godoy
iain duncan [EMAIL PROTECTED] writes: On Sat, 2007-03-02 at 18:44 -0500, Karl Guertin wrote: On 2/3/07, iain duncan [EMAIL PROTECTED] wrote: InvalidRequestError: Given column 'page_article.ordering', attached to table 'page_article', failed to locate a corresponding column from table

[sqlalchemy] Re: SA 0.3.4 and sequence for non-primary key column

2007-02-04 Thread che
thanks again, Michael. Stefan --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL

[sqlalchemy] Probleming specifying a schema for Table() and using relations

2007-02-04 Thread Andreas Jung
I am getting the following error when defining a one-to-many relationship using the following code: db = create_engine('postgres://postgres:[EMAIL PROTECTED]/eCommerce') metadata = BoundMetaData(db) mapperFactory = MapperFactory(metadata) ProductAward, ProductAwardTable =

[sqlalchemy] Re: Inspect and __init__ of a mapped class

2007-02-04 Thread Patrick Lewis
On Feb 4, 5:54 am, [EMAIL PROTECTED] wrote: I'm trying to create a mapped object where I don't know what the exact constructor arguments of the object might be. I was trying to use the inspect module to get the right arguments, but it looks like the mapper is redefining the original

[sqlalchemy] Re: sqlalchemy lost connection?

2007-02-04 Thread iain duncan
On Sun, 2007-04-02 at 10:33 -0200, Jorge Godoy wrote: iain duncan [EMAIL PROTECTED] writes: ridiculous but at least it works. I suppose in the case of a web app the cron job could even be on any old server using wget. I'd put the cron job on the same server as the app... :-) The load

[sqlalchemy] Re: any particular reason for creating unused lists?

2007-02-04 Thread Michael Bayer
OK, i added this in 2298. I dont notice any speed enhancement in overall performance of the unit tests even though it builds on set and not sets.Set...this is probably because we dont use OrderedSet too much. Also i had to make some changes so its compatible with 2.3 (no generator expressions,

[sqlalchemy] Re: Probleming specifying a schema for Table() and using relations

2007-02-04 Thread Michael Bayer
well the way out for the moment is to not use reflection since its screwing up with schemas. On Feb 4, 1:27 pm, Andreas Jung [EMAIL PROTECTED] wrote: I am getting the following error when defining a one-to-many relationship using the following code: db =

[sqlalchemy] Re: Probleming specifying a schema for Table() and using relations

2007-02-04 Thread Michael Bayer
so, I just committed a test for PG reflection across schemas in r2299 and PG foreign key reflection works fine for alternate schema tables, also works in 0.3.4, and in r2300 i changed it to ensure that auto- reflection of referenced tables works (which is what you seem to be looking for with the

[sqlalchemy] Re: sqlalchemy lost connection?

2007-02-04 Thread Michael Bayer
three people have replied to this user and nobody has referenced the documented (as well as FAQ'ed) feature specifically built to deal with this ?! sorry im so cranky...but man you guys have to help me a little more :) use pool_recycle=some number of seconds less than 8 hours on your

[sqlalchemy] Re: sqlalchemy lost connection?

2007-02-04 Thread iain duncan
On Sun, 2007-04-02 at 22:00 +, Michael Bayer wrote: three people have replied to this user and nobody has referenced the documented (as well as FAQ'ed) feature specifically built to deal with this ?! sorry im so cranky...but man you guys have to help me a little more :) use

[sqlalchemy] doc bug for Association Object example code

2007-02-04 Thread iain duncan
Not sure if this is the right place, hope so. In the example for Association Object on http://www.sqlalchemy.org/docs/datamapping.myt#datamapping The bottom part reads: for a in alist: for k in a.keywords: if k.keyword.name == 'jacks_stories': print k.user.user_name