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
@@ -2,2 +2,4 @@
+#include <stdlib.h> // For "system()" command
+
/* OPIE */
@@ -226 +228,86 @@ void Converter::closeEvent( QCloseEvent *e )
}
+
+
+
+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
@@ -14,2 +14,3 @@ public:
void start_conversion();
+ void start_upgrade();
void selectedDatabase( int num );
@@ -24,2 +25,3 @@ private:
// the predefinition in the UI-File !!
+ // If you don't understand what I am talking about: Keep your fingers away!!
enum DataBases{
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
@@ -13,4 +13,4 @@
<y>0</y>
- <width>269</width>
- <height>324</height>
+ <width>308</width>
+ <height>323</height>
</rect>
@@ -59,2 +59,13 @@
<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>
@@ -68,2 +79,8 @@
</property>
+ <property>
+ <name>layoutMargin</name>
+ </property>
+ <property>
+ <name>layoutSpacing</name>
+ </property>
<grid>
@@ -71,3 +88,3 @@
<name>margin</name>
- <number>11</number>
+ <number>4</number>
</property>
@@ -75,3 +92,3 @@
<name>spacing</name>
- <number>6</number>
+ <number>2</number>
</property>
@@ -114,2 +131,8 @@
</property>
+ <property>
+ <name>layoutMargin</name>
+ </property>
+ <property>
+ <name>layoutSpacing</name>
+ </property>
<grid>
@@ -117,3 +140,3 @@
<name>margin</name>
- <number>11</number>
+ <number>4</number>
</property>
@@ -121,3 +144,3 @@
<name>spacing</name>
- <number>6</number>
+ <number>2</number>
</property>
@@ -195,2 +218,8 @@
</property>
+ <property>
+ <name>layoutMargin</name>
+ </property>
+ <property>
+ <name>layoutSpacing</name>
+ </property>
<grid>
@@ -198,3 +227,3 @@
<name>margin</name>
- <number>11</number>
+ <number>4</number>
</property>
@@ -202,3 +231,3 @@
<name>spacing</name>
- <number>6</number>
+ <number>4</number>
</property>
@@ -227,2 +256,8 @@
</property>
+ <property>
+ <name>layoutMargin</name>
+ </property>
+ <property>
+ <name>layoutSpacing</name>
+ </property>
<vbox>
@@ -230,3 +265,3 @@
<name>margin</name>
- <number>11</number>
+ <number>4</number>
</property>
@@ -234,3 +269,3 @@
<name>spacing</name>
- <number>6</number>
+ <number>2</number>
</property>
@@ -285,2 +320,8 @@
</connection>
+ <connection>
+ <sender>PushButton2</sender>
+ <signal>clicked()</signal>
+ <receiver>converter_base</receiver>
+ <slot>start_upgrade()</slot>
+ </connection>
<slot access="public">selectedDatabase(int)</slot>
@@ -289,2 +330,3 @@
<slot access="public">start_conversion()</slot>
+ <slot access="public">start_upgrade()</slot>
</connections>