// Code generated by sqlc. DO NOT EDIT. // versions: // sqlc v1.30.0 // source: aliases.sql package db import ( "context" ) const countAliasesByDomain = `-- name: CountAliasesByDomain :one SELECT COUNT(*) as count FROM virtual_aliases WHERE domain_id = ? ` func (q *Queries) CountAliasesByDomain(ctx context.Context, domainID uint32) (int64, error) { row := q.db.QueryRowContext(ctx, countAliasesByDomain, domainID) var count int64 err := row.Scan(&count) return count, err } const createAlias = `-- name: CreateAlias :exec INSERT INTO virtual_aliases (domain_id, source, destination) VALUES (?, ?, ?) ` type CreateAliasParams struct { DomainID uint32 `json:"domain_id"` Source string `json:"source"` Destination string `json:"destination"` } func (q *Queries) CreateAlias(ctx context.Context, arg CreateAliasParams) error { _, err := q.db.ExecContext(ctx, createAlias, arg.DomainID, arg.Source, arg.Destination) return err } const deleteAlias = `-- name: DeleteAlias :exec DELETE FROM virtual_aliases WHERE id = ? ` func (q *Queries) DeleteAlias(ctx context.Context, id uint32) error { _, err := q.db.ExecContext(ctx, deleteAlias, id) return err } const getAliasByID = `-- name: GetAliasByID :one SELECT id, domain_id, source, destination FROM virtual_aliases WHERE id = ? ` func (q *Queries) GetAliasByID(ctx context.Context, id uint32) (VirtualAlias, error) { row := q.db.QueryRowContext(ctx, getAliasByID, id) var i VirtualAlias err := row.Scan( &i.ID, &i.DomainID, &i.Source, &i.Destination, ) return i, err } const getAliasBySource = `-- name: GetAliasBySource :one SELECT id, domain_id, source, destination FROM virtual_aliases WHERE source = ? ` func (q *Queries) GetAliasBySource(ctx context.Context, source string) (VirtualAlias, error) { row := q.db.QueryRowContext(ctx, getAliasBySource, source) var i VirtualAlias err := row.Scan( &i.ID, &i.DomainID, &i.Source, &i.Destination, ) return i, err } const getAliasesByDomain = `-- name: GetAliasesByDomain :many SELECT id, domain_id, source, destination FROM virtual_aliases WHERE domain_id = ? ` func (q *Queries) GetAliasesByDomain(ctx context.Context, domainID uint32) ([]VirtualAlias, error) { rows, err := q.db.QueryContext(ctx, getAliasesByDomain, domainID) if err != nil { return nil, err } defer rows.Close() var items []VirtualAlias for rows.Next() { var i VirtualAlias if err := rows.Scan( &i.ID, &i.DomainID, &i.Source, &i.Destination, ); 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 getAllAliases = `-- name: GetAllAliases :many SELECT id, domain_id, source, destination FROM virtual_aliases ` func (q *Queries) GetAllAliases(ctx context.Context) ([]VirtualAlias, error) { rows, err := q.db.QueryContext(ctx, getAllAliases) if err != nil { return nil, err } defer rows.Close() var items []VirtualAlias for rows.Next() { var i VirtualAlias if err := rows.Scan( &i.ID, &i.DomainID, &i.Source, &i.Destination, ); 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 }