1-- name: UpsertVisitor :exec
 2INSERT INTO
 3  visitors (id, view_count, created_at, last_seen)
 4VALUES
 5  (?, 1, ?, ?) ON CONFLICT (id) DO
 6UPDATE
 7SET
 8  view_count = view_count + 1,
 9  last_seen = excluded.last_seen;
10
11-- name: VisitorWithID :one
12SELECT
13  *
14FROM
15  visitors
16WHERE
17  id = ?;