On May 6, 2008, at 6:17 AM, Nagarajan wrote:
>
> All,
> I am a newbie to SQLAlchemy.
> I needed an ORM for my system and after a research, I decided on
> SQLAlchemy.
>
> I used SQLAutocode that generated this model.py (a snippet is pasted
> here)....
> -------------------------------------
> X----------------------------------------------------------
> Sources = Table('Sources', metadata,
> Column(u'id', PGInteger(), primary_key=True, nullable=False,
> default
> =PassiveDefault(u'nextval(\'"public"."Sources_id_seq"\'::regclass)')),
> Column(u'name', PGString(length=256,
> convert_unicode=False, assert_unicode=None), primary_key=False,
> nullable=False),
> Column(u'description', PGString(length=256,
> convert_unicode=False, assert_unicode=None), primary_key=False,
> nullable=False),
>
> schema='public'
> )
> class SourcesObject(object): pass
> mapper(SourcesObject, Sources)
that Table is a little messed up, in particular "default" doesnt take
a PassiveDefault as an argument. the "Sources_id_seq" is implicit
when the "id" column is created as SERIAL, but since im not sure how
this table is getting created, do it like this:
s = Table("Sources", metadata, Column('id', Integer,
Sequence("Sources_id_seq"), primary_key=True),
Column('name', String(256), nullable=False),
Column('description', String(256), nullable=False)
)
--~--~---------~--~----~------------~-------~--~----~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
