From ac657953bcb5fd220d9408e63b22fc1c29e1e5e9 Mon Sep 17 00:00:00 2001
From: Minje Ahn <minje.ahn@samsung.com>
Date: Fri, 28 Jun 2024 07:52:35 +0900
Subject: [PATCH] Add OS upgrade script

Change-Id: Ia81a7b23580206bc0341ecdc925e599a147e4072
Signed-off-by: Minje Ahn <minje.ahn@samsung.com>
---
 packaging/media-server.spec     |  8 +++++++-
 scripts/500.media_db_upgrade.sh | 20 ++++++++++++++++++++
 2 files changed, 27 insertions(+), 1 deletion(-)
 create mode 100755 scripts/500.media_db_upgrade.sh

diff --git a/packaging/media-server.spec b/packaging/media-server.spec
index c3e3da8..42c5531 100644
--- a/packaging/media-server.spec
+++ b/packaging/media-server.spec
@@ -1,6 +1,6 @@
 Name:       media-server
 Summary:    A server for media content management
-Version:    0.6.5
+Version:    0.6.6
 Release:    0
 Group:      Multimedia/Service
 License:    Apache-2.0
@@ -40,6 +40,8 @@ BuildRequires:  pkgconfig(deviced)
 %define product_tv 0
 %endif
 
+%define upgrade_script_path /usr/share/upgrade/scripts/
+
 %if ("%{sec_buildconf_optimized_memory}" == "1")
 %define on_demand 1
 %else
@@ -106,6 +108,9 @@ mkdir -p m4
 
 %make_install
 
+mkdir -p %{buildroot}%{upgrade_script_path}
+cp -f scripts/500.media_db_upgrade.sh %{buildroot}%{upgrade_script_path}
+
 mkdir -p %{buildroot}%{_unitdir}/multi-user.target.wants
 install -m 644 %{SOURCE1} %{buildroot}%{_unitdir}/media-server.service
 %if 0%{?on_demand}
@@ -181,6 +186,7 @@ chmod 755 /etc/gumd/useradd.d/30_media-server-add.post
 /etc/multimedia/media_content_config.ini
 /etc/gumd/useradd.d/30_media-server-add.post
 %license LICENSE.APLv2.0
+%{upgrade_script_path}/500.media_db_upgrade.sh
 
 %files -n libmedia-utils
 %manifest libmedia-utils.manifest
diff --git a/scripts/500.media_db_upgrade.sh b/scripts/500.media_db_upgrade.sh
new file mode 100755
index 0000000..0ecd74c
--- /dev/null
+++ b/scripts/500.media_db_upgrade.sh
@@ -0,0 +1,20 @@
+#!/bin/sh
+# OS upgrade script for media.db
+
+/usr/bin/sqlite3 /opt/usr/home/owner/.applications/dbspace/.media.db << EOF
+
+drop table media;
+drop table folder;
+drop table playlist_map;
+drop table playlist;
+drop table album;
+drop table tag_map;
+drop table tag;
+drop table bookmark;
+drop table storage;
+drop table face_scan_list;
+drop table face;
+drop view playlist_view;
+drop view tag_view;
+
+EOF
-- 
2.7.4