mssql xml datatype is not recognized

When trying to load metadata SA trips up when it gets to a column with the datatype xml and aborts. Basically the way SA walks the schema you cannot autoload any DB where any related table has a xml column in it (even if it is not the table you are trying to load).

It would be acceptable to me to omit the column (with warning) or return as text.

Here is a stack trace:

../sqlalchemy/engine/reflection.py:40: SAWarning: Did not recognize type 'xml' of column 'Settings' ret = fn(self, con, args, *kw) Traceback (most recent call last): self._metadata.reflect(schema=schema) File "sqlalchemy/schema.py", line 2056, in reflect File "sqlalchemy/schema.py", line 209, in new File "sqlalchemy/schema.py", line 265, in _init File "sqlalchemy/engine/base.py", line 1866, in reflecttable File "sqlalchemy/engine/default.py", line 228, in reflecttable File "sqlalchemy/engine/reflection.py", line 436, in reflecttable File "sqlalchemy/schema.py", line 209, in new File "sqlalchemy/schema.py", line 257, in _init File "sqlalchemy/engine/base.py", line 1451, in reflecttable File "sqlalchemy/engine/base.py", line 1866, in reflecttable File "sqlalchemy/engine/default.py", line 228, in reflecttable File "sqlalchemy/engine/reflection.py", line 436, in reflecttable File "sqlalchemy/schema.py", line 209, in new File "sqlalchemy/schema.py", line 257, in _init File "sqlalchemy/engine/base.py", line 1451, in reflecttable File "sqlalchemy/engine/base.py", line 1866, in reflecttable File "sqlalchemy/engine/default.py", line 228, in reflecttable File "sqlalchemy/engine/reflection.py", line 436, in reflecttable File "sqlalchemy/schema.py", line 209, in new File "sqlalchemy/schema.py", line 257, in _init File "sqlalchemy/engine/base.py", line 1451, in reflecttable File "sqlalchemy/engine/base.py", line 1866, in reflecttable File "sqlalchemy/engine/default.py", line 228, in reflecttable File "sqlalchemy/engine/reflection.py", line 376, in reflecttable File "sqlalchemy/engine/reflection.py", line 223, in get_columns File "<string>", line 1, in <lambda> File "sqlalchemy/engine/reflection.py", line 40, in cache File "sqlalchemy/dialects/mssql/base.py", line 1211, in get_columns TypeError: issubclass() arg 1 must be a class

Comments (2)