get_team.sql.go

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

package authqueries

import (
	"context"

	"github.com/google/uuid"
)

const getAutoJoinTeamsBySSOOrganizationID = `-- name: GetAutoJoinTeamsBySSOOrganizationID :many
SELECT t.id, t.created_at, t.is_blocked, t.name, t.tier, t.email, t.is_banned, t.blocked_reason, t.cluster_id, t.sandbox_scheduling_labels, t.sso_organization_id, t.sso_auto_join, t.slug
FROM "public"."teams" t
WHERE t.sso_organization_id = $1::uuid
  AND t.sso_auto_join = true
  AND t.is_blocked = false
  AND t.is_banned = false
ORDER BY t.created_at ASC
`

type GetAutoJoinTeamsBySSOOrganizationIDRow struct {
	Team Team
}

func (q *Queries) GetAutoJoinTeamsBySSOOrganizationID(ctx context.Context, ssoOrganizationID uuid.UUID) ([]GetAutoJoinTeamsBySSOOrganizationIDRow, error) {
	rows, err := q.db.Query(ctx, getAutoJoinTeamsBySSOOrganizationID, ssoOrganizationID)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []GetAutoJoinTeamsBySSOOrganizationIDRow
	for rows.Next() {
		var i GetAutoJoinTeamsBySSOOrganizationIDRow
		if err := rows.Scan(
			&i.Team.ID,
			&i.Team.CreatedAt,
			&i.Team.IsBlocked,
			&i.Team.Name,
			&i.Team.Tier,
			&i.Team.Email,
			&i.Team.IsBanned,
			&i.Team.BlockedReason,
			&i.Team.ClusterID,
			&i.Team.SandboxSchedulingLabels,
			&i.Team.SsoOrganizationID,
			&i.Team.SsoAutoJoin,
			&i.Team.Slug,
		); err != nil {
			return nil, err
		}
		items = append(items, i)
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}
	return items, nil
}

const getTeamWithTierByAPIKey = `-- name: GetTeamWithTierByAPIKey :one
SELECT t.id, t.created_at, t.is_blocked, t.name, t.tier, t.email, t.is_banned, t.blocked_reason, t.cluster_id, t.sandbox_scheduling_labels, t.sso_organization_id, t.sso_auto_join, t.slug, tl.id, tl.max_length_hours, tl.concurrent_sandboxes, tl.concurrent_template_builds, tl.max_vcpu, tl.max_ram_mb, tl.disk_mb, tl.events_ttl_days, tl.default_free_disk_size_mb, tl.max_disk_size_mb FROM "public"."team_api_keys" tak
JOIN "public"."teams" t ON tak.team_id = t.id
JOIN "public"."team_limits" tl on tl.id = t.id
WHERE tak.team_id = t.id
  AND tak.api_key_hash = $1
`

type GetTeamWithTierByAPIKeyRow struct {
	Team      Team
	TeamLimit TeamLimit
}

func (q *Queries) GetTeamWithTierByAPIKey(ctx context.Context, apiKeyHash string) (GetTeamWithTierByAPIKeyRow, error) {
	row := q.db.QueryRow(ctx, getTeamWithTierByAPIKey, apiKeyHash)
	var i GetTeamWithTierByAPIKeyRow
	err := row.Scan(
		&i.Team.ID,
		&i.Team.CreatedAt,
		&i.Team.IsBlocked,
		&i.Team.Name,
		&i.Team.Tier,
		&i.Team.Email,
		&i.Team.IsBanned,
		&i.Team.BlockedReason,
		&i.Team.ClusterID,
		&i.Team.SandboxSchedulingLabels,
		&i.Team.SsoOrganizationID,
		&i.Team.SsoAutoJoin,
		&i.Team.Slug,
		&i.TeamLimit.ID,
		&i.TeamLimit.MaxLengthHours,
		&i.TeamLimit.ConcurrentSandboxes,
		&i.TeamLimit.ConcurrentTemplateBuilds,
		&i.TeamLimit.MaxVcpu,
		&i.TeamLimit.MaxRamMb,
		&i.TeamLimit.DiskMb,
		&i.TeamLimit.EventsTtlDays,
		&i.TeamLimit.DefaultFreeDiskSizeMb,
		&i.TeamLimit.MaxDiskSizeMb,
	)
	return i, err
}

const getTeamWithTierByTeamAndUser = `-- name: GetTeamWithTierByTeamAndUser :one
SELECT t.id, t.created_at, t.is_blocked, t.name, t.tier, t.email, t.is_banned, t.blocked_reason, t.cluster_id, t.sandbox_scheduling_labels, t.sso_organization_id, t.sso_auto_join, t.slug, tl.id, tl.max_length_hours, tl.concurrent_sandboxes, tl.concurrent_template_builds, tl.max_vcpu, tl.max_ram_mb, tl.disk_mb, tl.events_ttl_days, tl.default_free_disk_size_mb, tl.max_disk_size_mb
FROM "public"."teams" t
         JOIN "public"."users_teams" ut ON ut.team_id = t.id
         JOIN "public"."team_limits" tl on tl.id = t.id
WHERE ut.user_id = $1 AND t.id = $2
`

type GetTeamWithTierByTeamAndUserParams struct {
	UserID uuid.UUID
	ID     uuid.UUID
}

type GetTeamWithTierByTeamAndUserRow struct {
	Team      Team
	TeamLimit TeamLimit
}

func (q *Queries) GetTeamWithTierByTeamAndUser(ctx context.Context, arg GetTeamWithTierByTeamAndUserParams) (GetTeamWithTierByTeamAndUserRow, error) {
	row := q.db.QueryRow(ctx, getTeamWithTierByTeamAndUser, arg.UserID, arg.ID)
	var i GetTeamWithTierByTeamAndUserRow
	err := row.Scan(
		&i.Team.ID,
		&i.Team.CreatedAt,
		&i.Team.IsBlocked,
		&i.Team.Name,
		&i.Team.Tier,
		&i.Team.Email,
		&i.Team.IsBanned,
		&i.Team.BlockedReason,
		&i.Team.ClusterID,
		&i.Team.SandboxSchedulingLabels,
		&i.Team.SsoOrganizationID,
		&i.Team.SsoAutoJoin,
		&i.Team.Slug,
		&i.TeamLimit.ID,
		&i.TeamLimit.MaxLengthHours,
		&i.TeamLimit.ConcurrentSandboxes,
		&i.TeamLimit.ConcurrentTemplateBuilds,
		&i.TeamLimit.MaxVcpu,
		&i.TeamLimit.MaxRamMb,
		&i.TeamLimit.DiskMb,
		&i.TeamLimit.EventsTtlDays,
		&i.TeamLimit.DefaultFreeDiskSizeMb,
		&i.TeamLimit.MaxDiskSizeMb,
	)
	return i, err
}

const getTeamWithTierByTeamID = `-- name: GetTeamWithTierByTeamID :one
SELECT t.id, t.created_at, t.is_blocked, t.name, t.tier, t.email, t.is_banned, t.blocked_reason, t.cluster_id, t.sandbox_scheduling_labels, t.sso_organization_id, t.sso_auto_join, t.slug, tl.id, tl.max_length_hours, tl.concurrent_sandboxes, tl.concurrent_template_builds, tl.max_vcpu, tl.max_ram_mb, tl.disk_mb, tl.events_ttl_days, tl.default_free_disk_size_mb, tl.max_disk_size_mb
FROM "public"."teams" t
         JOIN "public"."team_limits" tl on tl.id = t.id
WHERE t.id = $1
`

type GetTeamWithTierByTeamIDRow struct {
	Team      Team
	TeamLimit TeamLimit
}

func (q *Queries) GetTeamWithTierByTeamID(ctx context.Context, id uuid.UUID) (GetTeamWithTierByTeamIDRow, error) {
	row := q.db.QueryRow(ctx, getTeamWithTierByTeamID, id)
	var i GetTeamWithTierByTeamIDRow
	err := row.Scan(
		&i.Team.ID,
		&i.Team.CreatedAt,
		&i.Team.IsBlocked,
		&i.Team.Name,
		&i.Team.Tier,
		&i.Team.Email,
		&i.Team.IsBanned,
		&i.Team.BlockedReason,
		&i.Team.ClusterID,
		&i.Team.SandboxSchedulingLabels,
		&i.Team.SsoOrganizationID,
		&i.Team.SsoAutoJoin,
		&i.Team.Slug,
		&i.TeamLimit.ID,
		&i.TeamLimit.MaxLengthHours,
		&i.TeamLimit.ConcurrentSandboxes,
		&i.TeamLimit.ConcurrentTemplateBuilds,
		&i.TeamLimit.MaxVcpu,
		&i.TeamLimit.MaxRamMb,
		&i.TeamLimit.DiskMb,
		&i.TeamLimit.EventsTtlDays,
		&i.TeamLimit.DefaultFreeDiskSizeMb,
		&i.TeamLimit.MaxDiskSizeMb,
	)
	return i, err
}

const getTeamsWithUsersTeamsWithTier = `-- name: GetTeamsWithUsersTeamsWithTier :many
SELECT t.id, t.created_at, t.is_blocked, t.name, t.tier, t.email, t.is_banned, t.blocked_reason, t.cluster_id, t.sandbox_scheduling_labels, t.sso_organization_id, t.sso_auto_join, t.slug, ut.is_default, tl.id, tl.max_length_hours, tl.concurrent_sandboxes, tl.concurrent_template_builds, tl.max_vcpu, tl.max_ram_mb, tl.disk_mb, tl.events_ttl_days, tl.default_free_disk_size_mb, tl.max_disk_size_mb
FROM "public"."teams" t
         JOIN "public"."users_teams" ut ON ut.team_id = t.id
         JOIN "public"."team_limits" tl on tl.id = t.id
WHERE ut.user_id = $1
`

type GetTeamsWithUsersTeamsWithTierRow struct {
	Team      Team
	IsDefault bool
	TeamLimit TeamLimit
}

func (q *Queries) GetTeamsWithUsersTeamsWithTier(ctx context.Context, userID uuid.UUID) ([]GetTeamsWithUsersTeamsWithTierRow, error) {
	rows, err := q.db.Query(ctx, getTeamsWithUsersTeamsWithTier, userID)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []GetTeamsWithUsersTeamsWithTierRow
	for rows.Next() {
		var i GetTeamsWithUsersTeamsWithTierRow
		if err := rows.Scan(
			&i.Team.ID,
			&i.Team.CreatedAt,
			&i.Team.IsBlocked,
			&i.Team.Name,
			&i.Team.Tier,
			&i.Team.Email,
			&i.Team.IsBanned,
			&i.Team.BlockedReason,
			&i.Team.ClusterID,
			&i.Team.SandboxSchedulingLabels,
			&i.Team.SsoOrganizationID,
			&i.Team.SsoAutoJoin,
			&i.Team.Slug,
			&i.IsDefault,
			&i.TeamLimit.ID,
			&i.TeamLimit.MaxLengthHours,
			&i.TeamLimit.ConcurrentSandboxes,
			&i.TeamLimit.ConcurrentTemplateBuilds,
			&i.TeamLimit.MaxVcpu,
			&i.TeamLimit.MaxRamMb,
			&i.TeamLimit.DiskMb,
			&i.TeamLimit.EventsTtlDays,
			&i.TeamLimit.DefaultFreeDiskSizeMb,
			&i.TeamLimit.MaxDiskSizeMb,
		); err != nil {
			return nil, err
		}
		items = append(items, i)
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}
	return items, nil
}