get_sandbox_record.sql.go

// Code generated by sqlc. DO NOT EDIT.
// versions:
//   sqlc v1.29.0
// source: get_sandbox_record.sql

package queries

import (
	"context"
	"time"

	"github.com/google/uuid"
)

const getSandboxRecordByTeamAndSandboxID = `-- name: GetSandboxRecordByTeamAndSandboxID :one
SELECT
    sl.sandbox_id,
    COALESCE(s.base_env_id, sl.env_id) AS template_id,
    sl.vcpu,
    sl.ram_mb,
    sl.total_disk_size_mb,
    sl.started_at,
    sl.stopped_at,
    c.sandbox_proxy_domain AS domain,
    COALESCE(template_alias.alias, '') AS alias
FROM billing.sandbox_logs sl
LEFT JOIN public.teams t ON t.id = sl.team_id
LEFT JOIN public.clusters c ON c.id = t.cluster_id
LEFT JOIN public.snapshots s
    ON s.sandbox_id = sl.sandbox_id
   AND s.team_id = sl.team_id
LEFT JOIN LATERAL (
    SELECT ea.alias
    FROM public.env_aliases ea
    WHERE ea.env_id = COALESCE(s.base_env_id, sl.env_id)
    ORDER BY ea.alias
    LIMIT 1
) template_alias ON TRUE
WHERE sl.team_id = $1::uuid
  AND sl.sandbox_id = $2::text
  AND sl.created_at >= $3::timestamptz
ORDER BY sl.created_at DESC
LIMIT 1
`

type GetSandboxRecordByTeamAndSandboxIDParams struct {
	TeamID       uuid.UUID
	SandboxID    string
	CreatedAfter time.Time
}

type GetSandboxRecordByTeamAndSandboxIDRow struct {
	SandboxID       string
	TemplateID      string
	Vcpu            int64
	RamMb           int64
	TotalDiskSizeMb int64
	StartedAt       time.Time
	StoppedAt       *time.Time
	Domain          *string
	Alias           string
}

func (q *Queries) GetSandboxRecordByTeamAndSandboxID(ctx context.Context, arg GetSandboxRecordByTeamAndSandboxIDParams) (GetSandboxRecordByTeamAndSandboxIDRow, error) {
	row := q.db.QueryRow(ctx, getSandboxRecordByTeamAndSandboxID, arg.TeamID, arg.SandboxID, arg.CreatedAfter)
	var i GetSandboxRecordByTeamAndSandboxIDRow
	err := row.Scan(
		&i.SandboxID,
		&i.TemplateID,
		&i.Vcpu,
		&i.RamMb,
		&i.TotalDiskSizeMb,
		&i.StartedAt,
		&i.StoppedAt,
		&i.Domain,
		&i.Alias,
	)
	return i, err
}