Overview
| Comment: | Tweak to v1.25, added table qualifiers to select, old db's had conflicting columns. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
1234f4303b4fdd7bbf445d47ac28d603 |
| User & Date: | mrwellan on 2011-09-13 09:57:57 |
| Other Links: | manifest | tags |
Context
|
2011-09-13
| ||
| 11:39 | Tweak to v1.25, some spreadsheet columns misaligned with the data. check-in: 233acb17b2 user: mrwellan tags: trunk | |
| 09:57 | Tweak to v1.25, added table qualifiers to select, old db's had conflicting columns. check-in: 1234f4303b user: mrwellan tags: trunk | |
|
2011-09-12
| ||
| 23:24 | Bumped version to v1.25 check-in: 68b04b8d85 user: matt tags: trunk, v1.25 | |
Changes
Modified db.scm from [884f0970bf] to [23a8f08942].
| ︙ | ︙ | |||
801 802 803 804 805 806 807 | (curr-test-name #f)) (sqlite3:for-each-row (lambda (run-id testname item-path category variable value expected tol units status comment) (set! curr-test-name testname) (set! test-data (append test-data (list (list run-id testname item-path category variable value expected tol units status comment))))) db ;; "SELECT run_id,testname,item_path,category,variable,td.value AS value,expected,tol,units,td.status AS status,td.comment AS comment FROM test_data AS td INNER JOIN tests ON tests.id=td.test_id WHERE test_id=?;" | | | 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 |
(curr-test-name #f))
(sqlite3:for-each-row
(lambda (run-id testname item-path category variable value expected tol units status comment)
(set! curr-test-name testname)
(set! test-data (append test-data (list (list run-id testname item-path category variable value expected tol units status comment)))))
db
;; "SELECT run_id,testname,item_path,category,variable,td.value AS value,expected,tol,units,td.status AS status,td.comment AS comment FROM test_data AS td INNER JOIN tests ON tests.id=td.test_id WHERE test_id=?;"
"SELECT run_id,testname,item_path,category,variable,td.value AS value,td.expected,td.tol,td.units,td.status AS status,td.comment AS comment FROM test_data AS td INNER JOIN tests ON tests.id=td.test_id WHERE testname=?;"
test-id)
(if curr-test-name
(set! results (append results (list (cons curr-test-name test-data)))))
))
(delete-duplicates test-ids))
(system (conc "mkdir -p " tempdir))
;; (pp results)
|
| ︙ | ︙ |