summaryrefslogtreecommitdiff
path: root/libopie2/opiedb
authoreilers <eilers>2004-04-10 17:13:14 (UTC)
committer eilers <eilers>2004-04-10 17:13:14 (UTC)
commit096b94bf150d2f3a2ef9a26940871ee7ffa58bdf (patch) (unidiff)
treec5cab0e19edc9aed9f8367a720619532ddac669c /libopie2/opiedb
parent4113636e53922f292477ca3f97035a624cf0450b (diff)
downloadopie-096b94bf150d2f3a2ef9a26940871ee7ffa58bdf.zip
opie-096b94bf150d2f3a2ef9a26940871ee7ffa58bdf.tar.gz
opie-096b94bf150d2f3a2ef9a26940871ee7ffa58bdf.tar.bz2
Some fixes to the namespace using.
the first test implementation of regexp-search for addressbook (disabled)
Diffstat (limited to 'libopie2/opiedb') (more/less context) (ignore whitespace changes)
-rw-r--r--libopie2/opiedb/osqlitedriver.cpp8
-rw-r--r--libopie2/opiedb/osqlitedriver.h3
2 files changed, 8 insertions, 3 deletions
diff --git a/libopie2/opiedb/osqlitedriver.cpp b/libopie2/opiedb/osqlitedriver.cpp
index 3ba161e..ccac2f8 100644
--- a/libopie2/opiedb/osqlitedriver.cpp
+++ b/libopie2/opiedb/osqlitedriver.cpp
@@ -1,231 +1,233 @@
1/* 1/*
2                 This file is part of the Opie Project 2                 This file is part of the Opie Project
3 3
4 =. 4 =.
5 .=l. 5 .=l.
6           .>+-= 6           .>+-=
7 _;:,     .>    :=|. This program is free software; you can 7 _;:,     .>    :=|. This program is free software; you can
8.> <`_,   >  .   <= redistribute it and/or modify it under 8.> <`_,   >  .   <= redistribute it and/or modify it under
9:`=1 )Y*s>-.--   : the terms of the GNU Library General Public 9:`=1 )Y*s>-.--   : the terms of the GNU Library General Public
10.="- .-=="i,     .._ License as published by the Free Software 10.="- .-=="i,     .._ License as published by the Free Software
11 - .   .-<_>     .<> Foundation; either version 2 of the License, 11 - .   .-<_>     .<> Foundation; either version 2 of the License,
12     ._= =}       : or (at your option) any later version. 12     ._= =}       : or (at your option) any later version.
13    .%`+i>       _;_. 13    .%`+i>       _;_.
14    .i_,=:_.      -<s. This program is distributed in the hope that 14    .i_,=:_.      -<s. This program is distributed in the hope that
15     +  .  -:.       = it will be useful, but WITHOUT ANY WARRANTY; 15     +  .  -:.       = it will be useful, but WITHOUT ANY WARRANTY;
16    : ..    .:,     . . . without even the implied warranty of 16    : ..    .:,     . . . without even the implied warranty of
17    =_        +     =;=|` MERCHANTABILITY or FITNESS FOR A 17    =_        +     =;=|` MERCHANTABILITY or FITNESS FOR A
18  _.=:.       :    :=>`: PARTICULAR PURPOSE. See the GNU 18  _.=:.       :    :=>`: PARTICULAR PURPOSE. See the GNU
19..}^=.=       =       ; Library General Public License for more 19..}^=.=       =       ; Library General Public License for more
20++=   -.     .`     .: details. 20++=   -.     .`     .: details.
21 :     =  ...= . :.=- 21 :     =  ...= . :.=-
22 -.   .:....=;==+<; You should have received a copy of the GNU 22 -.   .:....=;==+<; You should have received a copy of the GNU
23  -_. . .   )=.  = Library General Public License along with 23  -_. . .   )=.  = Library General Public License along with
24    --        :-=` this library; see the file COPYING.LIB. 24    --        :-=` this library; see the file COPYING.LIB.
25 If not, write to the Free Software Foundation, 25 If not, write to the Free Software Foundation,
26 Inc., 59 Temple Place - Suite 330, 26 Inc., 59 Temple Place - Suite 330,
27 Boston, MA 02111-1307, USA. 27 Boston, MA 02111-1307, USA.
28 28
29*/ 29*/
30 30
31#include "osqlquery.h" 31#include "osqlquery.h"
32#include "osqlitedriver.h" 32#include "osqlitedriver.h"
33 33
34#include <opie2/odebug.h> 34#include <opie2/odebug.h>
35 35
36#include <stdlib.h> 36#include <stdlib.h>
37#include <regex.h>
38#include <stdio.h> 37#include <stdio.h>
39 38
40// fromLocal8Bit() does not work as expected. Thus it 39// fromLocal8Bit() does not work as expected. Thus it
41// is replaced by fromLatin1() (eilers) 40// is replaced by fromLatin1() (eilers)
42#define __BUGGY_LOCAL8BIT_ 41#define __BUGGY_LOCAL8BIT_
43 42
44using namespace Opie::DB; 43namespace Opie {
45using namespace Opie::DB::Internal; 44namespace DB {
45namespace Internal {
46 46
47namespace { 47namespace {
48 struct Query { 48 struct Query {
49 OSQLError::ValueList errors; 49 OSQLError::ValueList errors;
50 OSQLResultItem::ValueList items; 50 OSQLResultItem::ValueList items;
51 OSQLiteDriver *driver; 51 OSQLiteDriver *driver;
52 }; 52 };
53} 53}
54 54
55 55
56OSQLiteDriver::OSQLiteDriver( QLibrary *lib ) 56OSQLiteDriver::OSQLiteDriver( QLibrary *lib )
57 : OSQLDriver( lib ) 57 : OSQLDriver( lib )
58{ 58{
59 m_sqlite = 0l; 59 m_sqlite = 0l;
60} 60}
61 61
62 62
63OSQLiteDriver::~OSQLiteDriver() { 63OSQLiteDriver::~OSQLiteDriver() {
64 close(); 64 close();
65} 65}
66 66
67 67
68QString OSQLiteDriver::id()const { 68QString OSQLiteDriver::id()const {
69 return QString::fromLatin1("SQLite"); 69 return QString::fromLatin1("SQLite");
70} 70}
71 71
72void OSQLiteDriver::setUserName( const QString& ) {} 72void OSQLiteDriver::setUserName( const QString& ) {}
73 73
74 74
75void OSQLiteDriver::setPassword( const QString& ) {} 75void OSQLiteDriver::setPassword( const QString& ) {}
76 76
77 77
78void OSQLiteDriver::setUrl( const QString& url ) { 78void OSQLiteDriver::setUrl( const QString& url ) {
79 m_url = url; 79 m_url = url;
80} 80}
81 81
82 82
83void OSQLiteDriver::setOptions( const QStringList& ) { 83void OSQLiteDriver::setOptions( const QStringList& ) {
84} 84}
85 85
86/* 86/*
87 * Functions to patch a regex search into sqlite 87 * Functions to patch a regex search into sqlite
88 */ 88 */
89int sqliteRlikeCompare(const char *zPattern, const char *zString, sqregex *reg){ 89int sqliteRlikeCompare(const char *zPattern, const char *zString, sqregex *reg){
90 int res; 90 int res;
91 91
92 if (reg->regex_raw == NULL || (strcmp (zPattern, reg->regex_raw) != 0)){ 92 if (reg->regex_raw == NULL || (strcmp (zPattern, reg->regex_raw) != 0)){
93 if (reg->regex_raw != NULL) { 93 if (reg->regex_raw != NULL) {
94 free(reg->regex_raw); 94 free(reg->regex_raw);
95 regfree(&reg->regex_c); 95 regfree(&reg->regex_c);
96 } 96 }
97 reg->regex_raw = (char *)malloc(strlen(zPattern)+1); 97 reg->regex_raw = (char *)malloc(strlen(zPattern)+1);
98 strncpy(reg->regex_raw, zPattern, strlen(zPattern)+1); 98 strncpy(reg->regex_raw, zPattern, strlen(zPattern)+1);
99 res = regcomp(&reg->regex_c, zPattern, REG_EXTENDED); 99 res = regcomp(&reg->regex_c, zPattern, REG_EXTENDED);
100 if ( res != 0 ) { 100 if ( res != 0 ) {
101 printf("Regcomp failed with code %u on string %s\n",res,zPattern); 101 printf("Regcomp failed with code %u on string %s\n",res,zPattern);
102 free(reg->regex_raw); 102 free(reg->regex_raw);
103 reg->regex_raw=NULL; 103 reg->regex_raw=NULL;
104 return 0; 104 return 0;
105 } 105 }
106 } 106 }
107 res = (regexec(&reg->regex_c, zString, 0, NULL, 0)==0); 107 res = (regexec(&reg->regex_c, zString, 0, NULL, 0)==0);
108 return res; 108 return res;
109} 109}
110 110
111void rlikeFunc(sqlite_func *context, int arg, const char **argv){ 111void rlikeFunc(sqlite_func *context, int arg, const char **argv){
112 if( argv[0]==0 || argv[1]==0 || argv[2]==0){ 112 if( argv[0]==0 || argv[1]==0 || argv[2]==0){
113 printf("One of arguments Null!!\n"); 113 printf("One of arguments Null!!\n");
114 return; 114 return;
115 } 115 }
116 sqlite_set_result_int(context, 116 sqlite_set_result_int(context,
117 sqliteRlikeCompare((const char*)argv[0], 117 sqliteRlikeCompare((const char*)argv[0],
118 (const char*)argv[1], (sqregex*)argv[2])); 118 (const char*)argv[1], (sqregex*)argv[2]));
119} 119}
120 120
121/* 121/*
122 * try to open a db specified via setUrl 122 * try to open a db specified via setUrl
123 * and options 123 * and options
124 */ 124 */
125bool OSQLiteDriver::open() { 125bool OSQLiteDriver::open() {
126 char *error; 126 char *error;
127 qDebug("OSQLiteDriver::open: about to open"); 127 qDebug("OSQLiteDriver::open: about to open");
128 m_sqlite = sqlite_open(m_url.local8Bit(), 128 m_sqlite = sqlite_open(m_url.local8Bit(),
129 0, 129 0,
130 &error ); 130 &error );
131 131
132 /* failed to open */ 132 /* failed to open */
133 if (m_sqlite == 0l ) { 133 if (m_sqlite == 0l ) {
134 // FIXME set the last error 134 // FIXME set the last error
135 qWarning("OSQLiteDriver::open: %s", error ); 135 qWarning("OSQLiteDriver::open: %s", error );
136 free( error ); 136 free( error );
137 return false; 137 return false;
138 } 138 }
139 sqlite_create_function(m_sqlite,"rlike",3,rlikeFunc,&sqreg); 139 sqlite_create_function(m_sqlite,"rlike",3,rlikeFunc,&sqreg);
140 return true; 140 return true;
141} 141}
142 142
143 143
144/* close the db 144/* close the db
145 * sqlite closes them without 145 * sqlite closes them without
146 * telling failure or success 146 * telling failure or success
147 */ 147 */
148bool OSQLiteDriver::close() { 148bool OSQLiteDriver::close() {
149 if (m_sqlite ) 149 if (m_sqlite )
150 sqlite_close( m_sqlite ), m_sqlite=0l; 150 sqlite_close( m_sqlite ), m_sqlite=0l;
151 if (sqreg.regex_raw != NULL){ 151 if (sqreg.regex_raw != NULL){
152 free(sqreg.regex_raw); 152 free(sqreg.regex_raw);
153 sqreg.regex_raw=NULL; 153 sqreg.regex_raw=NULL;
154 regfree(&sqreg.regex_c); 154 regfree(&sqreg.regex_c);
155 } 155 }
156 return true; 156 return true;
157} 157}
158 158
159 159
160/* Query */ 160/* Query */
161OSQLResult OSQLiteDriver::query( OSQLQuery* qu) { 161OSQLResult OSQLiteDriver::query( OSQLQuery* qu) {
162 if ( !m_sqlite ) { 162 if ( !m_sqlite ) {
163 // FIXME set error code 163 // FIXME set error code
164 OSQLResult result( OSQLResult::Failure ); 164 OSQLResult result( OSQLResult::Failure );
165 return result; 165 return result;
166 } 166 }
167 Query query; 167 Query query;
168 query.driver = this; 168 query.driver = this;
169 char *err; 169 char *err;
170 /* SQLITE_OK 0 if return code > 0 == failure */ 170 /* SQLITE_OK 0 if return code > 0 == failure */
171 if ( sqlite_exec(m_sqlite, qu->query(),&call_back, &query, &err) > 0 ) { 171 if ( sqlite_exec(m_sqlite, qu->query(),&call_back, &query, &err) > 0 ) {
172 qWarning("OSQLiteDriver::query: Error while executing"); 172 qWarning("OSQLiteDriver::query: Error while executing");
173 free(err ); 173 free(err );
174 // FixMe Errors 174 // FixMe Errors
175 } 175 }
176 176
177 OSQLResult result(OSQLResult::Success, 177 OSQLResult result(OSQLResult::Success,
178 query.items, 178 query.items,
179 query.errors ); 179 query.errors );
180 return result; 180 return result;
181} 181}
182 182
183 183
184OSQLTable::ValueList OSQLiteDriver::tables() const { 184OSQLTable::ValueList OSQLiteDriver::tables() const {
185 185
186} 186}
187 187
188 188
189OSQLError OSQLiteDriver::lastError() { 189OSQLError OSQLiteDriver::lastError() {
190 OSQLError error; 190 OSQLError error;
191 return error; 191 return error;
192}; 192};
193 193
194 194
195/* handle a callback add the row to the global 195/* handle a callback add the row to the global
196 * OSQLResultItem 196 * OSQLResultItem
197 */ 197 */
198int OSQLiteDriver::handleCallBack( int, char**, char** ) { 198int OSQLiteDriver::handleCallBack( int, char**, char** ) {
199 return 0; 199 return 0;
200} 200}
201 201
202 202
203/* callback_handler add the values to the list*/ 203/* callback_handler add the values to the list*/
204int OSQLiteDriver::call_back( void* voi, int argc, 204int OSQLiteDriver::call_back( void* voi, int argc,
205 char** argv, char** columns) { 205 char** argv, char** columns) {
206 Query* qu = (Query*)voi; 206 Query* qu = (Query*)voi;
207 207
208 //copy them over to a OSQLResultItem 208 //copy them over to a OSQLResultItem
209 QMap<QString, QString> tableString; 209 QMap<QString, QString> tableString;
210 QMap<int, QString> tableInt; 210 QMap<int, QString> tableInt;
211 for (int i = 0; i < argc; i++ ) { 211 for (int i = 0; i < argc; i++ ) {
212 212
213#ifdef __BUGGY_LOCAL8BIT_ 213#ifdef __BUGGY_LOCAL8BIT_
214 tableInt.insert( i, QString::fromLatin1( argv[i] ) ); 214 tableInt.insert( i, QString::fromLatin1( argv[i] ) );
215 tableString.insert( QString::fromLatin1( columns[i] ), 215 tableString.insert( QString::fromLatin1( columns[i] ),
216 QString::fromLatin1( argv[i] ) ); 216 QString::fromLatin1( argv[i] ) );
217#else 217#else
218 tableInt.insert( i, QString::fromLocal8Bit( argv[i] ) ); 218 tableInt.insert( i, QString::fromLocal8Bit( argv[i] ) );
219 tableString.insert( QString::fromLocal8Bit( columns[i] ), 219 tableString.insert( QString::fromLocal8Bit( columns[i] ),
220 QString::fromLocal8Bit( argv[i] ) ); 220 QString::fromLocal8Bit( argv[i] ) );
221#endif 221#endif
222 } 222 }
223 OSQLResultItem item( tableString, tableInt ); 223 OSQLResultItem item( tableString, tableInt );
224 qu->items.append( item ); 224 qu->items.append( item );
225 225
226 return ((Query*)voi)->driver->handleCallBack( argc, 226 return ((Query*)voi)->driver->handleCallBack( argc,
227 argv, 227 argv,
228 columns ); 228 columns );
229 229
230 230
231} 231}
232
233}}} // namespace OPIE::DB::Internal
diff --git a/libopie2/opiedb/osqlitedriver.h b/libopie2/opiedb/osqlitedriver.h
index d5ab224..33037b8 100644
--- a/libopie2/opiedb/osqlitedriver.h
+++ b/libopie2/opiedb/osqlitedriver.h
@@ -1,53 +1,56 @@
1#ifndef OSQL_LITE_DRIVER_H 1#ifndef OSQL_LITE_DRIVER_H
2#define OSQL_LITE_DRIVER_H 2#define OSQL_LITE_DRIVER_H
3 3
4#include <sqlite.h> 4#include <sqlite.h>
5#if defined (__GNUC__) && (__GNUC__ < 3) 5#if defined (__GNUC__) && (__GNUC__ < 3)
6#include <sys/types.h> 6#include <sys/types.h>
7#endif 7#endif
8#ifdef Q_OS_MACX
9#include <sys/types.h>
10#endif
8#include <regex.h> 11#include <regex.h>
9 12
10#include "osqldriver.h" 13#include "osqldriver.h"
11#include "osqlerror.h" 14#include "osqlerror.h"
12#include "osqlresult.h" 15#include "osqlresult.h"
13 16
14namespace Opie { 17namespace Opie {
15namespace DB { 18namespace DB {
16namespace Internal { 19namespace Internal {
17 20
18struct sqregex { 21struct sqregex {
19 char *regex_raw; 22 char *regex_raw;
20 regex_t regex_c; 23 regex_t regex_c;
21}; 24};
22 25
23class OSQLiteDriver : public OSQLDriver { 26class OSQLiteDriver : public OSQLDriver {
24 Q_OBJECT 27 Q_OBJECT
25public: 28public:
26 OSQLiteDriver( QLibrary *lib = 0l ); 29 OSQLiteDriver( QLibrary *lib = 0l );
27 ~OSQLiteDriver(); 30 ~OSQLiteDriver();
28 QString id()const; 31 QString id()const;
29 void setUserName( const QString& ); 32 void setUserName( const QString& );
30 void setPassword( const QString& ); 33 void setPassword( const QString& );
31 void setUrl( const QString& url ); 34 void setUrl( const QString& url );
32 void setOptions( const QStringList& ); 35 void setOptions( const QStringList& );
33 bool open(); 36 bool open();
34 bool close(); 37 bool close();
35 OSQLError lastError(); 38 OSQLError lastError();
36 OSQLResult query( OSQLQuery* ); 39 OSQLResult query( OSQLQuery* );
37 OSQLTable::ValueList tables()const; 40 OSQLTable::ValueList tables()const;
38 41
39private: 42private:
40 OSQLError m_lastE; 43 OSQLError m_lastE;
41 OSQLResult m_result; 44 OSQLResult m_result;
42 OSQLResultItem m_items; 45 OSQLResultItem m_items;
43 int handleCallBack( int, char**, char** ); 46 int handleCallBack( int, char**, char** );
44 static int call_back( void*, int, char**, char** ); 47 static int call_back( void*, int, char**, char** );
45 QString m_url; 48 QString m_url;
46 sqlite *m_sqlite; 49 sqlite *m_sqlite;
47 sqregex sqreg; 50 sqregex sqreg;
48}; 51};
49} 52}
50} 53}
51} 54}
52 55
53#endif 56#endif