db

package
v0.6.0 Latest Latest
Warning

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

Go to latest
Published: Aug 18, 2026 License: Apache-2.0 Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type AddRelationParams added in v0.5.0

type AddRelationParams struct {
	FromID   uuid.UUID
	FieldID  int32
	ToID     uuid.UUID
	Position int32
}

type ClearContentFieldValuesParams added in v0.5.0

type ClearContentFieldValuesParams struct {
	Key  string
	Type string
}

type ClearRelationsOfFieldParams added in v0.5.0

type ClearRelationsOfFieldParams struct {
	FromID  uuid.UUID
	FieldID int32
}

type ClearRevisionFieldValuesParams added in v0.5.0

type ClearRevisionFieldValuesParams struct {
	Key  string
	Type string
}

type CoreContent added in v0.4.0

type CoreContent struct {
	ID          uuid.UUID
	Type        string
	Status      string
	Slug        string
	Title       string
	Content     string
	Excerpt     string
	AuthorID    uuid.UUID
	PublishedAt *time.Time
	CreatedAt   time.Time
	UpdatedAt   time.Time
	ParentID    *uuid.UUID
	Path        string
	Fields      content.Values
}

type CoreContentField added in v0.5.0

type CoreContentField struct {
	ID        int32
	TypeKey   string
	Key       string
	Label     string
	Kind      string
	RelatesTo *string
	Many      bool
	Required  bool
	CreatedAt time.Time
	UpdatedAt time.Time
}

type CoreContentRelation added in v0.5.0

type CoreContentRelation struct {
	FromID   uuid.UUID
	FieldID  int32
	ToID     uuid.UUID
	Position int32
	SortAt   time.Time
	Visible  bool
}

type CoreContentRevision added in v0.4.0

type CoreContentRevision struct {
	ID        uuid.UUID
	ContentID uuid.UUID
	Kind      string
	AuthorID  uuid.UUID
	Title     string
	Content   string
	Excerpt   string
	CreatedAt time.Time
	Fields    content.Values
}

type CoreContentType added in v0.4.0

type CoreContentType struct {
	Key           string
	SingularLabel string
	PluralLabel   string
	RouteWord     string
	Hierarchical  bool
	Revisions     bool
	RevisionCap   int32
	PageKind      string
	IsDefault     bool
	Active        bool
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type CoreMedia added in v0.3.0

type CoreMedia struct {
	ID          int64
	MediaType   string
	File        string
	Title       string
	AltText     string
	Caption     string
	Description string
	MimeType    string
	Width       int32
	Height      int32
	Filesize    int64
	Sizes       media.RenditionMap
	AuthorID    uuid.UUID
	CreatedAt   time.Time
	UpdatedAt   time.Time
}

type CoreSetting added in v0.2.0

type CoreSetting struct {
	Key   string
	Value string
}

type CoreUserSetting added in v0.6.0

type CoreUserSetting struct {
	UserID uuid.UUID
	Key    string
	Value  string
}

type CountContentByStatusRow added in v0.4.0

type CountContentByStatusRow struct {
	Status string
	Total  int64
}

type CountContentParams added in v0.4.0

type CountContentParams struct {
	Type   string
	Status string
	Search string
}

type CountMediaParams added in v0.3.0

type CountMediaParams struct {
	MediaType string
	Mimes     []string
	Search    string
}

type CreateContentFieldParams added in v0.5.0

type CreateContentFieldParams struct {
	TypeKey   string
	Key       string
	Label     string
	Kind      string
	RelatesTo *string
	Many      bool
	Required  bool
	CreatedAt time.Time
	UpdatedAt time.Time
}

type CreateContentParams added in v0.4.0

type CreateContentParams struct {
	ID          uuid.UUID
	Type        string
	Status      string
	Slug        string
	Title       string
	Content     string
	Excerpt     string
	AuthorID    uuid.UUID
	PublishedAt *time.Time
	CreatedAt   time.Time
	UpdatedAt   time.Time
	ParentID    *uuid.UUID
	Path        string
}

type CreateContentTypeParams added in v0.4.0

type CreateContentTypeParams struct {
	Key           string
	SingularLabel string
	PluralLabel   string
	RouteWord     string
	Hierarchical  bool
	Revisions     bool
	RevisionCap   int32
	PageKind      string
	IsDefault     bool
	Active        bool
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type CreateMediaParams added in v0.3.0

type CreateMediaParams struct {
	MediaType   string
	File        string
	Title       string
	AltText     string
	Caption     string
	Description string
	MimeType    string
	Width       int32
	Height      int32
	Filesize    int64
	Sizes       media.RenditionMap
	AuthorID    uuid.UUID
	CreatedAt   time.Time
	UpdatedAt   time.Time
}

type CreateRevisionParams

type CreateRevisionParams struct {
	ID        uuid.UUID
	ContentID uuid.UUID
	Kind      string
	AuthorID  uuid.UUID
	Title     string
	Content   string
	Excerpt   string
	Fields    content.Values
	CreatedAt time.Time
}

type DBTX

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type DeleteAutosaveParams

type DeleteAutosaveParams struct {
	ContentID uuid.UUID
	AuthorID  uuid.UUID
}

type DeleteContentFieldParams added in v0.5.0

type DeleteContentFieldParams struct {
	TypeKey string
	Key     string
}

type DeleteRevisionParams

type DeleteRevisionParams struct {
	ContentID uuid.UUID
	ID        uuid.UUID
}

type GetAutosaveParams

type GetAutosaveParams struct {
	ContentID uuid.UUID
	AuthorID  uuid.UUID
}

type GetAutosaveRow added in v0.5.0

type GetAutosaveRow struct {
	ID        uuid.UUID
	ContentID uuid.UUID
	Kind      string
	AuthorID  uuid.UUID
	Title     string
	Content   string
	Excerpt   string
	Fields    content.Values
	CreatedAt time.Time
}

type GetRevisionParams

type GetRevisionParams struct {
	ContentID uuid.UUID
	ID        uuid.UUID
}

type GetRevisionRow added in v0.5.0

type GetRevisionRow struct {
	ID        uuid.UUID
	ContentID uuid.UUID
	Kind      string
	AuthorID  uuid.UUID
	Title     string
	Content   string
	Excerpt   string
	Fields    content.Values
	CreatedAt time.Time
}

type GetUserSettingParams added in v0.6.0

type GetUserSettingParams struct {
	UserID uuid.UUID
	Key    string
}

type ListContentParams added in v0.4.0

type ListContentParams struct {
	Type      string
	Status    string
	Search    string
	OrderBy   string
	OrderDir  string
	RowOffset int32
	RowLimit  int32
}

type ListContentRow added in v0.4.0

type ListContentRow struct {
	ID          uuid.UUID
	Type        string
	Status      string
	Slug        string
	Title       string
	Excerpt     string
	AuthorID    uuid.UUID
	PublishedAt *time.Time
	CreatedAt   time.Time
	UpdatedAt   time.Time
	ParentID    *uuid.UUID
	Path        string
	Fields      content.Values
}

type ListMediaParams added in v0.3.0

type ListMediaParams struct {
	MediaType string
	Mimes     []string
	Search    string
	RowOffset int32
	RowLimit  int32
}

type ListRelatedContentParams added in v0.5.0

type ListRelatedContentParams struct {
	Target    uuid.UUID
	RowOffset int32
	RowLimit  int32
}

type ListRelatedContentRow added in v0.5.0

type ListRelatedContentRow struct {
	ID          uuid.UUID
	Type        string
	Status      string
	Slug        string
	Title       string
	Excerpt     string
	AuthorID    uuid.UUID
	PublishedAt *time.Time
	CreatedAt   time.Time
	UpdatedAt   time.Time
	ParentID    *uuid.UUID
	Path        string
	Fields      content.Values
}

type ListRelationFieldsOfTypeRow added in v0.5.0

type ListRelationFieldsOfTypeRow struct {
	ID        int32
	Key       string
	RelatesTo *string
	Many      bool
}

type ListRelationSummariesRow added in v0.5.0

type ListRelationSummariesRow struct {
	Key   string
	ID    uuid.UUID
	Title string
	Path  string
}

type ListRelationTargetsRow added in v0.5.0

type ListRelationTargetsRow struct {
	Key  string
	ToID uuid.UUID
}

type ListRevisionsRow

type ListRevisionsRow struct {
	ID        uuid.UUID
	ContentID uuid.UUID
	Kind      string
	AuthorID  uuid.UUID
	Title     string
	Excerpt   string
	CreatedAt time.Time
}

type MoveDescendantsParams added in v0.4.0

type MoveDescendantsParams struct {
	UpdatedAt time.Time
	ID        uuid.UUID
	Path      string
}

type PruneRevisionsParams

type PruneRevisionsParams struct {
	ContentID uuid.UUID
	Keep      int32
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) AddRelation added in v0.5.0

func (q *Queries) AddRelation(ctx context.Context, arg AddRelationParams) error

func (*Queries) ClearContentFieldValues added in v0.5.0

func (q *Queries) ClearContentFieldValues(ctx context.Context, arg ClearContentFieldValuesParams) error

func (*Queries) ClearRelationsOfField added in v0.5.0

func (q *Queries) ClearRelationsOfField(ctx context.Context, arg ClearRelationsOfFieldParams) error

func (*Queries) ClearRevisionFieldValues added in v0.5.0

func (q *Queries) ClearRevisionFieldValues(ctx context.Context, arg ClearRevisionFieldValuesParams) error

func (*Queries) ContentDepth added in v0.4.0

func (q *Queries) ContentDepth(ctx context.Context, id uuid.UUID) (int32, error)

func (*Queries) CountChildren added in v0.4.0

func (q *Queries) CountChildren(ctx context.Context, id *uuid.UUID) (int64, error)

func (*Queries) CountContent added in v0.4.0

func (q *Queries) CountContent(ctx context.Context, arg CountContentParams) (int64, error)

func (*Queries) CountContentByStatus added in v0.4.0

func (q *Queries) CountContentByStatus(ctx context.Context, type_ string) ([]CountContentByStatusRow, error)

func (*Queries) CountMedia added in v0.3.0

func (q *Queries) CountMedia(ctx context.Context, arg CountMediaParams) (int64, error)

func (*Queries) CountRelatedContent added in v0.5.0

func (q *Queries) CountRelatedContent(ctx context.Context, target uuid.UUID) (int64, error)

func (*Queries) CreateContent added in v0.4.0

func (q *Queries) CreateContent(ctx context.Context, arg CreateContentParams) (CoreContent, error)

SPDX-License-Identifier: Apache-2.0

func (*Queries) CreateContentField added in v0.5.0

func (q *Queries) CreateContentField(ctx context.Context, arg CreateContentFieldParams) (CoreContentField, error)

func (*Queries) CreateContentType added in v0.4.0

func (q *Queries) CreateContentType(ctx context.Context, arg CreateContentTypeParams) (CoreContentType, error)

func (*Queries) CreateMedia added in v0.3.0

func (q *Queries) CreateMedia(ctx context.Context, arg CreateMediaParams) (CoreMedia, error)

func (*Queries) CreateRevision

func (q *Queries) CreateRevision(ctx context.Context, arg CreateRevisionParams) error

func (*Queries) DeleteAutosave

func (q *Queries) DeleteAutosave(ctx context.Context, arg DeleteAutosaveParams) error

func (*Queries) DeleteContent added in v0.4.0

func (q *Queries) DeleteContent(ctx context.Context, id uuid.UUID) (int64, error)

func (*Queries) DeleteContentField added in v0.5.0

func (q *Queries) DeleteContentField(ctx context.Context, arg DeleteContentFieldParams) (int64, error)

func (*Queries) DeleteContentType added in v0.4.0

func (q *Queries) DeleteContentType(ctx context.Context, key string) (int64, error)

func (*Queries) DeleteMedia added in v0.3.0

func (q *Queries) DeleteMedia(ctx context.Context, id int64) (CoreMedia, error)

func (*Queries) DeleteRevision

func (q *Queries) DeleteRevision(ctx context.Context, arg DeleteRevisionParams) (int64, error)

func (*Queries) GetAutosave

func (q *Queries) GetAutosave(ctx context.Context, arg GetAutosaveParams) (GetAutosaveRow, error)

func (*Queries) GetContent added in v0.4.0

func (q *Queries) GetContent(ctx context.Context, id uuid.UUID) (CoreContent, error)

func (*Queries) GetContentType added in v0.4.0

func (q *Queries) GetContentType(ctx context.Context, key string) (CoreContentType, error)

func (*Queries) GetMedia added in v0.3.0

func (q *Queries) GetMedia(ctx context.Context, id int64) (CoreMedia, error)

func (*Queries) GetPublishedContentByPath added in v0.4.0

func (q *Queries) GetPublishedContentByPath(ctx context.Context, path string) (CoreContent, error)

func (*Queries) GetRevision

func (q *Queries) GetRevision(ctx context.Context, arg GetRevisionParams) (GetRevisionRow, error)

func (*Queries) GetSetting added in v0.2.0

func (q *Queries) GetSetting(ctx context.Context, key string) (string, error)

func (*Queries) GetUserSetting added in v0.6.0

func (q *Queries) GetUserSetting(ctx context.Context, arg GetUserSettingParams) (string, error)

func (*Queries) ListContent added in v0.4.0

func (q *Queries) ListContent(ctx context.Context, arg ListContentParams) ([]ListContentRow, error)

func (*Queries) ListContentFields added in v0.5.0

func (q *Queries) ListContentFields(ctx context.Context) ([]CoreContentField, error)

func (*Queries) ListContentFieldsOfType added in v0.5.0

func (q *Queries) ListContentFieldsOfType(ctx context.Context, typeKey string) ([]CoreContentField, error)

func (*Queries) ListContentTypes added in v0.4.0

func (q *Queries) ListContentTypes(ctx context.Context) ([]CoreContentType, error)

func (*Queries) ListMedia added in v0.3.0

func (q *Queries) ListMedia(ctx context.Context, arg ListMediaParams) ([]CoreMedia, error)

func (*Queries) ListRelatedContent added in v0.5.0

func (q *Queries) ListRelatedContent(ctx context.Context, arg ListRelatedContentParams) ([]ListRelatedContentRow, error)

func (*Queries) ListRelationFieldsOfType added in v0.5.0

func (q *Queries) ListRelationFieldsOfType(ctx context.Context, typeKey string) ([]ListRelationFieldsOfTypeRow, error)

func (*Queries) ListRelationSummaries added in v0.5.0

func (q *Queries) ListRelationSummaries(ctx context.Context, fromID uuid.UUID) ([]ListRelationSummariesRow, error)

func (*Queries) ListRelationTargets added in v0.5.0

func (q *Queries) ListRelationTargets(ctx context.Context, fromID uuid.UUID) ([]ListRelationTargetsRow, error)

func (*Queries) ListRevisions

func (q *Queries) ListRevisions(ctx context.Context, contentID uuid.UUID) ([]ListRevisionsRow, error)

func (*Queries) LockContent added in v0.4.0

func (q *Queries) LockContent(ctx context.Context, id uuid.UUID) (CoreContent, error)

func (*Queries) LockContentType added in v0.4.0

func (q *Queries) LockContentType(ctx context.Context, key string) (CoreContentType, error)

func (*Queries) LockDefaultContentType added in v0.4.0

func (q *Queries) LockDefaultContentType(ctx context.Context) (CoreContentType, error)

func (*Queries) LockFieldKeysOfType added in v0.5.0

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

func (*Queries) MoveDescendants added in v0.4.0

func (q *Queries) MoveDescendants(ctx context.Context, arg MoveDescendantsParams) error

func (*Queries) PruneRevisions

func (q *Queries) PruneRevisions(ctx context.Context, arg PruneRevisionsParams) error

func (*Queries) RefreshRelationVisibility added in v0.5.0

func (q *Queries) RefreshRelationVisibility(ctx context.Context, id uuid.UUID) error

func (*Queries) RestoreContent added in v0.4.0

func (q *Queries) RestoreContent(ctx context.Context, arg RestoreContentParams) (CoreContent, error)

func (*Queries) RestoreContentKeepingSlug added in v0.4.0

func (q *Queries) RestoreContentKeepingSlug(ctx context.Context, arg RestoreContentKeepingSlugParams) (CoreContent, error)

func (*Queries) RetypeContentPaths added in v0.4.0

func (q *Queries) RetypeContentPaths(ctx context.Context, arg RetypeContentPathsParams) error

func (*Queries) SetSetting added in v0.2.0

func (q *Queries) SetSetting(ctx context.Context, arg SetSettingParams) error

func (*Queries) SetUserSetting added in v0.6.0

func (q *Queries) SetUserSetting(ctx context.Context, arg SetUserSettingParams) error

func (*Queries) SiblingSlugTaken added in v0.4.0

func (q *Queries) SiblingSlugTaken(ctx context.Context, arg SiblingSlugTakenParams) (bool, error)

func (*Queries) TrashContent added in v0.4.0

func (q *Queries) TrashContent(ctx context.Context, arg TrashContentParams) (CoreContent, error)

func (*Queries) TypesOfContent added in v0.5.0

func (q *Queries) TypesOfContent(ctx context.Context, ids []uuid.UUID) ([]TypesOfContentRow, error)

func (*Queries) UpdateContent added in v0.4.0

func (q *Queries) UpdateContent(ctx context.Context, arg UpdateContentParams) (CoreContent, error)

func (*Queries) UpdateContentField added in v0.5.0

func (q *Queries) UpdateContentField(ctx context.Context, arg UpdateContentFieldParams) (CoreContentField, error)

func (*Queries) UpdateContentType added in v0.4.0

func (q *Queries) UpdateContentType(ctx context.Context, arg UpdateContentTypeParams) (CoreContentType, error)

func (*Queries) UpdateMedia added in v0.3.0

func (q *Queries) UpdateMedia(ctx context.Context, arg UpdateMediaParams) (CoreMedia, error)

func (*Queries) UpsertAutosave

func (q *Queries) UpsertAutosave(ctx context.Context, arg UpsertAutosaveParams) (UpsertAutosaveRow, error)

func (*Queries) WithTx

func (q *Queries) WithTx(tx pgx.Tx) *Queries

type RestoreContentKeepingSlugParams added in v0.4.0

type RestoreContentKeepingSlugParams struct {
	UpdatedAt time.Time
	ID        uuid.UUID
}

type RestoreContentParams added in v0.4.0

type RestoreContentParams struct {
	UpdatedAt time.Time
	ID        uuid.UUID
}

type RetypeContentPathsParams added in v0.4.0

type RetypeContentPathsParams struct {
	RouteWord string
	Was       string
	UpdatedAt time.Time
	Key       string
}

type SetSettingParams added in v0.2.0

type SetSettingParams struct {
	Key   string
	Value string
}

type SetUserSettingParams added in v0.6.0

type SetUserSettingParams struct {
	UserID uuid.UUID
	Key    string
	Value  string
}

type SiblingSlugTakenParams added in v0.4.0

type SiblingSlugTakenParams struct {
	Type     string
	ParentID *uuid.UUID
	Slug     string
	ID       uuid.UUID
}

type TrashContentParams added in v0.4.0

type TrashContentParams struct {
	Suffix    string
	UpdatedAt time.Time
	ID        uuid.UUID
}

type TypesOfContentRow added in v0.5.0

type TypesOfContentRow struct {
	ID   uuid.UUID
	Type string
}

type UpdateContentFieldParams added in v0.5.0

type UpdateContentFieldParams struct {
	Label     string
	Required  bool
	UpdatedAt time.Time
	TypeKey   string
	Key       string
}

type UpdateContentParams added in v0.4.0

type UpdateContentParams struct {
	Status            string
	Slug              string
	Path              string
	ParentID          *uuid.UUID
	Title             string
	Content           string
	Excerpt           string
	Fields            content.Values
	PublishedAt       *time.Time
	UpdatedAt         time.Time
	ID                uuid.UUID
	ExpectedUpdatedAt time.Time
}

type UpdateContentTypeParams added in v0.4.0

type UpdateContentTypeParams struct {
	SingularLabel string
	PluralLabel   string
	RouteWord     string
	Hierarchical  bool
	Revisions     bool
	RevisionCap   int32
	PageKind      string
	IsDefault     bool
	Active        bool
	UpdatedAt     time.Time
	Key           string
}

type UpdateMediaParams added in v0.3.0

type UpdateMediaParams struct {
	Title             string
	AltText           string
	Caption           string
	Description       string
	UpdatedAt         time.Time
	ID                int64
	ExpectedUpdatedAt time.Time
}

type UpsertAutosaveParams

type UpsertAutosaveParams struct {
	ID        uuid.UUID
	ContentID uuid.UUID
	AuthorID  uuid.UUID
	Title     string
	Content   string
	Excerpt   string
	Fields    content.Values
	CreatedAt time.Time
}

type UpsertAutosaveRow added in v0.5.0

type UpsertAutosaveRow struct {
	ID        uuid.UUID
	ContentID uuid.UUID
	Kind      string
	AuthorID  uuid.UUID
	Title     string
	Content   string
	Excerpt   string
	Fields    content.Values
	CreatedAt time.Time
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL