Enable macro and plugin developers to use REGEXP on all database backends
|Reported by:||Owned by:|
It would be most helpful to allow plugin developers to query the trac database by also using regular expressions. The reason for that is, that LIKE cannot be used to narrow down search results based on for example character classes and so on.
While mysql and postgresql natively support REGEXPs in different ways, sqlite requires a user function to be created before that any queries using REGEXP to the database can be send.
In the attached archive you find new versions of the database backends that will add regexp(), regexpi(), not_regexp() and a not_regexpi() helpers to the connection wrappers.
In addition, the sqlite_backend's connection wrapper will now register a regexp() user function with the wrapped connection.