Re: [Sqlalchemy-users] Is this the best way to do this or is there a better way?

Thanks I hadn't tried that one, that makes the code look nicer Jose > Original Message > Subject: Re: [Sqlalchemy-users] Is this the best way to do this or is > there a better way? > From: Michael Bayer <[EMAIL PROTECTED]> > Date: Thu, September 21,

[Sqlalchemy-users] Is this the best way to do this or is there a better way?

b.query(Tgmouse).select_by(tgmouse_table.c.pathnum.like('%TG02-0010SK%')) Is there a way to do the query with with our referring directly to tgmouse_table? Thanks for any and all help Jose - Take Surveys. Earn Cash. In

Re: [Sqlalchemy-users] session trouble

Thanks everyone for all the help, it seems to be working now that I'm using explicit sessions rather then the threaded one I had been using Jose Jose Galvez wrote: > Dear sqlalchemy users, I'm pretty new to sqlalchemy and I've run into a > problem that I cant seem to figure

Re: [Sqlalchemy-users] session trouble

BTW thanks for the quick reply :) Jose Michael Bayer wrote: > make sure the "threadlocal" mod is not imported anywhere in the > application. or the "assignmapper" mod either. > > > On Sep 19, 2006, at 12:25 AM, Jose Galvez wrote: > > >> Dear sql

Re: [Sqlalchemy-users] session trouble

Ok that must be it, I was using threadlocal (took it from one of the pylons examples). I'll read through the docs better to see how to connect with out using that and write back if I get stuck Jose Jose Galvez wrote: > Dear sqlalchemy users, I'm pretty new to sqlalchemy and I&

[Sqlalchemy-users] session trouble

27; (this is '23998864')). I believe its the session that was created with the first query, but I'm not sure how to recover that session to use it rather then the one that I must be creating. Any and all help would be great Jose

RE: [Sqlalchemy-users] Postgres injection attack

Just reread the article (actually if i had read Michael's post better) and it states the the use of bind parameters protects against the attach. Still going to ask the psycoph group so see if a new beta is on the way or not. Jose > Original Message > Subject: RE:

RE: [Sqlalchemy-users] Postgres injection attack

installed)? Jose > Original Message > Subject: Re: [Sqlalchemy-users] Postgres injection attack > From: David Geller <[EMAIL PROTECTED]> > Date: Wed, May 24, 2006 9:12 am > To: Michael Bayer <[EMAIL PROTECTED]> > Cc: sqlalchemy-users > > H. Won

Re: [Sqlalchemy-users] odd join behavior

Cool, that looks more pythonic to me. BTW thanks for writing such a cool ORM Jose Michael Bayer wrote: > you can point to the object too, just dont put it in a string: > > ForeignKey(othertable.c.mycol) > > > > On Mar 27, 2006, at 10:26 PM, Jose Galvez wrote: > >&g

Re: [Sqlalchemy-users] odd join behavior

xceptions.ArgumentError: Table 'None.People' not defined > > the ForeignKey in Things should point to "people.id", not "People.id" > which does not exist. Oh I get it, I need to point to the actual table column, not the Object thats crea

Re: [Sqlalchemy-users] odd join behavior

=True), sqlalchemy.Column('thing', sqlalchemy.String(200)), sqlalchemy.Column('person', sqlalchemy.Integer, sqlalchemy.ForeignKey('People.id')), ) print sqlalchemy.join(Things, People).select().execute().fetchall()

[Sqlalchemy-users] odd join behavior

ldn't the above code work if I've defined the foreign key relationship correctly? jose --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live w

[Sqlalchemy-users] sqlalchemy newbe questoin

ly with a regular psycopg connection and do select * from foo, the normal user is able to get the data just fine. So my question is, what do I need to do to allow a normal user to discover the table relations? Thanks for any and all help Jose --