Skip to content
Snippets Groups Projects
_ds_postgres_document_stats.sql 555 B
Newer Older
-- :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)