db

package
v0.4.0 Latest Latest
Warning

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

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

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

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
}

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
}

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 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 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
	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 DeleteRevisionParams

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

type GetAutosaveParams

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

type GetRevisionParams

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

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
}

type ListMediaParams added in v0.3.0

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

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) 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) 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) 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) 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) (CoreContentRevision, 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) (CoreContentRevision, error)

func (*Queries) GetSetting added in v0.2.0

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

func (*Queries) ListContent added in v0.4.0

func (q *Queries) ListContent(ctx context.Context, arg ListContentParams) ([]ListContentRow, 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) 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) 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) 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) 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) UpdateContent added in v0.4.0

func (q *Queries) UpdateContent(ctx context.Context, arg UpdateContentParams) (CoreContent, 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) (CoreContentRevision, 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 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 UpdateContentParams added in v0.4.0

type UpdateContentParams struct {
	Status            string
	Slug              string
	Path              string
	ParentID          *uuid.UUID
	Title             string
	Content           string
	Excerpt           string
	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
	CreatedAt time.Time
}

Jump to

Keyboard shortcuts

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