On Oct 2, 2010, at 5:30 PM, Jarrod Chesney wrote:
> Hi All
> I'm reflecting a postgresql schema and then taking a str() of the
> column types, It goes well until it hits a "double" field type.
>
> here is the str of my reflected column object:
> set: set([Column(u'ASSET_ID', DOUBLE_PRECISION(precision=53,
> asdecimal=False), table=<tbl_SITES>)])
>
> Here is the stack trace
> File "/home/jchesney/workspace_lin/rsconf/src/plugins/som/
> reconcile_schema/reconciler/objects/Column.py", line 35, in snapshot
> column_record.type = str(column.type).partition('(')[0]
> File "/home/jchesney/workspace_lin/sqlalchemy/lib/sqlalchemy/
> types.py", line 146, in __str__
> return unicode(self.compile()).encode('ascii', 'backslashreplace')
> File "/home/jchesney/workspace_lin/sqlalchemy/lib/sqlalchemy/
> types.py", line 140, in compile
> return dialect.type_compiler.process(self)
> File "/home/jchesney/workspace_lin/sqlalchemy/lib/sqlalchemy/engine/
> base.py", line 761, in process
> return type_._compiler_dispatch(self)
> File "/home/jchesney/workspace_lin/sqlalchemy/lib/sqlalchemy/sql/
> visitors.py", line 48, in _compiler_dispatch
> return getter(visitor)(self, **kw)
> AttributeError: 'GenericTypeCompiler' object has no attribute
> 'visit_DOUBLE_PRECISION'
>
>
> Is this a SQLA bug?
nope, that's not a SQL standard type so it can't be rendered to string without
a PG compiler. from sqlalchemy.dialects import postgresql;
str(type.compile(dialect=postgresql.dialect()))
--
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.
