[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 L

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

2007-02-04 Thread Patrick Lewis
On Feb 4, 4:54 pm, "Michael Bayer" <[EMAIL PROTECTED]> wrote: > hi - > > use the class_mapper(classname).props dictionary. Not sure if that will work. Consider: users_table = Table('app_user', metadata, Column('user_id', Integer, primary_key=True), Column('user_name', Unicode(16), uniq

[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 pool_

[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= on your create_engine(). On Feb 4, 3:20 pm, iain duncan <

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

2007-02-04 Thread Michael Bayer
hi - use the class_mapper(classname).props dictionary. sdobrev - time for you to read all the docs ! http://www.sqlalchemy.org/docs/docstrings.myt#docstrings_sqlalchemy.orm.mapper_Mapper On Feb 4, 2:20 pm, "Patrick Lewis" <[EMAIL PROTECTED]> wrote: > On Feb 4, 5:54 am, [EMAIL PROTECTED] wro

[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 P

[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 = create_engine('postgres://post

[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 expressio

[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... :-)

[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 origi

[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 = mapperFactory('Product

[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] 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

[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 machin

[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 migh