a simplified test case would help, also turn on your sql echoing and
take a look at what SQL its generating. also older versions of
sqlite have some order by strangeness going on so thats something to
keep in mind too.
On Oct 17, 2006, at 3:07 PM, GeoffL wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
