In sqlite you can define a unique constraint without a name (and without CONSTRAINT):
CREATE TABLE foo (a int, b int, UNIQUE (a,b)); The SQLAlchemy "get_unique_constraints" doesn't pick that up, due to the regex looking for CONSTRAINT <some name> UNIQUE (columns here). What's a reasonable solution here? I'm using the (probably wrong) regular expression: '(?!CONSTRAINT \w+)? UNIQUE \(([^\)]+)\)' to identify these, parsing the same sql output that SQLAlchemy also uses. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.