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
38 lines
705 B
Go
38 lines
705 B
Go
// Code generated by sqlc. DO NOT EDIT.
|
|
// versions:
|
|
// sqlc v1.31.1
|
|
// source: query.sql
|
|
|
|
package querytest
|
|
|
|
import (
|
|
"context"
|
|
"database/sql"
|
|
)
|
|
|
|
const deleteAuthor = `-- name: DeleteAuthor :exec
|
|
DELETE FROM books AS b
|
|
WHERE NOT b.author IN (
|
|
SELECT a.name
|
|
FROM authors AS a
|
|
WHERE a.age >= ?
|
|
)
|
|
AND NOT b.translator IN (
|
|
SELECT t.name
|
|
FROM translators AS t
|
|
WHERE t.age >= ?
|
|
)
|
|
AND b.year <= ?
|
|
`
|
|
|
|
type DeleteAuthorParams struct {
|
|
Age sql.NullInt64
|
|
Age_2 sql.NullInt64
|
|
Year sql.NullInt64
|
|
}
|
|
|
|
func (q *Queries) DeleteAuthor(ctx context.Context, arg DeleteAuthorParams) error {
|
|
_, err := q.db.ExecContext(ctx, deleteAuthor, arg.Age, arg.Age_2, arg.Year)
|
|
return err
|
|
}
|