Overview
| Comment: | misnamed table in query, steps => test_steps |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | v1.62-no-rpc |
| Files: | files | file ages | folders |
| SHA1: |
2edc3f05a826456bb73133137acb8065 |
| User & Date: | matt on 2016-11-27 19:16:51 |
| Other Links: | branch diff | manifest | tags |
Context
|
2016-11-28
| ||
| 22:06 | Simplified and streamlined the rollup code check-in: 47f0625f23 user: matt tags: v1.62-no-rpc | |
|
2016-11-27
| ||
| 19:16 | misnamed table in query, steps => test_steps check-in: 2edc3f05a8 user: matt tags: v1.62-no-rpc | |
| 13:08 | Fixed runs cleanup where not constrained by run_id. Added missing mutex-unlock before recursively calling homehost. check-in: 8956d8d873 user: matt tags: v1.62-no-rpc | |
Changes
Modified db.scm from [08f18b2262] to [a2c9fda77a].
| ︙ | ︙ | |||
2425 2426 2427 2428 2429 2430 2431 |
dbstruct
0
#t
(lambda (db)
(sqlite3:with-transaction
db
(lambda ()
| | | 2425 2426 2427 2428 2429 2430 2431 2432 2433 2434 2435 2436 2437 2438 2439 |
dbstruct
0
#t
(lambda (db)
(sqlite3:with-transaction
db
(lambda ()
(sqlite3:execute db "DELETE FROM test_steps WHERE test_id IN (SELECT id FROM tests WHERE state='DELETED' AND event_time<?);" targtime)
(sqlite3:execute db "DELETE FROM test_data WHERE test_id IN (SELECT id FROM tests WHERE state='DELETED' AND event_time<?);" targtime)
(sqlite3:execute db "DELETE FROM tests WHERE state='DELETED' AND event_time<?;" targtime)))))))
;; set tests with state currstate and status currstatus to newstate and newstatus
;; use currstate = #f and or currstatus = #f to apply to any state or status respectively
;; WARNING: SQL injection risk. NB// See new but not yet used "faster" version below
;;
|
| ︙ | ︙ |