On 10/18/07, Markus Gritsch <[EMAIL PROTECTED]> wrote:
> 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 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 -~----------~----~----~----~------~----~------~--~---
ActivityRecording.db3
Description: Binary data
