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

package db

import (
	"context"
	"time"

	"github.com/jackc/pgx/v5/pgtype"
)

const createShelve = `-- name: CreateShelve :one
INSERT INTO shelves (cabinet_id,name,level_index, description, created_at)
VALUES (
    $1,
    $2,
    $3,
    $4,
    $5
)
RETURNING id, cabinet_id, name, level_index, description, created_at, updated_at
`

type CreateShelveParams struct {
	CabinetID   int64       `db:"cabinet_id" json:"cabinetId"`
	Name        string      `db:"name" json:"name"`
	LevelIndex  int32       `db:"level_index" json:"levelIndex"`
	Description pgtype.Text `db:"description" json:"description"`
	CreatedAt   time.Time   `db:"created_at" json:"createdAt"`
}

func (q *Queries) CreateShelve(ctx context.Context, arg CreateShelveParams) (Shelf, error) {
	row := q.db.QueryRow(ctx, createShelve,
		arg.CabinetID,
		arg.Name,
		arg.LevelIndex,
		arg.Description,
		arg.CreatedAt,
	)
	var i Shelf
	err := row.Scan(
		&i.ID,
		&i.CabinetID,
		&i.Name,
		&i.LevelIndex,
		&i.Description,
		&i.CreatedAt,
		&i.UpdatedAt,
	)
	return i, err
}

const deleteShelve = `-- name: DeleteShelve :execrows
DELETE FROM shelves
WHERE id = $1
`

func (q *Queries) DeleteShelve(ctx context.Context, id int64) (int64, error) {
	result, err := q.db.Exec(ctx, deleteShelve, id)
	if err != nil {
		return 0, err
	}
	return result.RowsAffected(), nil
}

const getShelveByID = `-- name: GetShelveByID :one
SELECT id, cabinet_id, name, level_index, description, created_at, updated_at FROM shelves
WHERE id = $1
`

func (q *Queries) GetShelveByID(ctx context.Context, id int64) (Shelf, error) {
	row := q.db.QueryRow(ctx, getShelveByID, id)
	var i Shelf
	err := row.Scan(
		&i.ID,
		&i.CabinetID,
		&i.Name,
		&i.LevelIndex,
		&i.Description,
		&i.CreatedAt,
		&i.UpdatedAt,
	)
	return i, err
}

const listShelves = `-- name: ListShelves :many
SELECT id, cabinet_id, name, level_index, description, created_at, updated_at FROM shelves
ORDER BY created_at DESC
`

func (q *Queries) ListShelves(ctx context.Context) ([]Shelf, error) {
	rows, err := q.db.Query(ctx, listShelves)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Shelf
	for rows.Next() {
		var i Shelf
		if err := rows.Scan(
			&i.ID,
			&i.CabinetID,
			&i.Name,
			&i.LevelIndex,
			&i.Description,
			&i.CreatedAt,
			&i.UpdatedAt,
		); err != nil {
			return nil, err
		}
		items = append(items, i)
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}
	return items, nil
}

const updateShelve = `-- name: UpdateShelve :one
UPDATE shelves
SET name = CASE WHEN $1 = '' THEN name ELSE $1 END,
    level_index = CASE WHEN $2 = 0 THEN level_index ELSE $2 END,
    description = coalesce($3, description),
    updated_at = $4
WHERE id = $5
RETURNING id, cabinet_id, name, level_index, description, created_at, updated_at
`

type UpdateShelveParams struct {
	Name        interface{} `db:"name" json:"name"`
	LevelIndex  interface{} `db:"level_index" json:"levelIndex"`
	Description pgtype.Text `db:"description" json:"description"`
	UpdatedAt   time.Time   `db:"updated_at" json:"updatedAt"`
	ID          int64       `db:"id" json:"id"`
}

func (q *Queries) UpdateShelve(ctx context.Context, arg UpdateShelveParams) (Shelf, error) {
	row := q.db.QueryRow(ctx, updateShelve,
		arg.Name,
		arg.LevelIndex,
		arg.Description,
		arg.UpdatedAt,
		arg.ID,
	)
	var i Shelf
	err := row.Scan(
		&i.ID,
		&i.CabinetID,
		&i.Name,
		&i.LevelIndex,
		&i.Description,
		&i.CreatedAt,
		&i.UpdatedAt,
	)
	return i, err
}