/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
internal/endtoend/testdata/unnest/postgresql/stdlib/go/query.sql.go
76 строк
2 KB
Kyle Gray
Release 1.31.1 (#4407)
22 апр 2026, 17:52
Не верифицирован
22 апр 2026, 17:52
a95e91d
Код
Авторство
О чём код?
// Code generated by sqlc. DO NOT EDIT. // versions: // sqlc v1.31.1 // source: query.sql package querytest import ( "context" "github.com/google/uuid" "github.com/lib/pq" ) const createMemories = `-- name: CreateMemories :many INSERT INTO memories (vampire_id) SELECT unnest($1::uuid[]) AS vampire_id RETURNING id, vampire_id, created_at, updated_at ` func (q *Queries) CreateMemories(ctx context.Context, vampireID []uuid.UUID) ([]Memory, error) { rows, err := q.db.QueryContext(ctx, createMemories, pq.Array(vampireID)) if err != nil { return nil, err } defer rows.Close() var items []Memory for rows.Next() { var i Memory if err := rows.Scan( &i.ID, &i.VampireID, &i.CreatedAt, &i.UpdatedAt, ); 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 getVampireIDs = `-- name: GetVampireIDs :many SELECT vampires.id::uuid FROM unnest($1::uuid[]) AS vampires (id) ` func (q *Queries) GetVampireIDs(ctx context.Context, vampireID []uuid.UUID) ([]uuid.UUID, error) { rows, err := q.db.QueryContext(ctx, getVampireIDs, pq.Array(vampireID)) if err != nil { return nil, err } defer rows.Close() var items []uuid.UUID for rows.Next() { var vampires_id uuid.UUID if err := rows.Scan(&vampires_id); err != nil { return nil, err } items = append(items, vampires_id) } if err := rows.Close(); err != nil { return nil, err } if err := rows.Err(); err != nil { return nil, err } return items, nil }