Thread: [Sqlalchemy-tickets] [sqlalchemy] #1399: Defect in ForeignKeys on PrimaryKey columns.
Brought to you by:
zzzeek
From: sqlalchemy <mi...@zz...> - 2009-04-30 16:56:24
|
#1399: Defect in ForeignKeys on PrimaryKey columns. --------------------+------------------------------------------------------- Reporter: guest | Owner: zzzeek Type: defect | Status: new Priority: medium | Milestone: Component: orm | Severity: no triage selected yet Keywords: | Status_field: awaiting triage --------------------+------------------------------------------------------- When creating a FK object, the column argument can be passed in as class.column, a string, or class.__table__.c.column. However, if the column the FK is created on is a primary key, using class.column raises an attribute error: AttributeError: Neither 'InstrumentedAttribute' object nor 'Comparator' object has an attribute 'table' The attached file shows a working FK using class.column (third class), and a defective fourth class that attempts to create a FK on a column that is also a PK using class.column. In the example, the PK is a composite of two columns, however this is not the issue, the code was tested and raised the same error without the second column. In the example, changing class.column for one of the other options listed above resolved the problem. This is not a serious defect as the other mechanisms work fine, but if this is a relatively easy fix it is worth doing as it provides more elegant syntax which is already working for the most part. -- Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1399> sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
From: sqlalchemy <mi...@zz...> - 2009-05-03 23:40:14
|
#1399: Defect in ForeignKeys on PrimaryKey columns. --------------------------------+------------------------------------------- Reporter: guest | Owner: zzzeek Type: defect | Status: new Priority: medium | Milestone: 0.5.xx Component: orm | Severity: minor - half an hour Resolution: | Keywords: Status_field: awaiting triage | --------------------------------+------------------------------------------- Changes (by zzzeek): * severity: no triage selected yet => minor - half an hour * milestone: => 0.5.xx -- Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1399#comment:1> sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
From: sqlalchemy <mi...@zz...> - 2009-06-15 22:54:02
|
#1399: Defect in ForeignKeys on PrimaryKey columns. --------------------------------+------------------------------------------- Reporter: guest | Owner: zzzeek Type: defect | Status: closed Priority: medium | Milestone: 0.5.xx Component: orm | Severity: minor - half an hour Resolution: duplicate | Keywords: Status_field: awaiting triage | --------------------------------+------------------------------------------- Changes (by zzzeek): * status: new => closed * resolution: => duplicate Comment: this is a dupe of 1353 and is fixed. -- Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1399#comment:2> sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |