summaryrefslogtreecommitdiff
authorzecke <zecke>2002-08-28 14:21:38 (UTC)
committer zecke <zecke>2002-08-28 14:21:38 (UTC)
commitb75e41eb899534999c4483c2357310c1d6f681c9 (patch) (unidiff)
tree45780b2f93d27283c538e03dc97b49e61a407b55
parent3d62bcb5570fc7b6221ce68d39735690f33a0fe0 (diff)
downloadopie-b75e41eb899534999c4483c2357310c1d6f681c9.zip
opie-b75e41eb899534999c4483c2357310c1d6f681c9.tar.gz
opie-b75e41eb899534999c4483c2357310c1d6f681c9.tar.bz2
Hehe the SQLite driver was missing
Diffstat (more/less context) (ignore whitespace changes)
-rw-r--r--libsql/osqlitedriver.cpp126
1 files changed, 126 insertions, 0 deletions
diff --git a/libsql/osqlitedriver.cpp b/libsql/osqlitedriver.cpp
new file mode 100644
index 0000000..9214ad3
--- a/dev/null
+++ b/libsql/osqlitedriver.cpp
@@ -0,0 +1,126 @@
1#include <stdlib.h>
2
3#include "osqlresult.h"
4#include "osqlquery.h"
5#include "osqlitedriver.h"
6
7
8namespace {
9 struct Query {
10 OSQLError::ValueList errors;
11 OSQLResultItem::ValueList items;
12 OSQLiteDriver *driver;
13 };
14}
15
16OSQLiteDriver::OSQLiteDriver( QLibrary *lib )
17 : OSQLDriver( lib )
18{
19 m_sqlite = 0l;
20}
21OSQLiteDriver::~OSQLiteDriver() {
22 close();
23}
24
25QString OSQLiteDriver::id()const {
26 return QString::fromLatin1("SQLite");
27}
28
29void OSQLiteDriver::setUserName( const QString& ) {}
30void OSQLiteDriver::setPassword( const QString& ) {}
31
32void OSQLiteDriver::setUrl( const QString& url ) {
33 m_url = url;
34}
35void OSQLiteDriver::setOptions( const QStringList& ) {
36}
37/*
38 * try to open a db specified via setUrl
39 * and options
40 */
41bool OSQLiteDriver::open() {
42 char *error;
43 qWarning("about to open");
44 m_sqlite = sqlite_open(m_url.local8Bit(),
45 0,
46 &error );
47
48 /* failed to open */
49 if (m_sqlite == 0l ) {
50 // FIXME set the last error
51 qWarning("error:%s", error );
52 free( error );
53 return false;
54 }
55 return true;
56}
57/* close the db
58 * sqlite closes them without
59 * telling failure or success
60 */
61bool OSQLiteDriver::close() {
62 if (m_sqlite )
63 sqlite_close( m_sqlite ), m_sqlite=0l;
64
65 return true;
66}
67/* Query */
68OSQLResult OSQLiteDriver::query( OSQLQuery* qu) {
69 if ( !m_sqlite ) {
70 // FIXME set error code
71 OSQLResult result( OSQLResult::Failure );
72 return result;
73 }
74 Query query;
75 query.driver = this;
76 char *err;
77 /* SQLITE_OK 0 if return code > 0 == failure */
78 if ( sqlite_exec(m_sqlite, qu->query(),&call_back, &query, &err) > 0 ) {
79 qWarning("Error while executing");
80 free(err );
81 // FixMe Errors
82 }
83 qWarning("Item count is %d", query.items.count() );
84 OSQLResult result(OSQLResult::Success,
85 query.items,
86 query.errors );
87 return result;
88}
89OSQLTable::ValueList OSQLiteDriver::tables() const {
90
91}
92OSQLError OSQLiteDriver::lastError() {
93 OSQLError error;
94 return error;
95};
96/* handle a callback add the row to the global
97 * OSQLResultItem
98 */
99int OSQLiteDriver::handleCallBack( int, char**, char** ) {
100 return 0;
101}
102/* callback_handler add the values to the list*/
103int OSQLiteDriver::call_back( void* voi, int argc,
104 char** argv, char** columns) {
105 qWarning("Callback with %d items", argc );
106 Query* qu = (Query*)voi;
107
108 //copy them over to a OSQLResultItem
109 QMap<QString, QString> tableString;
110 QMap<int, QString> tableInt;
111 for (int i = 0; i < argc; i++ ) {
112 qWarning("%s|%s", columns[i], argv[i] );
113 tableInt.insert( i, QString::fromLocal8Bit(argv[i] ) );
114 tableString.insert( QString::fromLocal8Bit( columns[i]),
115 QString::fromLocal8Bit( argv[i] ) );
116
117 }
118 OSQLResultItem item( tableString, tableInt );
119 qu->items.append( item );
120
121 return ((Query*)voi)->driver->handleCallBack( argc,
122 argv,
123 columns );
124
125
126}