diff options
author | Aleksander Mistewicz <a.mistewicz@samsung.com> | 2016-07-22 11:43:26 +0200 |
---|---|---|
committer | Aleksander Mistewicz <a.mistewicz@samsung.com> | 2016-11-02 17:17:41 +0100 |
commit | a91d1aa1a8b4eb4bbb096d9ab1d9a6b76ac90d70 (patch) | |
tree | 1037018ec91fe14eb65606a35a8bcbebde210c65 /tsp | |
parent | 92e50d0ae61acb30dc07e60f2dcf0ec6a7e3ac79 (diff) | |
download | major-a91d1aa1a8b4eb4bbb096d9ab1d9a6b76ac90d70.tar.gz major-a91d1aa1a8b4eb4bbb096d9ab1d9a6b76ac90d70.tar.bz2 major-a91d1aa1a8b4eb4bbb096d9ab1d9a6b76ac90d70.zip |
Add schema and initial values for sqlite3 db
tsp/results-schema.sql contains basic table definitions
of device, result, test and "currentstatus" view.
Change-Id: I53c5a7e5d744aba07500ef5492c490368692cb44
Signed-off-by: Aleksander Mistewicz <a.mistewicz@samsung.com>
Diffstat (limited to 'tsp')
-rw-r--r-- | tsp/results-schema.sql | 30 | ||||
-rw-r--r-- | tsp/results-values-device.sql | 3 | ||||
-rw-r--r-- | tsp/results-values-result.sql | 5 |
3 files changed, 38 insertions, 0 deletions
diff --git a/tsp/results-schema.sql b/tsp/results-schema.sql new file mode 100644 index 0000000..3f1551d --- /dev/null +++ b/tsp/results-schema.sql @@ -0,0 +1,30 @@ +CREATE TABLE IF NOT EXISTS device ( + did INTEGER PRIMARY KEY, + dname TEXT NOT NULL UNIQUE +); + +CREATE TABLE IF NOT EXISTS result ( + rid INTEGER PRIMARY KEY, + rname TEXT NOT NULL UNIQUE +); + +CREATE TABLE IF NOT EXISTS test ( + tid INTEGER PRIMARY KEY AUTOINCREMENT, + tnumber TEXT, + tdate TEXT, + trid INTEGER REFERENCES result (rid), + tdid INTEGER REFERENCES device (did), + UNIQUE (tnumber, tdid) ON CONFLICT REPLACE +); + +CREATE VIEW IF NOT EXISTS currentstatus AS + SELECT + test.tnumber AS "SR", + test.tdate AS "Date", + 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 + ORDER BY SR DESC +; diff --git a/tsp/results-values-device.sql b/tsp/results-values-device.sql new file mode 100644 index 0000000..cfe3740 --- /dev/null +++ b/tsp/results-values-device.sql @@ -0,0 +1,3 @@ +INSERT OR IGNORE INTO device VALUES (NULL, "odroid"); +INSERT OR IGNORE INTO device VALUES (NULL, "minnow32"); +INSERT OR IGNORE INTO device VALUES (NULL, "minnow64"); diff --git a/tsp/results-values-result.sql b/tsp/results-values-result.sql new file mode 100644 index 0000000..d770a39 --- /dev/null +++ b/tsp/results-values-result.sql @@ -0,0 +1,5 @@ +INSERT OR IGNORE INTO result VALUES (NULL, "OK"); +INSERT OR IGNORE INTO result VALUES (NULL, "Unclear"); +INSERT OR IGNORE INTO result VALUES (NULL, "Fail"); +INSERT OR IGNORE INTO result VALUES (NULL, "Identical"); +INSERT OR IGNORE INTO result VALUES (NULL, "Snapshot"); |