-rw-r--r-- | noncore/tools/pimconverter/converter.cpp | 147 | ||||
-rwxr-xr-x | noncore/tools/pimconverter/converter.h | 3 |
2 files changed, 87 insertions, 63 deletions
diff --git a/noncore/tools/pimconverter/converter.cpp b/noncore/tools/pimconverter/converter.cpp index 2cd6969..fa3e714 100644 --- a/noncore/tools/pimconverter/converter.cpp +++ b/noncore/tools/pimconverter/converter.cpp @@ -1,32 +1,33 @@ #include "converter.h" #include <stdlib.h> // For "system()" command /* OPIE */ #include <opie2/oapplicationfactory.h> #include <opie2/odebug.h> #include <opie2/opimglobal.h> +#include <qpe/global.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 ) { @@ -40,52 +41,51 @@ 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" ) ); + QMessageBox::warning( this, tr("PimConverter"), + tr( "<qt>It is not a good idea to use" + "the same source and destformat !</qt>")); 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: @@ -206,108 +206,129 @@ void Converter::start_conversion(){ 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(); } +bool Converter::sqliteCopyAndConvert(const QString& src, const QString &dest, QString &cmd) +{ + if (!QFile::exists( src ) ) { + cmd = tr("No SQLite2 database exists"); + return false; + } + + if( QFile::exists( dest ) ) { + cmd = tr("A copy of the SQLite2 exists"); + return false; + } + + /* + * Copy it over + */ + cmd = "cp " + Global::shellQuote(src) + " " + Global::shellQuote(dest); + if( ::system( cmd ) != 0 ) + return false; + + /* + * Delete it to make place for the new file + */ + cmd = "rm " + Global::shellQuote(src); + if( ::system( cmd ) != 0 ) + return false; + + /* + * Convert it + */ + cmd = "sqlite " + Global::shellQuote(dest) + " .dump | sqlite3 " + Global::shellQuote(src); + return ::system( cmd ) == 0; +} + 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?", + switch( QMessageBox::warning( this, tr("Pim-Converter"), + tr("<qt>Are you really sure that you " + "want to convert your database from " + "sqlite V2 to sqlite V3?</qt>"), 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!" ); + QMessageBox::critical( this, tr("Pim-Converter"), + tr("<qt>An internal error occurred: " + "sqlite was not accessible! " + "Please correct the PATH or install " + "this packages!</qt>") ); 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!" ); + QMessageBox::critical( this, tr("Pim-Converter"), + tr("<qt>An internal error occurred: " + "sqlite3 was not accessible! " + "Please correct the PATH or install " + "this packages!</qt>") ); + return; + } + + QString src, dest, cmd; + src = Global::applicationFileName("addressbook", "addressbook.db" ); + dest = Global::applicationFileName("addressbook", "addressbook.db_v2" ); + + if(!sqliteCopyAndConvert(src, dest, cmd)) { + QMessageBox::critical( this, tr("Pim-Converter"), + tr("<qt>An internal error occurred: " + "Converting the addressbook command was impossible! " + "Executed the following command: %1</qt>").arg(cmd) ); 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; - } + + src = Global::applicationFileName("datebook", "datebook.db" ); + dest = Global::applicationFileName("datebook", "datebook.db_v2" ); + if(!sqliteCopyAndConvert(src, dest, cmd)) { + QMessageBox::critical( this, tr("Pim-Converter"), + tr("<qt>An internal error occurred: " + "Converting the datebook command was impossible! " + "Executed the following command: '%1' </qt>").arg(cmd) + ); + 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; - } + src = Global::applicationFileName("todolist", "todolist.db" ); + dest = Global::applicationFileName("todolist", "todolist.db_v2" ); + if(!sqliteCopyAndConvert(src, dest, cmd)) { + QMessageBox::critical( this, tr("Pim-Converter"), + tr("<qt>An internal error occurred: " + "Converting the todolist command was impossible! " + "Executed the following command: '%1' </qt>").arg(cmd) ); + return; } - QMessageBox::information( this, "Pim-Converter", - "Conversion is finished!", - "&OK", NULL, NULL, - 0, // Enter == button 0 - 0 ); - - + QMessageBox::information( this, tr("Pim-Converter"), + tr("Conversion is finished!"), + QMessageBox::Ok ); } diff --git a/noncore/tools/pimconverter/converter.h b/noncore/tools/pimconverter/converter.h index 9d75d79..e9035e7 100755 --- a/noncore/tools/pimconverter/converter.h +++ b/noncore/tools/pimconverter/converter.h @@ -19,28 +19,31 @@ public: 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; + +private: + static bool sqliteCopyAndConvert( const QString &src, const QString &destination, QString &lastCommand ); }; #endif |