Newer
Older

Bruno Burke
committed
-- :name create-document-stats! :! :n
-- :doc creates a new document-stats record
INSERT INTO :i:document-stats-table AS st
(repository, "document", "version", request_count)
VALUES (:repository-name, :document-id, :version, 1)
ON CONFLICT(repository, "document", "version")
DO UPDATE SET request_count = st.request_count + 1
-- :name log-request! :! :n
-- :doc creates a new request-log record
INSERT INTO :i:request-log-table
(repository, "document", "version")
VALUES (:repository-name, :document-id, :version)