Overview
| Comment: | typo fix |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | v1.55 |
| Files: | files | file ages | folders |
| SHA1: |
5b6ec2e95cfa7318f458cfcbd3ee63fc |
| User & Date: | matt on 2013-08-29 08:39:00 |
| Other Links: | branch diff | manifest | tags |
Context
|
2013-08-30
| ||
| 16:46 | Two minor fixes; lengthen timeout for queue handler, fix typo in jobgroup handling check-in: 87cbe68f31 user: mrwellan tags: v1.55 | |
|
2013-08-29
| ||
| 08:39 | typo fix check-in: 5b6ec2e95c user: matt tags: v1.55 | |
|
2013-08-23
| ||
| 00:15 | Added placeholder for index.html generator check-in: 832f340bbb user: matt tags: v1.55 | |
Changes
Modified db.scm from [af754dfc45] to [8a5cde103d].
| ︙ | ︙ | |||
480 481 482 483 484 485 486 | (sqlite3:prepare db stmt)) (list ;; delete all tests that belong to runs that are 'deleted' "DELETE FROM tests WHERE run_id in (SELECT id FROM runs WHERE state='deleted');" ;; delete all tests that are 'DELETED' "DELETE FROM tests WHERE state='DELETED';" ;; delete all tests that have no run | | | 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 |
(sqlite3:prepare db stmt))
(list
;; delete all tests that belong to runs that are 'deleted'
"DELETE FROM tests WHERE run_id in (SELECT id FROM runs WHERE state='deleted');"
;; delete all tests that are 'DELETED'
"DELETE FROM tests WHERE state='DELETED';"
;; delete all tests that have no run
"DELETE FROM tests WHERE run_id NOT IN (SELECT DISTINCT id FROM runs);"
;; delete all runs that are state='deleted'
"DELETE FROM runs WHERE state='deleted';"
;; delete empty runs
"DELETE FROM runs WHERE id NOT IN (SELECT DISTINCT r.id FROM runs AS r INNER JOIN tests AS t ON t.run_id=r.id);"
))))
(sqlite3:with-transaction
db
|
| ︙ | ︙ |