summaryrefslogtreecommitdiff
authorbrad <brad>2004-04-05 10:58:32 (UTC)
committer brad <brad>2004-04-05 10:58:32 (UTC)
commit0b481957a2eebf28b05d9803780d05ad4232aa00 (patch) (unidiff)
tree85b6b3123f8bbb86a79806ab07d9189c041730ce
parent900fb3d498891d9aca81c362b2ea3460d1dc3f59 (diff)
downloadopie-0b481957a2eebf28b05d9803780d05ad4232aa00.zip
opie-0b481957a2eebf28b05d9803780d05ad4232aa00.tar.gz
opie-0b481957a2eebf28b05d9803780d05ad4232aa00.tar.bz2
Regex support for sqlite (finally)
Diffstat (more/less context) (ignore whitespace changes)
-rw-r--r--libopie2/opiedb/osqlitedriver.cpp30
1 files changed, 30 insertions, 0 deletions
diff --git a/libopie2/opiedb/osqlitedriver.cpp b/libopie2/opiedb/osqlitedriver.cpp
index 2c53248..eea1093 100644
--- a/libopie2/opiedb/osqlitedriver.cpp
+++ b/libopie2/opiedb/osqlitedriver.cpp
@@ -36,2 +36,4 @@
36#include <stdlib.h> 36#include <stdlib.h>
37#include <regex.h>
38#include <stdio.h>
37 39
@@ -84,2 +86,29 @@ void OSQLiteDriver::setOptions( const QStringList& ) {
84 86
87/*------------------------------------------------------------------/*
88 * Functions to patch a regex search into sqlite
89 * -----------------------------------------------------------------*/
90int sqliteRlikeCompare(const char *zPattern, const char *zString){
91 regex_t regex;
92 int res;
93 if ( zPattern==NULL || zString==NULL ) {
94 printf("One of the args was null!\n");
95 return 0;
96 }
97 res = regcomp(&regex, zPattern, REG_EXTENDED);
98 if ( res != 0 ) {
99 printf("Regcomp failed with code %u on string %s\n",res,zPattern);
100
101 return 0;
102 }
103 res = (regexec(&regex, zString, 0, NULL, 0)==0);
104 regfree(&regex);
105 return res;
106}
107
108void rlikeFunc(sqlite_func *context, int arg, const char **argv){
109 if( argv[0]==0 || argv[1]==0 ) return;
110 sqlite_set_result_int(context,
111 sqliteRlikeCompare((const char*)argv[0],
112 (const char*)argv[1]));
113}
85 114
@@ -103,2 +132,3 @@ bool OSQLiteDriver::open() {
103 } 132 }
133 sqlite_create_function(m_sqlite,"rlike",2,rlikeFunc,NULL);
104 return true; 134 return true;