0f4df23290
Some checks failed
kotlin / test (push) Has been skipped
python / test (push) Has been skipped
typescript / test (push) Has been skipped
go / build darwin/amd64 (push) Has been cancelled
go / build linux/amd64 (push) Has been cancelled
go / build windows/amd64 (push) Has been cancelled
go / build darwin/arm64 (push) Has been cancelled
go / build linux/arm64 (push) Has been cancelled
go / build windows/arm64 (push) Has been cancelled
go / test (push) Has been cancelled
go / vuln_check (push) Has been cancelled
49 lines
994 B
Plaintext
49 lines
994 B
Plaintext
--- a/query.sql
|
|
+++ b/query.sql
|
|
@@ -1,7 +1,8 @@
|
|
-- name: GetAuthor :one
|
|
-select id,name , bio
|
|
-from authors
|
|
-where id = $1 limit 1; -- the primary lookup
|
|
+SELECT id, name, bio
|
|
+FROM authors
|
|
+WHERE id = $1
|
|
+LIMIT 1; -- the primary lookup
|
|
|
|
/* This listing powers the admin page.
|
|
Keep it ordered by name so the UI stays stable. */
|
|
@@ -8,5 +9,6 @@
|
|
-- name: ListAuthors :many
|
|
-SELECT id, name, bio FROM authors
|
|
+SELECT id, name, bio
|
|
+FROM authors
|
|
ORDER BY name;
|
|
|
|
-- name: CreateAuthor :one
|
|
@@ -13,8 +15,5 @@
|
|
-INSERT INTO authors (
|
|
- name, bio
|
|
-) VALUES (
|
|
- $1, $2
|
|
-)
|
|
+INSERT INTO authors (name, bio)
|
|
+VALUES ($1, $2)
|
|
RETURNING *;
|
|
|
|
-- name: PickyQuery :many
|
|
@@ -21,5 +20,6 @@
|
|
-SELECT id, -- the primary key
|
|
- name
|
|
+SELECT
|
|
+ id, -- the primary key
|
|
+ name
|
|
FROM authors
|
|
WHERE id > $1;
|
|
|
|
@@ -30,4 +30,4 @@
|
|
SELECT name FROM authors WHERE name = @slug AND @filter::bool;
|
|
|
|
-- name: DeleteAuthor :exec
|
|
-DELETE FROM authors WHERE id = @id
|
|
+DELETE FROM authors WHERE id = @id;
|