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)
-------------------------------------
X----------------------------------------------------------
When I try to insert data into this table using this piece of code,
source = SourcesObject()
source.name = "a2"
source.description = "b2"
session.save(source)
session.commit()
I get this error,
******************************************************************************************
raise exceptions.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
sqlalchemy.exceptions.ProgrammingError: (ProgrammingError) can't adapt
'INSERT INTO public."Sources" (id, name, description) VALUES (%(id)s, %
(name)s, %(description)s)' {'description': 'b2', 'name': 'a2', 'id':
PassiveDefault(<sqlalchemy.sql.expression._TextClause object at
0x02AA3C50>)}
*****************************************************************************************
I browsed through many forums, I couldn't get a solution.
Could you assist me?
Thanks,
Nagarajan.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
