[sqlalchemy] SAWarning causes memory leak

2010-06-07 Thread nekto0n
Hi there! Interesting feature was discovered. When you supply queries with non- unicode values you get this: Unicode type received non-unicode bind param value 'ya37esbr24qhlu9kojf5z1x6m8gvinc0' All warnings after being emitted go into the warning registry in order to be able to ignore them in

Re: [sqlalchemy] SAWarning causes memory leak

2010-06-07 Thread Michael Bayer
wow that sucks does the warnings module document that ?we'd have to change that warning immediately. On Jun 7, 2010, at 9:09 AM, nekto0n wrote: Hi there! Interesting feature was discovered. When you supply queries with non- unicode values you get this: Unicode type received

Re: [sqlalchemy] Re: Questions about session

2010-06-07 Thread Conor
On 06/06/2010 02:58 PM, Az wrote: Hi Conor, Basically I sat down and made some decisions and changes. I've created an actual copy of the Student class as in I've now got two classes, Student and StudentUnmapped. The Unmapped one has the same attributes as the mapped one, except for being...

Re: [sqlalchemy] How to load properties of table manually?

2010-06-07 Thread Conor
On 06/07/2010 12:34 AM, Victor Lin wrote: Hi, I use a cache on some pages of my TurboGears2 application, and I encounter a problem. There is a query in those page method, for example: @beaker_cache(expire=30, type='memory', query_args=True) @expose() def foo(): data =

[sqlalchemy] zope.sqlalchemy 0.5 released

2010-06-07 Thread Laurence Rowe
I've just uploaded the 0.5 release of zope.sqlalchemy to PYPI, bringing SQLAlchemy 0.6 support. http://pypi.python.org/pypi/zope.sqlalchemy Savepoint release support (nested transaction commit) is currently being discussed on ZODB-dev:

[sqlalchemy] Re: Questions about session

2010-06-07 Thread Az
Sounds good. Just beware that deepcopy will try to make copies of all the objects referenced by your StudentUnmapped objects (assuming you didn't define __deepcopy__), so you may end up copying projects, supervisors, etc. Good point. I'm deepcopying my students, projects and supervisors

Re: [sqlalchemy] Re: Questions about session

2010-06-07 Thread Conor
On 06/07/2010 02:56 PM, Az wrote: Sounds good. Just beware that deepcopy will try to make copies of all the objects referenced by your StudentUnmapped objects (assuming you didn't define __deepcopy__), so you may end up copying projects, supervisors, etc. Good point. I'm deepcopying my

[sqlalchemy] Re: From sqlalchemy 0.5 to 0.6

2010-06-07 Thread Marc Pfister
On Jun 1, 2:46 pm, Emanuele Gesuato emanuele.gesu...@gmail.com wrote: I'm trying to port an application from sqlalchemy 0.5 to 0.6 but i got a strange error when i try to run the program in windows xp. The log is the following: Traceback (most recent call last):   File database.pyc, line

[sqlalchemy] Re: Questions about session

2010-06-07 Thread Az
By default, deepcopy will make one copy of everything in the object graph reachable by the object you feed it. The scary part is that, unless you also pass in a /memo/ argument to each call to deepcopy, it will copy the entire graph /every single call/. So if you deepcopy the students

[sqlalchemy] Re: Questions about session

2010-06-07 Thread Az
Additionally, before I tried out the create_db_record... However whenever I try to commit: #[§§0§] student_records = best_node for rec in student_records.itervalues(): MCS.session.add(rec) MCS.session.commit() I get: