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
65 lines
1.0 KiB
SQL
65 lines
1.0 KiB
SQL
/* name: GetAuthor :one */
|
|
SELECT * FROM authors
|
|
WHERE author_id = ?;
|
|
|
|
/* name: GetBook :one */
|
|
SELECT * FROM books
|
|
WHERE book_id = ?;
|
|
|
|
/* name: DeleteBook :exec */
|
|
DELETE FROM books
|
|
WHERE book_id = ?;
|
|
|
|
/* name: BooksByTitleYear :many */
|
|
SELECT * FROM books
|
|
WHERE title = ? AND yr = ?;
|
|
|
|
/* name: BooksByTags :many */
|
|
SELECT
|
|
book_id,
|
|
title,
|
|
name,
|
|
isbn,
|
|
tag
|
|
FROM books
|
|
LEFT JOIN authors ON books.author_id = authors.author_id
|
|
WHERE tag IN (sqlc.slice(tags));
|
|
|
|
/* name: CreateAuthor :one */
|
|
INSERT INTO authors (name) VALUES (?)
|
|
RETURNING *;
|
|
|
|
/* name: CreateBook :one */
|
|
INSERT INTO books (
|
|
author_id,
|
|
isbn,
|
|
book_type,
|
|
title,
|
|
yr,
|
|
available,
|
|
tag
|
|
) VALUES (
|
|
?,
|
|
?,
|
|
?,
|
|
?,
|
|
?,
|
|
?,
|
|
?
|
|
)
|
|
RETURNING *;
|
|
|
|
/* name: UpdateBook :exec */
|
|
UPDATE books
|
|
SET title = ?1, tag = ?2
|
|
WHERE book_id = ?3;
|
|
|
|
/* name: UpdateBookISBN :exec */
|
|
UPDATE books
|
|
SET title = ?1, tag = ?2, isbn = ?4
|
|
WHERE book_id = ?3;
|
|
|
|
/* name: DeleteAuthorBeforeYear :exec */
|
|
DELETE FROM books
|
|
WHERE yr < ? AND author_id = ?;
|