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 [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
-~----------~----~----~----~------~----~------~--~---
