Regex support for sqlite (finally)

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 @@
 #include <stdlib.h>
+#include <regex.h>
+#include <stdio.h>
 
@@ -84,2 +86,29 @@ void OSQLiteDriver::setOptions( const QStringList& ) {
 
+/*------------------------------------------------------------------/*
+ * Functions to patch a regex search into sqlite
+ * -----------------------------------------------------------------*/
+int sqliteRlikeCompare(const char *zPattern, const char *zString){
+          regex_t regex;
+        int res;
+        if ( zPattern==NULL || zString==NULL ) {
+                printf("One of the args was null!\n");
+                return 0;
+        }
+        res = regcomp(&regex, zPattern, REG_EXTENDED);
+        if ( res != 0 ) {
+                printf("Regcomp failed with code %u on string %s\n",res,zPattern);
+
+                return 0;
+        }
+        res = (regexec(&regex, zString, 0, NULL, 0)==0);
+        regfree(&regex);
+        return res;
+}
+
+void rlikeFunc(sqlite_func *context, int arg, const char **argv){
+        if( argv[0]==0 || argv[1]==0 ) return;
+                sqlite_set_result_int(context,
+                sqliteRlikeCompare((const char*)argv[0],
+        (const char*)argv[1]));
+}
 
@@ -103,2 +132,3 @@ bool OSQLiteDriver::open() {
     }
+    sqlite_create_function(m_sqlite,"rlike",2,rlikeFunc,NULL);
     return true;