[sqlalchemy] Re: Unit Of work seems to be calling save/delete twice

2007-06-20 Thread Eric Ongerth
Hello, * Apologies if this is a duplicate -- I attempted to post a few hours earlier but the result vanished. Could be that the earlier effort went off as a direct email to MB, instead of a post to this group as intended. chris e posted about this topic in April and I was trying to respond on

[sqlalchemy] How to catch a changed event in ORM

2007-06-20 Thread Can Xue
I'm working in a GUI project and use the SQLAlchemy for ORM. Can anyone tell me how to catch a attribute changed event in SQLAlchemy so that application can update the UI automaticly. Thank you. -- XUE Can --~--~-~--~~~---~--~~ You received this message because

[sqlalchemy] Re: session.clear() not clearing cascaded items?

2007-06-20 Thread svilen
i think i found something... i am doing testing about these links and nodes. For each testcase i have one constant set of nodes, and then trying different scenarios with various combination of links. Each scenario creates all database stuff a new - db, metadata, mappers, session - and after

[sqlalchemy] Re: How to catch a changed event in ORM

2007-06-20 Thread Eric Ongerth
On Jun 20, 12:45 am, Can Xue [EMAIL PROTECTED] wrote: I'm working in a GUI project and use the SQLAlchemy for ORM. Can anyone tell me how to catch a attribute changed event in SQLAlchemy so that application can update the UI automaticly. Thank you. -- XUE Can This may be more of a Python

[sqlalchemy] [TICKET 614] [PATCH] - one-liner to fix orig_set on scalar selects

2007-06-20 Thread Ian Charnas
http://www.sqlalchemy.org/trac/ticket/614 basically this line: self.orig_set = [] needs to be this line: self.orig_set = util.Set() or certain selects will throw an error saying list type has no attribute 'add' I couldn't find a sqlalchemy-tickets list, so I thought I'd post here. -Ian

[sqlalchemy] Re: Unit Of work seems to be calling save/delete twice

2007-06-20 Thread Eric Ongerth
p.s.: I'm curious whether this is the same issue mentioned in ticket 370, though that was apparently specific to Firebird's treatement of rowcounts; here I'm on postgresql 8.2. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the

[sqlalchemy] Re: Unit Of work seems to be calling save/delete twice

2007-06-20 Thread Michael Bayer
On Jun 20, 2007, at 2:52 AM, Eric Ongerth wrote: If I had to guess, maybe this 3-way split of secondary/association tables is the thing that might be causing problems. I set it up that way to keep a strong, up-front distinction between events being in an item's future vs. its

[sqlalchemy] Re: Unit Of work seems to be calling save/delete twice

2007-06-20 Thread Eric Ongerth
Thanks. I'll be getting back to this tomorrow too. Meanwhile: please note -- easily overlooked, item.current has uselist=False in its relation to Gearset because an item can only *currently* be involved in, at most, one set of items / one in progress reservation. However, item.history and

[sqlalchemy] Re: How to catch a changed event in ORM

2007-06-20 Thread svilen
I'm working in a GUI project and use the SQLAlchemy for ORM. Can anyone tell me how to catch a attribute changed event in SQLAlchemy so that application can update the UI automaticly. Thank you. -- XUE Can This may be more of a Python question, because it is not specifically

[sqlalchemy] Re: How to catch a changed event in ORM

2007-06-20 Thread Can Xue
Thank you but when I try downloading http://www.sistechnology.com/o2rm/o2rm0224.tar.bz2, I get a 404 not found :-( 2007/6/21, svilen [EMAIL PROTECTED]: I'm working in a GUI project and use the SQLAlchemy for ORM. Can anyone tell me how to catch a attribute changed event in SQLAlchemy so

[sqlalchemy] Re: How to catch a changed event in ORM

2007-06-20 Thread sdobrev
sorry, http://linuxteam.sistechnology.com/o2rm/o2rm0224.tar.bz2 Thank you but when I try downloading http://www.sistechnology.com/o2rm/o2rm0224.tar.bz2, I get a 404 not found :-( --~--~-~--~~~---~--~~ You received this message because you are subscribed to the

[sqlalchemy] Re: Unit Of work seems to be calling save/delete twice

2007-06-20 Thread Michael Bayer
ok its fixed in 2750 and it was mega-dumb, yes it was the uselist=False. lets pretend this one didnt happen this late in the game On Jun 20, 2007, at 2:52 AM, Eric Ongerth wrote: items = Table('items', metadata, Column('id', Integer, primary_key=True, autoincrement=True),

[sqlalchemy] help with IronPython

2007-06-20 Thread d_henderson
I recently tried SA again, and found that IronPython can now import it without errors. I seem to be missing some critical bit when connecting the driver to SA I have IPCE-r6 ipy -V IronPython 1.1 (1.1) on .NET 2.0.50727.42 My test program starts like so: import sys, os, os.path import

[sqlalchemy] Re: help with IronPython

2007-06-20 Thread Rick Morrison
The SA MSSQL module currently supports the three DBAPI modules mentioned above (pyodbc, pymssql, adodbapi). You'll need to either get one of those three to import under IronPython, or add support for the IPCE adaptor. On 6/20/07, d_henderson [EMAIL PROTECTED] wrote: I recently tried SA

[sqlalchemy] Re: in_ operator as kwarg to filter_by

2007-06-20 Thread David S.
snip But now a user of the query needs to know about the underlying selectable itself In case anyone reads this for info, that last statement is not true because you can access the columns from the mapped class. See

[sqlalchemy] Re: How to catch a changed event in ORM

2007-06-20 Thread sdobrev
I'm working in a GUI project and use the SQLAlchemy for ORM. Can anyone tell me how to catch a attribute changed event in SQLAlchemy so that application can update the UI automaticly. depending on how/when exactly are u going to check for attr-change, u can look for 'dirtyness' of the