Michael Bayer wrote:
> would need to see mappings.
First, let me mention that this issue only occurs on Postgres; I can't
replicate it on SQLite.
This is the many-to-many relation table (posted previously):
--------
table = rdb.Table(
'relation',
metadata,
rdb.Column('id', rdb.Integer, primary_key=True, autoincrement=True),
rdb.Column('left', rdb.String(length=32),
rdb.ForeignKey("soup.uuid"), index=True),
rdb.Column('right', rdb.String(length=32),
rdb.ForeignKey("soup.uuid")),
rdb.Column('order', rdb.Integer, nullable=False))
The soup table:
--------
table = rdb.Table(
'soup',
metadata,
rdb.Column('id', rdb.Integer, primary_key=True, autoincrement=True),
rdb.Column('uuid', rdb.String(length=32), unique=True, index=True),
rdb.Column('spec', rdb.String, index=True),
)
The relation property that should behave like an ordered list:
---------
orm.relation(
bootstrap.Relation,
primaryjoin=soup_table.c.uuid==relation_table.c.left,
collection_class=RelationList,
enable_typechecks=False)
I reproduce the problem like so:
1) Append some new item to the list, save and commit.
2) Repeat (1); an ``IntegrityError`` is raised:
IntegrityError: (IntegrityError) insert or update on table "relation"
violates foreign key constraint "relation_right_fkey"
DETAIL: Key (right)=(tcbb53226374211dd8a730017f2d1db9) is not
present in table "soup".
'INSERT INTO relation (id, "left", "right", "order") VALUES
(%(id)s, %(left)s, %(right)s, %(order)s)' {'left':
'tcbb31e28374211dd8a730017f2d1db9', 'right':
'tcbb53226374211dd8a730017f2d1db9', 'order': 1, 'id': 2L}
Any clues are greatly appreciated.
\malthe
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
