Add tizen 5.0 unified support

Database update is required. Run:

	. tsp/common.sh
	sqlite3 "${DBPATH}" -batch < tsp/results-schema.sql

Change-Id: I2478b1fa56f0383267c89638a973ca7b66ea8b94
Signed-off-by: Katarzyna Gorska <k.gorska@samsung.com>

3 files changed, 18 insertions, 0 deletions

diff --git a/tsp/common.sh b/tsp/common.sh
index e4af955..5180fb8 100755
--- a/tsp/common.sh
+++ b/tsp/common.sh
@@ -63,6 +63,7 @@ DBPATH="${WS_PUBLISH}/${DBNAME}"
 WWW_PUBLISH="${WS_PUBLISH}/current_status.html"
 WWW_3_PUBLISH="${WS_PUBLISH}/current_status_3.html"
 WWW_4_PUBLISH="${WS_PUBLISH}/current_status_4.html"
+WWW_5_PUBLISH="${WS_PUBLISH}/current_status_5.html"
 UPDATE_WWW="/var/tmp/should_update_www"
 WS_PUBLISH_WWW="${WS_PUBLISH}/www"
 TSP_WWW="${TSP_DIR}/www"
diff --git a/tsp/jobs/update_www.sh b/tsp/jobs/update_www.sh
index 0f1c30a..8dc3ca5 100755
--- a/tsp/jobs/update_www.sh
+++ b/tsp/jobs/update_www.sh
@@ -25,5 +25,6 @@ test -f "${UPDATE_WWW}" || die "No need to update the webpage" 0
 publish -limit 4096 -db "${DBPATH}" -out "${WWW_PUBLISH}"
 publish -limit 2048 -tizen3 -db "${DBPATH}" -out "${WWW_3_PUBLISH}"
 publish -limit 2048 -tizen4 -db "${DBPATH}" -out "${WWW_4_PUBLISH}"
+publish -limit 2048 -tizen5 -db "${DBPATH}" -out "${WWW_5_PUBLISH}"
 
 rm "${UPDATE_WWW}"
diff --git a/tsp/results-schema.sql b/tsp/results-schema.sql
index c47fb9a..77d4b1a 100644
--- a/tsp/results-schema.sql
+++ b/tsp/results-schema.sql
@@ -57,3 +57,19 @@ CREATE VIEW IF NOT EXISTS currentstatus4 AS
     WHERE SR LIKE "%4.0-unified%"
     ORDER BY SR DESC
 ;
+
+CREATE VIEW IF NOT EXISTS currentstatus5 AS
+    SELECT
+        test.tnumber AS "SR",
+        test.tdate AS "Date",
+        test.tbuildnr AS "Build nr",
+        device.dname AS "Device",
+        result.rname AS "Status"
+    FROM test
+    INNER JOIN device ON test.tdid = device.did
+    INNER JOIN result ON result.rid = test.trid
+    WHERE SR LIKE "%5.0-unified%"
+    ORDER BY SR DESC
+;
+
+