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

package sqlc

import (
	"context"
)

const DeletePermission = `-- name: DeletePermission :exec
DELETE FROM permissions WHERE origin = ? AND permission_type = ?
`

type DeletePermissionParams struct {
	Origin         string `json:"origin"`
	PermissionType string `json:"permission_type"`
}

func (q *Queries) DeletePermission(ctx context.Context, arg DeletePermissionParams) error {
	_, err := q.db.ExecContext(ctx, DeletePermission, arg.Origin, arg.PermissionType)
	return err
}

const GetPermission = `-- name: GetPermission :one
SELECT origin, permission_type, decision, updated_at FROM permissions WHERE origin = ? AND permission_type = ? LIMIT 1
`

type GetPermissionParams struct {
	Origin         string `json:"origin"`
	PermissionType string `json:"permission_type"`
}

func (q *Queries) GetPermission(ctx context.Context, arg GetPermissionParams) (Permission, error) {
	row := q.db.QueryRowContext(ctx, GetPermission, arg.Origin, arg.PermissionType)
	var i Permission
	err := row.Scan(
		&i.Origin,
		&i.PermissionType,
		&i.Decision,
		&i.UpdatedAt,
	)
	return i, err
}

const ListAllPermissions = `-- name: ListAllPermissions :many
SELECT origin, permission_type, decision, updated_at FROM permissions ORDER BY origin, permission_type
`

func (q *Queries) ListAllPermissions(ctx context.Context) ([]Permission, error) {
	rows, err := q.db.QueryContext(ctx, ListAllPermissions)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	items := []Permission{}
	for rows.Next() {
		var i Permission
		if err := rows.Scan(
			&i.Origin,
			&i.PermissionType,
			&i.Decision,
			&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 ListPermissionsByOrigin = `-- name: ListPermissionsByOrigin :many
SELECT origin, permission_type, decision, updated_at FROM permissions WHERE origin = ? ORDER BY updated_at DESC
`

func (q *Queries) ListPermissionsByOrigin(ctx context.Context, origin string) ([]Permission, error) {
	rows, err := q.db.QueryContext(ctx, ListPermissionsByOrigin, origin)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	items := []Permission{}
	for rows.Next() {
		var i Permission
		if err := rows.Scan(
			&i.Origin,
			&i.PermissionType,
			&i.Decision,
			&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 SetPermission = `-- name: SetPermission :exec
INSERT INTO permissions (origin, permission_type, decision, updated_at)
VALUES (?, ?, ?, CURRENT_TIMESTAMP)
ON CONFLICT(origin, permission_type) DO UPDATE SET
    decision = excluded.decision,
    updated_at = CURRENT_TIMESTAMP
`

type SetPermissionParams struct {
	Origin         string `json:"origin"`
	PermissionType string `json:"permission_type"`
	Decision       string `json:"decision"`
}

func (q *Queries) SetPermission(ctx context.Context, arg SetPermissionParams) error {
	_, err := q.db.ExecContext(ctx, SetPermission, arg.Origin, arg.PermissionType, arg.Decision)
	return err
}