db

type Addon struct {
	ID            string
	AppID         string
	Kind          string
	Name          string
	ContainerName string
	VolumeName    string
	PasswordEnc   []byte
	Version       string
	State         string
	CreatedAt     string
	UpdatedAt     string
}

type ApiToken struct {
	ID         string
	UserID     string
	Name       string
	TokenHash  string
	CreatedAt  string
	LastUsedAt sql.NullString
	RevokedAt  sql.NullString
}

type App struct {
	ID            string
	Name          string
	Hostname      string
	Port          int64
	MemoryBytes   int64
	NanoCpus      int64
	PidsLimit     int64
	OverridesJson string
	CreatedBy     string
	CreatedAt     string
	UpdatedAt     string
	ScanPolicy    string
}

type AppendAuditEventParams struct {
	Ts           string
	Actor        string
	Action       string
	ResourceType string
	ResourceID   string
	RequestID    string
	Result       string
	DetailsJson  string
	PrevHash     string
	Hash         string
}

type AppendDeploymentLogParams struct {
	DeploymentID string
	Seq          int64
	Ts           string
	Stream       string
	Line         string
}

type AuditEvent struct {
	Seq          int64
	Ts           string
	Actor        string
	Action       string
	ResourceType string
	ResourceID   string
	RequestID    string
	Result       string
	DetailsJson  string
	PrevHash     string
	Hash         string
}

type Backup struct {
	ID         string
	AddonID    string
	State      string
	ObjectKey  string
	SizeBytes  int64
	Error      string
	StartedAt  string
	FinishedAt sql.NullString
}

type CreateAPITokenParams struct {
	ID        string
	UserID    string
	Name      string
	TokenHash string
	CreatedAt string
}

type CreateAddonParams struct {
	ID            string
	AppID         string
	Kind          string
	Name          string
	ContainerName string
	VolumeName    string
	PasswordEnc   []byte
	Version       string
	State         string
	CreatedAt     string
	UpdatedAt     string
}

type CreateAppParams struct {
	ID            string
	Name          string
	Hostname      string
	Port          int64
	MemoryBytes   int64
	NanoCpus      int64
	PidsLimit     int64
	OverridesJson string
	CreatedBy     string
	CreatedAt     string
	UpdatedAt     string
}

type CreateBackupParams struct {
	ID        string
	AddonID   string
	State     string
	StartedAt string
}

type CreateDeploymentParams struct {
	ID            string
	AppID         string
	Trigger       string
	Actor         string
	CommitSha     string
	CommitMessage string
	ImageRef      string
	CreatedAt     string
	UpdatedAt     string
}

type CreateReleaseParams struct {
	ID              string
	AppID           string
	DeploymentID    string
	ImageRef        string
	ImageDigest     string
	Active          int64
	SbomPath        string
	ScanSummaryJson string
	CreatedAt       string
}

type CreateSessionParams struct {
	ID           string
	UserID       string
	TokenHash    string
	TotpVerified int64
	Ip           string
	UserAgent    string
	CreatedAt    string
	LastSeenAt   string
	ExpiresAt    string
}

type CreateUserParams struct {
	ID           string
	Email        string
	PasswordHash string
	Role         string
	CreatedAt    string
	UpdatedAt    string
}

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DeleteExpiredSessionsParams struct {
	ExpiresAt string
	RevokedAt sql.NullString
}

type DeleteSecretParams struct {
	AppID string
	Name  string
}

type DeleteStaleLoginAttemptsParams struct {
	FirstBefore string
	Now         sql.NullString
}

type Deployment struct {
	ID            string
	AppID         string
	Trigger       string
	Actor         string
	CommitSha     string
	CommitMessage string
	ImageRef      string
	State         string
	Error         string
	ContainerID   string
	ContainerName string
	ReleaseID     sql.NullString
	CreatedAt     string
	UpdatedAt     string
	StartedAt     sql.NullString
	FinishedAt    sql.NullString
}

type DeploymentLog struct {
	DeploymentID string
	Seq          int64
	Ts           string
	Stream       string
	Line         string
}

type FinishBackupParams struct {
	State      string
	ObjectKey  string
	SizeBytes  int64
	Error      string
	FinishedAt sql.NullString
	ID         string
}

type FinishDeploymentParams struct {
	State      string
	Error      string
	ReleaseID  sql.NullString
	FinishedAt sql.NullString
	UpdatedAt  string
	ID         string
}

type GetAddonByNameParams struct {
	AppID string
	Name  string
}

type GitSource struct {
	AppID               string
	Provider            string
	RepoUrl             string
	Branch              string
	BaseDir             string
	Dockerfile          string
	WebhookSecretEnc    []byte
	DeployKeyPrivateEnc []byte
	DeployKeyPublic     string
	PollIntervalSeconds int64
	LastSeenCommit      string
	CreatedAt           string
	UpdatedAt           string
}

type ListAuditEventsForResourceParams struct {
	ResourceType string
	ResourceID   string
	Limit        int64
}

type ListAuditEventsParams struct {
	Seq   int64
	Limit int64
}

type ListBackupsForAddonParams struct {
	AddonID string
	Limit   int64
}

type ListDeploymentLogsParams struct {
	DeploymentID string
	Seq          int64
	Limit        int64
}

type ListDeploymentsForAppParams struct {
	AppID string
	Limit int64
}

type ListReleasesForAppParams struct {
	AppID string
	Limit int64
}

type ListSecretCiphertextsRow struct {
	Name     string
	ValueEnc []byte
}

type ListSecretMetadataRow struct {
	ID        string
	AppID     string
	Name      string
	Version   int64
	CreatedBy string
	CreatedAt string
	UpdatedAt string
}

type LoginAttempt struct {
	Key         string
	Count       int64
	FirstAt     string
	LockedUntil sql.NullString
}

type Querier interface {
	AppendAuditEvent(ctx context.Context, arg AppendAuditEventParams) (AuditEvent, error)
	AppendDeploymentLog(ctx context.Context, arg AppendDeploymentLogParams) error
	CountAuditEvents(ctx context.Context) (int64, error)
	CountDeploymentLogs(ctx context.Context, deploymentID string) (int64, error)
	CountOtherActiveOwners(ctx context.Context, id string) (int64, error)
	CountUsers(ctx context.Context) (int64, error)
	CreateAPIToken(ctx context.Context, arg CreateAPITokenParams) (ApiToken, error)
	CreateAddon(ctx context.Context, arg CreateAddonParams) (Addon, error)
	CreateApp(ctx context.Context, arg CreateAppParams) (App, error)
	CreateBackup(ctx context.Context, arg CreateBackupParams) (Backup, error)
	CreateDeployment(ctx context.Context, arg CreateDeploymentParams) (Deployment, error)
	CreateRelease(ctx context.Context, arg CreateReleaseParams) (Release, error)
	CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
	DeleteAddon(ctx context.Context, id string) error
	DeleteApp(ctx context.Context, id string) error
	DeleteExpiredSessions(ctx context.Context, arg DeleteExpiredSessionsParams) error
	DeleteGitSource(ctx context.Context, appID string) error
	DeleteLoginAttempt(ctx context.Context, key string) error
	DeleteSecret(ctx context.Context, arg DeleteSecretParams) (int64, error)
	DeleteStaleLoginAttempts(ctx context.Context, arg DeleteStaleLoginAttemptsParams) (int64, error)
	DeleteUser(ctx context.Context, id string) error
	FinishBackup(ctx context.Context, arg FinishBackupParams) error
	FinishDeployment(ctx context.Context, arg FinishDeploymentParams) (Deployment, error)
	GetAPITokenByHash(ctx context.Context, tokenHash string) (ApiToken, error)
	GetActiveRelease(ctx context.Context, appID string) (Release, error)
	GetAddon(ctx context.Context, id string) (Addon, error)
	GetAddonByName(ctx context.Context, arg GetAddonByNameParams) (Addon, error)
	GetApp(ctx context.Context, id string) (App, error)
	GetAppByName(ctx context.Context, name string) (App, error)
	GetBackup(ctx context.Context, id string) (Backup, error)
	GetDeployment(ctx context.Context, id string) (Deployment, error)
	GetGitSource(ctx context.Context, appID string) (GitSource, error)
	GetLoginAttempt(ctx context.Context, key string) (LoginAttempt, error)
	GetRelease(ctx context.Context, id string) (Release, error)
	GetSession(ctx context.Context, id string) (Session, error)
	GetSessionByTokenHash(ctx context.Context, tokenHash string) (Session, error)
	GetUser(ctx context.Context, id string) (User, error)
	GetUserByEmail(ctx context.Context, email string) (User, error)
	LastAuditEvent(ctx context.Context) (AuditEvent, error)
	ListAPITokensForUser(ctx context.Context, userID string) ([]ApiToken, error)
	ListActiveDeployments(ctx context.Context) ([]Deployment, error)
	ListAddons(ctx context.Context) ([]Addon, error)
	ListAddonsForApp(ctx context.Context, appID string) ([]Addon, error)
	ListApps(ctx context.Context) ([]App, error)
	ListAuditEvents(ctx context.Context, arg ListAuditEventsParams) ([]AuditEvent, error)
	ListAuditEventsForResource(ctx context.Context, arg ListAuditEventsForResourceParams) ([]AuditEvent, error)
	ListBackupsForAddon(ctx context.Context, arg ListBackupsForAddonParams) ([]Backup, error)
	ListDeploymentLogs(ctx context.Context, arg ListDeploymentLogsParams) ([]DeploymentLog, error)
	ListDeploymentsForApp(ctx context.Context, arg ListDeploymentsForAppParams) ([]Deployment, error)
	ListLiveSessionsForUser(ctx context.Context, userID string) ([]Session, error)
	ListPollingGitSources(ctx context.Context) ([]GitSource, error)
	ListReleasesForApp(ctx context.Context, arg ListReleasesForAppParams) ([]Release, error)
	ListSecretCiphertexts(ctx context.Context, appID string) ([]ListSecretCiphertextsRow, error)
	ListSecretMetadata(ctx context.Context, appID string) ([]ListSecretMetadataRow, error)
	ListUsers(ctx context.Context) ([]User, error)
	MarkSessionTOTPVerified(ctx context.Context, id string) error
	NextDeploymentLogSeq(ctx context.Context, deploymentID string) (int64, error)
	RevokeAPIToken(ctx context.Context, arg RevokeAPITokenParams) (int64, error)
	// User administration (E2.2). Sessions and API tokens are revoked, never deleted, so the rows
	// keep their audit value; DeleteUser cascades through the schema's ON DELETE CASCADE.
	RevokeAllAPITokensForUser(ctx context.Context, arg RevokeAllAPITokensForUserParams) (int64, error)
	RevokeOtherUserSessions(ctx context.Context, arg RevokeOtherUserSessionsParams) error
	RevokeSession(ctx context.Context, arg RevokeSessionParams) error
	RevokeUserSessions(ctx context.Context, arg RevokeUserSessionsParams) error
	SetActiveRelease(ctx context.Context, arg SetActiveReleaseParams) error
	SetAddonState(ctx context.Context, arg SetAddonStateParams) error
	SetDeploymentBuilt(ctx context.Context, arg SetDeploymentBuiltParams) error
	SetDeploymentCommit(ctx context.Context, arg SetDeploymentCommitParams) error
	SetDeploymentContainer(ctx context.Context, arg SetDeploymentContainerParams) error
	SetDeploymentStarted(ctx context.Context, arg SetDeploymentStartedParams) error
	SetDeploymentState(ctx context.Context, arg SetDeploymentStateParams) (Deployment, error)
	SetUserDisabled(ctx context.Context, arg SetUserDisabledParams) error
	SetUserTOTP(ctx context.Context, arg SetUserTOTPParams) error
	SupersedeHealthyDeployments(ctx context.Context, arg SupersedeHealthyDeploymentsParams) error
	TouchAPIToken(ctx context.Context, arg TouchAPITokenParams) error
	TouchSession(ctx context.Context, arg TouchSessionParams) error
	TrimDeploymentLogs(ctx context.Context, arg TrimDeploymentLogsParams) error
	UpdateAppResources(ctx context.Context, arg UpdateAppResourcesParams) (App, error)
	UpdateAppRouting(ctx context.Context, arg UpdateAppRoutingParams) (App, error)
	UpdateAppScanPolicy(ctx context.Context, arg UpdateAppScanPolicyParams) (App, error)
	UpdateGitSourceLastSeen(ctx context.Context, arg UpdateGitSourceLastSeenParams) error
	UpdateReleaseScan(ctx context.Context, arg UpdateReleaseScanParams) error
	UpdateUserPassword(ctx context.Context, arg UpdateUserPasswordParams) error
	UpdateUserRole(ctx context.Context, arg UpdateUserRoleParams) error
	UpsertGitSource(ctx context.Context, arg UpsertGitSourceParams) (GitSource, error)
	UpsertLoginAttempt(ctx context.Context, arg UpsertLoginAttemptParams) error
	UpsertSecret(ctx context.Context, arg UpsertSecretParams) (UpsertSecretRow, error)
}

type Queries struct {
	// contains filtered or unexported fields
}

type Release struct {
	ID              string
	AppID           string
	DeploymentID    string
	ImageRef        string
	ImageDigest     string
	Active          int64
	SbomPath        string
	ScanSummaryJson string
	CreatedAt       string
}

type RevokeAPITokenParams struct {
	RevokedAt sql.NullString
	ID        string
	UserID    string
}

type RevokeAllAPITokensForUserParams struct {
	RevokedAt sql.NullString
	UserID    string
}

type RevokeOtherUserSessionsParams struct {
	RevokedAt sql.NullString
	UserID    string
	ID        string
}

type RevokeSessionParams struct {
	RevokedAt sql.NullString
	ID        string
}

type RevokeUserSessionsParams struct {
	RevokedAt sql.NullString
	UserID    string
}

type Secret struct {
	ID        string
	AppID     string
	Name      string
	ValueEnc  []byte
	Version   int64
	CreatedBy string
	CreatedAt string
	UpdatedAt string
}

type Session struct {
	ID           string
	UserID       string
	TokenHash    string
	TotpVerified int64
	Ip           string
	UserAgent    string
	CreatedAt    string
	LastSeenAt   string
	ExpiresAt    string
	RevokedAt    sql.NullString
}

type SetActiveReleaseParams struct {
	ID    string
	AppID string
}

type SetAddonStateParams struct {
	State     string
	UpdatedAt string
	ID        string
}

type SetDeploymentBuiltParams struct {
	ImageRef  string
	UpdatedAt string
	ID        string
}

type SetDeploymentCommitParams struct {
	CommitSha     string
	CommitMessage string
	UpdatedAt     string
	ID            string
}

type SetDeploymentContainerParams struct {
	ContainerID   string
	ContainerName string
	UpdatedAt     string
	ID            string
}

type SetDeploymentStartedParams struct {
	StartedAt sql.NullString
	UpdatedAt string
	ID        string
}

type SetDeploymentStateParams struct {
	State     string
	Error     string
	UpdatedAt string
	ID        string
}

type SetUserDisabledParams struct {
	Disabled  int64
	UpdatedAt string
	ID        string
}

type SetUserTOTPParams struct {
	TotpSecretEnc []byte
	TotpEnabled   int64
	RecoveryCodes sql.NullString
	UpdatedAt     string
	ID            string
}

type SupersedeHealthyDeploymentsParams struct {
	UpdatedAt string
	AppID     string
	ID        string
}

type TouchAPITokenParams struct {
	LastUsedAt sql.NullString
	ID         string
}

type TouchSessionParams struct {
	LastSeenAt string
	ID         string
}

type TrimDeploymentLogsParams struct {
	DeploymentID string
	Seq          int64
}

type UpdateAppResourcesParams struct {
	MemoryBytes   int64
	NanoCpus      int64
	PidsLimit     int64
	OverridesJson string
	UpdatedAt     string
	ID            string
}

type UpdateAppRoutingParams struct {
	Hostname  string
	Port      int64
	UpdatedAt string
	ID        string
}

type UpdateAppScanPolicyParams struct {
	ScanPolicy string
	UpdatedAt  string
	ID         string
}

type UpdateGitSourceLastSeenParams struct {
	LastSeenCommit string
	UpdatedAt      string
	AppID          string
}

type UpdateReleaseScanParams struct {
	SbomPath        string
	ScanSummaryJson string
	ID              string
}

type UpdateUserPasswordParams struct {
	PasswordHash string
	UpdatedAt    string
	ID           string
}

type UpdateUserRoleParams struct {
	Role      string
	UpdatedAt string
	ID        string
}

type UpsertGitSourceParams struct {
	AppID               string
	Provider            string
	RepoUrl             string
	Branch              string
	BaseDir             string
	Dockerfile          string
	WebhookSecretEnc    []byte
	DeployKeyPrivateEnc []byte
	DeployKeyPublic     string
	PollIntervalSeconds int64
	LastSeenCommit      string
	CreatedAt           string
	UpdatedAt           string
}

type UpsertLoginAttemptParams struct {
	Key         string
	Count       int64
	FirstAt     string
	LockedUntil sql.NullString
}

type UpsertSecretParams struct {
	ID        string
	AppID     string
	Name      string
	ValueEnc  []byte
	CreatedBy string
	CreatedAt string
	UpdatedAt string
}

type UpsertSecretRow struct {
	ID        string
	AppID     string
	Name      string
	Version   int64
	CreatedBy string
	CreatedAt string
	UpdatedAt string
}

type User struct {
	ID            string
	Email         string
	PasswordHash  string
	Role          string
	TotpSecretEnc []byte
	TotpEnabled   int64
	RecoveryCodes sql.NullString
	Disabled      int64
	CreatedAt     string
	UpdatedAt     string
}