summaryrefslogtreecommitdiff
authorbrad <brad>2004-04-05 19:24:04 (UTC)
committer brad <brad>2004-04-05 19:24:04 (UTC)
commitcb3097d5249b6bd576d0212394ab57e885f9e9da (patch) (unidiff)
treef4a25035e43804507bb69d30da5b735082a1e0df
parent35c73e46c62f60596037c85a5545e13e4488b81f (diff)
downloadopie-cb3097d5249b6bd576d0212394ab57e885f9e9da.zip
opie-cb3097d5249b6bd576d0212394ab57e885f9e9da.tar.gz
opie-cb3097d5249b6bd576d0212394ab57e885f9e9da.tar.bz2
*Basic* regex caching for massive search speedup (and I mean lots)
Yes, it's ugly. Yes, it's simple. Yes it probably breaks several fundamental coding rules. Yes, I'm open to suggestions as to how to do it better and more in the Opie way.
Diffstat (more/less context) (ignore whitespace changes)
-rw-r--r--libopie2/opiedb/osqlitedriver.cpp35
1 files changed, 21 insertions, 14 deletions
diff --git a/libopie2/opiedb/osqlitedriver.cpp b/libopie2/opiedb/osqlitedriver.cpp
index eea1093..4eda9b9 100644
--- a/libopie2/opiedb/osqlitedriver.cpp
+++ b/libopie2/opiedb/osqlitedriver.cpp
@@ -38,12 +38,14 @@
38#include <stdio.h> 38#include <stdio.h>
39 39
40// fromLocal8Bit() does not work as expected. Thus it 40// fromLocal8Bit() does not work as expected. Thus it
41// is replaced by fromLatin1() (eilers) 41// is replaced by fromLatin1() (eilers)
42#define __BUGGY_LOCAL8BIT_ 42#define __BUGGY_LOCAL8BIT_
43 43
44 char *regex_raw;
45 regex_t regex_c;
44 46
45using namespace Opie::DB; 47using namespace Opie::DB;
46using namespace Opie::DB::Internal; 48using namespace Opie::DB::Internal;
47 49
48namespace { 50namespace {
49 struct Query { 51 struct Query {
@@ -81,30 +83,33 @@ void OSQLiteDriver::setUrl( const QString& url ) {
81} 83}
82 84
83 85
84void OSQLiteDriver::setOptions( const QStringList& ) { 86void OSQLiteDriver::setOptions( const QStringList& ) {
85} 87}
86 88
87/*------------------------------------------------------------------/* 89/*
88 * Functions to patch a regex search into sqlite 90 * Functions to patch a regex search into sqlite
89 * -----------------------------------------------------------------*/ 91 */
90int sqliteRlikeCompare(const char *zPattern, const char *zString){ 92int sqliteRlikeCompare(const char *zPattern, const char *zString){
91 regex_t regex;
92 int res; 93 int res;
93 if ( zPattern==NULL || zString==NULL ) { 94 if (regex_raw == NULL || (strcmp (zPattern, regex_raw) != 0)){
94 printf("One of the args was null!\n"); 95 if (regex_raw != NULL) {
95 return 0; 96 free(regex_raw);
96 } 97 regfree(&regex_c);
97 res = regcomp(&regex, zPattern, REG_EXTENDED); 98 }
98 if ( res != 0 ) { 99 regex_raw = (char *)malloc(strlen(zPattern)+1);
99 printf("Regcomp failed with code %u on string %s\n",res,zPattern); 100 strncpy(regex_raw, zPattern, strlen(zPattern)+1);
100 101 res = regcomp(&regex_c, zPattern, REG_EXTENDED);
102 if ( res != 0 ) {
103 printf("Regcomp failed with code %u on string %s\n",res,zPattern);
104 free(regex_raw);
105 regex_raw=NULL;
101 return 0; 106 return 0;
107 }
102 } 108 }
103 res = (regexec(&regex, zString, 0, NULL, 0)==0); 109 res = (regexec(&regex_c, zString, 0, NULL, 0)==0);
104 regfree(&regex);
105 return res; 110 return res;
106} 111}
107 112
108void rlikeFunc(sqlite_func *context, int arg, const char **argv){ 113void rlikeFunc(sqlite_func *context, int arg, const char **argv){
109 if( argv[0]==0 || argv[1]==0 ) return; 114 if( argv[0]==0 || argv[1]==0 ) return;
110 sqlite_set_result_int(context, 115 sqlite_set_result_int(context,
@@ -139,13 +144,15 @@ bool OSQLiteDriver::open() {
139 * sqlite closes them without 144 * sqlite closes them without
140 * telling failure or success 145 * telling failure or success
141 */ 146 */
142bool OSQLiteDriver::close() { 147bool OSQLiteDriver::close() {
143 if (m_sqlite ) 148 if (m_sqlite )
144 sqlite_close( m_sqlite ), m_sqlite=0l; 149 sqlite_close( m_sqlite ), m_sqlite=0l;
145 150 free(regex_raw);
151 regex_raw=NULL;
152 regfree(&regex_c);
146 return true; 153 return true;
147} 154}
148 155
149 156
150/* Query */ 157/* Query */
151OSQLResult OSQLiteDriver::query( OSQLQuery* qu) { 158OSQLResult OSQLiteDriver::query( OSQLQuery* qu) {