Thanks for the tip. I didn't know about the warning filter, but I got it
working now.
This helps alot because we have some bash scripts that do things like:
SOMEVAR=`my_app.py <args>`
Michael Bayer wrote:
> 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
>>
>>
>>
>>
>
>
> >
>
>
--
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
-~----------~----~----~----~------~----~------~--~---
