[sqlalchemy] Newbie (yeah, me) has some problems adding an object to the database

2009-01-25 Thread Michael Meier
Dear list I'm new to sqlalchemy and so far, I am very impressed. I was able to install SQLalchemy in about two minutes or so :-) and at the moment, I am trying to follow the steps in the documentation. I started with three tables (shown below) and tried to save a user in the database using the

[sqlalchemy] Re: Newbie (yeah, me) has some problems adding an object to the database

2009-01-25 Thread Michael Meier
never mind, found the mistake. should have read it from the beginning :-/ --~--~-~--~~~---~--~~ 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] Odd inheritance issue

2009-01-25 Thread Gloria W
Hi All, I have something stuping me right now. I'm using SqlAlchemy . 0.5.2 and Python 2.6. My issue is as follows: This class works perfectly: import sys import pprint import pdb from sqlalchemy import * from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import *

[sqlalchemy] Re: Odd inheritance issue

2009-01-25 Thread Gloria W
This should be called Odd Aggregation Issue. I am almost certain it's not related to inheritance, which is nested further up in the MemberProfile and Gender objects (which also work file). --~--~-~--~~~---~--~~ You received this message because you are subscribed

[sqlalchemy] Re: unions and order_by

2009-01-25 Thread Brett
The Controlling Ordering section of the docs mentions that using order_by on mappers is the standard way for setting a default ordering against a single mapped entity. This seems like a good feature. Is there another way? Will this be deprecated in the future? What's also really weird is that

[sqlalchemy] INTERVAL 1 DAY in ORM

2009-01-25 Thread Jan Koprowski
Hi ! I get some query: DELETE FROM passwordrequest WHERE requested_at = (NOW() - INTERVAL 1 DAY) which delete all requests older then one day. How can I get this effect in SQLAlchemy ? Greetings from Poland Jan Koprowski --~--~-~--~~~---~--~~ You received

[sqlalchemy] oracle flashback query

2009-01-25 Thread botz
Hi, I'm wondering if there's a way I can add a string to the tablename in a select query without affecting reflection, aliases, etc. Eg. given: t = Table( 'c1', column( 'c1', Integer, primary_key=True) I'd like to be able to generate: SELECT scntest.c1 AS scntest_c1 FROM scntest AS OF SCN 123

[sqlalchemy] Re: INTERVAL 1 DAY in ORM

2009-01-25 Thread Andreas Jung
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 26.01.2009 6:23 Uhr, Jan Koprowski wrote: Hi ! I get some query: DELETE FROM passwordrequest WHERE requested_at = (NOW() - INTERVAL 1 DAY) which delete all requests older then one day. How can I get this effect in SQLAlchemy ?