Add REGEXP support to SQL queries

[david.l.jones@…]

SQLite allows the use of a REGEXP search [1]. Such a feature would be useful in cases such as parsing multiple CCs, multiple asignees on a ticket [2], etc. All that has to be done is to create a user function on the connection [3].

I've attached a diff of what (I think) will enable this (I am using r3406 currently). The patch will add a user function in SQLite immediately after the connection is made. The user function is called regexp. (See trac_sqlite_regexp_r3406.patch​)

References:

1. ​http://www.sqlite.org/lang_expr.html: What is currently allowed in SQLite expressions
2. #2662: Using REGEXP in SQLite to parse multi-user assignments
3. ​http://initd.org/pub/software/pysqlite/doc/usage-guide.html#creating-user-defined-functions pysqlite documentation to add a user-defined function

[david.l.jones@…]

Adding regexp to the SQLite connection

[anonymous]

Do not forget to catch some exceptions ​http://initd.org/tracker/pysqlite/wiki/SnippetsRegexp

[Christian Boos]

Since ​PostgreSQL and ​MySQL both have native support for regular expressions, we could indeed add this capability to the SQLite backend.

[david.l.jones@…]

Although this would be useful for some specific back end parts, this would probably be most useful for adding to search, especially when searching changesets.

[Carsten Klein <carsten.klein@…>]

see also #8914 for a patch. however, #8914 is definitely a duplicate of this.

[Carsten Klein <carsten.klein@…>]

I have ported the patch to the latest trunk available at github.com.

You can find it under ​https://github.com/axnsoftware/trac-bugs-n-features/tree/trac-issue-3273

Feel free to further test it. I originally tested it with sqlite. It would be nice, if you could test this with postgresql and mysql, if you happen to use use a db backend.