yes, please work this + the mappers you gave me into a small test case using sqlite:// .
On Mar 18, 2007, at 7:58 PM, Steve Zatz wrote: > > 2429 still has the problem. Below are the relevant tables and > classes: > > item_table = Table('item',metadata, > Column('id', Integer, primary_key=True), > Column('uuid', String(32), unique=True, nullable=False), > Column('parent_uuid', String(32), > ForeignKey('item.uuid'), nullable=True), > Column('priority', Integer, default=1), > Column('name',String(150)), > Column('createdate', DateTime, > default=datetime.datetime.now), > Column('finisheddate', Date), > Column('duedate', Date), > Column('note', String), > Column('section_id', Integer, ForeignKey('section.id')), > Column('timestamp', DateTime, > default=datetime.datetime.now, onupdate=datetime.datetime.now), > Column('deleted', Boolean, default=False), > ) > > section_table = Table('section', metadata, > Column('id', Integer, primary_key=True), > Column('name', String(25), unique=True, > nullable=False), > Column('timestamp', DateTime, > default=datetime.datetime.now, onupdate=datetime.datetime.now), > ) > > keyword_table = Table('keyword', metadata, > Column('uuid',String(32), primary_key=True), > Column('name', String(25), unique=True, > nullable=False), > Column('timestamp', DateTime, > default=datetime.datetime.now, onupdate=datetime.datetime.now), > Column('deleted', Boolean, default=False), > ) > > > itemkeyword_table = Table('item_keyword', metadata, > Column('item_uuid', String(32), > ForeignKey('item.uuid'), primary_key=True), > Column('keyword_uuid', String(32), > ForeignKey('keyword.uuid'), primary_key=True), > Column('display', Boolean, default=True), > Column('timestamp', DateTime, > default=datetime.datetime.now, onupdate=datetime.datetime.now), > Column('deleted', Boolean, default=False), > ) > > > class Item(object): > def __init__(self, name, uuid=None, **kw): > self.name = name > if uuid: > self.uuid = uuid > else: > self.uuid = get_uuid() > for k in kw: > setattr(self, k, kw[k]) > > def _get_age(self): > return datetime.datetime.now() - self.timestamp > > age = property(_get_age) > > def _get_keywords(self): > return [ik.keyword for ik in self.itemkeywords] > > keywords = property(_get_keywords) > > class Section(object): > def __init__(self, name): > self.name = name > > class Keyword(object): > def __init__(self, name, uuid=None): > self.name = name > if uuid: > self.uuid = uuid > else: > self.uuid = get_uuid() > > > class ItemKeyword(object): > def __init__(self, keyword=None): > if keyword: > self.keyword = keyword > > ---------------------------------------------------------------------- > ------------ > If this doesn't help, I'll try to create the smallest test case that > demonstrates the problem. > > > --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---