I downgraded SQLA to version 0.5.5, no luck, (Simon) what version of
python are you using?
On Oct 15, 2009, at 4:45 PM, Martijn Moeling wrote:
>
> Hi Simon/all,
>
> When I run your example i get:
>
> Traceback (most recent call last):
> File "/var/www/PyWebOs/caltst.py", line 41, in <module>
> cal = Calendar()
> File "<string>", line 4, in __init__
> File "/usr/local/lib/python2.6/site-packages/sqlalchemy/orm/
> state.py", line 71, in initialize_instance
> fn(self, instance, args, kwargs)
> File "/usr/local/lib/python2.6/site-packages/sqlalchemy/orm/
> mapper.py", line 1810, in _event_on_init
> instrumenting_mapper.compile()
> File "/usr/local/lib/python2.6/site-packages/sqlalchemy/orm/
> mapper.py", line 666, in compile
> "Message was: %s" % mapper._compile_failed)
> InvalidRequestError: One or more mappers failed to compile. Exception
> was probably suppressed within a hasattr() call. Message was: One or
> more mappers failed to compile. Exception was probably suppressed
> within a hasattr() call. Message was: One or more mappers failed to
> compile. Exception was probably suppressed within a hasattr() call.
> Message was: Could not find table 'Calendar' with which to generate a
> foreign key
>
>
> So I am starting to get the impression there is something wrong beyond
> my code.
>
> Your and my example are ruling out MySQL (or the Mysql part of
> SQLAlchemy)
>
> Now there is python 2.6.2 and SQLA version 0.5.6 on a Linux box....
> Anyone having trouble with these versions?
>
>
> Martijn
>
>
> On Oct 15, 2009, at 4:10 PM, King Simon-NFHD78 wrote:
>
>>
>> import sqlalchemy as sa
>> import sqlalchemy.orm as orm
>> from sqlalchemy.ext.declarative import declarative_base
>>
>> Base = declarative_base()
>>
>> class XProp(Base):
>> __tablename__ = "CalendarXProps"
>> Id = sa.Column(sa.Integer, primary_key=True)
>> EventId = sa.Column(sa.ForeignKey('CalendarEvents.Id'))
>> AlarmId = sa.Column(sa.ForeignKey('CalendarAlarms.Id'))
>> CalendarId = sa.Column(sa.ForeignKey('Calendars.Id'))
>> Name = sa.Column(sa.String(20))
>> Value = sa.Column(sa.String(20))
>>
>> class Event(Base):
>> __tablename__ = "CalendarEvents"
>> Id = sa.Column(sa.Integer, primary_key=True)
>> CalendarId = sa.Column(sa.ForeignKey('Calendars.Id'))
>> XProps = orm.relation(XProp, backref='Events')
>>
>> class Alarm(Base):
>> __tablename__ = "CalendarAlarms"
>> Id = sa.Column(sa.Integer, primary_key=True)
>> CalendarId = sa.Column(sa.ForeignKey('Calendars.Id'))
>> XProps = orm.relation(XProp, backref='Alarms')
>>
>> class Calendar(Base):
>> __tablename__ = "Calendars"
>> Id = sa.Column(sa.Integer, primary_key=True)
>> Events = orm.relation(Event, backref='Calendar')
>> Alarms = orm.relation(Alarm, backref='Calendar')
>> XProps = orm.relation(XProp, backref='Calendar')
>>
>> if __name__ == '__main__':
>> engine = sa.create_engine('sqlite:///')
>> Base.metadata.create_all(bind=engine)
>> Session = orm.sessionmaker(bind=engine)()
>>
>> cal = Calendar()
>> cal.Events.append(Event(XProps=[XProp(Name='Hello', Value='World'),
>> XProp(Name='foo', Value='bar')]))
>>
>>
>> Session.add(cal)
>> Session.flush()
>>
>> print cal
>> for event in cal.Events:
>> print event
>> for prop in event.XProps:
>> print prop
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
