internal/endtoend/testdata/select_union/postgres/stdlib/go/query.sql.go - main - githubmirror/sqlc

internal/endtoend/testdata/select_union/postgres/stdlib/go/query.sql.go
190 строк4 KB
Kyle Gray
Release 1.31.1 (#4407)
22 апр 2026, 17:52
22 апр 2026, 17:52a95e91d
// Code generated by sqlc. DO NOT EDIT.
// versions:
//   sqlc v1.31.1
// source: query.sql

package querytest

import (
	"context"
)

const selectExcept = `-- name: SelectExcept :many
SELECT a, b FROM foo
EXCEPT
SELECT a, b FROM foo
`

func (q *Queries) SelectExcept(ctx context.Context) ([]Foo, error) {
	rows, err := q.db.QueryContext(ctx, selectExcept)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Foo
	for rows.Next() {
		var i Foo
		if err := rows.Scan(&i.A, &i.B); 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
}

const selectIntersect = `-- name: SelectIntersect :many
SELECT a, b FROM foo
INTERSECT
SELECT a, b FROM foo
`

func (q *Queries) SelectIntersect(ctx context.Context) ([]Foo, error) {
	rows, err := q.db.QueryContext(ctx, selectIntersect)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Foo
	for rows.Next() {
		var i Foo
		if err := rows.Scan(&i.A, &i.B); 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
}

const selectUnion = `-- name: SelectUnion :many
SELECT a, b FROM foo
UNION
SELECT a, b FROM foo
`

func (q *Queries) SelectUnion(ctx context.Context) ([]Foo, error) {
	rows, err := q.db.QueryContext(ctx, selectUnion)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Foo
	for rows.Next() {
		var i Foo
		if err := rows.Scan(&i.A, &i.B); 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
}

const selectUnionAliased = `-- name: SelectUnionAliased :many
(SELECT a, b FROM foo)
UNION
SELECT a, b FROM foo
`

func (q *Queries) SelectUnionAliased(ctx context.Context) ([]Foo, error) {
	rows, err := q.db.QueryContext(ctx, selectUnionAliased)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Foo
	for rows.Next() {
		var i Foo
		if err := rows.Scan(&i.A, &i.B); 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
}

const selectUnionOther = `-- name: SelectUnionOther :many
SELECT a, b FROM foo
UNION
SELECT a, b FROM bar
`

func (q *Queries) SelectUnionOther(ctx context.Context) ([]Foo, error) {
	rows, err := q.db.QueryContext(ctx, selectUnionOther)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Foo
	for rows.Next() {
		var i Foo
		if err := rows.Scan(&i.A, &i.B); 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
}

const selectUnionWithLimit = `-- name: SelectUnionWithLimit :many
SELECT a, b FROM foo
UNION
SELECT a, b FROM foo
LIMIT $1 OFFSET $2
`

type SelectUnionWithLimitParams struct {
	Limit  int32
	Offset int32
}

func (q *Queries) SelectUnionWithLimit(ctx context.Context, arg SelectUnionWithLimitParams) ([]Foo, error) {
	rows, err := q.db.QueryContext(ctx, selectUnionWithLimit, arg.Limit, arg.Offset)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Foo
	for rows.Next() {
		var i Foo
		if err := rows.Scan(&i.A, &i.B); 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
}