#include "converter.h" /* OPIE */ #include #include #include // Include SQL related header files #define __USE_SQL #include /* QT */ #include #include #include #include #include OPIE_EXPORT_APP( Opie::Core::OApplicationFactory ) 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::create( OPimGlobal::CONTACTLIST, OPimGlobal::XML, "converter" ); } break; case TODOLIST:{ sourceDB = OPimAccessFactory::create( OPimGlobal::TODOLIST, OPimGlobal::XML, "converter" ); }break; case DATEBOOK:{ sourceDB = OPimAccessFactory::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::create( OPimGlobal::CONTACTLIST, OPimGlobal::SQL, "converter" ); } break; case TODOLIST:{ sourceDB = OPimAccessFactory::create( OPimGlobal::TODOLIST, OPimGlobal::SQL, "converter" ); }break; case DATEBOOK:{ sourceDB = OPimAccessFactory::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::create( OPimGlobal::CONTACTLIST, OPimGlobal::XML, "converter" ); } break; case TODOLIST:{ destDB = OPimAccessFactory::create( OPimGlobal::TODOLIST, OPimGlobal::XML, "converter" ); }break; case DATEBOOK:{ destDB = OPimAccessFactory::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::create( OPimGlobal::CONTACTLIST, OPimGlobal::SQL, "converter" ); } break; case TODOLIST:{ destDB = OPimAccessFactory::create( OPimGlobal::TODOLIST, OPimGlobal::SQL, "converter" ); }break; case DATEBOOK:{ destDB = OPimAccessFactory::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 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 (sourceDB); delete static_cast (destDB); break; case TODOLIST: delete static_cast (sourceDB); delete static_cast (destDB); break; case DATEBOOK: delete static_cast (sourceDB); delete static_cast (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(); }