-rw-r--r-- | libopie2/opiedb/osqlitedriver.cpp | 8 | ||||
-rw-r--r-- | libopie2/opiedb/osqlitedriver.h | 3 |
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,109 +1,109 @@ | |||
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 | ||
44 | using namespace Opie::DB; | 43 | namespace Opie { |
45 | using namespace Opie::DB::Internal; | 44 | namespace DB { |
45 | namespace Internal { | ||
46 | 46 | ||
47 | namespace { | 47 | namespace { |
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 | ||
56 | OSQLiteDriver::OSQLiteDriver( QLibrary *lib ) | 56 | OSQLiteDriver::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 | ||
63 | OSQLiteDriver::~OSQLiteDriver() { | 63 | OSQLiteDriver::~OSQLiteDriver() { |
64 | close(); | 64 | close(); |
65 | } | 65 | } |
66 | 66 | ||
67 | 67 | ||
68 | QString OSQLiteDriver::id()const { | 68 | QString OSQLiteDriver::id()const { |
69 | return QString::fromLatin1("SQLite"); | 69 | return QString::fromLatin1("SQLite"); |
70 | } | 70 | } |
71 | 71 | ||
72 | void OSQLiteDriver::setUserName( const QString& ) {} | 72 | void OSQLiteDriver::setUserName( const QString& ) {} |
73 | 73 | ||
74 | 74 | ||
75 | void OSQLiteDriver::setPassword( const QString& ) {} | 75 | void OSQLiteDriver::setPassword( const QString& ) {} |
76 | 76 | ||
77 | 77 | ||
78 | void OSQLiteDriver::setUrl( const QString& url ) { | 78 | void OSQLiteDriver::setUrl( const QString& url ) { |
79 | m_url = url; | 79 | m_url = url; |
80 | } | 80 | } |
81 | 81 | ||
82 | 82 | ||
83 | void OSQLiteDriver::setOptions( const QStringList& ) { | 83 | void 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 | */ |
89 | int sqliteRlikeCompare(const char *zPattern, const char *zString, sqregex *reg){ | 89 | int 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(®->regex_c); | 95 | regfree(®->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(®->regex_c, zPattern, REG_EXTENDED); | 99 | res = regcomp(®->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(®->regex_c, zString, 0, NULL, 0)==0); | 107 | res = (regexec(®->regex_c, zString, 0, NULL, 0)==0); |
108 | return res; | 108 | return res; |
109 | } | 109 | } |
@@ -168,64 +168,66 @@ OSQLResult OSQLiteDriver::query( OSQLQuery* qu) { | |||
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 | ||
184 | OSQLTable::ValueList OSQLiteDriver::tables() const { | 184 | OSQLTable::ValueList OSQLiteDriver::tables() const { |
185 | 185 | ||
186 | } | 186 | } |
187 | 187 | ||
188 | 188 | ||
189 | OSQLError OSQLiteDriver::lastError() { | 189 | OSQLError 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 | */ |
198 | int OSQLiteDriver::handleCallBack( int, char**, char** ) { | 198 | int 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*/ |
204 | int OSQLiteDriver::call_back( void* voi, int argc, | 204 | int 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 | ||
14 | namespace Opie { | 17 | namespace Opie { |
15 | namespace DB { | 18 | namespace DB { |
16 | namespace Internal { | 19 | namespace Internal { |
17 | 20 | ||
18 | struct sqregex { | 21 | struct sqregex { |
19 | char *regex_raw; | 22 | char *regex_raw; |
20 | regex_t regex_c; | 23 | regex_t regex_c; |
21 | }; | 24 | }; |
22 | 25 | ||
23 | class OSQLiteDriver : public OSQLDriver { | 26 | class OSQLiteDriver : public OSQLDriver { |
24 | Q_OBJECT | 27 | Q_OBJECT |
25 | public: | 28 | public: |
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 | ||
39 | private: | 42 | private: |
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 |