90 lines
2.2 KiB
Go
90 lines
2.2 KiB
Go
// 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
|
|
}
|