Overview
| Comment: | added new indexes on tests table |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | v1.65 | v1.6523 |
| Files: | files | file ages | folders |
| SHA1: |
55bfa73d283ae904ae5cea04b8b27e6c |
| User & Date: | bjbarcla on 2019-02-01 11:15:05 |
| Other Links: | branch diff | manifest | tags |
Context
|
2019-02-06
| ||
| 14:29 | Added -area as an alias to -area-tag to silence errors from MCC check-in: 29f35f475c user: jmoon18 tags: v1.65 | |
|
2019-02-02
| ||
| 19:31 | Merged v1.65 changes Leaf check-in: 1d106be172 user: matt tags: v1.65-intra-waiton | |
| 18:55 | Merged changes from v1.65 check-in: 3484aad005 user: matt tags: v1.65-multi-db | |
|
2019-02-01
| ||
| 11:15 | added new indexes on tests table check-in: 55bfa73d28 user: bjbarcla tags: v1.65, v1.6523 | |
|
2019-01-31
| ||
| 17:14 | bumped version to v1.6523 check-in: 582b7fa0fb user: bjbarcla tags: v1.65 | |
Changes
Modified db.scm from [bac3051f9d] to [da7bac24de].
| ︙ | ︙ | |||
1330 1331 1332 1333 1334 1335 1336 |
comment TEXT DEFAULT '',
event_time TIMESTAMP DEFAULT (strftime('%s','now')),
fail_count INTEGER DEFAULT 0,
pass_count INTEGER DEFAULT 0,
archived INTEGER DEFAULT 0, -- 0=no, > 1=archive block id where test data can be found
last_update INTEGER DEFAULT (strftime('%s','now')),
CONSTRAINT testsconstraint UNIQUE (run_id, testname, item_path));")
| | > > > > > | 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 |
comment TEXT DEFAULT '',
event_time TIMESTAMP DEFAULT (strftime('%s','now')),
fail_count INTEGER DEFAULT 0,
pass_count INTEGER DEFAULT 0,
archived INTEGER DEFAULT 0, -- 0=no, > 1=archive block id where test data can be found
last_update INTEGER DEFAULT (strftime('%s','now')),
CONSTRAINT testsconstraint UNIQUE (run_id, testname, item_path));")
;; deprecated -- (sqlite3:execute db "CREATE INDEX IF NOT EXISTS tests_index ON tests (run_id, testname, item_path, uname);")
(sqlite3:execute db "CREATE INDEX IF NOT EXISTS tests_run_id_index ON tests (run_id);") ;; new
(sqlite3:execute db "CREATE INDEX IF NOT EXISTS tests_testname_index ON tests (testname,item_path);") ;; new
(sqlite3:execute db "CREATE INDEX IF NOT EXISTS tests_state_status_index ON tests (state, status); ") ;; new
(sqlite3:execute db "CREATE TRIGGER IF NOT EXISTS update_tests_trigger AFTER UPDATE ON tests
FOR EACH ROW
BEGIN
UPDATE tests SET last_update=(strftime('%s','now'))
WHERE id=old.id;
END;")
(sqlite3:execute db "CREATE TABLE IF NOT EXISTS test_steps
|
| ︙ | ︙ |