db

package
v0.0.0-...-1087858 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Aug 8, 2026 License: MIT Imports: 12 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func ForeignKeysEnabled 

func ForeignKeysEnabled(ctx context.Context, db *sql.DB) (bool, error)

func JournalMode 

func JournalMode(ctx context.Context, db *sql.DB) (string, error)

func Open 

func Open(opts Options) (*sql.DB, error)

func RunMigrations 

func RunMigrations(ctx context.Context, db *sql.DB) error

Types

type AssetRow 

type AssetRow struct {
	ID          int64
	WebsiteID   int64
	Filename    string
	ContentType string
	SizeBytes   int64
	ContentHash string
	CreatedAt   string
}

type AuditLogRow 

type AuditLogRow struct {
	ID              int64
	Actor           string
	Timestamp       string
	EnvironmentID   *int64
	Operation       string
	ResourceSummary string
	ReleaseID       *string
	MetadataJSON    string
}

type AuthPolicyRow 

type AuthPolicyRow struct {
	ID            int64
	EnvironmentID int64
	PathPrefix    string
	Username      string
	PasswordHash  string
	CreatedAt     string
	UpdatedAt     string
}

type BackendRow 

type BackendRow struct {
	ID            int64
	EnvironmentID int64
	PathPrefix    string
	Upstream      string
	CreatedAt     string
	UpdatedAt     string
}

type ComponentRow 

type ComponentRow struct {
	ID          int64
	WebsiteID   int64
	Name        string
	Scope       string
	ContentHash string
	CSSHash     string
	JSHash      string
	CreatedAt   string
	UpdatedAt   string
}

type DomainBindingResolvedRow 

type DomainBindingResolvedRow struct {
	ID              int64
	Domain          string
	EnvironmentID   int64
	WebsiteName     string
	EnvironmentName string
	CreatedAt       string
	UpdatedAt       string
}

type DomainBindingRow 

type DomainBindingRow struct {
	ID            int64
	Domain        string
	EnvironmentID int64
	CreatedAt     string
	UpdatedAt     string
}

type EnvironmentRow 

type EnvironmentRow struct {
	ID              int64
	WebsiteID       int64
	Name            string
	ActiveReleaseID *string
	CreatedAt       string
	UpdatedAt       string
}

type ListTelemetryEventsParams 

type ListTelemetryEventsParams struct {
	EnvironmentID int64
	EventName     string
	Since         *string
	Until         *string
	Limit         int
	Offset        int
}

type Options 

type Options struct {
	Path          string
	EnableWAL     bool
	BusyTimeoutMS int
	MaxOpenConns  int
	MaxIdleConns  int
}

func DefaultOptions 

func DefaultOptions(path string) Options

type PageRow 

type PageRow struct {
	ID          int64
	WebsiteID   int64
	Name        string
	Route       string
	Title       string
	Description string
	LayoutJSON  string
	HeadJSON    string
	ContentHash string
	CreatedAt   string
	UpdatedAt   string
}

func (PageRow) HeadJSONOrDefault 

func (r PageRow) HeadJSONOrDefault() string

type Queries 

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

func NewQueries 

func NewQueries(db queryer) *Queries

func (*Queries) DeleteAssetByFilename 

func (q *Queries) DeleteAssetByFilename(ctx context.Context, websiteID int64, filename string) (int64, error)

func (*Queries) DeleteAssetsNotIn 

func (q *Queries) DeleteAssetsNotIn(ctx context.Context, websiteID int64, filenames []string) (int64, error)

func (*Queries) DeleteAuthPolicyByPathPrefix 

func (q *Queries) DeleteAuthPolicyByPathPrefix(ctx context.Context, environmentID int64, pathPrefix string) (bool, error)

func (*Queries) DeleteBackendByPathPrefix 

func (q *Queries) DeleteBackendByPathPrefix(ctx context.Context, environmentID int64, pathPrefix string) (bool, error)

func (*Queries) DeleteComponentByName 

func (q *Queries) DeleteComponentByName(ctx context.Context, websiteID int64, name string) (int64, error)

func (*Queries) DeleteComponentsNotIn 

func (q *Queries) DeleteComponentsNotIn(ctx context.Context, websiteID int64, names []string) (int64, error)

func (*Queries) DeleteDomainBindingByDomain 

func (q *Queries) DeleteDomainBindingByDomain(ctx context.Context, domain string) (bool, error)

func (*Queries) DeleteExpiredReleasePreviews 

func (q *Queries) DeleteExpiredReleasePreviews(ctx context.Context, now string) (int64, error)

func (*Queries) DeletePageByName 

func (q *Queries) DeletePageByName(ctx context.Context, websiteID int64, name string) (int64, error)

func (*Queries) DeletePagesNotIn 

func (q *Queries) DeletePagesNotIn(ctx context.Context, websiteID int64, names []string) (int64, error)

func (*Queries) DeleteReleasePreviewByID 

func (q *Queries) DeleteReleasePreviewByID(ctx context.Context, environmentID, id int64) (bool, error)

func (*Queries) DeleteReleasesByEnvironment 

func (q *Queries) DeleteReleasesByEnvironment(ctx context.Context, environmentID int64, releaseIDs []string) (int64, error)

func (*Queries) DeleteStyleBundleByName 

func (q *Queries) DeleteStyleBundleByName(ctx context.Context, websiteID int64, name string) (int64, error)

func (*Queries) DeleteStyleBundlesNotIn 

func (q *Queries) DeleteStyleBundlesNotIn(ctx context.Context, websiteID int64, names []string) (int64, error)

func (*Queries) DeleteTelemetryEventsOlderThanDays 

func (q *Queries) DeleteTelemetryEventsOlderThanDays(ctx context.Context, retentionDays int) (int64, error)

func (*Queries) DeleteWebsiteIconsNotIn 

func (q *Queries) DeleteWebsiteIconsNotIn(ctx context.Context, websiteID int64, slots []string) (int64, error)

func (*Queries) GetActiveReleasePreviewByHostname 

func (q *Queries) GetActiveReleasePreviewByHostname(ctx context.Context, hostname, now string) (ReleasePreviewRow, error)

func (*Queries) GetAuthPolicyByPathPrefix 

func (q *Queries) GetAuthPolicyByPathPrefix(ctx context.Context, environmentID int64, pathPrefix string) (AuthPolicyRow, error)

func (*Queries) GetBackendByPathPrefix 

func (q *Queries) GetBackendByPathPrefix(ctx context.Context, environmentID int64, pathPrefix string) (BackendRow, error)

func (*Queries) GetDomainBindingByDomain 

func (q *Queries) GetDomainBindingByDomain(ctx context.Context, domain string) (DomainBindingResolvedRow, error)

func (*Queries) GetEnvironmentByName 

func (q *Queries) GetEnvironmentByName(ctx context.Context, websiteID int64, name string) (EnvironmentRow, error)

func (*Queries) GetReleaseByID 

func (q *Queries) GetReleaseByID(ctx context.Context, id string) (ReleaseRow, error)

func (*Queries) GetReleasePreviewByID 

func (q *Queries) GetReleasePreviewByID(ctx context.Context, environmentID, id int64) (ReleasePreviewRow, error)

func (*Queries) GetWebsiteByName 

func (q *Queries) GetWebsiteByName(ctx context.Context, name string) (WebsiteRow, error)

func (*Queries) InsertAsset 

func (q *Queries) InsertAsset(ctx context.Context, in AssetRow) (int64, error)

func (*Queries) InsertAuditLog 

func (q *Queries) InsertAuditLog(ctx context.Context, in AuditLogRow) (int64, error)

func (*Queries) InsertComponent 

func (q *Queries) InsertComponent(ctx context.Context, in ComponentRow) (int64, error)

func (*Queries) InsertDomainBinding 

func (q *Queries) InsertDomainBinding(ctx context.Context, in DomainBindingRow) (int64, error)

func (*Queries) InsertEnvironment 

func (q *Queries) InsertEnvironment(ctx context.Context, in EnvironmentRow) (int64, error)

func (*Queries) InsertPage 

func (q *Queries) InsertPage(ctx context.Context, in PageRow) (int64, error)

func (*Queries) InsertRelease 

func (q *Queries) InsertRelease(ctx context.Context, in ReleaseRow) error

func (*Queries) InsertReleasePreview 

func (q *Queries) InsertReleasePreview(ctx context.Context, in ReleasePreviewRow) (int64, error)

func (*Queries) InsertStyleBundle 

func (q *Queries) InsertStyleBundle(ctx context.Context, in StyleBundleRow) (int64, error)

func (*Queries) InsertTelemetryEvent 

func (q *Queries) InsertTelemetryEvent(ctx context.Context, in TelemetryEventRow) (int64, error)

func (*Queries) InsertWebsite 

func (q *Queries) InsertWebsite(ctx context.Context, in WebsiteRow) (int64, error)

func (*Queries) ListAssetsByWebsite 

func (q *Queries) ListAssetsByWebsite(ctx context.Context, websiteID int64) ([]AssetRow, error)

func (*Queries) ListAuthPolicies 

func (q *Queries) ListAuthPolicies(ctx context.Context) ([]AuthPolicyRow, error)

func (*Queries) ListAuthPoliciesByEnvironment 

func (q *Queries) ListAuthPoliciesByEnvironment(ctx context.Context, environmentID int64) ([]AuthPolicyRow, error)

func (*Queries) ListBackends 

func (q *Queries) ListBackends(ctx context.Context) ([]BackendRow, error)

func (*Queries) ListBackendsByEnvironment 

func (q *Queries) ListBackendsByEnvironment(ctx context.Context, environmentID int64) ([]BackendRow, error)

func (*Queries) ListComponentsByWebsite 

func (q *Queries) ListComponentsByWebsite(ctx context.Context, websiteID int64) ([]ComponentRow, error)

func (*Queries) ListDomainBindings 

func (q *Queries) ListDomainBindings(ctx context.Context, websiteName, environmentName string) ([]DomainBindingResolvedRow, error)

func (*Queries) ListLatestReleaseActors 

func (q *Queries) ListLatestReleaseActors(ctx context.Context, environmentID int64, releaseIDs []string) (map[string]string, error)

func (*Queries) ListPagesByWebsite 

func (q *Queries) ListPagesByWebsite(ctx context.Context, websiteID int64) ([]PageRow, error)

func (*Queries) ListReferencedBlobHashes 

func (q *Queries) ListReferencedBlobHashes(ctx context.Context) ([]string, error)

func (*Queries) ListReleasePreviews 

func (q *Queries) ListReleasePreviews(ctx context.Context, now string) ([]ReleasePreviewResolvedRow, error)

func (*Queries) ListReleasePreviewsByEnvironment 

func (q *Queries) ListReleasePreviewsByEnvironment(ctx context.Context, environmentID int64, now string) ([]ReleasePreviewRow, error)

func (*Queries) ListReleasesByEnvironment 

func (q *Queries) ListReleasesByEnvironment(ctx context.Context, environmentID int64) ([]ReleaseRow, error)

func (*Queries) ListReleasesByEnvironmentPage 

func (q *Queries) ListReleasesByEnvironmentPage(ctx context.Context, environmentID int64, limit, offset int) ([]ReleaseRow, error)

func (*Queries) ListStyleBundlesByWebsite 

func (q *Queries) ListStyleBundlesByWebsite(ctx context.Context, websiteID int64) ([]StyleBundleRow, error)

func (*Queries) ListTelemetryEvents 

func (q *Queries) ListTelemetryEvents(ctx context.Context, in ListTelemetryEventsParams) ([]TelemetryEventRow, error)

func (*Queries) ListWebsiteIconsByWebsite 

func (q *Queries) ListWebsiteIconsByWebsite(ctx context.Context, websiteID int64) ([]WebsiteIconRow, error)

func (*Queries) RestoreAuthPolicy 

func (q *Queries) RestoreAuthPolicy(ctx context.Context, in AuthPolicyRow) error

func (*Queries) RestoreBackend 

func (q *Queries) RestoreBackend(ctx context.Context, in BackendRow) error

func (*Queries) RestoreDomainBinding 

func (q *Queries) RestoreDomainBinding(ctx context.Context, in DomainBindingRow) error

func (*Queries) RestoreReleasePreview 

func (q *Queries) RestoreReleasePreview(ctx context.Context, in ReleasePreviewRow) error

func (*Queries) UpdateEnvironmentActiveRelease 

func (q *Queries) UpdateEnvironmentActiveRelease(ctx context.Context, environmentID int64, releaseID *string) error

func (*Queries) UpdateWebsiteSpec 

func (q *Queries) UpdateWebsiteSpec(ctx context.Context, in WebsiteRow) error

func (*Queries) UpsertAsset 

func (q *Queries) UpsertAsset(ctx context.Context, in AssetRow) error

func (*Queries) UpsertAuthPolicy 

func (q *Queries) UpsertAuthPolicy(ctx context.Context, in AuthPolicyRow) error

func (*Queries) UpsertBackend 

func (q *Queries) UpsertBackend(ctx context.Context, in BackendRow) error

func (*Queries) UpsertComponent 

func (q *Queries) UpsertComponent(ctx context.Context, in ComponentRow) error

func (*Queries) UpsertPage 

func (q *Queries) UpsertPage(ctx context.Context, in PageRow) error

func (*Queries) UpsertStyleBundle 

func (q *Queries) UpsertStyleBundle(ctx context.Context, in StyleBundleRow) error

func (*Queries) UpsertWebsiteIcon 

func (q *Queries) UpsertWebsiteIcon(ctx context.Context, in WebsiteIconRow) error

type ReleasePreviewResolvedRow 

type ReleasePreviewResolvedRow struct {
	ID              int64
	EnvironmentID   int64
	ReleaseID       string
	Hostname        string
	CreatedBy       string
	ExpiresAt       string
	CreatedAt       string
	WebsiteName     string
	EnvironmentName string
}

type ReleasePreviewRow 

type ReleasePreviewRow struct {
	ID            int64
	EnvironmentID int64
	ReleaseID     string
	Hostname      string
	CreatedBy     string
	ExpiresAt     string
	CreatedAt     string
}

type ReleaseRow 

type ReleaseRow struct {
	ID            string
	EnvironmentID int64
	ManifestJSON  string
	OutputHashes  string
	BuildLog      string
	Status        string
	CreatedAt     string
}

type StyleBundleRow 

type StyleBundleRow struct {
	ID        int64
	WebsiteID int64
	Name      string
	FilesJSON string
	CreatedAt string
	UpdatedAt string
}

type TelemetryEventRow 

type TelemetryEventRow struct {
	ID            int64
	EnvironmentID int64
	EventName     string
	Path          string
	OccurredAt    *string
	ReceivedAt    string
	SessionID     *string
	AttrsJSON     string
}

type WebsiteIconRow 

type WebsiteIconRow struct {
	ID          int64
	WebsiteID   int64
	Slot        string
	SourcePath  string
	ContentType string
	SizeBytes   int64
	ContentHash string
	CreatedAt   string
	UpdatedAt   string
}

type WebsiteRow 

type WebsiteRow struct {
	ID                 int64
	Name               string
	DefaultStyleBundle string
	BaseTemplate       string
	HeadJSON           string
	SEOJSON            string
	ContentHash        string
	CreatedAt          string
	UpdatedAt          string
}

func (WebsiteRow) HeadJSONOrDefault 

func (r WebsiteRow) HeadJSONOrDefault() string

func (WebsiteRow) SEOJSONOrDefault 

func (r WebsiteRow) SEOJSONOrDefault() string

Source Files

View all Source files

Directories

Path Synopsis

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.