| 1 | -- SPDX-License-Identifier: AGPL-3.0-or-later |
| 2 | |
| 3 | -- name: GetMeta :one |
| 4 | SELECT key, value, updated_at |
| 5 | FROM meta |
| 6 | WHERE key = $1; |
| 7 | |
| 8 | -- name: SetMeta :exec |
| 9 | INSERT INTO meta (key, value) |
| 10 | VALUES ($1, $2) |
| 11 | ON CONFLICT (key) DO UPDATE |
| 12 | SET value = EXCLUDED.value; |
| 13 | |
| 14 | -- name: ListMeta :many |
| 15 | SELECT key, value, updated_at |
| 16 | FROM meta |
| 17 | ORDER BY key; |
| 18 | |
| 19 | -- name: DeleteMeta :exec |
| 20 | DELETE FROM meta WHERE key = $1; |
| 21 |