[sqlalchemy] Re: SQLAlchemy usage in TurboGears

2008-10-02 Thread Christoph Zwerschke
Michael Bayer schrieb: your current approach of using classical mappings with Session.mapper is entirely supported. ... So without reading the thread, I think declarative would probably be good, you can use it with Session.mapper if you want, though I view Session.mapper as somewhat

[sqlalchemy] Re: enumeration values in the column - referenced from another table

2008-10-02 Thread rca
thanks for the pointer, I tried and finally managed something the synonym (with the big neon don't panic in my head) I can do the conversion and insert integers id in place of textual representation and when accessing the parameter .surface, get the textual representation instead of id In this

[sqlalchemy] Re: enumeration values in the column - referenced from another table

2008-10-02 Thread az
if the tables have nothing in common, u can have a MapperExtension that when touching one item updates the proper table. as a working big example, see sqlalachemyAggregator, either in http://dev.gafol.net/t/aggregator or

[sqlalchemy] Multiple names/column_property for the same column

2008-10-02 Thread Cleber
Hi there, Sorry if this has come before, but I did not manage to find a specific answer on the mailing list archives. I'm porting an application to SA, and because of legacy code, I need to maintain nicknames (for now) for some attribute names. The database structure itself has column names

[sqlalchemy] Re: enumeration values in the column - referenced from another table

2008-10-02 Thread rca
Thanks again, it is much appreciated On Oct 2, 1:03 pm, [EMAIL PROTECTED] wrote: if the tables have nothing in common, u can have a MapperExtension that when touching one item updates the proper table. as a working big example, see sqlalachemyAggregator, either

[sqlalchemy] Re: Multiple names/column_property for the same column

2008-10-02 Thread az
u want to have one USerName pointing to username, or u want both, pointing to same column? first is done by changing key in the mapper.properties dict. the other... synonim()? On Thursday 02 October 2008 16:41:05 Cleber wrote: Hi there, Sorry if this has come before, but I did not manage

[sqlalchemy] Re: Multiple names/column_property for the same column

2008-10-02 Thread Cleber
My goal was the second one. I did try to use SynonymProperty, but got confused about it. Now with the correct use of synonym() it's all working! Thanks! On Oct 2, 10:38 am, [EMAIL PROTECTED] wrote: u want to have one USerName pointing to username, or u want both, pointing to same column?

[sqlalchemy] Re: enumeration values in the column - referenced from another table

2008-10-02 Thread rca
i think this should be it: http://www.sqlalchemy.org/docs/04/plugins.html#plugins_associationproxy and relevant discussion here: http://groups.google.com/group/sqlalchemy/browse_thread/thread/52565295f54fd85/31f53dca1e31e5ee?hl=enlnk=gstq=mapper+for+two+tables#31f53dca1e31e5ee On Oct 2, 3:50 

[sqlalchemy] Losing object state after rollback

2008-10-02 Thread Joril
Hi everyone! I'm sorry, I'm using SQLA 0.5rc1 with autocommit=True, and I'm having a problem with rollbacks.. It looks to me that whenever I try to save an object that triggers some kind of exception (thus triggering a rollback) I lose that object's previous state.. To elaborate, here's a simple

[sqlalchemy] Re: How to filter values in PGArray

2008-10-02 Thread Alex K
Hi, Seems that you need to call a function, here are the docs describing how to do this: http://www.sqlalchemy.org/docs/05/sqlexpression.html#sql_everythingelse_functions Regards, Alex On Oct 2, 3:49 pm, Ye Xu [EMAIL PROTECTED] wrote: Hello Everyone, database table testArray Column |

[sqlalchemy] Re: enumeration values in the column - referenced from another table

2008-10-02 Thread az
On Thursday 02 October 2008 17:13:24 rca wrote: i think this should be it: http://www.sqlalchemy.org/docs/04/plugins.html#plugins_associationp roxy and relevant discussion here: http://groups.google.com/group/sqlalchemy/browse_thread/thread/5256

[sqlalchemy] Re: Losing object state after rollback

2008-10-02 Thread Michael Bayer
On Oct 2, 2008, at 10:35 AM, Joril wrote: Hi everyone! I'm sorry, I'm using SQLA 0.5rc1 with autocommit=True, and I'm having a problem with rollbacks.. It looks to me that whenever I try to save an object that triggers some kind of exception (thus triggering a rollback) I lose that

[sqlalchemy] eagerload vs having the object and lazy

2008-10-02 Thread az
hi lets say, A points to B. i do a query against A about which things link to some instance of B. then, 1) if i specify eagerload, i get many times same object-data being piped from the server; ok but i dont want it 2) if i dont specify eagerload (lazy), access to each A fires a

[sqlalchemy] adding children to ORM object using property causes problems, maybe a bug?

2008-10-02 Thread Randy Syring
After some work with Gedd on #sqlalchemy, it seems that adding children to a parent object using a custom property() doesn't work as we expected it would. A test case is here: http://paste.pocoo.org/show/86848/ The error is triggered by line #53. Are we doing something wrong or is this a bug

[sqlalchemy] Re: adding children to ORM object using property causes problems, maybe a bug?

2008-10-02 Thread jason kirtland
Randy Syring wrote: After some work with Gedd on #sqlalchemy, it seems that adding children to a parent object using a custom property() doesn't work as we expected it would. A test case is here: http://paste.pocoo.org/show/86848/ The error is triggered by line #53. Are we doing

[sqlalchemy] Re: SqlAlchemy and kinterbasdb init problem

2008-10-02 Thread Michael Shaw
I found a workaround... Setting WSGIApplicationGroup = ${GLOBAL} for each app and adding a patch to sqlalchemy.databases.firebird.py to check self.dbapi.initialization before calling self.dbapi.init() This causes all the apps to run under one python subinterpreter and the global variable in

[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-02 Thread Michael Bayer
On Oct 2, 2008, at 11:57 AM, [EMAIL PROTECTED] wrote: hi lets say, A points to B. i do a query against A about which things link to some instance of B. then, 1) if i specify eagerload, i get many times same object-data being piped from the server; ok but i dont want it 2) if i dont

[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-02 Thread az
On Thursday 02 October 2008 22:26:06 Michael Bayer wrote: On Oct 2, 2008, at 11:57 AM, [EMAIL PROTECTED] wrote: hi lets say, A points to B. i do a query against A about which things link to some instance of B. then, 1) if i specify eagerload, i get many times same object-data being

[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-02 Thread Michael Bayer
On Oct 2, 2008, at 4:05 PM, [EMAIL PROTECTED] wrote: On Thursday 02 October 2008 22:26:06 Michael Bayer wrote: On Oct 2, 2008, at 11:57 AM, [EMAIL PROTECTED] wrote: hi lets say, A points to B. i do a query against A about which things link to some instance of B. then, 1) if i specify

[sqlalchemy] [searching developers] IMDbPY and SQLAlchemy

2008-10-02 Thread Davide Alberani
Hi all, I'm the leading developer of IMDbPY [1], a python package to access and manage information of the IMDb [2] internet movie database; it can work fetching data from the web site and from a local copy of the data, conveniently put in a database. So far I've used SQLObject but, due to

[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-02 Thread az
seems that A0.dbid = A1.dbid = Ax.dbid are not equivalent, in regards to the relation/get(). On Thursday 02 October 2008 22:48:23 Michael Bayer wrote: On Oct 2, 2008, at 4:05 PM, [EMAIL PROTECTED] wrote: On Thursday 02 October 2008 22:26:06 Michael Bayer wrote: On Oct 2, 2008, at 11:57 AM,

[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-02 Thread Michael Bayer
On Oct 2, 2008, at 5:43 PM, [EMAIL PROTECTED] wrote: * SA: INFO SELECT B.v_id AS B_v_id, B.db_id AS B_db_id, B.ax_id AS B_ax_id FROM B WHERE B.ax_id = ? * SA: INFO [1] BBB:1 * SA: INFO SELECT A0.pp AS A0_pp, A0.atype AS A0_atype, A0.db_id AS A0_db_id, A1.db_id AS A1_db_id, A1.name AS

[sqlalchemy] Re: eagerload vs having the object and lazy

2008-10-02 Thread az
On Thursday 02 October 2008 22:48:23 Michael Bayer wrote: On Oct 2, 2008, at 4:05 PM, [EMAIL PROTECTED] wrote: On Thursday 02 October 2008 22:26:06 Michael Bayer wrote: On Oct 2, 2008, at 11:57 AM, [EMAIL PROTECTED] wrote: hi lets say, A points to B. i do a query against A about which