Re: [Sqlalchemy-users] Using SA to Persist Arbitrary Python Dictionaries?

2006-04-28 Thread Michael Bayer
ed - i have an example i havent brought up much yet that is similar: http://www.sqlalchemy.org/trac/browser/sqlalchemy/trunk/examples/ vertical/vertical.py it should be working in the trunk, though i havent run it for awhile. - m On Apr 28, 2006, at 6:02 PM, Ed Suominen wrote: A project

[Sqlalchemy-users] Google Summer of Code 2006

2006-04-28 Thread Jonathan LaCour
I am signed up and approved as a mentor for SoC 2006. I am primarily signed up because I am interested in finding a student wanting to work on SQLAlchemy and TurboGears. Here are the things I would like to see: * A fully-polished ActiveMapper with a strong unit test suite, based upon

[Sqlalchemy-users] Using SA to Persist Arbitrary Python Dictionaries?

2006-04-28 Thread Ed Suominen
A project I'm working on will use persistent dictionary objects that contain various types of Python objects. The dict will be saved to and restored from a database with SQLAlchemy. I'm picturing a database schema like the following: http://deadbeefbabe.org/paste/362 This prototype code uses my "

Re: [Sqlalchemy-users] session context proposal

2006-04-28 Thread Gustavo Niemeyer
> my current proposal regarding the association of objects to sessions, > as well as the optional association of objects and classes to > "session contexts", is as follows: (...) That's very nice! I'm looking forward to refactor our application to use this interface. > # returns the ses

Re: [Sqlalchemy-users] UPDATE with subselects in WHERE

2006-04-28 Thread Michael Bayer
oh wacky, total bug.  just fixed it in rev 1348.On Apr 28, 2006, at 2:44 AM, Dale Sedivec wrote:users = Table("users", engine,               Column("id", Integer, primary_key=True),               Column("name", String, unique=True, nullable=False)) users.create() passwords = Table("passwords", eng

Re: [Sqlalchemy-users] session context proposal

2006-04-28 Thread Michael Bayer
On Apr 27, 2006, at 11:05 PM, Daniel Miller wrote: I assume you're implicitly referring to any method that would call Session._bind_to(). Personally, I think Session._bind_to() should raise an exception if the object-to-be-bound is associated with some other _open_ session (rather than sile