summaryrefslogtreecommitdiff
Unidiff
Diffstat (more/less context) (ignore whitespace changes)
-rw-r--r--libopie2/opiedb/osqlbackend.cpp2
-rw-r--r--libopie2/opiedb/osqlitedriver.cpp12
-rw-r--r--libopie2/opiedb/osqlresult.cpp2
-rw-r--r--libopie2/opiedb/osqltable.h2
4 files changed, 10 insertions, 8 deletions
diff --git a/libopie2/opiedb/osqlbackend.cpp b/libopie2/opiedb/osqlbackend.cpp
index aede7c1..5c37480 100644
--- a/libopie2/opiedb/osqlbackend.cpp
+++ b/libopie2/opiedb/osqlbackend.cpp
@@ -48,33 +48,33 @@ QString OSQLBackEnd::license() const {
48 return m_license; 48 return m_license;
49} 49}
50QCString OSQLBackEnd::library() const { 50QCString OSQLBackEnd::library() const {
51 return m_lib; 51 return m_lib;
52} 52}
53bool OSQLBackEnd::isDefault()const { 53bool OSQLBackEnd::isDefault()const {
54 return m_default; 54 return m_default;
55} 55}
56int OSQLBackEnd::preference()const { 56int OSQLBackEnd::preference()const {
57 return m_pref; 57 return m_pref;
58} 58}
59void OSQLBackEnd::setName( const QString& name ) { 59void OSQLBackEnd::setName( const QString& name ) {
60 m_name = name; 60 m_name = name;
61} 61}
62void OSQLBackEnd::setVendor( const QString& vendor ) { 62void OSQLBackEnd::setVendor( const QString& vendor ) {
63 m_vendor = vendor; 63 m_vendor = vendor;
64} 64}
65void OSQLBackEnd::setLicense( const QString & license ) { 65void OSQLBackEnd::setLicense( const QString & license ) {
66 m_license = license; 66 m_license = license;
67} 67}
68void OSQLBackEnd::setLibrary( const QCString& lib ) { 68void OSQLBackEnd::setLibrary( const QCString& lib ) {
69 m_lib = lib; 69 m_lib = lib;
70} 70}
71void OSQLBackEnd::setDefault( bool def) { 71void OSQLBackEnd::setDefault( bool def) {
72 m_default = def; 72 m_default = def;
73} 73}
74void OSQLBackEnd::setPreference( int pref ) { 74void OSQLBackEnd::setPreference( int pref ) {
75 m_pref = pref; 75 m_pref = pref;
76} 76}
77 77
78 78
79} 79}
80} \ No newline at end of file 80}
diff --git a/libopie2/opiedb/osqlitedriver.cpp b/libopie2/opiedb/osqlitedriver.cpp
index 92f89cf..c8b560f 100644
--- a/libopie2/opiedb/osqlitedriver.cpp
+++ b/libopie2/opiedb/osqlitedriver.cpp
@@ -7,66 +7,66 @@
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 <stdio.h> 37#include <stdio.h>
38 38
39namespace Opie { 39namespace Opie {
40namespace DB { 40namespace DB {
41namespace Internal { 41namespace Internal {
42 42
43namespace { 43namespace {
44 struct Query { 44 struct Query {
45 OSQLError::ValueList errors; 45 OSQLError::ValueList errors;
46 OSQLResultItem::ValueList items; 46 OSQLResultItem::ValueList items;
47 OSQLiteDriver *driver; 47 OSQLiteDriver *driver;
48 }; 48 };
49} 49}
50 50
51 51
52OSQLiteDriver::OSQLiteDriver( QLibrary *lib ) 52OSQLiteDriver::OSQLiteDriver( QLibrary *lib )
53 : OSQLDriver( lib ) 53 : OSQLDriver( lib )
54{ 54{
55 m_sqlite = 0l; 55 m_sqlite = 0l;
56} 56}
57 57
58 58
59OSQLiteDriver::~OSQLiteDriver() { 59OSQLiteDriver::~OSQLiteDriver() {
60 close(); 60 close();
61} 61}
62 62
63 63
64QString OSQLiteDriver::id()const { 64QString OSQLiteDriver::id()const {
65 return QString::fromLatin1("SQLite"); 65 return QString::fromLatin1("SQLite");
66} 66}
67 67
68void OSQLiteDriver::setUserName( const QString& ) {} 68void OSQLiteDriver::setUserName( const QString& ) {}
69 69
70 70
71void OSQLiteDriver::setPassword( const QString& ) {} 71void OSQLiteDriver::setPassword( const QString& ) {}
72 72
@@ -75,144 +75,144 @@ void OSQLiteDriver::setUrl( const QString& url ) {
75 m_url = url; 75 m_url = url;
76} 76}
77 77
78 78
79void OSQLiteDriver::setOptions( const QStringList& ) { 79void OSQLiteDriver::setOptions( const QStringList& ) {
80} 80}
81 81
82/* 82/*
83 * Functions to patch a regex search into sqlite 83 * Functions to patch a regex search into sqlite
84 */ 84 */
85int sqliteRlikeCompare(const char *zPattern, const char *zString, sqregex *reg){ 85int sqliteRlikeCompare(const char *zPattern, const char *zString, sqregex *reg){
86 int res; 86 int res;
87 if (reg->regex_raw == NULL || (strcmp (zPattern, reg->regex_raw) != 0)){ 87 if (reg->regex_raw == NULL || (strcmp (zPattern, reg->regex_raw) != 0)){
88 if (reg->regex_raw != NULL) { 88 if (reg->regex_raw != NULL) {
89 free(reg->regex_raw); 89 free(reg->regex_raw);
90 regfree(&reg->regex_c); 90 regfree(&reg->regex_c);
91 } 91 }
92 reg->regex_raw = (char *)malloc(strlen(zPattern)+1); 92 reg->regex_raw = (char *)malloc(strlen(zPattern)+1);
93 strncpy(reg->regex_raw, zPattern, strlen(zPattern)+1); 93 strncpy(reg->regex_raw, zPattern, strlen(zPattern)+1);
94 res = regcomp(&reg->regex_c, zPattern, REG_EXTENDED); 94 res = regcomp(&reg->regex_c, zPattern, REG_EXTENDED);
95 if ( res != 0 ) { 95 if ( res != 0 ) {
96 printf("Regcomp failed with code %u on string %s\n",res,zPattern); 96 printf("Regcomp failed with code %u on string %s\n",res,zPattern);
97 free(reg->regex_raw); 97 free(reg->regex_raw);
98 reg->regex_raw=NULL; 98 reg->regex_raw=NULL;
99 return 0; 99 return 0;
100 } 100 }
101 } 101 }
102 res = (regexec(&reg->regex_c, zString, 0, NULL, 0)==0); 102 res = (regexec(&reg->regex_c, zString, 0, NULL, 0)==0);
103 return res; 103 return res;
104} 104}
105 105
106void rlikeFunc(sqlite_func *context, int arg, const char **argv){ 106void rlikeFunc(sqlite_func *context, int arg, const char **argv){
107 if( argv[0]==0 || argv[1]==0 ){ 107 if( arg < 2 || argv[0]==0 || argv[1]==0 ){
108 printf("One of arguments Null!!\n"); 108 printf("One of arguments Null!!\n");
109 return; 109 return;
110 } 110 }
111 sqlite_set_result_int(context, 111 sqlite_set_result_int(context,
112 sqliteRlikeCompare((const char*)argv[0], 112 sqliteRlikeCompare((const char*)argv[0],
113 (const char*)argv[1], (sqregex *)sqlite_user_data(context) )); 113 (const char*)argv[1], (sqregex *)sqlite_user_data(context) ));
114} 114}
115 115
116/* 116/*
117 * try to open a db specified via setUrl 117 * try to open a db specified via setUrl
118 * and options 118 * and options
119 */ 119 */
120bool OSQLiteDriver::open() { 120bool OSQLiteDriver::open() {
121 char *error; 121 char *error;
122 122
123 odebug << "OSQLiteDriver::open: about to open" << oendl; 123 odebug << "OSQLiteDriver::open: about to open" << oendl;
124 m_sqlite = sqlite_open(m_url.local8Bit(), 124 m_sqlite = sqlite_open(m_url.local8Bit(),
125 0, 125 0,
126 &error ); 126 &error );
127 127
128 /* failed to open */ 128 /* failed to open */
129 if (m_sqlite == 0l ) { 129 if (m_sqlite == 0l ) {
130 // FIXME set the last error 130 // FIXME set the last error
131 owarn << "OSQLiteDriver::open: " << error << "" << oendl; 131 owarn << "OSQLiteDriver::open: " << error << "" << oendl;
132 free( error ); 132 free( error );
133 return false; 133 return false;
134 } 134 }
135 if (sqlite_create_function(m_sqlite,"rlike",2,rlikeFunc,&sqreg) != 0) 135 if (sqlite_create_function(m_sqlite,"rlike",2,rlikeFunc,&sqreg) != 0)
136 odebug << "Unable to create user defined function!" << oendl; 136 odebug << "Unable to create user defined function!" << oendl;
137 if (sqlite_function_type(m_sqlite,"rlike",SQLITE_NUMERIC) != 0) 137 if (sqlite_function_type(m_sqlite,"rlike",SQLITE_NUMERIC) != 0)
138 odebug << "Unable to set rlike function result type!" << oendl; 138 odebug << "Unable to set rlike function result type!" << oendl;
139 sqreg.regex_raw = NULL; 139 sqreg.regex_raw = NULL;
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 odebug << "Freeing regex on close" << oendl; 152 odebug << "Freeing regex on close" << oendl;
153 free(sqreg.regex_raw); 153 free(sqreg.regex_raw);
154 sqreg.regex_raw=NULL; 154 sqreg.regex_raw=NULL;
155 regfree(&sqreg.regex_c); 155 regfree(&sqreg.regex_c);
156 } 156 }
157 return true; 157 return true;
158} 158}
159 159
160 160
161/* Query */ 161/* Query */
162OSQLResult OSQLiteDriver::query( OSQLQuery* qu) { 162OSQLResult OSQLiteDriver::query( OSQLQuery* qu) {
163 if ( !m_sqlite ) { 163 if ( !m_sqlite ) {
164 // FIXME set error code 164 // FIXME set error code
165 OSQLResult result( OSQLResult::Failure ); 165 OSQLResult result( OSQLResult::Failure );
166 return result; 166 return result;
167 } 167 }
168 Query query; 168 Query query;
169 query.driver = this; 169 query.driver = this;
170 char *err; 170 char *err;
171 /* SQLITE_OK 0 if return code > 0 == failure */ 171 /* SQLITE_OK 0 if return code > 0 == failure */
172 if ( sqlite_exec(m_sqlite, qu->query().utf8(),&call_back, &query, &err) > 0 ) { 172 if ( sqlite_exec(m_sqlite, qu->query().utf8(),&call_back, &query, &err) > 0 ) {
173 owarn << "OSQLiteDriver::query: Error while executing " << err << "" << oendl; 173 owarn << "OSQLiteDriver::query: Error while executing " << err << "" << oendl;
174 free( err ); 174 free( err );
175 // FixMe Errors 175 // FixMe Errors
176 } 176 }
177 177
178 OSQLResult result(OSQLResult::Success, 178 OSQLResult result(OSQLResult::Success,
179 query.items, 179 query.items,
180 query.errors ); 180 query.errors );
181 return result; 181 return result;
182} 182}
183 183
184 184
185OSQLTable::ValueList OSQLiteDriver::tables() const { 185OSQLTable::ValueList OSQLiteDriver::tables() const {
186 186 return OSQLTable::ValueList();
187} 187}
188 188
189 189
190OSQLError OSQLiteDriver::lastError() { 190OSQLError OSQLiteDriver::lastError() {
191 OSQLError error; 191 OSQLError error;
192 return error; 192 return error;
193}; 193};
194 194
195 195
196/* handle a callback add the row to the global 196/* handle a callback add the row to the global
197 * OSQLResultItem 197 * OSQLResultItem
198 */ 198 */
199int OSQLiteDriver::handleCallBack( int, char**, char** ) { 199int OSQLiteDriver::handleCallBack( int, char**, char** ) {
200 return 0; 200 return 0;
201} 201}
202 202
203 203
204/* callback_handler add the values to the list*/ 204/* callback_handler add the values to the list*/
205int OSQLiteDriver::call_back( void* voi, int argc, 205int OSQLiteDriver::call_back( void* voi, int argc,
206 char** argv, char** columns) { 206 char** argv, char** columns) {
207 Query* qu = (Query*)voi; 207 Query* qu = (Query*)voi;
208 208
209 //copy them over to a OSQLResultItem 209 //copy them over to a OSQLResultItem
210 QMap<QString, QString> tableString; 210 QMap<QString, QString> tableString;
211 QMap<int, QString> tableInt; 211 QMap<int, QString> tableInt;
212 for (int i = 0; i < argc; i++ ) { 212 for (int i = 0; i < argc; i++ ) {
213 213
214 tableInt.insert( i, QString::fromUtf8( argv[i] ) ); 214 tableInt.insert( i, QString::fromUtf8( argv[i] ) );
215 tableString.insert( QString::fromUtf8( columns[i] ), 215 tableString.insert( QString::fromUtf8( columns[i] ),
216 QString::fromUtf8( argv[i] ) ); 216 QString::fromUtf8( argv[i] ) );
217 } 217 }
218 OSQLResultItem item( tableString, tableInt ); 218 OSQLResultItem item( tableString, tableInt );
diff --git a/libopie2/opiedb/osqlresult.cpp b/libopie2/opiedb/osqlresult.cpp
index 268ac8e..a34ab2f 100644
--- a/libopie2/opiedb/osqlresult.cpp
+++ b/libopie2/opiedb/osqlresult.cpp
@@ -42,68 +42,70 @@ QString OSQLResultItem::data( int column, bool *ok ) const {
42 TableInt::ConstIterator it = m_int.find( column ); 42 TableInt::ConstIterator it = m_int.find( column );
43 43
44 /* if found */ 44 /* if found */
45 if ( it != m_int.end() ) { 45 if ( it != m_int.end() ) {
46 if ( ok ) *ok = true; 46 if ( ok ) *ok = true;
47 return it.data(); 47 return it.data();
48 }else{ 48 }else{
49 if ( ok ) *ok = false; 49 if ( ok ) *ok = false;
50 return QString::null; 50 return QString::null;
51 } 51 }
52} 52}
53/* 53/*
54 * DateFormat is 'YYYY-MM-DD' 54 * DateFormat is 'YYYY-MM-DD'
55 */ 55 */
56QDate OSQLResultItem::dataToDate( const QString& column, bool *ok ) { 56QDate OSQLResultItem::dataToDate( const QString& column, bool *ok ) {
57 QDate date = QDate::currentDate(); 57 QDate date = QDate::currentDate();
58 QString str = data( column, ok ); 58 QString str = data( column, ok );
59 if (!str.isEmpty() ) { 59 if (!str.isEmpty() ) {
60 ;// convert 60 ;// convert
61 } 61 }
62 return date; 62 return date;
63} 63}
64QDate OSQLResultItem::dataToDate( int column, bool *ok ) { 64QDate OSQLResultItem::dataToDate( int column, bool *ok ) {
65 QDate date = QDate::currentDate(); 65 QDate date = QDate::currentDate();
66 QString str = data( column, ok ); 66 QString str = data( column, ok );
67 if (!str.isEmpty() ) { 67 if (!str.isEmpty() ) {
68 ;// convert 68 ;// convert
69 } 69 }
70 return date; 70 return date;
71 71
72} 72}
73QDateTime OSQLResultItem::dataToDateTime( const QString& column, bool *ok ) { 73QDateTime OSQLResultItem::dataToDateTime( const QString& column, bool *ok ) {
74// #FIXME xxx
74 QDateTime time = QDateTime::currentDateTime(); 75 QDateTime time = QDateTime::currentDateTime();
75 return time; 76 return time;
76} 77}
77QDateTime OSQLResultItem::dataToDateTime( int column, bool *ok ) { 78QDateTime OSQLResultItem::dataToDateTime( int column, bool *ok ) {
79// #FIXME xxx
78 QDateTime time = QDateTime::currentDateTime(); 80 QDateTime time = QDateTime::currentDateTime();
79 return time; 81 return time;
80} 82}
81 83
82OSQLResult::OSQLResult( enum State state, 84OSQLResult::OSQLResult( enum State state,
83 const OSQLResultItem::ValueList& list, 85 const OSQLResultItem::ValueList& list,
84 const OSQLError::ValueList& error ) 86 const OSQLError::ValueList& error )
85 : m_state( state ), m_list( list ), m_error( error ) 87 : m_state( state ), m_list( list ), m_error( error )
86{ 88{
87 89
88} 90}
89OSQLResult::~OSQLResult() { 91OSQLResult::~OSQLResult() {
90 92
91} 93}
92OSQLResult::State OSQLResult::state()const { 94OSQLResult::State OSQLResult::state()const {
93 return m_state; 95 return m_state;
94} 96}
95void OSQLResult::setState( OSQLResult::State state ) { 97void OSQLResult::setState( OSQLResult::State state ) {
96 m_state = state; 98 m_state = state;
97} 99}
98OSQLError::ValueList OSQLResult::errors()const { 100OSQLError::ValueList OSQLResult::errors()const {
99 return m_error; 101 return m_error;
100} 102}
101void OSQLResult::setErrors( const OSQLError::ValueList& err ) { 103void OSQLResult::setErrors( const OSQLError::ValueList& err ) {
102 m_error = err; 104 m_error = err;
103} 105}
104OSQLResultItem::ValueList OSQLResult::results()const { 106OSQLResultItem::ValueList OSQLResult::results()const {
105 return m_list; 107 return m_list;
106} 108}
107void OSQLResult::setResults( const OSQLResultItem::ValueList& result ) { 109void OSQLResult::setResults( const OSQLResultItem::ValueList& result ) {
108 m_list = result; 110 m_list = result;
109} 111}
diff --git a/libopie2/opiedb/osqltable.h b/libopie2/opiedb/osqltable.h
index 86c30dd..8dd786f 100644
--- a/libopie2/opiedb/osqltable.h
+++ b/libopie2/opiedb/osqltable.h
@@ -41,62 +41,62 @@ public:
41 ~OSQLTableItem(); 41 ~OSQLTableItem();
42 42
43 OSQLTableItem& operator=( const OSQLTableItem& ); 43 OSQLTableItem& operator=( const OSQLTableItem& );
44 44
45 /** 45 /**
46 * the fieldName 46 * the fieldName
47 */ 47 */
48 QString fieldName() const; 48 QString fieldName() const;
49 49
50 /** 50 /**
51 * the field Type 51 * the field Type
52 */ 52 */
53 Type type() const; 53 Type type() const;
54 QVariant more() const; 54 QVariant more() const;
55private: 55private:
56 class OSQLTableItemPrivate; 56 class OSQLTableItemPrivate;
57 OSQLTableItemPrivate* d; 57 OSQLTableItemPrivate* d;
58 Type m_type; 58 Type m_type;
59 QString m_field; 59 QString m_field;
60 QVariant m_var; 60 QVariant m_var;
61}; 61};
62 62
63/** 63/**
64 * A OSQLTable consists of OSQLTableItems 64 * A OSQLTable consists of OSQLTableItems
65 */ 65 */
66class OSQLTable { 66class OSQLTable {
67public: 67public:
68 typedef QValueList<OSQLTable> ValueList; 68 typedef QValueList<OSQLTable> ValueList;
69 69
70 /** 70 /**
71 * @param tableName the Name of the Table 71 * @param tableName the Name of the Table
72 */ 72 */
73 OSQLTable(const QString& tableName); 73 OSQLTable(const QString& tableName = QString::null);
74 74
75 /** 75 /**
76 * d'tor 76 * d'tor
77 */ 77 */
78 ~OSQLTable(); 78 ~OSQLTable();
79 79
80 /** 80 /**
81 * setColumns sets the Columns of the Table 81 * setColumns sets the Columns of the Table
82 */ 82 */
83 void setColumns( const OSQLTableItem::ValueList& ); 83 void setColumns( const OSQLTableItem::ValueList& );
84 84
85 /** 85 /**
86 * returns all columns of the table 86 * returns all columns of the table
87 */ 87 */
88 OSQLTableItem::ValueList columns() const; 88 OSQLTableItem::ValueList columns() const;
89 89
90 QString tableName()const; 90 QString tableName()const;
91 91
92private: 92private:
93 QString m_table; 93 QString m_table;
94 OSQLTableItem::ValueList m_list; 94 OSQLTableItem::ValueList m_list;
95 class Private; 95 class Private;
96 Private *d; 96 Private *d;
97}; 97};
98 98
99} 99}
100} 100}
101 101
102#endif 102#endif