// Code generated by sqlc. DO NOT EDIT.
// versions:
//   sqlc v1.31.1
// source: providers.sql

package db

import (
	"context"
)

const getProviderRow = `-- name: GetProviderRow :one
SELECT provider_id, display_name, notes, lifecycle, revision, created_at, updated_at, created_by, updated_by
FROM providers
WHERE provider_id = ?
`

func (q *Queries) GetProviderRow(ctx context.Context, providerID string) (Provider, error) {
	row := q.db.QueryRowContext(ctx, getProviderRow, providerID)
	var i Provider
	err := row.Scan(
		&i.ProviderID,
		&i.DisplayName,
		&i.Notes,
		&i.Lifecycle,
		&i.Revision,
		&i.CreatedAt,
		&i.UpdatedAt,
		&i.CreatedBy,
		&i.UpdatedBy,
	)
	return i, err
}

const listProviderRows = `-- name: ListProviderRows :many
SELECT p.provider_id, p.display_name, p.notes, p.lifecycle, p.revision, p.created_at, p.updated_at, p.created_by, p.updated_by,
       COUNT(t.trunk_id) AS trunk_count
FROM providers p
LEFT JOIN trunks t ON t.provider_id = p.provider_id
GROUP BY p.provider_id, p.display_name, p.notes, p.lifecycle, p.revision, p.created_at, p.updated_at, p.created_by, p.updated_by
ORDER BY p.updated_at DESC, p.provider_id ASC
`

type ListProviderRowsRow struct {
	ProviderID  string `json:"provider_id"`
	DisplayName string `json:"display_name"`
	Notes       string `json:"notes"`
	Lifecycle   string `json:"lifecycle"`
	Revision    int64  `json:"revision"`
	CreatedAt   string `json:"created_at"`
	UpdatedAt   string `json:"updated_at"`
	CreatedBy   string `json:"created_by"`
	UpdatedBy   string `json:"updated_by"`
	TrunkCount  int64  `json:"trunk_count"`
}

func (q *Queries) ListProviderRows(ctx context.Context) ([]ListProviderRowsRow, error) {
	rows, err := q.db.QueryContext(ctx, listProviderRows)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	items := []ListProviderRowsRow{}
	for rows.Next() {
		var i ListProviderRowsRow
		if err := rows.Scan(
			&i.ProviderID,
			&i.DisplayName,
			&i.Notes,
			&i.Lifecycle,
			&i.Revision,
			&i.CreatedAt,
			&i.UpdatedAt,
			&i.CreatedBy,
			&i.UpdatedBy,
			&i.TrunkCount,
		); 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
}