Dave Harrison wrote:
> sysMessageTable = Table(
> 'sysmessage',
> Column('id', Integer, primary_key=True),
> Column('timestamp', DateTime, nullable=False,
> default=datetime.datetime.now()),
> Column('summary', String(100), nullable=False),
> Column('message', TEXT()),
> Column('viewed', Boolean, nullable=False, default=False),
>
> when I import my db.py file (literally at the time of import), I get
> this error,
>
> Traceback (most recent call last):
> File "scripts/testdata", line 7, in <module>
> from mymod.db import *
> File "./mymod/db.py", line 129, in <module>
> Column('viewed', Boolean, nullable=False, default=False),
> File
> "/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.0dev_r3150-py2.5.egg/sqlalchemy/schema.py",
> line 146, in __call__
> table = metadata.tables[key]
> AttributeError: 'Column' object has no attribute 'tables'
>
> Any suggestions ?
>
I think you need MetaData() object in your Table() declaration, like this:
meta = MetaData()
sysMessageTable = Table(
'sysmessage', meta,
Column('id', Integer, primary_key=True))
--
Paul
> Cheers
> Dave
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
