| -rw-r--r-- | noncore/tools/pimconverter/converter.cpp | 87 | ||||
| -rwxr-xr-x | noncore/tools/pimconverter/converter.h | 2 | ||||
| -rw-r--r-- | noncore/tools/pimconverter/converter_base.ui | 62 |
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> |