On Jan 10, 2013, at 9:08 AM, Przemyslaw Wegrzyn wrote: > Hi! > > Is there any plan for supporting declarative, function-based indexes? I'm > pretty sure I've seen a statement somewhere about supporting it in 0.8.x, but > can't find it at the moment. > > Right now I have to use constructs like this one: > > event.listen(Line.__table__, 'after_create', > DDL("CREATE UNIQUE INDEX idx_line_names ON lines (fk_customer_id, > UPPER(name))")) > > Indexes ignoring case seem quite popular, I find it a bit inconvenient to use > DDL() for that :) > Or perhaps there is a better (more declarative) way to do this sort of things?
it's been ticket 695 for many years and I've just attached a preliminary patch. Needs some cleanup and tests. http://www.sqlalchemy.org/trac/ticket/695#comment:6 -- 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.