Hi there,
I have a mysql database that I use on several linux boxes.
No I get the following error on on of them:
Traceback (most recent call last):
File "../bin/zopepy", line 317, in <module>
execfile(__file__)
File "t.py", line 38, in <module>
BaseA.metadata.reflect(local_engine_a)
File
"/home/zope/key2go/eggs/SQLAlchemy-0.9.2-py2.6-linux-i686.egg/sqlalchemy/sql/schema.py",
line 3268, in reflect
Table(name, self, **reflect_opts)
File
"/home/zope/key2go/eggs/SQLAlchemy-0.9.2-py2.6-linux-i686.egg/sqlalchemy/sql/schema.py",
line 350, in __new__
table._init(name, metadata, *args, **kw)
File
"/home/zope/key2go/eggs/SQLAlchemy-0.9.2-py2.6-linux-i686.egg/sqlalchemy/sql/schema.py",
line 423, in _init
self._autoload(metadata, autoload_with, include_columns)
File
"/home/zope/key2go/eggs/SQLAlchemy-0.9.2-py2.6-linux-i686.egg/sqlalchemy/sql/schema.py",
line 435, in _autoload
self, include_columns, exclude_columns
File
"/home/zope/key2go/eggs/SQLAlchemy-0.9.2-py2.6-linux-i686.egg/sqlalchemy/engine/base.py",
line 1160, in run_callable
return callable_(self, *args, **kwargs)
File
"/home/zope/key2go/eggs/SQLAlchemy-0.9.2-py2.6-linux-i686.egg/sqlalchemy/engine/default.py",
line 345, in reflecttable
return insp.reflecttable(table, include_columns, exclude_columns)
File
"/home/zope/key2go/eggs/SQLAlchemy-0.9.2-py2.6-linux-i686.egg/sqlalchemy/engine/reflection.py",
line 463, in reflecttable
for col_d in self.get_columns(table_name, schema,
**table.dialect_kwargs):
TypeError: get_columns() keywords must be strings
this is the testscript I use to create the error:
from sqlalchemy import create_engine
from sqlalchemy.dialects import mysql
import sys
infoa = {
'username' : 'root',
'pw' : '',
'host' :'localhost',
'drivername' : 'mysql',
'database' : 'energie_2',
'extra_param' : ''
}
LOCAL_DSN_A
="%(drivername)s://%(username)s@%(host)s/%(database)s?charset=utf8%(extra_param)s"
% infoa
local_engine_a = create_engine(LOCAL_DSN_A)
BaseA.metadata.reflect(local_engine_a)
thanks for your help
and thanks for a wonderful library.
robert
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.