[Trac-tickets] [The Trac Project] #3273: Add REGEXP support to SQL queries

[The Trac Project]

#3273: Add REGEXP support to SQL queries
-------------------------------------+--------------------------------------
 Reporter:  david.l.jones at gmail.com  |       Owner:  daniel       
     Type:  enhancement              |      Status:  new          
 Priority:  normal                   |   Milestone:  0.10         
Component:  report system            |     Version:  devel        
 Severity:  minor                    |    Keywords:  sqlite regexp
-------------------------------------+--------------------------------------
 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
 [attachment: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

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/3273>
The Trac Project <http://trac.edgewall.com/>