On Dec 17, 2008, at 6:36 AM, Diez B. Roggisch wrote:
> > Hi, > > we've got some function-based indices we currently create using plain > text()-calls, like this: > > CREATE UNIQUE INDEX > users_lower_email_index > ON > user_db.users (lower(email)); > > This works, but it would be nice to stay in the SA-world even with > these > indices. > > And for schema-evolution purposes, we utilize reflection to compare > tables. > Reflection does not not include indices like the above though. Or I > missed > them? > > If not, is there a way to add that to SA, maybe through a plugin? > I'd be happy > to contribute if this is seen as valuable addition, I must add > though that > because we solely use postgres, I won't be able to add support for > anything > beyond that - but maybe others would step up to integrate other > engines. Randall Smith has been working on a schema inspection API which I believe seeks to reflect a wider variety of constructs such as indexes. His progress can be seen here: http://www.sqlalchemy.org/trac/browser/sqlalchemy/branches/reflection He was pretty active as of three weeks ago but hasn't been around lately, I can give you his email address if you want to contact him to collaborate further. Search this mailing list for a discussion about the API. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---