/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
examples/batch/postgresql/query.sql
56 строк
942 B
Nao Yonashiro
feat: to allow spaces between function name and arguments of functions to be rewritten (#2250)
06 июн 2023, 19:33
Не верифицирован
06 июн 2023, 19:33
f9a6345
Код
Авторство
О чём код?
-- name: GetAuthor :one SELECT * FROM authors WHERE author_id = $1; -- name: DeleteBookExecResult :execresult DELETE FROM books WHERE book_id = $1; -- name: DeleteBook :batchexec DELETE FROM books WHERE book_id = $1; -- name: DeleteBookNamedFunc :batchexec DELETE FROM books WHERE book_id = sqlc.arg (book_id); -- name: DeleteBookNamedSign :batchexec DELETE FROM books WHERE book_id = @book_id; -- name: BooksByYear :batchmany SELECT * FROM books WHERE year = $1; -- name: CreateAuthor :one INSERT INTO authors (name) VALUES ($1) RETURNING *; -- name: CreateBook :batchone INSERT INTO books ( author_id, isbn, book_type, title, year, available, tags ) VALUES ( $1, $2, $3, $4, $5, $6, $7 ) RETURNING *; -- name: UpdateBook :batchexec UPDATE books SET title = $1, tags = $2 WHERE book_id = $3; -- name: GetBiography :batchone SELECT biography FROM authors WHERE author_id = $1;