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