#3273: Add REGEXP support to SQL queries
-------------------------------------+--------------------------------------
Reporter: [EMAIL PROTECTED] | 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/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
