From c070964e142398f55c01c00b02f12015d886bd5c Mon Sep 17 00:00:00 2001 From: unwox Date: Thu, 19 Dec 2024 16:36:09 +0600 Subject: small improvements --- bin/fetch.fnl | 11 ++++------- 1 file changed, 4 insertions(+), 7 deletions(-) (limited to 'bin') diff --git a/bin/fetch.fnl b/bin/fetch.fnl index a5f8d63..c23019f 100644 --- a/bin/fetch.fnl +++ b/bin/fetch.fnl @@ -143,13 +143,11 @@ AND creation_time < ?" [site creation-time]))))) -(fn populate-search-table [] - (local tx (must (luna.db.begin db))) +(fn populate-search-table [tx] (must (luna.db.exec-tx tx "DELETE FROM search" [])) (must (luna.db.exec-tx tx "INSERT INTO search - SELECT title, url, 'products' - FROM products;" [])) - (must (luna.db.commit tx))) + SELECT title, url, 'products' + FROM products;" []))) ;; replace with with-tx (local tx (must (luna.db.begin db))) @@ -158,6 +156,5 @@ gorkovchay])] (store-products tx (parser.products))) (cache.clear-tx tx "page:") +(populate-search-table tx) (must (luna.db.commit tx)) - -(populate-search-table) -- cgit v1.2.3