diff options
| author | Marius Peter <dev@marius-peter.com> | 2025-11-30 11:58:25 +0100 |
|---|---|---|
| committer | Marius Peter <dev@marius-peter.com> | 2025-11-30 11:58:25 +0100 |
| commit | 1a8775dfe5786e71e7486e0d26d7dda627db2335 (patch) | |
| tree | 40b3b294f8ac4c02b5c7bc45746ef787e1bde102 /db | |
| parent | 355bbfd898a8b61797b3a077f15c5f97ab7ebb04 (diff) | |
Refactor 'measured-on' to 'measurement-date'.
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrations.rkt | 4 | ||||
| -rw-r--r-- | db/seed.rkt | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/db/migrations.rkt b/db/migrations.rkt index d07b130..a312623 100644 --- a/db/migrations.rkt +++ b/db/migrations.rkt @@ -111,9 +111,9 @@ (list (create-table #:if-not-exists nutrient_measurements #:columns [id integer #:not-null] ;; ISO8601 date - [measured_on text #:not-null] + [measurement_date text #:not-null] #:constraints (primary-key id) - (unique measured_on)))) + (unique measurement_date)))) (define-migration "create table nutrient_targets" (list (create-table #:if-not-exists nutrient_targets diff --git a/db/seed.rkt b/db/seed.rkt index 7530651..25d7ee3 100644 --- a/db/seed.rkt +++ b/db/seed.rkt @@ -51,14 +51,14 @@ (define header (next-row)) (define (row->seed! row) (define row-alist (map cons header row)) - (define measured-on (cdr (first row-alist))) + (define measurement-date (cdr (first row-alist))) (define nutrient-values (for/hash ([nm (in-list (cdr row-alist))]) (define formula (car nm)) (define n (get-nutrient #:formula formula)) (define v (string->number (cdr nm))) (values n v))) - (create-nutrient-measurement! measured-on nutrient-values)) + (create-nutrient-measurement! measurement-date nutrient-values)) (with-tx (csv-for-each row->seed! next-row))) (define (seed-crops!) |