Add os upgrade file for database

Change-Id: Ia679c169d26d8e9163d385362c08875776abc2ce
Signed-off-by: hyunuk.tak <hyunuk.tak@samsung.com>

diff --git a/packaging/stc-manager.spec b/packaging/stc-manager.spec
index 30d4919..2ed5dc0 100644 (file)
--- a/packaging/stc-manager.spec
+++ b/packaging/stc-manager.spec
@@ -10,6 +10,8 @@ Source0:    %{name}-%{version}.tar.gz
 %define enable_statistics YES
 %define enable_restriction YES
 %define database_full_path /opt/usr/dbspace/.stc-manager-datausage.db
+%define upgrade_script_filename 500.stc-manager_upgrade.sh
+%define upgrade_script_path /usr/share/upgrade/scripts
 
 BuildRequires:  cmake
 BuildRequires:  pkgconfig(glib-2.0)
@@ -143,6 +145,10 @@ cp resources/dbus/stc-manager.conf %{buildroot}%{_sysconfdir}/dbus-1/system.d/st
 mkdir -p %{buildroot}%{_datadir}/dbus-1/system-services/
 cp resources/dbus/net.stc-manager.service %{buildroot}%{_datadir}/dbus-1/system-services/net.stc-manager.service
 
+#OS Upgrade
+mkdir -p %{buildroot}%{upgrade_script_path}
+cp -f scripts/%{upgrade_script_filename} %{buildroot}%{upgrade_script_path}
+
 %files
 %manifest %{name}.manifest
 %license LICENSE
@@ -168,6 +174,8 @@ cp resources/dbus/net.stc-manager.service %{buildroot}%{_datadir}/dbus-1/system-
 %{_bindir}/gtest*
 %endif
 
+%{upgrade_script_path}/%{upgrade_script_filename}
+
 %files plugin-appstatus
 %manifest %{name}.manifest
 %attr(644, -,-) %{_datadir}/icons/*.png

diff --git a/scripts/500.stc-manager_upgrade.sh b/scripts/500.stc-manager_upgrade.sh
new file mode 100644 (file)
index 0000000..ad0c84b
--- /dev/null
+++ b/scripts/500.stc-manager_upgrade.sh
@@ -0,0 +1,52 @@
+#!/bin/sh
+PATH=/bin:/usr/bin:/sbin:/usr/sbin
+
+#----------------------------------------------------------------#
+# stc-manager patch script for upgrade (4.0 -> the latest tizen) #
+#----------------------------------------------------------------#
+
+if [ "$OLD_VER" = "4.0.0.0" ]; then
+       sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "alter table restrictions rename column rst_state to rstn_type;"
+
+       sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "CREATE TABLE IF NOT EXISTS fw_lock (
+         name TEXT PRIMARY KEY,
+         state INT
+       );"
+
+       sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "CREATE TABLE IF NOT EXISTS fw_chains (
+         chain TEXT PRIMARY KEY,
+         target INT,
+         priority INT
+       );"
+
+       sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "CREATE TABLE IF NOT EXISTS fw_rules (
+         key BIGINT PRIMARY KEY,
+         chain TEXT NOT NULL,
+         direction INT,
+         s_ip_type INT,
+         d_ip_type INT,
+         s_port_type INT,
+         d_port_type INT,
+         protocol INT,
+         family INT,
+         s_ip1 TEXT NOT NULL,
+         s_ip2 TEXT NOT NULL,
+         d_ip1 TEXT NOT NULL,
+         d_ip2 TEXT NOT NULL,
+         s_port1 INT,
+         s_port2 INT,
+         d_port1 INT,
+         d_port2 INT,
+         ifname TEXT NOT NULL,
+         target INT,
+         log_level INT,
+         log_prefix TEXT NOT NULL,
+         nflog_group INT,
+         nflog_prefix TEXT NOT NULL,
+         nflog_range INT,
+         nflog_threshold INT,
+         identifier TEXT NOT NULL
+       );"
+
+       sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "CREATE INDEX IF NOT EXISTS rules_index ON fw_rules (chain, target);"
+fi