Re: [sqlalchemy] Re: integrity error in FK relation

2009-12-02 Thread Tefnet Developers - Tomasz Jezierski
Dnia 2009-12-01, Wt o godzinie 21:58 -0800, rajasekhar911 pisze: but this happen only when i use innodb as engine. didnt give an error on myisam on mysql or sqlite. Probably because myisam is not transactional and sqlite usually doesn't care about constraints. Tomasz Jezierski Tefnet

Re: [sqlalchemy] easy_install SQLAlchemy

2009-12-01 Thread Tefnet Developers - Tomasz Jezierski
Dnia 2009-12-01, Wt o godzinie 18:45 +0100, Alexandre Conrad pisze: Hey there, just wondering: easy_install SQLAlchemy downloads and installs version 0.5.2. Shouldn't it be 0.5.6? # easy_install SQLAlchemy Searching for SQLAlchemy Reading http://pypi.python.org/simple/SQLAlchemy/

Re: [sqlalchemy] Filter on relation???

2009-11-24 Thread Tefnet Developers - Tomasz Jezierski
Dnia 2009-11-24, Wt o godzinie 11:18 +0100, Christian Démolis pisze: Is it possible to put a filter on a relation in the declaration? Example : LeNomDuUtilisateur = relation(Utilisateur, filter_by=Utilisateur.Login, backref=backref('verrouillage')) I'm not sure what exactly your example

[sqlalchemy] Re: Query on a related object's field

2009-11-13 Thread Tefnet Developers - Tomasz Jezierski
Dnia 2009-11-13, Pt o godzinie 05:02 -0800, bojanb pisze: What is the easiest way of getting the equivalent of this: session.query(Someclass).filter_by(related_obj.field=somevalue) Ie. I want to filter by a field of an object that is in relation to objects of Someclass. My original

[sqlalchemy] Re: what time sqlalchemy 0.6 out?

2009-11-11 Thread Tefnet Developers - Tomasz Jezierski
Dnia 2009-11-10, Wt o godzinie 22:36 -0500, Michael Bayer pisze: haven't seen a DBAPI for drizzle as of yet. I don't use drizzle myself so I don't know how stable it is... but there is DBAPI for drizzle... https://launchpad.net/drizzle-interface/+milestone/ongoing-development On Nov

[sqlalchemy] Re: Directly saving a dictionary of column values to SA...

2009-10-30 Thread Tefnet Developers - Tomasz Jezierski
Dnia 2009-10-30, Pt o godzinie 01:44 -0700, Shane pisze: Hi All, I am using SA within TurboGears. When saving data from form fields, I often have a dict of key/value pairs (where values is always a string and must by correctly typed) where each key is set up to correspond to a column

[sqlalchemy] Re: Auto-generated Code?

2009-10-23 Thread Tefnet Developers - Tomasz Jezierski
Dnia 2009-10-23, Pt o godzinie 15:00 +0800, Stone Puzzle pisze: Is there a way or lib to help us generating python code of all of the tables and relations automatically from a existing database? http://turbogears.org/2.1/docs/main/Utilities/sqlautocode.html Tomasz Jezierski Tefnet