[sqlalchemy] declarative base and association object

2009-02-09 Thread vctr...@gmail.com
Hi, I would like to use an association object with two tables derived from two declarative base classes. What would be (if one may say) the right way to access (get and set) the additional values in the association object? When I set the 2 entities from the base classes and associate them I get

[sqlalchemy] Declarative Base ID

2009-02-01 Thread vctr...@gmail.com
The ID field in a declarative base is a sequence that is not controled by the user (or is it?). Is there a way to get it to start the counting of the ID from 0 and not from 1? Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to

[sqlalchemy] Re: Declarative Base ID

2009-02-01 Thread vctr...@gmail.com
  the primary key attributes on a pending object to 0 and flush to force   a zero. On Feb 1, 2009, at 7:24 AM, vctr...@gmail.com wrote: The ID field in a declarative base is a sequence that is not controled by the user (or is it?). Is there a way to get it to start the counting of the ID

[sqlalchemy] Sanity checks

2009-01-01 Thread vctr...@gmail.com
Is there a way to do some sanity check through thr SQLAlchemy. Check like - SQL Service is running, DB exists etc. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email

[sqlalchemy] declerative base and relation

2008-12-24 Thread vctr...@gmail.com
Hi, I tried the following example (from the documentation): class User(Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) name = Column(String(50)) addresses = relation(Address, backref=user) class Address(Base): __tablename__ = 'addresses' id =

[sqlalchemy] psycopg2 and Python 2.6

2008-12-23 Thread vctr...@gmail.com
Hi all, I'm trying to port to python 2.6 with SQLAlchemy over PostgrSQL and it seems that all is porting BUT the psycopg2 component? Is anyone aware of a working version of psycopg2 for Linx 64 arch? In general - does SQLAlchemy support 2.6? I was under the impression that it does. Is there

[sqlalchemy] Polymorphic Identity and declarative base

2008-12-16 Thread vctr...@gmail.com
A newbie question: Is there a way to define a subclass using declarative base which defined the polymorphic identity on more than one value? Is there a way to do it outside the declarative base? A bane example: In subclass Citrus I would like to be able to declare several types of fruits