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

[sqlalchemy] Re: in_ operator as kwarg to filter_by

2007-06-20 Thread David S.
> 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 http://www.sqlalchemy.org/docs/datamapping.html#datamapping_query_columnsonclass

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

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

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

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

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

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

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

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

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

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

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