query.sql.go

// Code generated by sqlc. DO NOT EDIT.
// versions:
//   sqlc v1.30.0
// source: query.sql

package querytest

import (
	"context"
	"strings"
)

const reuseWithSlice = `-- name: ReuseWithSlice :many
SELECT id, typ, name FROM mytable
WHERE typ IN (/*SLICE:types*/?) AND (name = ? OR id = ? OR name = ?)
`

type ReuseWithSliceParams struct {
	Types []int64
	Name  string
	ID    int64
}

func (q *Queries) ReuseWithSlice(ctx context.Context, arg ReuseWithSliceParams) ([]Mytable, error) {
	query := reuseWithSlice
	var queryParams []interface{}
	if len(arg.Types) > 0 {
		for _, v := range arg.Types {
			queryParams = append(queryParams, v)
		}
		query = strings.Replace(query, "/*SLICE:types*/?", strings.Repeat(",?", len(arg.Types))[1:], 1)
	} else {
		query = strings.Replace(query, "/*SLICE:types*/?", "NULL", 1)
	}
	queryParams = append(queryParams, arg.Name)
	queryParams = append(queryParams, arg.ID)
	queryParams = append(queryParams, arg.Name)
	rows, err := q.db.QueryContext(ctx, query, queryParams...)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Mytable
	for rows.Next() {
		var i Mytable
		if err := rows.Scan(&i.ID, &i.Typ, &i.Name); 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
}