| -rw-r--r-- | libopie2/opiedb/opiedb.pro | 51 | ||||
| -rw-r--r-- | libopie2/opiedb/osqlitedriver.cpp | 69 |
2 files changed, 84 insertions, 36 deletions
diff --git a/libopie2/opiedb/opiedb.pro b/libopie2/opiedb/opiedb.pro index d869e6f..249d8b5 100644 --- a/libopie2/opiedb/opiedb.pro +++ b/libopie2/opiedb/opiedb.pro @@ -1,41 +1,36 @@ TEMPLATE = lib -#CONFIG += qt warn_on debug -CONFIG += qt warn_on release +CONFIG += qt warn_on debug DESTDIR = $(OPIEDIR)/lib -HEADERS = osqlbackend.h \ - osqldriver.h \ - osqlerror.h \ - osqlmanager.h \ - osqlquery.h \ - osqlresult.h \ - osqltable.h \ - osqlbackendmanager.h \ - osqlitedriver.h -SOURCES = osqlbackend.cpp \ - osqldriver.cpp \ - osqlerror.cpp \ - osqlmanager.cpp \ - osqlquery.cpp \ - osqlresult.cpp \ - osqltable.cpp \ - osqlbackendmanager.cpp \ - osqlitedriver.cpp +HEADERS = osqlbackend.h \ + osqldriver.h \ + osqlerror.h \ + osqlmanager.h \ + osqlquery.h \ + osqlresult.h \ + osqltable.h \ + osqlbackendmanager.h \ + osqlitedriver.h +SOURCES = osqlbackend.cpp \ + osqldriver.cpp \ + osqlerror.cpp \ + osqlmanager.cpp \ + osqlquery.cpp \ + osqlresult.cpp \ + osqltable.cpp \ + osqlbackendmanager.cpp \ + osqlitedriver.cpp INTERFACES = TARGET = opiedb2 VERSION = 1.8.2 -INCLUDEPATH += $(OPIEDIR)/include -DEPENDPATH += $(OPIEDIR)/include - -MOC_DIR = moc -OBJECTS_DIR = obj - -LIBS += -lsqlite -lqpe +INCLUDEPATH = $(OPIEDIR)/include +DEPENDPATH = $(OPIEDIR)/include +LIBS += -lsqlite -lqpe !contains( platform, x11 ) { include ( $(OPIEDIR)/include.pro ) } contains( platform, x11 ) { - LIBS += -L$(OPIEDIR)/lib -Wl,-rpath,$(OPIEDIR)/lib + LIBS += -L$(OPIEDIR)/lib -Wl,-rpath,$(OPIEDIR)/lib } diff --git a/libopie2/opiedb/osqlitedriver.cpp b/libopie2/opiedb/osqlitedriver.cpp index 99fd218..b857534 100644 --- a/libopie2/opiedb/osqlitedriver.cpp +++ b/libopie2/opiedb/osqlitedriver.cpp @@ -1,122 +1,175 @@ -#include <stdlib.h> +/* + This file is part of the Opie Project + + =. + .=l. + .>+-= + _;:, .> :=|. This program is free software; you can +.> <`_, > . <= redistribute it and/or modify it under +:`=1 )Y*s>-.-- : the terms of the GNU Library General Public +.="- .-=="i, .._ License as published by the Free Software + - . .-<_> .<> Foundation; either version 2 of the License, + ._= =} : or (at your option) any later version. + .%`+i> _;_. + .i_,=:_. -<s. This program is distributed in the hope that + + . -:. = it will be useful, but WITHOUT ANY WARRANTY; + : .. .:, . . . without even the implied warranty of + =_ + =;=|` MERCHANTABILITY or FITNESS FOR A + _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU +..}^=.= = ; Library General Public License for more +++= -. .` .: details. + : = ...= . :.=- + -. .:....=;==+<; You should have received a copy of the GNU + -_. . . )=. = Library General Public License along with + -- :-=` this library; see the file COPYING.LIB. + If not, write to the Free Software Foundation, + Inc., 59 Temple Place - Suite 330, + Boston, MA 02111-1307, USA. + +*/ #include "osqlresult.h" #include "osqlquery.h" #include "osqlitedriver.h" -// fromLocal8Bit() does not work as expected. Thus it +#include <opie2/odebug.h> + +#include <stdlib.h> + +// fromLocal8Bit() does not work as expected. Thus it // is replaced by fromLatin1() (eilers) #define __BUGGY_LOCAL8BIT_ namespace { struct Query { OSQLError::ValueList errors; OSQLResultItem::ValueList items; OSQLiteDriver *driver; }; } + OSQLiteDriver::OSQLiteDriver( QLibrary *lib ) : OSQLDriver( lib ) { m_sqlite = 0l; } + + OSQLiteDriver::~OSQLiteDriver() { close(); } + QString OSQLiteDriver::id()const { return QString::fromLatin1("SQLite"); } void OSQLiteDriver::setUserName( const QString& ) {} + + void OSQLiteDriver::setPassword( const QString& ) {} + void OSQLiteDriver::setUrl( const QString& url ) { m_url = url; } + + void OSQLiteDriver::setOptions( const QStringList& ) { } + + /* * try to open a db specified via setUrl * and options */ bool OSQLiteDriver::open() { char *error; - qWarning("about to open"); + odebug << "OSQLiteDriver::open: about to open" << oendl; m_sqlite = sqlite_open(m_url.local8Bit(), 0, &error ); /* failed to open */ if (m_sqlite == 0l ) { // FIXME set the last error - qWarning("error:%s", error ); + owarn << "OSQLiteDriver::open: " << error << oendl; free( error ); return false; } return true; } + + /* close the db * sqlite closes them without * telling failure or success */ bool OSQLiteDriver::close() { if (m_sqlite ) sqlite_close( m_sqlite ), m_sqlite=0l; return true; } + + /* Query */ OSQLResult OSQLiteDriver::query( OSQLQuery* qu) { if ( !m_sqlite ) { // FIXME set error code OSQLResult result( OSQLResult::Failure ); return result; } Query query; query.driver = this; char *err; /* SQLITE_OK 0 if return code > 0 == failure */ if ( sqlite_exec(m_sqlite, qu->query(),&call_back, &query, &err) > 0 ) { - qWarning("Error while executing"); + owarn << "OSQLiteDriver::query: Error while executing" << oendl; free(err ); // FixMe Errors } - // qWarning("Item count is %d", query.items.count() ); + OSQLResult result(OSQLResult::Success, query.items, query.errors ); return result; } + + OSQLTable::ValueList OSQLiteDriver::tables() const { } + + OSQLError OSQLiteDriver::lastError() { OSQLError error; return error; }; + + /* handle a callback add the row to the global * OSQLResultItem */ int OSQLiteDriver::handleCallBack( int, char**, char** ) { return 0; } + + /* callback_handler add the values to the list*/ int OSQLiteDriver::call_back( void* voi, int argc, char** argv, char** columns) { - // qWarning("Callback with %d items", argc ); Query* qu = (Query*)voi; //copy them over to a OSQLResultItem QMap<QString, QString> tableString; QMap<int, QString> tableInt; for (int i = 0; i < argc; i++ ) { - //qWarning("%s|%s", columns[i], argv[i] ); #ifdef __BUGGY_LOCAL8BIT_ tableInt.insert( i, QString::fromLatin1( argv[i] ) ); tableString.insert( QString::fromLatin1( columns[i] ), QString::fromLatin1( argv[i] ) ); #else |