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
73 lines
1.7 KiB
SQL
73 lines
1.7 KiB
SQL
-- name: GetAuthor :one
|
|
select id,name , bio from authors
|
|
where id = ? limit 1;
|
|
|
|
# hash comment
|
|
-- name: ListAuthors :many
|
|
SELECT id, name, bio FROM authors
|
|
ORDER BY name DESC;
|
|
|
|
-- name: PickyQuery :many
|
|
SELECT id, -- the primary key
|
|
name,
|
|
-- computed downstream
|
|
bio
|
|
FROM authors
|
|
-- soft-deleted rows are filtered
|
|
WHERE bio IS NOT NULL
|
|
AND id > ?;
|
|
|
|
-- name: InlineBlock :many
|
|
SELECT /* inline note */ id, name FROM authors ORDER BY name;
|
|
|
|
-- name: CountSigils :one
|
|
SELECT count(*) FROM authors
|
|
WHERE id <> ? AND name <> @user_name; # session variable stays
|
|
|
|
-- name: CastUnsigned :one
|
|
SELECT CAST(id AS UNSIGNED) FROM authors LIMIT 1;
|
|
|
|
-- name: FirstTwin :one
|
|
SELECT id FROM authors LIMIT 1;
|
|
|
|
-- name: SecondTwin :one
|
|
SELECT id FROM authors LIMIT 1;
|
|
|
|
-- name: CreateAuthor :execresult
|
|
insert into authors (
|
|
name, bio
|
|
) values (
|
|
?, ?
|
|
);
|
|
|
|
-- name: CasePreserved :many
|
|
SELECT ID, Name FROM Authors WHERE Name <> '' ORDER BY Name;
|
|
|
|
-- name: LiteralsSurvive :one
|
|
SELECT true AS t, false AS f, 1.50 AS score, CASE WHEN name = '' THEN NULL ELSE name END AS n FROM authors LIMIT 1;
|
|
|
|
-- name: DistinctNames :many
|
|
SELECT DISTINCT name FROM authors;
|
|
|
|
-- name: UnionOrdered :many
|
|
SELECT name AS foo FROM authors
|
|
UNION
|
|
SELECT bio AS foo FROM authors
|
|
ORDER BY foo;
|
|
|
|
-- name: ConcatNames :many
|
|
SELECT group_concat(DISTINCT name ORDER BY name DESC SEPARATOR ' ') FROM authors GROUP BY bio;
|
|
|
|
-- name: Hinted :one
|
|
SELECT /*+ MAX_EXECUTION_TIME(1000) */ id FROM authors LIMIT 1;
|
|
|
|
-- name: UpdateWithJoin :exec
|
|
UPDATE authors AS a JOIN authors AS p ON p.id = a.id
|
|
SET a.name = ?
|
|
WHERE p.bio IS NOT NULL;
|
|
|
|
-- name: ShowWarnings :many
|
|
SHOW WARNINGS;
|
|
|
|
CREATE TABLE scores (points decimal(10, 5), views bigint unsigned NOT NULL);
|