through very little effort of my own, people are adding new reflective capabilities to the dialects all the time since there's apparently a need for people to write various toolkits and such based on schema definitions. Randall Smith is working on a huge branch for reflection that will up the capabilities by a wide margin. So various "I couldn't reflect XYZ warnings" are probably going to become more commonplace, with the main thing to keep in mind that they're only warnings. You can of course control the emission of warnings with a high degree of granularity by using the Python warning filter.
On Jan 6, 2009, at 6:25 PM, David Gardner wrote: > > I got a new warning with 0.5.0 that I didn't receive with 0.5rc4 > > /users/dgardner/dev/lib/python2.5/site-packages/SQLAlchemy-0.5.0- > py2.5.egg/sqlalchemy/engine/base.py:1265: > SAWarning: Skipped unsupported reflection of expression-based index > not_done_idx > self.dialect.reflecttable(conn, table, include_columns) > > It's complaining about this index: > > CREATE INDEX not_done_idx > ON task > USING btree > ((state <> 'Approved'::text)); > > > Which I think is weird, since SA doesn't really need to be aware of > non-PK indexes, its just something to speed up some common queries. > Can > I disable this warning? > I am autoloading it: > > task_table = Table('task', metadata, autoload=True) > mapper(Task,task_table, properties={ > 'Notes':relation(Note,secondary=note_task_table, > order_by=note_table.c.updated.desc(), backref='Tasks'), > 'State':relation(TaskState), > 'Group':relation(Group, lazy=True)}, > save_on_init=False) > > -- > David Gardner > Pipeline Tools Programmer, "Sid the Science Kid" > Jim Henson Creature Shop > dgard...@creatureshop.com > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---