Hi,
I got no idea, whether this is possible with SA (version 0.6.4), but I
want to map multiple columns as one list into the resulting object.
I have the following code:
location_table = Table('loc_location', metadata,
Column('LOC_ID', Integer, primary_key=True),
Column('LOC_L1', Integer, key='layer1'),
Column('LOC_L2', Integer, key='layer2'),
Column('LOC_L3', Integer, key='layer3'),
Column('LOC_L4', Integer, key='layer4'),
Column('LOC_L5', Integer, key='layer5'),
Column('A_Name', String(100), key='name'),
)
class Location(object):
def __repr__(self):
return u"<%s>" % self.name
if i then try to do the following:
mapper(Location, location_table, properties={
'hirachy': column_property([
location_table.c.layer1,
location_table.c.layer2,
])
})
It tells me: "AttributeError: 'list' object has no attribute 'label'"
I also tried to use a select, but it then tells me:
"sqlalchemy.exc.OperationalError: (OperationalError) 1241: Operand
should contain 1 column(s)"
Is there any way to achieve that? It would be great, if SA then bushes
back the changes to the list to the database, too.
bye
--
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.
