/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
examples/booktest/mysql/query.sql
63 строки
1 KB
Kyle Conroy
examples: Run tests for MySQL booktest (#627)
27 июл 2020, 18:59
Не верифицирован
27 июл 2020, 18:59
5fbb224
Код
Авторство
О чём код?
/* 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, tags FROM books LEFT JOIN authors ON books.author_id = authors.author_id WHERE tags = ?; /* name: CreateAuthor :execresult */ INSERT INTO authors (name) VALUES (?); /* name: CreateBook :execresult */ INSERT INTO books ( author_id, isbn, book_type, title, yr, available, tags ) VALUES ( ?, ?, ?, ?, ?, ?, ? ); /* name: UpdateBook :exec */ UPDATE books SET title = ?, tags = ? WHERE book_id = ?; /* name: UpdateBookISBN :exec */ UPDATE books SET title = ?, tags = ?, isbn = ? WHERE book_id = ?; /* name: DeleteAuthorBeforeYear :exec */ DELETE FROM books WHERE yr < ? AND author_id = ?; -- WHERE yr < sqlc.arg(min_publish_year) AND author_id = ?;