[sqlalchemy] Re: Handling unique constraints

2008-01-05 Thread sdobrev
Matt Haggard wrote: I'm using SQLAlchemy with Pylons and am having trouble validating data. I have an App object mapped to a table with a unique constraint on App.number. Here's some code: q = Session.query(App) if app_id: q = q.filter_by(id=app_id).first()

[sqlalchemy] Re: Emptying out the session of new objects

2008-01-05 Thread Michael Bayer
On Jan 4, 2008, at 9:46 PM, Dave Harrison wrote: Hey Mike, Below is a minimal test case that always produces the below failure for me under 0.4.2 but not under 0.4.1, OK, its actually something that was buggy in 0.4.1 but didnt produce a symptom, give r4003 a try which fixes this

[sqlalchemy] Schema display

2008-01-05 Thread [EMAIL PROTECTED]
Hi Guys, I was wondering where the function create_schema_graph has gone, or what it has changed to. Any assistance would be appreciated. Let me know, Morgan --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

[sqlalchemy] Re: Emptying out the session of new objects

2008-01-05 Thread Dave Harrison
On Sunday 06 January 2008 05:30:04 Michael Bayer wrote: On Jan 4, 2008, at 9:46 PM, Dave Harrison wrote: Hey Mike, Below is a minimal test case that always produces the below failure for me under 0.4.2 but not under 0.4.1, OK, its actually something that was buggy in 0.4.1 but didnt

[sqlalchemy] Polymorphic mappers on boolean types

2008-01-05 Thread Dave Harrison
Hey all, More fun with inheritance and mappers. In the following situation where the polymorphic type is a Boolean, the mapper for the object that matches on False incorrectly returns the parent object. Cheers Dave -- -- testapi.py

[sqlalchemy] Re: Handling unique constraints

2008-01-05 Thread Chris
Matt, Take a look at the formencode module, it will simplify what you are trying to do here - handles all your parameter validation, form filling, and telling the user X,Y,Z are wrong etc. http://wiki.pylonshq.com/display/pylonsdocs/Form+Handling and formencode docs http://www.formencode.org/