summaryrefslogtreecommitdiff
path: root/bin/fetch.fnl
diff options
context:
space:
mode:
Diffstat (limited to 'bin/fetch.fnl')
-rw-r--r--bin/fetch.fnl4
1 files changed, 3 insertions, 1 deletions
diff --git a/bin/fetch.fnl b/bin/fetch.fnl
index c23019f..53a8f7a 100644
--- a/bin/fetch.fnl
+++ b/bin/fetch.fnl
@@ -101,7 +101,9 @@
(fn store-products [tx products]
(when (< 0 (# products))
(local sql
- (.. "INSERT OR REPLACE INTO products VALUES "
+ (.. "INSERT OR REPLACE INTO products"
+ "(url, site, title, description, year, image, price, weight, volume, price_per, archived, creation_time)"
+ " VALUES "
(array.join
(map (fn [_ _] "(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")
products)