[sqlalchemy] InvalidRequestError

2008-01-20 Thread VitaminJ
Hi! Is there a way to find out about the state an object is in? I am particular interested to find out if there is the need to call session.update() for an object or if the identidy is already contained in the session. I cannot manage to do this, but get an Invalid Request Errror. So the

[sqlalchemy] Postgis+sqlalchemy - KeyError: geometry

2008-01-20 Thread Mando
Hi, I'm trying to update somes values into a postgis layer through sqlalchemy, but, when I connect with the table I receive this message: Traceback (most recent call last): File /Applications/qgis0.9.0.app/Contents/MacOS/share/qgis/python/ plugins/sortpglayer_plugin/pyarchinit_dbconn.py, line

[sqlalchemy] Re: InvalidRequestError

2008-01-20 Thread Michael Bayer
On Jan 20, 2008, at 10:03 AM, VitaminJ wrote: Hi! Is there a way to find out about the state an object is in? I am particular interested to find out if there is the need to call session.update() for an object or if the identidy is already contained in the session. I cannot manage to do

[sqlalchemy] Re: Postgis+sqlalchemy - KeyError: geometry

2008-01-20 Thread Mando
On 20 Gen, 18:01, Michael Bayer [EMAIL PROTECTED] wrote: On Jan 20, 2008, at 11:57 AM, Mando wrote: I'm working on mac os x 10.4, python 2.5, SQLAlchemy-0.3.3, psycopg2-2.0.6, pgsql821+postgis121-1 upgrade to at least 0.3.11, the unknown column type of geometry will   produce a

[sqlalchemy] Re: Postgis+sqlalchemy - KeyError: geometry

2008-01-20 Thread Michael Bayer
On Jan 20, 2008, at 11:57 AM, Mando wrote: I'm working on mac os x 10.4, python 2.5, SQLAlchemy-0.3.3, psycopg2-2.0.6, pgsql821+postgis121-1 upgrade to at least 0.3.11, the unknown column type of geometry will produce a generically-typed column and a warning message.

[sqlalchemy] Re: Postgis+sqlalchemy - KeyError: geometry

2008-01-20 Thread Mando
No, the problem appears also with SQLAlchemy-0.3.11 and SQLAlchemy-0.4.2p3. /Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/site- packages/SQLAlchemy-0.4.2p3-py2.5.egg/sqlalchemy/databases/postgres.py: 509: RuntimeWarning: Did not recognize type 'geometry' of column 'the_geom'

[sqlalchemy] Re: InvalidRequestError

2008-01-20 Thread VitaminJ
Thanks for the great support and all the work! Merge is exactly what I had in mind. The documentation for merge() states what I was looking for: This method is useful for bringing in objects which may have been restored from a serialization, such as those stored in an HTTP session, where the

[sqlalchemy] Re: Postgis+sqlalchemy - KeyError: geometry

2008-01-20 Thread Mando
With SQLAlchemy-0.4.2p3 I've solved the problem in this (terrible!!!) way: I've added an 'if' into postgres.py file at line 514 and now work correctly. I maje this beacause I don't know how add a column type into sqlalchemy code: else: if attype != 'geometry':

[sqlalchemy] Re: Postgis+sqlalchemy - KeyError: geometry

2008-01-20 Thread Michael Bayer
On Jan 20, 2008, at 12:42 PM, Mando wrote: No, the problem appears also with SQLAlchemy-0.3.11 and SQLAlchemy-0.4.2p3. /Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/site- packages/SQLAlchemy-0.4.2p3-py2.5.egg/sqlalchemy/databases/ postgres.py: 509: RuntimeWarning:

[sqlalchemy] ORM Join with explicit Alias

2008-01-20 Thread Eoghan Murray
Hi All, I wish to do an aliased join similar to the last example in the section http://www.sqlalchemy.org/docs/04/ormtutorial.html#datamapping_joins session.query(User).\ ... join('addresses', aliased=True).filter(Address.email_address=='[EMAIL PROTECTED]').\ ... join('addresses',

[sqlalchemy] Unique ID's

2008-01-20 Thread Morgan
Hi Guys, I have field that I want to put a unique identifier in. This unique Id i would like to be a composite key or simply a random number. What do you guys suggest for this, is there a particular method which works well for some of you? Thanks in advance Morgan

[sqlalchemy] Re: ORM Join with explicit Alias

2008-01-20 Thread Michael Bayer
On Jan 20, 2008, at 6:52 PM, Eoghan Murray wrote: Hi All, I wish to do an aliased join similar to the last example in the section http://www.sqlalchemy.org/docs/04/ormtutorial.html#datamapping_joins session.query(User).\ ... join('addresses',

[sqlalchemy] Re: ORM Join with explicit Alias

2008-01-20 Thread Eoghan Murray
On Jan 21, 12:12 am, Michael Bayer [EMAIL PROTECTED] wrote: On Jan 20, 2008, at 6:52 PM, Eoghan Murray wrote: Hi All, I wish to do an aliased join similar to the last example in the sectionhttp://www.sqlalchemy.org/docs/04/ormtutorial.html#datamapping_joins session.query(User).\

[sqlalchemy] Re: Unique ID's

2008-01-20 Thread Hermann Himmelbauer
Am Montag, 21. Januar 2008 01:16 schrieb Morgan: Hi Guys, I have field that I want to put a unique identifier in. This unique Id i would like to be a composite key or simply a random number. What do you guys suggest for this, is there a particular method which works well for some of you?