summaryrefslogtreecommitdiff
Side-by-side diff
Diffstat (more/less context) (ignore whitespace changes)
-rw-r--r--noncore/tools/pimconverter/converter.cpp87
-rwxr-xr-xnoncore/tools/pimconverter/converter.h2
-rw-r--r--noncore/tools/pimconverter/converter_base.ui62
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,98 +1,100 @@
#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;
@@ -131,96 +133,181 @@ void Converter::start_conversion(){
}
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>