query.sql.go

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

package querytest

import (
	"context"
	"strings"
)

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

type BrokenQueryParams struct {
	Types    []int64
	Allnames interface{}
	Names    []string
}

func (q *Queries) BrokenQuery(ctx context.Context, arg BrokenQueryParams) ([]Mytable, error) {
	query := brokenQuery
	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.Allnames)
	if len(arg.Names) > 0 {
		for _, v := range arg.Names {
			queryParams = append(queryParams, v)
		}
		query = strings.Replace(query, "/*SLICE:names*/?", strings.Repeat(",?", len(arg.Names))[1:], 1)
	} else {
		query = strings.Replace(query, "/*SLICE:names*/?", "NULL", 1)
	}
	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,
			&i.Val,
		); 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
}