all repos — nergen.net-guestbook.git @ ee820325ea27e1e43687589024be6936ec543a7b

Unnamed repository; edit this file 'description' to name the repository.

sqlc_gb/query.sql (view raw)

 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 
-- name: TableCreate :exec
CREATE TABLE IF NOT EXISTS gb (
  id INTEGER NOT NULL PRIMARY KEY,
  msg TEXT NOT NULL,
  stamp DATETIME NOT NULL,
  flags INTEGER NOT NULL DEFAULT 0
);

-- name: GetPost :one
SELECT * FROM gb
WHERE id = ? LIMIT 1;

-- name: GetPosts :many
SELECT * FROM gb
ORDER BY stamp DESC;

-- name: AddPost :one
INSERT INTO gb (
  msg, stamp, flags
) VALUES (
  ?, ?, ?
)
RETURNING *;

-- name: UpdateMsg :exec
UPDATE gb
set msg = ?
WHERE id = ?;

-- name: UpdateFlags :exec
UPDATE gb
set flags = ?
WHERE id = ?;

-- name: DeleteFilm :exec
DELETE FROM gb
WHERE id = ?;