MCPcopy
hub / github.com/xo/dbtpl / BookByBookID

Function BookByBookID

_examples/django/sqlserver/book.dbtpl.go:154–169  ·  view source on GitHub ↗

BookByBookID retrieves a row from 'django.books' as a [Book]. Generated from index 'books_book_id_pkey'.

(ctx context.Context, db DB, bookID int64)

Source from the content-addressed store, hash-verified

152//
153// Generated from index 'books_book_id_pkey'.
154func BookByBookID(ctx context.Context, db DB, bookID int64) (*Book, error) {
155 // query
156 const sqlstr = `SELECT ` +
157 `book_id, isbn, book_type, title, year, available, books_author_id_fkey ` +
158 `FROM django.books ` +
159 `WHERE book_id = @p1`
160 // run
161 logf(sqlstr, bookID)
162 b := Book{
163 _exists: true,
164 }
165 if err := db.QueryRowContext(ctx, sqlstr, bookID).Scan(&b.BookID, &b.ISBN, &b.BookType, &b.Title, &b.Year, &b.Available, &b.BooksAuthorIDFkey); err != nil {
166 return nil, logerror(err)
167 }
168 return &b, nil
169}
170
171// BooksByBooksAuthorIDFkey retrieves a row from 'django.books' as a [Book].
172//

Callers 1

BookMethod · 0.70

Calls 3

logerrorFunction · 0.70
QueryRowContextMethod · 0.65
ScanMethod · 0.45

Tested by

no test coverage detected