internal/database/gen/clubs.sql.go - main - Arsinenko/CompClubAPI_Go

internal/database/gen/clubs.sql.go
144 строки3 KB
Arsinenko
EquipmentService
15 окт 2025, 14:21
15 окт 2025, 14:21fd78e25
// Code generated by sqlc. DO NOT EDIT.
// versions:
//   sqlc v1.30.0
// source: clubs.sql

package gen

import (
	"context"
	"database/sql"
)

const closeClub = `-- name: CloseClub :one
update clubs
set is_alive = $2
where name = $1 returning name, address, phone, working_hours, is_alive
`

type CloseClubParams struct {
	Name    string
	IsAlive sql.NullBool
}

func (q *Queries) CloseClub(ctx context.Context, arg CloseClubParams) (Club, error) {
	row := q.db.QueryRowContext(ctx, closeClub, arg.Name, arg.IsAlive)
	var i Club
	err := row.Scan(
		&i.Name,
		&i.Address,
		&i.Phone,
		&i.WorkingHours,
		&i.IsAlive,
	)
	return i, err
}

const createClub = `-- name: CreateClub :one
insert into clubs (name, address, phone, working_hours) values ($1, $2, $3, $4) returning name, address, phone, working_hours, is_alive
`

type CreateClubParams struct {
	Name         string
	Address      string
	Phone        string
	WorkingHours string
}

func (q *Queries) CreateClub(ctx context.Context, arg CreateClubParams) (Club, error) {
	row := q.db.QueryRowContext(ctx, createClub,
		arg.Name,
		arg.Address,
		arg.Phone,
		arg.WorkingHours,
	)
	var i Club
	err := row.Scan(
		&i.Name,
		&i.Address,
		&i.Phone,
		&i.WorkingHours,
		&i.IsAlive,
	)
	return i, err
}

const getClub = `-- name: GetClub :one
select name, address, phone, working_hours, is_alive from clubs
where clubs.name = $1
`

func (q *Queries) GetClub(ctx context.Context, name string) (Club, error) {
	row := q.db.QueryRowContext(ctx, getClub, name)
	var i Club
	err := row.Scan(
		&i.Name,
		&i.Address,
		&i.Phone,
		&i.WorkingHours,
		&i.IsAlive,
	)
	return i, err
}

const getClubs = `-- name: GetClubs :many
select name, address, phone, working_hours, is_alive from clubs
`

func (q *Queries) GetClubs(ctx context.Context) ([]Club, error) {
	rows, err := q.db.QueryContext(ctx, getClubs)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Club
	for rows.Next() {
		var i Club
		if err := rows.Scan(
			&i.Name,
			&i.Address,
			&i.Phone,
			&i.WorkingHours,
			&i.IsAlive,
		); 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 updateClub = `-- name: UpdateClub :one
update clubs set address = $2, phone = $3, working_hours = $4 where name = $1 returning name, address, phone, working_hours, is_alive
`

type UpdateClubParams struct {
	Name         string
	Address      string
	Phone        string
	WorkingHours string
}

func (q *Queries) UpdateClub(ctx context.Context, arg UpdateClubParams) (Club, error) {
	row := q.db.QueryRowContext(ctx, updateClub,
		arg.Name,
		arg.Address,
		arg.Phone,
		arg.WorkingHours,
	)
	var i Club
	err := row.Scan(
		&i.Name,
		&i.Address,
		&i.Phone,
		&i.WorkingHours,
		&i.IsAlive,
	)
	return i, err
}