summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAleksander Mistewicz <a.mistewicz@samsung.com>2017-08-17 13:41:40 (GMT)
committerAleksander Mistewicz <a.mistewicz@samsung.com>2017-09-27 16:58:33 (GMT)
commit5a38f807507abd6fd0864642163ac4378c5e935f (patch)
tree0ef9042f1f46a8345e869f262dd8f594199e80b7
parentebba10f82e007453bb6da61e4d313a43f5b12c46 (diff)
downloadmajor-5a38f807507abd6fd0864642163ac4378c5e935f.zip
major-5a38f807507abd6fd0864642163ac4378c5e935f.tar.gz
major-5a38f807507abd6fd0864642163ac4378c5e935f.tar.bz2
Add tizen 4.0 unified supportrefs/changes/24/181824/1
Database update is required. Run: . tsp/common.sh sqlite3 "${DBPATH}" -batch < tsp/results-schema.sql Change-Id: If8d823dad442e57b206c44584f4d4404a8518299
-rwxr-xr-xtsp/common.sh1
-rwxr-xr-xtsp/jobs/update_www.sh1
-rw-r--r--tsp/results-schema.sql14
3 files changed, 16 insertions, 0 deletions
diff --git a/tsp/common.sh b/tsp/common.sh
index fb191f6..810865a 100755
--- a/tsp/common.sh
+++ b/tsp/common.sh
@@ -59,6 +59,7 @@ DBNAME="results.db3"
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"
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 804b121..c765f33 100755
--- a/tsp/jobs/update_www.sh
+++ b/tsp/jobs/update_www.sh
@@ -24,5 +24,6 @@ test -f "${UPDATE_WWW}" || die "No need to update the webpage" 0
publish -limit 2048 -db "${DBPATH}" -out "${WWW_PUBLISH}"
publish -limit 1024 -tizen3 -db "${DBPATH}" -out "${WWW_3_PUBLISH}"
+publish -limit 1024 -tizen4 -db "${DBPATH}" -out "${WWW_4_PUBLISH}"
rm "${UPDATE_WWW}"
diff --git a/tsp/results-schema.sql b/tsp/results-schema.sql
index 7b40105..c47fb9a 100644
--- a/tsp/results-schema.sql
+++ b/tsp/results-schema.sql
@@ -43,3 +43,17 @@ CREATE VIEW IF NOT EXISTS currentstatus3 AS
WHERE SR LIKE "%3.0-common%"
ORDER BY SR DESC
;
+
+CREATE VIEW IF NOT EXISTS currentstatus4 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 "%4.0-unified%"
+ ORDER BY SR DESC
+;