Hi,
when running the script
#---
from sqlalchemy import create_engine, MetaData, Table
engine = create_engine('sqlite:///ActivityRecording.db3', echo=True)
metadata = MetaData()
metadata.bind = engine
act = Table('act', metadata, autoload=True)
print [c.name for c in act.columns]
#---
against the attached database (which was created by SQLObject), the
following traceback is shown:
C:\Python25\lib\site-packages\sqlalchemy\databases\sqlite.py:276:
RuntimeWarning: Did not recognize type 'DECIMAL' of column
'hourly_rate'
warnings.warn(RuntimeWarning("Did not recognize type '%s' of column
'%s'" % (coltype, name)))
Traceback (most recent call last):
File "sepp2.py", line 9, in <module>
act = Table('act', metadata, autoload=True)
File "C:\Python25\lib\site-packages\sqlalchemy\schema.py", line 114,
in __call__
metadata._get_bind(raiseerr=True).reflecttable(table,
include_columns=include_columns)
File "C:\Python25\lib\site-packages\sqlalchemy\engine\base.py", line
1178, in reflecttable
self.dialect.reflecttable(conn, table, include_columns)
File "C:\Python25\lib\site-packages\sqlalchemy\databases\sqlite.py",
line 281, in reflecttable
coltype = coltype(*[int(a) for a in args])
TypeError: 'NullType' object is not callable
It runs fine when I try to pull the table definition for the same
schema from a MySQL backend.
Kind regards,
Markus
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---