Pimconverter got a button to convert databases from sqlite 2->3.

If correct implementation is confirmed, I will commit the rest..

3 files changed, 141 insertions, 10 deletions

diff --git a/noncore/tools/pimconverter/converter.cpp b/noncore/tools/pimconverter/converter.cpp
index e9de3c3..2cd6969 100644
--- a/noncore/tools/pimconverter/converter.cpp
+++ b/noncore/tools/pimconverter/converter.cpp
@@ -1,226 +1,313 @@
 #include "converter.h"
 
+#include <stdlib.h> // For "system()" command
+
 /* OPIE */
 #include <opie2/oapplicationfactory.h>
 #include <opie2/odebug.h>
 #include <opie2/opimglobal.h>
 // Include SQL related header files
 #define __USE_SQL
 #include <opie2/opimaccessfactory.h>
 
 /* QT */
 #include <qdatetime.h>
 #include <qprogressbar.h>
 #include <qcombobox.h>
 #include <qcheckbox.h>
 #include <qmessagebox.h>
 
 
 OPIE_EXPORT_APP( Opie::Core::OApplicationFactory<Converter> )
 
 using namespace Opie;
 using namespace Pim;
 
 Converter::Converter(QWidget *p, const char* n,  WFlags fl):
     converter_base( p, n, fl ),
     m_selectedDatabase( ADDRESSBOOK ),
     m_selectedSourceFormat( XML ),
     m_selectedDestFormat( SQL ),
     m_criticalState( false )
 {
     m_dataBaseSelector -> setCurrentItem( m_selectedDatabase );
     m_sourceFormatSelector -> setCurrentItem( m_selectedSourceFormat );
     m_destFormatSelector -> setCurrentItem( m_selectedDestFormat );
     m_eraseDB -> setChecked( true );  // Default erase on copy
 }
 
 void Converter::selectedDatabase( int num )
 {
     m_selectedDatabase = num;
 }
 
 void Converter::selectedDestFormat( int num )
 {
     m_selectedDestFormat = num;
 }
 
 void Converter::selectedSourceFormat( int num )
 {
     m_selectedSourceFormat = num;
 }
 
 void Converter::start_conversion(){
 
     // Creating backends to the requested databases..
     OPimBase* sourceDB;
     OPimBase* destDB;
 
     odebug << "SourceFormat: " <<  m_selectedSourceFormat << oendl;
     odebug << "DestFormat: " << m_selectedDestFormat << oendl;
     if ( m_selectedSourceFormat == m_selectedDestFormat ){
 
             QMessageBox::warning( this, "PimConverter",
                                   tr( "It is not a good idea to use\n" )
                                   +tr( "the same source and destformat !" ),
                                   tr( "Ok" ) );
             return;
     }
 
     switch( m_selectedSourceFormat ){
     case XML:
         odebug << "XMLSourceDB = " << m_selectedDatabase << "" << oendl;
         switch( m_selectedDatabase ){
         case ADDRESSBOOK:{
             sourceDB = OPimAccessFactory<OPimContactAccess>::create( OPimGlobal::CONTACTLIST, OPimGlobal::XML, "converter" );
                 }
             break;
         case TODOLIST:{
             sourceDB = OPimAccessFactory<OPimTodoAccess>::create( OPimGlobal::TODOLIST, OPimGlobal::XML, "converter" );
             }break;
         case DATEBOOK:{
             sourceDB = OPimAccessFactory<ODateBookAccess>::create( OPimGlobal::DATEBOOK, OPimGlobal::XML, "converter" );
                 }
             break;
         default:
             owarn << "Unknown database selected (" << m_selectedDatabase << ")" << oendl;
             return;
         }
         break;
     case SQL:
         odebug << "SQLSourceDB = " << m_selectedDatabase << "" << oendl;
         switch( m_selectedDatabase ){
         case ADDRESSBOOK:{
             sourceDB = OPimAccessFactory<OPimContactAccess>::create( OPimGlobal::CONTACTLIST, OPimGlobal::SQL, "converter" );
                 }
             break;
         case TODOLIST:{
             sourceDB = OPimAccessFactory<OPimTodoAccess>::create( OPimGlobal::TODOLIST, OPimGlobal::SQL, "converter" );
             }break;
         case DATEBOOK:{
             sourceDB = OPimAccessFactory<ODateBookAccess>::create( OPimGlobal::DATEBOOK, OPimGlobal::SQL, "converter" );
                 }
             break;
         default:
             owarn << "Unknown database selected (" << m_selectedDatabase << ")" << oendl;
             return;
         }
         break;
     default:
         owarn << "Unknown source format selected (" << m_selectedSourceFormat << ") !!" << oendl;
         return;
     }
 
     switch ( m_selectedDestFormat ){
     case XML:
         odebug << "XMLDestDB = " << m_selectedDatabase << "" << oendl;
         switch( m_selectedDatabase ){
         case ADDRESSBOOK:{
             destDB = OPimAccessFactory<OPimContactAccess>::create( OPimGlobal::CONTACTLIST, OPimGlobal::XML, "converter" );
                 }
             break;
         case TODOLIST:{
             destDB = OPimAccessFactory<OPimTodoAccess>::create( OPimGlobal::TODOLIST, OPimGlobal::XML, "converter" );
             }break;
         case DATEBOOK:{
             destDB = OPimAccessFactory<ODateBookAccess>::create( OPimGlobal::DATEBOOK, OPimGlobal::XML, "converter" );
                 }
             break;
         default:
             owarn << "Unknown database selected (" << m_selectedDatabase << ")" << oendl;
             return;
         }
         break;
     case SQL:
         odebug << "SQLDestDB = " << m_selectedDatabase << "" << oendl;
         switch( m_selectedDatabase ){
         case ADDRESSBOOK:{
             destDB = OPimAccessFactory<OPimContactAccess>::create( OPimGlobal::CONTACTLIST, OPimGlobal::SQL, "converter" );
                 }
             break;
         case TODOLIST:{
             destDB = OPimAccessFactory<OPimTodoAccess>::create( OPimGlobal::TODOLIST, OPimGlobal::SQL, "converter" );
             }break;
         case DATEBOOK:{
             destDB = OPimAccessFactory<ODateBookAccess>::create( OPimGlobal::DATEBOOK, OPimGlobal::SQL, "converter" );
                 }
             break;
         default:
             owarn << "Unknown database selected (" << m_selectedDatabase << ")" << oendl;
             return;
         }
         break;
     default:
         owarn << "Unknown destination format selected (" << m_selectedDestFormat << ")!!" << oendl;
         return;
     }
 
     if ( !sourceDB || !destDB )
         return;
 
     m_criticalState = true;
 
     sourceDB -> load();
     destDB -> load();
 
     QTime t;
     t.start();
 
     // Clean the dest-database if requested (isChecked)
     if ( m_eraseDB -> isChecked() ){
         odebug << "Clearing destination database!" << oendl;
         destDB -> clear();
     }
 
     // Now transmit every pim-item from the source database to the destination -database
     QArray<int> uidList = sourceDB->records();
     odebug << "Try to move data for addressbook.. (" << uidList.count() << " items) " << oendl;
     m_progressBar->setTotalSteps( uidList.count() );
     int count = 0;
     for ( uint i = 0; i < uidList.count(); ++i ){
         odebug << "Adding uid: " << uidList[i] << "" << oendl;
         OPimRecord* rec = sourceDB -> record( uidList[i] );
         destDB -> add( rec );
         m_progressBar->setProgress( ++count );
     }
 
     // Now commit data..
     destDB -> save();
 
     m_criticalState = false;
 
     // Delete the frontends. Backends will be deleted automatically, too !
     // We have to cast them back to delete them properly !
     switch( m_selectedDatabase ){
     case ADDRESSBOOK:
         delete static_cast<OPimContactAccess*> (sourceDB);
         delete static_cast<OPimContactAccess*> (destDB);
         break;
     case TODOLIST:
         delete static_cast<OPimTodoAccess*> (sourceDB);
         delete static_cast<OPimTodoAccess*> (destDB);
         break;
     case DATEBOOK:
         delete static_cast<ODateBookAccess*> (sourceDB);
         delete static_cast<ODateBookAccess*> (destDB);
         break;
     default:
         owarn << "Unknown database selected (" << m_selectedDatabase << ")" << oendl;
         return;
     }
 
 
     owarn << "Conversion is finished and needed " << t.elapsed() << " ms !" << oendl;
 }
 
 void Converter::closeEvent( QCloseEvent *e )
 {
 
         /* Due to the fact that we don't have multitasking here, this
          * critical handling don't make sense, but the future..
          */
         if ( m_criticalState ){
                 e->ignore();
                 return;
         }
         e->accept();
 }
+
+
+
+void Converter::start_upgrade()
+{
+        odebug << "Start upgrading" << oendl;
+        switch( QMessageBox::warning( this, "Pim-Converter",
+                                      "Are you really sure that you\n"
+                                      "want to convert your database from\n"
+                                      "sqlite V2 to sqlite V3?",
+                                      QMessageBox::Ok | QMessageBox::Default,
+                                      QMessageBox::Abort | QMessageBox::Escape )) {
+
+        case QMessageBox::Abort: // Abort clicked or Escape pressed
+                // abort
+                return;
+                break;
+        }
+        odebug << "Checking whether sqlite is installed" << oendl;
+        if ( system( "which sqlite" ) != 0 ){
+                QMessageBox::critical( this, "Pim-Converter",
+                                       QString("An internal error occurred:\n") +
+                                       "sqlite was not accessible!\n"+
+                                       "Please correct the PATH or install \n" + 
+                                       "this packages!" );
+                return;
+        }
+        if ( system( "which sqlite3" ) != 0 ){
+                QMessageBox::critical( this, "Pim-Converter",
+                                       QString("An internal error occurred:\n") +
+                                       "sqlite3 was not accessible!\n"+
+                                       "Please correct the PATH or install \n" + 
+                                       "this packages!" );
+                return;
+        }
+        if ( QFile::exists( "~/Applications/addressbook/addressbook.db" ) 
+             && !QFile::exists( "~/Applications/addressbook/addressbook.db_v2" ) ){ 
+                odebug << "Executing conversion commands" << oendl;
+                QString addr_convert_string = "cd ~/Applications/addressbook/;cp addressbook.db addressbook.db_v2;sqlite addressbook.db_v2 .dump | sqlite3 addressbook.db";
+                odebug << "1. Addressbook Command:" << addr_convert_string << oendl;
+                if ( system( addr_convert_string ) != 0 ){
+                        QMessageBox::critical( this, "Pim-Converter",
+                                               QString("An internal error occurred:\n") +
+                                               "Converting the addressbook command was impossible!\n"+
+                                               "Executed the following command:\n" + 
+                                               addr_convert_string );
+                        return;
+                }
+        }
+        if ( QFile::exists( "~/Applications/datebook/datebook.db" ) 
+             && !QFile::exists( "~/Applications/datebook/datebook.db_v2" ) ){ 
+                QString dateb_convert_string = "cd ~/Applications/datebook/;cp datebook.db datebook.db_v2;sqlite datebook.db_v2 .dump | sqlite3 datebook.db";
+                odebug << "2. Datebook Command" << dateb_convert_string << oendl;
+                if ( system( dateb_convert_string ) != 0 ){
+                        QMessageBox::critical( this, "Pim-Converter",
+                                               QString("An internal error occurred:\n") +
+                                               "Converting the datebook command was impossible!\n"+
+                                               "Executed the following command:\n" + 
+                                               dateb_convert_string );
+                        return;
+                }
+        }
+
+        if ( QFile::exists( "~/Applications/todolist/todolist.db" ) 
+             && !QFile::exists( "~/Applications/todolist/todolist.db_v2" ) ){ 
+                QString todo_convert_string = "cd ~/Applications/todolist/;cp todolist.db todolist.db_v2;sqlite todolist.db_v2 .dump | sqlite3 todolist.db";
+                odebug << "3. Todolist Command:" << todo_convert_string << oendl;
+                if ( system( todo_convert_string ) != 0 ){
+                        QMessageBox::critical( this, "Pim-Converter",
+                                               QString("An internal error occurred:\n") +
+                                               "Converting the todolist command was impossible!\n"+
+                                               "Executed the following command:\n" + 
+                                               todo_convert_string );
+                        return;
+                }
+        }
+
+        QMessageBox::information( this, "Pim-Converter",
+                                  "Conversion is finished!",
+                                  "&OK", NULL, NULL,
+                                  0,      // Enter == button 0
+                                  0 );
+        
+        
+}
diff --git a/noncore/tools/pimconverter/converter.h b/noncore/tools/pimconverter/converter.h
index 344562a..9d75d79 100755
--- a/noncore/tools/pimconverter/converter.h
+++ b/noncore/tools/pimconverter/converter.h
@@ -1,44 +1,46 @@
 #ifndef _CONVERTER_H_
 #define _CONVERTER_H_
 
 
 #include "converter_base.h"
 
 
 class Converter: public converter_base {
 public:
         Converter(QWidget *parent, const char* name, WFlags fl);
         static QString appName() { return QString::fromLatin1("opimconverter");}
 
         // Slots defined in the ui-description file
         void start_conversion();
+        void start_upgrade();
         void selectedDatabase( int num );
         void selectedDestFormat( int num );
         void selectedSourceFormat( int num );
 
         void closeEvent( QCloseEvent *e );
         
 private:
         // Caution:
         // The order and value of the following enums must be regarding
         // the predefinition in the UI-File !!
+        // If you don't understand what I am talking about: Keep your fingers away!!
         enum DataBases{
                 ADDRESSBOOK = 0,
                 TODOLIST    = 1,
                 DATEBOOK    = 2,
         };
 
         enum DbFormats{
                 XML = 0,
                 SQL = 1,
         };
 
         int m_selectedDatabase;
         int m_selectedSourceFormat;
         int m_selectedDestFormat;
         bool m_criticalState;
 
 };
 
 
 #endif
diff --git a/noncore/tools/pimconverter/converter_base.ui b/noncore/tools/pimconverter/converter_base.ui
index a5b22c9..b519f2e 100644
--- a/noncore/tools/pimconverter/converter_base.ui
+++ b/noncore/tools/pimconverter/converter_base.ui
@@ -1,291 +1,333 @@
 <!DOCTYPE UI><UI>
 <class>converter_base</class>
 <widget>
     <class>QWidget</class>
     <property stdset="1">
         <name>name</name>
         <cstring>converter_base</cstring>
     </property>
     <property stdset="1">
         <name>geometry</name>
         <rect>
             <x>0</x>
             <y>0</y>
-            <width>269</width>
-            <height>324</height>
+            <width>308</width>
+            <height>323</height>
         </rect>
     </property>
     <property stdset="1">
         <name>caption</name>
         <string>PIM-Database Converter</string>
     </property>
     <property>
         <name>layoutMargin</name>
     </property>
     <grid>
         <property stdset="1">
             <name>margin</name>
             <number>4</number>
         </property>
         <property stdset="1">
             <name>spacing</name>
             <number>6</number>
         </property>
         <widget row="0"  column="0" >
             <class>QGroupBox</class>
             <property stdset="1">
                 <name>name</name>
                 <cstring>GroupBox6</cstring>
             </property>
             <property stdset="1">
                 <name>title</name>
                 <string>Converter</string>
             </property>
             <property>
                 <name>layoutMargin</name>
             </property>
             <property>
                 <name>layoutSpacing</name>
             </property>
             <vbox>
                 <property stdset="1">
                     <name>margin</name>
                     <number>4</number>
                 </property>
                 <property stdset="1">
                     <name>spacing</name>
                     <number>2</number>
                 </property>
                 <widget>
+                    <class>QPushButton</class>
+                    <property stdset="1">
+                        <name>name</name>
+                        <cstring>PushButton2</cstring>
+                    </property>
+                    <property stdset="1">
+                        <name>text</name>
+                        <string>Upgrade to SQLite3</string>
+                    </property>
+                </widget>
+                <widget>
                     <class>QGroupBox</class>
                     <property stdset="1">
                         <name>name</name>
                         <cstring>GroupBox1</cstring>
                     </property>
                     <property stdset="1">
                         <name>title</name>
                         <string>Select Database:</string>
                     </property>
+                    <property>
+                        <name>layoutMargin</name>
+                    </property>
+                    <property>
+                        <name>layoutSpacing</name>
+                    </property>
                     <grid>
                         <property stdset="1">
                             <name>margin</name>
-                            <number>11</number>
+                            <number>4</number>
                         </property>
                         <property stdset="1">
                             <name>spacing</name>
-                            <number>6</number>
+                            <number>2</number>
                         </property>
                         <widget row="0"  column="1" >
                             <class>QComboBox</class>
                             <item>
                                 <property>
                                     <name>text</name>
                                     <string>Addressbook</string>
                                 </property>
                             </item>
                             <item>
                                 <property>
                                     <name>text</name>
                                     <string>TodoList</string>
                                 </property>
                             </item>
                             <item>
                                 <property>
                                     <name>text</name>
                                     <string>Datebook</string>
                                 </property>
                             </item>
                             <property stdset="1">
                                 <name>name</name>
                                 <cstring>m_dataBaseSelector</cstring>
                             </property>
                         </widget>
                     </grid>
                 </widget>
                 <widget>
                     <class>QGroupBox</class>
                     <property stdset="1">
                         <name>name</name>
                         <cstring>GroupBox2</cstring>
                     </property>
                     <property stdset="1">
                         <name>title</name>
                         <string>Source/Destination:</string>
                     </property>
+                    <property>
+                        <name>layoutMargin</name>
+                    </property>
+                    <property>
+                        <name>layoutSpacing</name>
+                    </property>
                     <grid>
                         <property stdset="1">
                             <name>margin</name>
-                            <number>11</number>
+                            <number>4</number>
                         </property>
                         <property stdset="1">
                             <name>spacing</name>
-                            <number>6</number>
+                            <number>2</number>
                         </property>
                         <widget row="1"  column="0" >
                             <class>QLabel</class>
                             <property stdset="1">
                                 <name>name</name>
                                 <cstring>TextLabel3_2</cstring>
                             </property>
                             <property stdset="1">
                                 <name>text</name>
                                 <string>to</string>
                             </property>
                         </widget>
                         <widget row="1"  column="1" >
                             <class>QComboBox</class>
                             <item>
                                 <property>
                                     <name>text</name>
                                     <string>XML</string>
                                 </property>
                             </item>
                             <item>
                                 <property>
                                     <name>text</name>
                                     <string>SQL (SQLite)</string>
                                 </property>
                             </item>
                             <property stdset="1">
                                 <name>name</name>
                                 <cstring>m_destFormatSelector</cstring>
                             </property>
                         </widget>
                         <widget row="0"  column="0" >
                             <class>QLabel</class>
                             <property stdset="1">
                                 <name>name</name>
                                 <cstring>TextLabel2_2</cstring>
                             </property>
                             <property stdset="1">
                                 <name>text</name>
                                 <string>Convert from</string>
                             </property>
                         </widget>
                         <widget row="0"  column="1" >
                             <class>QComboBox</class>
                             <item>
                                 <property>
                                     <name>text</name>
                                     <string>XML</string>
                                 </property>
                             </item>
                             <item>
                                 <property>
                                     <name>text</name>
                                     <string>SQL (SQLite)</string>
                                 </property>
                             </item>
                             <property stdset="1">
                                 <name>name</name>
                                 <cstring>m_sourceFormatSelector</cstring>
                             </property>
                         </widget>
                     </grid>
                 </widget>
                 <widget>
                     <class>QGroupBox</class>
                     <property stdset="1">
                         <name>name</name>
                         <cstring>GroupBox5</cstring>
                     </property>
                     <property stdset="1">
                         <name>title</name>
                         <string>Config:</string>
                     </property>
+                    <property>
+                        <name>layoutMargin</name>
+                    </property>
+                    <property>
+                        <name>layoutSpacing</name>
+                    </property>
                     <grid>
                         <property stdset="1">
                             <name>margin</name>
-                            <number>11</number>
+                            <number>4</number>
                         </property>
                         <property stdset="1">
                             <name>spacing</name>
-                            <number>6</number>
+                            <number>4</number>
                         </property>
                         <widget row="0"  column="0" >
                             <class>QCheckBox</class>
                             <property stdset="1">
                                 <name>name</name>
                                 <cstring>m_eraseDB</cstring>
                             </property>
                             <property stdset="1">
                                 <name>text</name>
                                 <string>Erase before copy</string>
                             </property>
                         </widget>
                     </grid>
                 </widget>
                 <widget>
                     <class>QGroupBox</class>
                     <property stdset="1">
                         <name>name</name>
                         <cstring>GroupBox4</cstring>
                     </property>
                     <property stdset="1">
                         <name>title</name>
                         <string>Progress:</string>
                     </property>
+                    <property>
+                        <name>layoutMargin</name>
+                    </property>
+                    <property>
+                        <name>layoutSpacing</name>
+                    </property>
                     <vbox>
                         <property stdset="1">
                             <name>margin</name>
-                            <number>11</number>
+                            <number>4</number>
                         </property>
                         <property stdset="1">
                             <name>spacing</name>
-                            <number>6</number>
+                            <number>2</number>
                         </property>
                         <widget>
                             <class>QProgressBar</class>
                             <property stdset="1">
                                 <name>name</name>
                                 <cstring>m_progressBar</cstring>
                             </property>
                         </widget>
                         <widget>
                             <class>QPushButton</class>
                             <property stdset="1">
                                 <name>name</name>
                                 <cstring>PushButton1</cstring>
                             </property>
                             <property stdset="1">
                                 <name>text</name>
                                 <string>Go!</string>
                             </property>
                         </widget>
                     </vbox>
                 </widget>
             </vbox>
         </widget>
     </grid>
 </widget>
 <connections>
     <connection>
         <sender>PushButton1</sender>
         <signal>clicked()</signal>
         <receiver>converter_base</receiver>
         <slot>start_conversion()</slot>
     </connection>
     <connection>
         <sender>m_sourceFormatSelector</sender>
         <signal>activated(int)</signal>
         <receiver>converter_base</receiver>
         <slot>selectedSourceFormat(int)</slot>
     </connection>
     <connection>
         <sender>m_dataBaseSelector</sender>
         <signal>activated(int)</signal>
         <receiver>converter_base</receiver>
         <slot>selectedDatabase(int)</slot>
     </connection>
     <connection>
         <sender>m_destFormatSelector</sender>
         <signal>activated(int)</signal>
         <receiver>converter_base</receiver>
         <slot>selectedDestFormat(int)</slot>
     </connection>
+    <connection>
+        <sender>PushButton2</sender>
+        <signal>clicked()</signal>
+        <receiver>converter_base</receiver>
+        <slot>start_upgrade()</slot>
+    </connection>
     <slot access="public">selectedDatabase(int)</slot>
     <slot access="public">selectedDestFormat(int)</slot>
     <slot access="public">selectedSourceFormat(int)</slot>
     <slot access="public">start_conversion()</slot>
+    <slot access="public">start_upgrade()</slot>
 </connections>
 </UI>