File size: 423 Bytes
e089492 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | -- name: RecordFileRead :exec
INSERT INTO read_files (
session_id,
path,
read_at
) VALUES (
?,
?,
strftime('%s', 'now')
) ON CONFLICT(path, session_id) DO UPDATE SET
read_at = excluded.read_at;
-- name: GetFileRead :one
SELECT * FROM read_files
WHERE session_id = ? AND path = ? LIMIT 1;
-- name: ListSessionReadFiles :many
SELECT * FROM read_files
WHERE session_id = ?
ORDER BY read_at DESC;
|