| 68 | } |
| 69 | |
| 70 | func (q *Queries) BooksByTitleYear(ctx context.Context, arg BooksByTitleYearParams) ([]Book, error) { |
| 71 | rows, err := q.db.Query(ctx, booksByTitleYear, arg.Title, arg.Year) |
| 72 | if err != nil { |
| 73 | return nil, err |
| 74 | } |
| 75 | defer rows.Close() |
| 76 | var items []Book |
| 77 | for rows.Next() { |
| 78 | var i Book |
| 79 | if err := rows.Scan( |
| 80 | &i.BookID, |
| 81 | &i.AuthorID, |
| 82 | &i.Isbn, |
| 83 | &i.BookType, |
| 84 | &i.Title, |
| 85 | &i.Year, |
| 86 | &i.Available, |
| 87 | &i.Tags, |
| 88 | ); err != nil { |
| 89 | return nil, err |
| 90 | } |
| 91 | items = append(items, i) |
| 92 | } |
| 93 | if err := rows.Err(); err != nil { |
| 94 | return nil, err |
| 95 | } |
| 96 | return items, nil |
| 97 | } |
| 98 | |
| 99 | const createAuthor = `-- name: CreateAuthor :one |
| 100 | INSERT INTO authors (name) VALUES ($1) |