On Feb 2, 2011, at 4:50 PM, A.M. wrote:
> Hello,
>
> I am using autoload to load some of my application metadata for views,
> however, since some information cannot be extracted from the view (such as
> the primary key) and because one UserDefinedType I am using cannot be
> recognized using reflection, I am passing certain column information into the
> Table __init__ method:
>
> Table(viewname,
> metadata,
> Column('id',Integer,primary_key=True),
> Column('acl',ACLItemArrayType,nullable=False),
> autoload=True)
>
> Unfortunately, I still get "Did not recognize type 'aclitem' of column 'acl'"
> because the column information is still trying to be reflected.
it will emit that warning when it loads the full set of columns, but your
ACLItemArrayType should be written into the Table metadata for the end result.
> Would it make sense for there to exist an option to exclude column names as
> part of table reflection and exclude those columns which are specified as
> part of Table()?
We currently have "include_columns" as a Table argument which works in the
opposite direction, "exclude_columns" is doable, but the better solution here
would be to allow you to register your new type with the dialect. You can
achieve that now through non-public API by adding PG's internal identifier for
the type plus your type to "ischema_names":
engine = create_engine('postgresql://....')
engine.dialect.ischema_names['ACLARRAY'] = ACLItemArrayType
>
> Cheers,
> M
>
> --
> 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
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
--
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
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
