Hi,
I'm using SQLAlchemy 0.28 with Pylons 0.98, and when I define this
structure (abridged, so I'm not sure it will really compile...)
people_table = Table("people", metadata,
Column('id', Integer, primary_key=True),
Column('user_name', String),
Column('first_name', String),
Column('last_name', String),
Column('password', String)
)
phone_numbers_table = Table("phone_numbers", metadata,
Column('id', Integer, primary_key=True),
Column('person_id', Integer, ForeignKey('people.id')),
Column('is_alert_number', Boolean),
Column('type', String),
Column('number', String)
)
class Person(object):
pass
class PhoneNumber(object):
pass
person_mapper = mapper(Person, people_table,
properties = {
'phones' : relation(PhoneNumber, cascade="all, delete-orphan",
backref="person", order_by=desc("is_alert_number"))
})
phone_mapper = mapper(PhoneNumber, phone_numbers_table)
and then do the following with a person:
for n in a_person.phones:
print n.number, n.is_alert_number
I get inconsistent results - at times just about anything can change -
usually the results are right but about one time in three the
is_alert_number is wrong, and occasionally not all the numbers are
listed or the order changes. Removing the "order_by" seems to fix
things.
I've looked through the bug list on Trac, and I've looked through the
group and nothing like this has jumped out at me. Are you interested
and should I try to get a real simplified test case?
cheers,
Geoff
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---
