20 files changed, 95 insertions, 6 deletions

diff --git a/libopie2/opiedb/TODO b/libopie2/opiedb/TODO
index ca04ac6..8b86187 100644
--- a/libopie2/opiedb/TODO
+++ b/libopie2/opiedb/TODO
@@ -1,9 +1,10 @@
 * something like Capabilities of a Driver
   - ROWID
   - How to declare INTEGER PRIMARY KEY
   - Abstract from implementation of some dbs
   - provides( Type::What )
+  - emit signals directly on arriving of data
   
  * OSQLDriver DriverVersion - DatabaseVersion
  * Better OSQLQueries
    - more than OSQLRawQuery
\ No newline at end of file
diff --git a/libopie2/opiedb/opiedb.pro b/libopie2/opiedb/opiedb.pro
index c773d6c..147435a 100644
--- a/libopie2/opiedb/opiedb.pro
+++ b/libopie2/opiedb/opiedb.pro
@@ -1,36 +1,36 @@
 TEMPLATE    = lib
 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
 INTERFACES  =
 TARGET      = opiedb2
-VERSION     = 1.8.2
+VERSION     = 1.9.0
 INCLUDEPATH = $(OPIEDIR)/include
 DEPENDPATH  = $(OPIEDIR)/include
 LIBS       += -lopiecore2 -lqpe -lsqlite
 
 !contains( platform, x11 ) {
   include ( $(OPIEDIR)/include.pro )
 }
 
 contains( platform, x11 ) {
   LIBS        += -L$(OPIEDIR)/lib -Wl,-rpath,$(OPIEDIR)/lib
 }
 
diff --git a/libopie2/opiedb/osqlbackend.cpp b/libopie2/opiedb/osqlbackend.cpp
index d6c39a9..6e5159f 100644
--- a/libopie2/opiedb/osqlbackend.cpp
+++ b/libopie2/opiedb/osqlbackend.cpp
@@ -1,51 +1,53 @@
 
 #include "osqlbackend.h"
 
+using namespace Opie::DB;
+
 
 OSQLBackEnd::OSQLBackEnd( const QString& name,
                           const QString& vendor,
                           const QString& license,
                           const QCString& lib )
     : m_name( name), m_vendor( vendor),  m_license( license ), m_lib( lib )
 {
     m_default = false;
     m_pref = -1;
 }
 OSQLBackEnd::OSQLBackEnd( const OSQLBackEnd& back ) {
     (*this) = back;
 }
 OSQLBackEnd::~OSQLBackEnd() {
 }
 bool OSQLBackEnd::operator==( const OSQLBackEnd& other ) {
     if ( m_pref != other.m_pref ) return false;
     if ( m_default != other.m_default ) return false;
     if ( m_name != other.m_name ) return false;
     if ( m_vendor != other.m_vendor ) return false;
     if ( m_license != other.m_license ) return false;
     if ( m_lib != other.m_lib ) return false;
 
     return true;
 }
 OSQLBackEnd &OSQLBackEnd::operator=(const OSQLBackEnd& back ) {
     m_name = back.m_name;
     m_vendor = back.m_vendor;
     m_license = back.m_license;
     m_lib = back.m_lib;
     m_pref = back.m_pref;
     m_default = back.m_default;
     return *this;
 }
 QString OSQLBackEnd::name() const {
     return m_name;
 }
 QString OSQLBackEnd::vendor() const {
     return m_vendor;
 }
 QString OSQLBackEnd::license() const {
     return m_license;
 }
 QCString OSQLBackEnd::library() const {
     return m_lib;
 }
 bool OSQLBackEnd::isDefault()const {
     return m_default;
diff --git a/libopie2/opiedb/osqlbackend.h b/libopie2/opiedb/osqlbackend.h
index ad879a4..28451b6 100644
--- a/libopie2/opiedb/osqlbackend.h
+++ b/libopie2/opiedb/osqlbackend.h
@@ -1,75 +1,83 @@
 
 #ifndef OSQL_BACKEND_H
 #define OSQL_BACKEND_H
 
 #include <qcstring.h>
 #include <qstring.h>
 #include <qvaluelist.h>
 
+
+namespace Opie {
+namespace DB {
 /**
  * OSQLBackEnd represents an available backend
  * to the Opie Database Service
  * It's used to easily extend OSQL services by
  * 3rd party plugins.
  * It's used to show
  */
 class OSQLBackEnd  /*: public QShared */ {
 public:
     typedef QValueList<OSQLBackEnd> ValueList;
     /**
      * A basic c'tor
      * @param name the user visible name of the service
      * @param vendor the vendor of the service
      * @param license the license of the service
      * @param library what is the name of lib if builtin it's builtin
      */
     OSQLBackEnd( const QString& name = QString::null,
                  const QString& vendor = QString::null,
                  const QString& license = QString::null,
                  const QCString& library = QCString() );
     OSQLBackEnd( const OSQLBackEnd& );
     OSQLBackEnd &operator=( const OSQLBackEnd& );
     bool operator==(const OSQLBackEnd& );
 
     ~OSQLBackEnd();
 
     /** @return the name */
     QString name()const;
 
     /** @return the vendor */
     QString vendor()const;
 
     /** @return the license */
     QString license()const;
 
     /** @return the name of the library */
     QCString library() const;
 
     bool isDefault()const;
     int preference()const;
 
     /** @param name the name to set */
     void setName( const QString& name );
 
     /** @param vendor the vendor to set */
     void setVendor( const QString& vendor );
 
     /** @param license the license applied */
     void setLicense( const QString& license );
 
     /** @param the lib to set */
     void setLibrary( const QCString& lib );
 
     void setDefault( bool );
     void setPreference( int );
 
 private:
     QString m_name;
     QString m_vendor;
     QString m_license;
     QCString m_lib;
     bool m_default :1;
     int m_pref;
+    class Private;
+    Private *d;
 };
 
+}
+}
+
 #endif
diff --git a/libopie2/opiedb/osqlbackendmanager.cpp b/libopie2/opiedb/osqlbackendmanager.cpp
index 95ed77b..fc18e07 100644
--- a/libopie2/opiedb/osqlbackendmanager.cpp
+++ b/libopie2/opiedb/osqlbackendmanager.cpp
@@ -1,94 +1,102 @@
 #include <qdir.h>
 #include <qmap.h>
 
 #include "osqlbackendmanager.h"
 
+/**
+ * \todo FIXME CONFIG!!!
+ */
+
 namespace {
     class Config {
         typedef QMap<QString, QString> List;
     public:
         Config( const QString& fileName );
         /**
          * Quite simple layout in nature
          * BeginFile
          * Key = Value
          */
         bool load();
         QString value( const QString& key );
     private:
         List m_list;
         QString m_fileName;
     };
     Config::Config( const QString& fileName )
         : m_fileName( fileName ) {
     }
 
     bool Config::load() {
         if (!QFile::exists( m_fileName ) )
             return false;
         QFile file( m_fileName );
         if (!file.open(IO_ReadOnly ) )
             return false;
         QStringList list = QStringList::split( '\n', file.readAll() );
         QStringList::Iterator it;
         QString line;
         for (it =  list.begin(); it != list.end(); ++it ) {
             line = (*it).stripWhiteSpace();
             qWarning("Anonymous::Config:" + line );
             QStringList test = QStringList::split(' ', line );
             m_list.insert( test[0], test[2] );
         }
         return true;
     }
     QString Config::value( const QString& key ) {
         return m_list[key];
     }
 };
+
+
+using namespace Opie::DB;
+
 OSQLBackEndManager::OSQLBackEndManager( const QStringList& path )
     :m_path( path )
 {
 }
 OSQLBackEndManager::~OSQLBackEndManager() {
 }
 /**
  * scan dirs
  */
 OSQLBackEnd::ValueList OSQLBackEndManager::scan() {
     OSQLBackEnd::ValueList list;
     if (!m_path.isEmpty() ) {
         QStringList::Iterator it;
         for ( it = m_path.begin(); it != m_path.end(); ++it ) {
             list += scanDir( (*it) );
         }
     }
     return list;
 }
 /**
  * scan a specified dir for *.osql
  */
 OSQLBackEnd::ValueList OSQLBackEndManager::scanDir( const QString& dirName ) {
     OSQLBackEnd::ValueList list;
     QDir dir( dirName );
     if (dir.exists() ) {
         QStringList files = dir.entryList( "*.osql" );
         QStringList::Iterator it;
         for ( it = files.begin(); it != files.end(); ++it ) {
             list.append( file2backend( (*it) ) );
         }
     }
     return list;
 }
 
 /**
  * read a config file and convert it to a OSQLBackEnd
  */
 OSQLBackEnd OSQLBackEndManager::file2backend( const QString& file ) {
     OSQLBackEnd end;
     qWarning("fileName: " + file  );
     Config cfg( file );
     if (cfg.load() ) {
         end.setName( cfg.value( "Name") );
         end.setVendor( cfg.value("Vendor") );
         end.setLicense( cfg.value("License") );
         end.setLibrary( cfg.value("Library").local8Bit() );
         end.setDefault( cfg.value("Default").toInt() );
diff --git a/libopie2/opiedb/osqlbackendmanager.h b/libopie2/opiedb/osqlbackendmanager.h
index bc357a9..00e81fc 100644
--- a/libopie2/opiedb/osqlbackendmanager.h
+++ b/libopie2/opiedb/osqlbackendmanager.h
@@ -1,20 +1,26 @@
 #ifndef OSQL_BACKEND_MANAGER_H
 #define OSQL_BACKEND_MANAGER_H
 
 #include <qstringlist.h>
 
 #include "osqlbackend.h"
 
+namespace Opie {
+namespace DB {
+
 class OSQLBackEndManager {
 public:
     OSQLBackEndManager(const QStringList& path );
     ~OSQLBackEndManager();
     OSQLBackEnd::ValueList scan();
 private:
     OSQLBackEnd::ValueList scanDir( const QString& dir );
     OSQLBackEnd file2backend( const QString& file );
     class OSQLBackEndManagerPrivate;
     OSQLBackEndManagerPrivate* d;
     QStringList m_path;
 };
+}
+}
+
 #endif
diff --git a/libopie2/opiedb/osqldriver.cpp b/libopie2/opiedb/osqldriver.cpp
index 258c116..a6dae77 100644
--- a/libopie2/opiedb/osqldriver.cpp
+++ b/libopie2/opiedb/osqldriver.cpp
@@ -1,13 +1,15 @@
 #include <qpe/qlibrary.h>
 
 #include "osqldriver.h"
 
+using namespace Opie::DB;
+
 OSQLDriver::OSQLDriver( QLibrary* lib )
 : QObject(), m_lib(lib) {
 }
 OSQLDriver::~OSQLDriver() {
     delete m_lib;
 }
 bool OSQLDriver::sync() {
     return true;
 }
diff --git a/libopie2/opiedb/osqldriver.h b/libopie2/opiedb/osqldriver.h
index 68d8ee6..492b8dd 100644
--- a/libopie2/opiedb/osqldriver.h
+++ b/libopie2/opiedb/osqldriver.h
@@ -1,87 +1,94 @@
 #ifndef OSQL_DRIVER_H
 #define OSQL_DRIVER_H
 
 #include <qobject.h>
 #include <qstring.h>
 
 #include "osqltable.h"
 
 class QLibrary;
+
+namespace Opie {
+namespace DB {
+
 class OSQLResult;
 class OSQLQuery;
 class OSQLError;
 
 /**
  * A OSQLDriver implements the communication with
  * a database.
  * After you queried and loaded a driver you can
  * set some informations and finally try to open
  * the database
  *
  */
 class OSQLDriver : public QObject{
     Q_OBJECT
 public:
     enum Capabilities { RowID=0 };
     /**
      * OSQLDriver constructor. It takes the QLibrary
      * as parent.
      *
      */
     OSQLDriver( QLibrary* lib=0 );
 
     virtual ~OSQLDriver();
     /**
      * Id returns the identifier of the OSQLDriver
      */
     virtual QString id()const = 0;
 
     /**
      * set the UserName to the database
      */
     virtual void setUserName( const QString& ) = 0;
 
     /**
      * set the PassWord to the database
      */
     virtual void setPassword( const QString& )= 0;
 
     /**
      * set the Url
      */
     virtual void setUrl( const QString& ) = 0;
 
     /**
      * setOptions
      */
     virtual void setOptions( const QStringList& ) = 0;
 
     /**
      * tries to open a connection to the database
      */
     virtual bool open() = 0;
     virtual bool close() = 0;
 
     virtual OSQLError lastError() = 0;
 
     /**
      * Query the Database with a OSQLQuery
      * OSQLResult holds the result
      */
     virtual OSQLResult query( OSQLQuery* ) = 0;
 
     /**
      * Get a list of tables
      */
     virtual OSQLTable::ValueList tables() const = 0l;
     virtual bool sync();
 
 
 private:
     QLibrary* m_lib;
     class OSQLDriverPrivate;
     OSQLDriverPrivate *d;
 
 };
 
+}
+}
+
 #endif
diff --git a/libopie2/opiedb/osqlerror.cpp b/libopie2/opiedb/osqlerror.cpp
index 3890a50..165ba65 100644
--- a/libopie2/opiedb/osqlerror.cpp
+++ b/libopie2/opiedb/osqlerror.cpp
@@ -1,23 +1,25 @@
 #include "osqlerror.h"
 
+using namespace Opie::DB;
+
 OSQLError::OSQLError( const QString& driverText,
                       const QString& driverDatabaseText,
                       int type, int subType )
     : m_drvText( driverText ), m_drvDBText( driverDatabaseText ),
       m_type( type ), m_number( subType )
 {
 }
 OSQLError::~OSQLError() {
 }
 QString OSQLError::driverText()const {
     return m_drvText;
 }
 QString OSQLError::databaseText()const {
     return m_drvDBText;
 }
 int OSQLError::type()const {
     return m_type;
 }
 int OSQLError::subNumber()const {
     return m_number;
 }
diff --git a/libopie2/opiedb/osqlerror.h b/libopie2/opiedb/osqlerror.h
index 35a4368..8fa973d 100644
--- a/libopie2/opiedb/osqlerror.h
+++ b/libopie2/opiedb/osqlerror.h
@@ -1,59 +1,64 @@
 #ifndef OSQL_ERROR_H
 #define OSQL_ERROR_H
 
 #include <qstring.h>
 #include <qvaluelist.h>
 
+
+namespace Opie {
+namespace DB {
 /**
  * OSQLError is the base class of all errors
  */
 class OSQLError {
 public:
     typedef QValueList<OSQLError> ValueList;
     enum Type { None = 0, // NoError
                 Internal, // Internal Error in OSQL
                 Unknown, // Unknown Error
                 Transaction, // Transaction Error
                 Statement, // Wrong Statement
                 Connection, // Connection Error( lost )
                 Driver // Driver Specefic error
     };
     enum DriverError {
         DriverInternal=0, // internal DriverError
         Permission, // Permission Problem
         Abort, // Abort of the SQL
         Busy, // Busy Error
         Locked, // Locked
         NoMem, // No Memory
         ReadOnly, // Database is read only
         Interrupt, // Interrupt
         IOErr, // IO Error
         Corrupt, // Database Corruption
         NotFound, // Table not Found
         Full, // Full
         CantOpen, // Can not open Table/Database
         Protocol, // internal protocol error
         Schema, // schema changed
         TooBig, // Data too big
         Mismatch, // Type mismatch
         Misuse // misuse
     };
     OSQLError( const QString& driverText = QString::null,
                const QString& driverDatabaseText = QString::null,
                int type = None, int subNumber = -1 );
     ~OSQLError();
 
     QString driverText()const;
     QString databaseText()const;
     int type()const;
     int subNumber()const;
 private:
     QString m_drvText;
     QString m_drvDBText;
     int m_type;
     int m_number;
     class OSQLErrorPrivate;
     OSQLErrorPrivate* d;
 };
 
+}
+}
 #endif
diff --git a/libopie2/opiedb/osqlitedriver.cpp b/libopie2/opiedb/osqlitedriver.cpp
index 6141504..47bc250 100644
--- a/libopie2/opiedb/osqlitedriver.cpp
+++ b/libopie2/opiedb/osqlitedriver.cpp
@@ -1,177 +1,180 @@
 /*
                              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 "osqlquery.h"
 #include "osqlitedriver.h"
 
 #include <opie2/odebug.h>
 
 #include <stdlib.h>
 
 // fromLocal8Bit() does not work as expected. Thus it
 // is replaced by fromLatin1() (eilers)
 #define __BUGGY_LOCAL8BIT_
 
 
+using namespace Opie::DB;
+using namespace Opie::DB::Private;
+
 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;
-    odebug << "OSQLiteDriver::open: about to open" << oendl;
+    qDebug("OSQLiteDriver::open: about to open");
     m_sqlite = sqlite_open(m_url.local8Bit(),
                            0,
                            &error );
 
     /* failed to open */
     if (m_sqlite == 0l ) {
         // FIXME set the last error
-        owarn << "OSQLiteDriver::open: " << error << oendl;
+        qWarning("OSQLiteDriver::open: %s", error );
         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 ) {
-        owarn << "OSQLiteDriver::query: Error while executing" << oendl;
+        qWarning("OSQLiteDriver::query: Error while executing");
         free(err );
         // FixMe Errors
     }
 
     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) {
     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++ ) {
 
 #ifdef __BUGGY_LOCAL8BIT_
         tableInt.insert( i, QString::fromLatin1( argv[i] ) );
         tableString.insert( QString::fromLatin1( columns[i] ),
                             QString::fromLatin1( argv[i] ) );
 #else
         tableInt.insert( i, QString::fromLocal8Bit( argv[i] ) );
         tableString.insert( QString::fromLocal8Bit( columns[i] ),
                             QString::fromLocal8Bit( argv[i] ) );
diff --git a/libopie2/opiedb/osqlitedriver.h b/libopie2/opiedb/osqlitedriver.h
index 6984539..3e1325b 100644
--- a/libopie2/opiedb/osqlitedriver.h
+++ b/libopie2/opiedb/osqlitedriver.h
@@ -1,34 +1,42 @@
 #ifndef OSQL_LITE_DRIVER_H
 #define OSQL_LITE_DRIVER_H
 
 #include <sqlite.h>
 
 #include "osqldriver.h"
 #include "osqlerror.h"
 #include "osqlresult.h"
 
+namespace Opie {
+namespace DB {
+namespace Private {
+
 class OSQLiteDriver : public OSQLDriver {
     Q_OBJECT
 public:
     OSQLiteDriver( QLibrary *lib = 0l );
     ~OSQLiteDriver();
     QString id()const;
     void setUserName( const QString& );
     void setPassword( const QString& );
     void setUrl( const QString& url );
     void setOptions( const QStringList& );
     bool open();
     bool close();
     OSQLError lastError();
     OSQLResult query( OSQLQuery* );
     OSQLTable::ValueList tables()const;
 private:
     OSQLError m_lastE;
     OSQLResult m_result;
     OSQLResultItem m_items;
     int handleCallBack( int, char**, char** );
     static int call_back( void*, int, char**, char** );
     QString m_url;
     sqlite *m_sqlite;
 };
+}
+}
+}
+
 #endif
diff --git a/libopie2/opiedb/osqlmanager.cpp b/libopie2/opiedb/osqlmanager.cpp
index 766ebe1..990d258 100644
--- a/libopie2/opiedb/osqlmanager.cpp
+++ b/libopie2/opiedb/osqlmanager.cpp
@@ -1,81 +1,83 @@
 
 #include <stdlib.h>
 
 #include "osqlmanager.h"
 #include "osqlbackendmanager.h"
 #include "osqlitedriver.h"
 
+using namespace Opie::DB;
+
 OSQLManager::OSQLManager() {
 }
 OSQLBackEnd::ValueList OSQLManager::queryBackEnd() {
     m_list.clear();
     QString opie = QString::fromLatin1( getenv("OPIEDIR") );
     QString qpe = QString::fromLatin1( getenv("QPEDIR") );
 
     if ( !m_path.contains(opie) && !opie.isEmpty() )
         m_path << opie;
     if ( !m_path.contains(qpe) && !qpe.isEmpty() )
         m_path << qpe;
 
     OSQLBackEndManager mng( m_path );
     m_list = mng.scan();
     m_list += builtIn();
 
     return m_list;
 }
 /*
  * loading dso's is currently not enabled due problems with QLibrary
  * beeing in libqpe and not libqte
  */
 OSQLDriver* OSQLManager::load( const QString& name ) {
     OSQLDriver* driver = 0l;
 
     if ( name == "SQLite" ) {
-        driver = new OSQLiteDriver();
+        driver = new Opie::DB::Private::OSQLiteDriver;
     }
     return driver;
 }
 /*
  * same as above
  */
 OSQLDriver* OSQLManager::load( const OSQLBackEnd& end) {
     OSQLDriver *driver = 0l;
     if ( end.library() == "builtin" &&
          end.name() == "SQLite" )
-        driver = new OSQLiteDriver();
+        driver = new Opie::DB::Private::OSQLiteDriver;
 
     return driver;
 }
 /*
  * let's find the a default with the highes preference
  */
 OSQLDriver* OSQLManager::standard() {
     OSQLDriver* driver =0l;
     if ( m_list.isEmpty() ) queryBackEnd();
     OSQLBackEnd::ValueList::Iterator it;
     OSQLBackEnd back;
     for ( it = m_list.begin(); it != m_list.end(); ++it ) {
         if ( (*it).isDefault() &&
              back.preference() < (*it).preference() ) {
             back = (*it);
         }
     }
     driver = load( back );
     return driver;
 }
 void OSQLManager::registerPath( const QString& path ) {
     m_path << path;
 }
 bool OSQLManager::unregisterPath( const QString& path ) {
     m_path.remove( path );
     return true;
 }
 OSQLBackEnd::ValueList OSQLManager::builtIn()const {
     OSQLBackEnd::ValueList list;
     // create the OSQLiteBackend
     OSQLBackEnd back("SQLite","Opie e.V.","GPL", "builtin" );
     back.setDefault( true );
     back.setPreference( 50 );
     list.append( back );
     return list;
 }
diff --git a/libopie2/opiedb/osqlmanager.h b/libopie2/opiedb/osqlmanager.h
index 5323b14..ca73c64 100644
--- a/libopie2/opiedb/osqlmanager.h
+++ b/libopie2/opiedb/osqlmanager.h
@@ -1,64 +1,70 @@
 
 #ifndef OSQL_MANAGER_H
 #define OSQL_MANAGER_H
 
 #include <qobject.h>
 #include <qstringlist.h>
 
 #include "osqlbackend.h"
 
 
+namespace Opie {
+namespace DB {
 /**
  * OSQLManager is responsible for loading
  * and unloading, querying different OSQL
  * services
  * Load a OSQLDriver and delete it yourself
  *
  */
 class OSQLDriver;
 class OSQLManager : public QObject {
     Q_OBJECT
 public:
     /**
      * Empty c'tor
      */
     OSQLManager();
 
     /**
      * Query the Manager for different backends
      */
     OSQLBackEnd::ValueList queryBackEnd();
 
     /**
      * Load a backend with it's name from param name
      */
     OSQLDriver* load( const QString& name );
 
     /**
      * Load a OSQLDevice from const reference of OSQLBackEnd
      */
     OSQLDriver* load( const OSQLBackEnd& );
 
     /**
      * loads the Opie standard backend
      */
     OSQLDriver *standard();
 
     /**
      * register path to the search path list
      * When querying for services we scan all the
      * registered path for backends
      */
     void registerPath( const QString& path );
 
     /**
      * unregisterPath from the search path list
      */
     bool unregisterPath( const QString& path );
 private:
     OSQLBackEnd::ValueList builtIn()const;
     OSQLBackEnd::ValueList m_list;
     QStringList m_path;
+    class Private;
+    Private *d;
 };
+}
+}
 
 #endif
diff --git a/libopie2/opiedb/osqlquery.cpp b/libopie2/opiedb/osqlquery.cpp
index ecd53f2..8270c4c 100644
--- a/libopie2/opiedb/osqlquery.cpp
+++ b/libopie2/opiedb/osqlquery.cpp
@@ -1,17 +1,19 @@
 
 #include "osqlquery.h"
 
+using namespace Opie::DB;
+
 OSQLQuery::OSQLQuery() {
 }
 OSQLQuery::~OSQLQuery() {
 }
 
 OSQLRawQuery::OSQLRawQuery(const QString& query)
     : OSQLQuery(), m_query( query ) {
 
 }
 OSQLRawQuery::~OSQLRawQuery() {
 }
 QString OSQLRawQuery::query()const {
     return m_query;
 }
diff --git a/libopie2/opiedb/osqlquery.h b/libopie2/opiedb/osqlquery.h
index 63c26b0..0265d2b 100644
--- a/libopie2/opiedb/osqlquery.h
+++ b/libopie2/opiedb/osqlquery.h
@@ -1,122 +1,130 @@
 
 #ifndef OSQL_QUERY_H
 #define OSQL_QUERY_H
 
 #include <qmap.h>
 #include <qvaluelist.h>
 #include <qstring.h>
 
 
+namespace Opie {
+namespace DB {
+
 /** I'm not happy with them
 class OSQLQueryOrder {
 public:
     typedef QValueList<OSQLQueryOrder> ValueList;
     OSQLQueryOrder(const QString& table = QString::null );
     OSQLQueryOrder( const OSQLQueryOrder& );
     ~OSQLQueryOrder();
     void setOrderFields( const QStringList& list );
     void setValue( const QString& fieldName, const QString& Value );
     void setValues( const QMap<QString, QString>& );
     QMap<QString, QString> orders() const;
     QString orderStatement()const;
     OSQLQueryOrder &operator=(const OSQLQueryOrder& );
 private:
     QMap<QString, QString> m_fields;
     class OSQLQueryOrderPrivate;
     OSQLQueryOrderPrivate* d;
 };
 class OSQLWhere {
 public:
     typedef QValueList<OSQLWhere> ValueList;
     enum Vergleiche { Equal = 0, Like, Greater, GreaterEqual,
                       Smaller, SmallerEqual };
     OSQLWhere(const QString& table = QString::null );
     ~OSQLWhere();
     void setExpression(const QString& key, enum Vergleiche, const QString& );
     QString statement()const;
 private:
     int m_vergleich;
     const QString& m_left;
     const QString& m_right;
 
 };
 */
 class OSQLQuery {
 public:
     OSQLQuery();
     virtual ~OSQLQuery();
 
     virtual QString query()const = 0;
+private:
+    class Private;
+    Private *d;    
 };
 
 class OSQLRawQuery : public OSQLQuery {
 public:
     OSQLRawQuery( const QString& query );
     ~OSQLRawQuery();
     QString query() const;
 private:
     class OSQLRawQueryPrivate;
     OSQLRawQueryPrivate* d;
     QString m_query;
 
 };
 /* I'm not happy with them again
 class OSQLSelectQuery : public OSQLQuery {
 public:
     OSQLSelectQuery();
     ~OSQLSelectQuery();
     void setTables( const QStringList& allTablesToQuery );
     void setValues( const QString& table, const QStringList& columns );
     void setOrder( const OSQLSelectQuery& );
     void setOrderList( const OSQLQueryOrder::ValueList& );
     void setWhereList( const OSQLWhere& );
     void setWhereList( const OSQLWhere::ValueList& );
     QString query()const;
 private:
     QStringList m_tables;
     QMap<QString, QStringList> m_values;
     OSQLQueryOrder::ValueList m_order;
     OSQLWhere::ValueList m_where;
     class OSQLSelectQueryPrivate;
     OSQLSelectQueryPrivate* d;
 };
 class OSQLInsertQuery : public OSQLQuery  {
 public:
     OSQLInsertQuery(const QString& table);
     ~OSQLInsertQuery();
     void setInserFields( const QStringList& );
     void setValue( const QString& field,  const QString& value );
     void setValues(const QMap<QString, QString>& );
     QString query()const;
 private:
     QString m_table;
     QStringList m_fields;
     QMap<QString, QString> m_values;
 };
 class OSQLDeleteQuery : public OSQLQuery {
 public:
     OSQLDeleteQuery(const QString& table);
     ~OSQLDeleteQuery();
     void setWhere( const OSQLWhere& );
     void setWheres( const OSQLWhere::ValueList& );
     QString query()const;
 private:
     QString m_table;
     OSQLWhere::ValueList m_where;
 
 };
 class OSQLUpdateQuery : public OSQLQuery {
 public:
     OSQLUpdateQuery( const QString& table );
     ~OSQLUpdateQuery();
     void setWhere( const OSQLWhere& );
     void setWheres( const OSQLWhere::ValueList& );
     */
     /* replaces all previous set Values */
     /*
     void setValue( const QString& field, const QString& value );
     void setValue( const QMap<QString, QString> &fields );
     QString query() const;
 };
 */
+}
+}
 #endif
diff --git a/libopie2/opiedb/osqlresult.cpp b/libopie2/opiedb/osqlresult.cpp
index 42da356..bad7d8b 100644
--- a/libopie2/opiedb/osqlresult.cpp
+++ b/libopie2/opiedb/osqlresult.cpp
@@ -1,51 +1,53 @@
 
 #include "osqlresult.h"
 
+using namespace Opie::DB;
+
 OSQLResultItem::OSQLResultItem( const TableString& string,
                                 const TableInt& Int)
     : m_string( string ), m_int( Int )
 {
 
 }
 OSQLResultItem::~OSQLResultItem() {
 }
 OSQLResultItem::OSQLResultItem( const OSQLResultItem& item) {
     *this = item;
 }
 OSQLResultItem &OSQLResultItem::operator=( const OSQLResultItem& other) {
     m_string = other.m_string;
     m_int = other.m_int;
     return *this;
 }
 OSQLResultItem::TableString OSQLResultItem::tableString()const{
     return m_string;
 }
 OSQLResultItem::TableInt OSQLResultItem::tableInt()const {
     return m_int;
 }
 QString OSQLResultItem::data( const QString& columnName, bool *ok ) {
     TableString::Iterator it = m_string.find( columnName );
 
     /* if found */
     if ( it != m_string.end() ) {
         if ( ok ) *ok = true;
         return it.data();
     }else{
         if ( ok )  *ok = false;
         return QString::null;
     }
 
 }
 QString OSQLResultItem::data( int column, bool *ok ) {
     TableInt::Iterator it = m_int.find( column );
 
     /* if found */
     if ( it != m_int.end() ) {
         if ( ok ) *ok = true;
         return it.data();
     }else{
         if ( ok )  *ok = false;
         return QString::null;
     }
 }
 /*
diff --git a/libopie2/opiedb/osqlresult.h b/libopie2/opiedb/osqlresult.h
index 9c9efa2..fc6f01a 100644
--- a/libopie2/opiedb/osqlresult.h
+++ b/libopie2/opiedb/osqlresult.h
@@ -1,57 +1,61 @@
 #ifndef OSQL_RESULT_H
 #define OSQL_RESULT_H
 
 #include <qdatetime.h>
 #include <qmap.h>
 #include <qvaluelist.h>
 
 
 #include "osqlerror.h"
+
+namespace Opie {
+namespace DB {
+
 /**
  * ResultItem  represents one row of the resulting answer
  */
 class OSQLResultItem {
 public:
     typedef QValueList<OSQLResultItem> ValueList;
     /**
      * TableString is used to establish the relations
      * between the column name and the real item
      */
     typedef QMap<QString, QString> TableString;
 
     /**
      * TableInt is used to establish a relation between a
      * position of a column and the row value
      */
     typedef QMap<int, QString> TableInt;
 
     /**
      * Default c'tor. It has a TableString and a TableInt
      */
     OSQLResultItem(const TableString& = TableString(),
                    const TableInt& = TableInt() );
     OSQLResultItem( const OSQLResultItem& );
     ~OSQLResultItem();
     OSQLResultItem &operator=( const OSQLResultItem& );
     /**
      * returns the TableString
      */
     TableString tableString()const;
 
     /**
      * returns the TableInt
      */
     TableInt tableInt() const;
 
     /**
      * retrieves the Data from columnName
      *
      */
     QString data( const QString& columnName, bool *ok = 0);
 
     /**
      * QString for column number
      */
     QString data(int columnNumber, bool *ok = 0);
 
     /**
@@ -62,51 +66,55 @@ public:
     /**
      * Date conversion from column-number
      */
     QDate dataToDate( int columnNumber, bool *ok = 0 );
 
     QDateTime dataToDateTime( const QString& columName, bool *ok = 0 );
     QDateTime dataToDateTime( int columnNumber, bool *ok = 0 );
 private:
     TableString m_string;
     TableInt m_int;
 };
 
 /**
  * the OSQLResult
  * either a SQL statement failed or succeeded
  */
 class OSQLResult {
 public:
     /** The State of a Result */
     enum State{ Success = 0, Failure,Undefined };
 
     /**
      * default c'tor
      * @param state The State of the Result
      * @param r ResultItems
      * @prarm errors the Errors a OSQLResult created
      */
     OSQLResult( enum State state = Undefined,
                 const OSQLResultItem::ValueList& r= OSQLResultItem::ValueList(),
                 const OSQLError::ValueList& errors = OSQLError::ValueList() );
     ~OSQLResult();
     State state()const;
     OSQLError::ValueList errors()const;
     OSQLResultItem::ValueList results()const;
 
     void setState( enum State state );
     void setErrors( const OSQLError::ValueList& error );
     void setResults( const OSQLResultItem::ValueList& result );
 
     OSQLResultItem first();
     OSQLResultItem next();
     bool atEnd();
     OSQLResultItem::ValueList::ConstIterator iterator()const;
 private:
     enum State m_state;
     OSQLResultItem::ValueList m_list;
     OSQLError::ValueList m_error;
     OSQLResultItem::ValueList::Iterator it;
+    class Private;
+    Private *d;
 };
 
+}
+}
 #endif
diff --git a/libopie2/opiedb/osqltable.cpp b/libopie2/opiedb/osqltable.cpp
index cde40f4..117cf21 100644
--- a/libopie2/opiedb/osqltable.cpp
+++ b/libopie2/opiedb/osqltable.cpp
@@ -1,46 +1,48 @@
 #include "osqltable.h"
 
+using namespace Opie::DB;
+
 OSQLTableItem::OSQLTableItem() {}
 OSQLTableItem::OSQLTableItem( enum Type type,
                               const QString& field,
                               const QVariant& var)
     : m_type( type ), m_field( field ), m_var( var )
 {
 
 }
 OSQLTableItem::~OSQLTableItem() {}
 OSQLTableItem::OSQLTableItem( const OSQLTableItem& item) {
     *this = item;
 }
 OSQLTableItem &OSQLTableItem::operator=(const OSQLTableItem& other) {
     m_var = other.m_var;
     m_field = other.m_field;
     m_type = other.m_type;
     return *this;
 }
 QString OSQLTableItem::fieldName()const{
     return m_field;
 }
 OSQLTableItem::Type OSQLTableItem::type()const {
     return m_type;
 }
 QVariant OSQLTableItem::more()const {
     return m_var;
 }
 
 OSQLTable::OSQLTable( const QString& tableName )
     : m_table( tableName )
 {
 
 }
 OSQLTable::~OSQLTable() {
 }
 void OSQLTable::setColumns( const OSQLTableItem::ValueList& list) {
     m_list = list;
 }
 OSQLTableItem::ValueList OSQLTable::columns()const {
     return m_list;
 }
 QString OSQLTable::tableName()const {
     return m_table;
 }
diff --git a/libopie2/opiedb/osqltable.h b/libopie2/opiedb/osqltable.h
index 87f7e74..86c30dd 100644
--- a/libopie2/opiedb/osqltable.h
+++ b/libopie2/opiedb/osqltable.h
@@ -1,95 +1,102 @@
 #ifndef OSQL_TABLE_H
 #define OSQL_TABLE_H
 
 #include <qstring.h>
 #include <qvaluelist.h>
 #include <qvariant.h>
 
+namespace Opie {
+namespace DB {
 /**
  * OSQLTableItem saves one column of a complete
  * table
  */
 class OSQLTableItem {
 public:
     typedef QValueList<OSQLTableItem> ValueList;
     /**
      * Type kinds ( to be extended )
      */
     enum Type { Undefined=-1, Integer=0, BigInteger =1,
                 Float = 2, VarChar = 4 };
     /**
      * A constructor
      * @param type the Type of the Column
      * @param fieldName the Name of the Column
      * @param var a Variant
      */
     OSQLTableItem();
     OSQLTableItem( enum Type type,
                    const QString& fieldName,
                    const QVariant& var= QVariant() );
 
     /**
      * copy c'tor
      */
     OSQLTableItem( const OSQLTableItem& );
 
     /**
      * d'tor
      */
     ~OSQLTableItem();
 
     OSQLTableItem& operator=( const OSQLTableItem& );
 
     /**
      * the fieldName
      */
     QString fieldName() const;
 
     /**
      * the field Type
      */
     Type type() const;
     QVariant more() const;
 private:
     class OSQLTableItemPrivate;
     OSQLTableItemPrivate* d;
     Type m_type;
     QString m_field;
     QVariant m_var;
 };
 
 /**
  * A OSQLTable consists of OSQLTableItems
  */
 class OSQLTable  {
 public:
     typedef QValueList<OSQLTable> ValueList;
 
     /**
      * @param tableName the Name of the Table
      */
     OSQLTable(const QString& tableName);
 
     /**
      * d'tor
      */
     ~OSQLTable();
 
     /**
      * setColumns sets the Columns of the Table
      */
     void setColumns( const OSQLTableItem::ValueList& );
 
     /**
      * returns all columns of the table
      */
     OSQLTableItem::ValueList columns() const;
 
     QString tableName()const;
 
 private:
     QString m_table;
     OSQLTableItem::ValueList m_list;
+    class Private;
+    Private *d;
 };
 
+}
+}
+
 #endif