map_to() was added in 0.6.6
On Jun 12, 2011, at 11:51 PM, Reece wrote: > Thanks, Michael. > > I'm getting further, but still have an error that I've not been able to > resolve. > > from sqlalchemy.ext.sqlsoup import SqlSoup > from sqlalchemy import Table > u = SqlSoup('postgresql+psycopg2://pub...@unison-db.org:5432/unison') > t = Table("pseqalias", u._metadata, autoload=True, schema='unison') > u.map_to('pseqalias', schema='unison', selectable=t, > mapper_args={"primary_key":[t.c.pannotation_id]}) > > For which I get: > File "/usr/lib/python2.7/dist-packages/sqlalchemy/ext/sqlsoup.py", line 558, > in __getattr__ > return self.entity(attr) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/ext/sqlsoup.py", line 547, > in entity > table = Table(attr, self._metadata, autoload=True, > autoload_with=self.bind, schema=schema or self.schema) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/schema.py", line 209, in > __new__ > table._init(name, metadata, *args, **kw) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/schema.py", line 257, in > _init > include_columns=include_columns) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1866, > in reflecttable > self.dialect.reflecttable(conn, table, include_columns) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line > 228, in reflecttable > return insp.reflecttable(table, include_columns) > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", line > 376, in reflecttable > for col_d in self.get_columns(table_name, schema, **tblkw): > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", line > 223, in get_columns > **kw) > File "<string>", line 1, in <lambda> > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", > line 40, in cache > ret = fn(self, con, *args, **kw) > File > "/usr/lib/python2.7/dist-packages/sqlalchemy/dialects/postgresql/base.py", > line 962, in get_columns > info_cache=kw.get('info_cache')) > File "<string>", line 1, in <lambda> > File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", > line 40, in cache > ret = fn(self, con, *args, **kw) > File > "/usr/lib/python2.7/dist-packages/sqlalchemy/dialects/postgresql/base.py", > line 876, in get_table_oid > raise exc.NoSuchTableError(table_name) > sqlalchemy.exc.NoSuchTableError: map_to > > This is SqlAlchemy 0.6.4. I'll try 0.7.1 shortly. I'd appreciate for any idea > you have. > > This database makes heavy use of views. I'd be very interested in any > suggestions you have for adding support for reflection of views. > > Thanks, > Reece > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/sqlalchemy/-/1zGXKGrrIhYJ. > 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.