[sqlalchemy] Questions about polymorphic mappers

2007-01-11 Thread Simon King
Hi, I have a couple of questions about polymorphic mapper inheritance. I'll use the employee/manager/engineer example from the docs, if that's OK. I'm also using SessionContext and assign_mapper, in case that makes a difference. I'd like to be able to call the base class (Employee), but have it

[sqlalchemy] Regression between r2168 and HEAD

2007-01-11 Thread Daniel Miller
After updating to HEAD this morning I got an error. This code has worked with many versions of SA and I've never seen anything like this error before. Here's the relevant code (modified from its original version to fit your screen): import sqlalchemy as sa class Version(object):

[sqlalchemy] Re: Test data apparently not saving

2007-01-11 Thread Michael Bayer
OK, i made it into a straight down program (attached) and it completes fine. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To

[sqlalchemy] Re: Saving bad data fails silently? (MySQL)

2007-01-11 Thread Michael Bayer
thats weird, inserting None into a PK col, even for mysql, should fail. try a small standalone test script that just INSERTs blank PK's into tables and see if it raises errors. On Jan 11, 2007, at 8:36 PM, Chris Shenton wrote: I've noticed this a few times now. Due to faulty logic in

[sqlalchemy] Re: autoloading oracle tables and the owner parameter

2007-01-11 Thread Michael Bayer
i notice your line numbers arent matching up with the most recent version of SA..they seem to match up with 0.3.0 or 0.3.1 which is before this bug was fixed (in 0.3.2 - http://www.sqlalchemy.org/trac/ticket/373).see if it works with the most recent version.

[sqlalchemy] Re: Test data apparently not saving

2007-01-11 Thread Patrick Lewis
Ok, that works for me, too. But, if I rework it how I think the test suite is running things, I get the same error. http://paste.turbogears.org/paste/832 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy

[sqlalchemy] Re: Test data apparently not saving

2007-01-11 Thread Patrick Lewis
A minor revision (made user1 global) http://paste.turbogears.org/paste/833 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To

[sqlalchemy] How to query like sys_id=42 AND ts_created 90 minutes ago ?

2007-01-11 Thread Chris Shenton
I've got a bunch of history and other timestamped information I will need to query against. The columns are created with type DateTime and get set upon row creation: history_table = Table( 'history', metadata, Column('history_id', Integer,primary_key=True),