consider column.key as primary target in result proxy

behavioral change following from ~~#2392~~:

from sqlalchemy import *

e = create_engine("sqlite://")
metadata = MetaData(e)
keyed1 = Table('keyed1', metadata,
        Column("a", CHAR(2), key="b"),
        Column("c", CHAR(2), key="q")
)
keyed2 = Table('keyed2', metadata,
        Column("a", CHAR(2)),
        Column("b", CHAR(2)),
)
metadata.create_all()

keyed1.insert().execute(dict(b="a1", q="c1"))
keyed2.insert().execute(dict(a="a2", b="b2"))

row = select([keyed2](keyed1,)).execute().first()

# current
try:
    row.a
    assert False
except:
    pass
assert row.b == 'b2'

# change:

#assert row.a == 'a2'

# would raise
#assert row.b == 'a1'

s = keyed1.select().apply_labels()

# current:
s.c.keyed1_a
# attribute error
try:
    s.c.keyed1_b
    assert False
except:
    pass

# change:

# OK
#s.c.keyed1_b

# would raise
#s.c.keyed1_a

Comments (5)