Closed
Description
The generated code asks for a int which prevents me from providing something like "10_" or "%10"
/* name: ListExtensions :many */
SELECT `id`,
`student_id`,
`length`,
`created_at`
FROM `extensions`
WHERE `student_id` LIKE ?Generated code
const listExtensions = `-- name: ListExtensions :many
select id, student_id, length, created_at from extensions where student_id like ? order by created_at desc limit 25
`
type ListExtensionsRow struct {
ID int `json:"id"`
StudentID int `json:"student_id"`
Length int `json:"length"`
CreatedAt time.Time `json:"created_at"`
}
func (q *Queries) ListExtensions(ctx context.Context, student_id int) ([]ListExtensionsRow, error) {
rows, err := q.query(ctx, q.listExtensionsStmt, listExtensions, student_id)
if err != nil {
return nil, err
}
defer rows.Close()
items := []ListExtensionsRow{}
for rows.Next() {
var i ListExtensionsRow
if err := rows.Scan(
&i.ID,
&i.StudentID,
&i.Length,
&i.CreatedAt,
); err != nil {
return nil, err
}
items = append(items, i)
}
if err := rows.Close(); err != nil {
return nil, err
}
if err := rows.Err(); err != nil {
return nil, err
}
return items, nil
}