that might be a bug in reflection within the sqlite dialect. make sure the bug still replicates on 0.5.4 and perhaps you can send us SQLite's pragma "table" for that table (via mailing list here or post a trac ticket as guest/guest).
On Jun 30, 2009, at 10:15 PM, Carl wrote: > > Hi, > Can anyone tell me what's I'm doing worng. The DB itself is fine I > access it via SA successfully from my web app (TG2). But, I need to > write a utility that uses it outside of the web app. > > Here is my code: > >>>> db = 'sqlite:///data/test.db' >>>> e = create_engine(db) >>>> m = MetaData(bind=e) >>>> m.reflect() > > Here is what I get: > > Traceback (most recent call last): > File "<stdin>", line 1, in <module> > File "/home/nine/server/tg2env/SQLAlchemy-0.5.1-py2.5.egg/sqlalchemy/ > schema.py", line 1702, in reflect > Table(name, self, **reflect_opts) > File "/home/nine/server/tg2env/SQLAlchemy-0.5.1-py2.5.egg/sqlalchemy/ > schema.py", line 113, in __call__ > return type.__call__(self, name, metadata, *args, **kwargs) > File "/home/nine/server/tg2env/SQLAlchemy-0.5.1-py2.5.egg/sqlalchemy/ > schema.py", line 241, in __init__ > _bind_or_error(metadata).reflecttable(self, > include_columns=include_columns) > File "/home/nine/server/tg2env/SQLAlchemy-0.5.1-py2.5.egg/sqlalchemy/ > engine/base.py", line 1265, in reflecttable > self.dialect.reflecttable(conn, table, include_columns) > File "/home/nine/server/tg2env/SQLAlchemy-0.5.1-py2.5.egg/sqlalchemy/ > databases/sqlite.py", line 493, in reflecttable > colargs.append(DefaultClause(sql.text(default))) > File "/home/nine/server/tg2env/SQLAlchemy-0.5.1-py2.5.egg/sqlalchemy/ > sql/expression.py", line 821, in text > return _TextClause(text, bind=bind, *args, **kwargs) > File "/home/nine/server/tg2env/SQLAlchemy-0.5.1-py2.5.egg/sqlalchemy/ > sql/expression.py", line 2083, in __init__ > self.text = self._bind_params_regex.sub(repl, text) > TypeError: expected string or buffer > > Thanks, Carl > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
