db

package
v0.3.0 Latest Latest
Warning

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

Go to latest
Published: Aug 11, 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 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 CorePost

type CorePost 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
}

type CorePostRevision

type CorePostRevision struct {
	ID        uuid.UUID
	PostID    uuid.UUID
	Kind      string
	AuthorID  uuid.UUID
	Title     string
	Content   string
	Excerpt   string
	CreatedAt time.Time
}

type CoreSetting added in v0.2.0

type CoreSetting struct {
	Key   string
	Value string
}

type CountMediaParams added in v0.3.0

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

type CountPostsByStatusRow

type CountPostsByStatusRow struct {
	Status string
	Total  int64
}

type CountPostsParams

type CountPostsParams struct {
	Type   string
	Status string
	Search string
}

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 CreatePostParams

type CreatePostParams 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
}

type CreateRevisionParams

type CreateRevisionParams struct {
	ID        uuid.UUID
	PostID    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 {
	PostID   uuid.UUID
	AuthorID uuid.UUID
}

type DeleteRevisionParams

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

type GetAutosaveParams

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

type GetPublishedPostParams

type GetPublishedPostParams struct {
	Type string
	Slug string
}

type GetRevisionParams

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

type ListMediaParams added in v0.3.0

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

type ListPostsParams

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

type ListPostsRow

type ListPostsRow 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
}

type ListRevisionsRow

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

type PruneRevisionsParams

type PruneRevisionsParams struct {
	PostID uuid.UUID
	Keep   int32
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CountMedia added in v0.3.0

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

func (*Queries) CountPosts

func (q *Queries) CountPosts(ctx context.Context, arg CountPostsParams) (int64, error)

func (*Queries) CountPostsByStatus

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

func (*Queries) CreateMedia added in v0.3.0

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

func (*Queries) CreatePost

func (q *Queries) CreatePost(ctx context.Context, arg CreatePostParams) (CorePost, error)

SPDX-License-Identifier: Apache-2.0

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) DeleteMedia added in v0.3.0

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

func (*Queries) DeletePost

func (q *Queries) DeletePost(ctx context.Context, id uuid.UUID) (int64, 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) (CorePostRevision, error)

func (*Queries) GetMedia added in v0.3.0

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

func (*Queries) GetPost

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

func (*Queries) GetPublishedPost

func (q *Queries) GetPublishedPost(ctx context.Context, arg GetPublishedPostParams) (CorePost, error)

func (*Queries) GetRevision

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

func (*Queries) GetSetting added in v0.2.0

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

func (*Queries) ListMedia added in v0.3.0

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

func (*Queries) ListPosts

func (q *Queries) ListPosts(ctx context.Context, arg ListPostsParams) ([]ListPostsRow, error)

func (*Queries) ListRevisions

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

func (*Queries) PruneRevisions

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

func (*Queries) RestorePost

func (q *Queries) RestorePost(ctx context.Context, arg RestorePostParams) (CorePost, error)

func (*Queries) RestorePostKeepingSlug

func (q *Queries) RestorePostKeepingSlug(ctx context.Context, arg RestorePostKeepingSlugParams) (CorePost, error)

func (*Queries) SetSetting added in v0.2.0

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

func (*Queries) TrashPost

func (q *Queries) TrashPost(ctx context.Context, arg TrashPostParams) (CorePost, error)

func (*Queries) UpdateMedia added in v0.3.0

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

func (*Queries) UpdatePost

func (q *Queries) UpdatePost(ctx context.Context, arg UpdatePostParams) (CorePost, error)

func (*Queries) UpsertAutosave

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

func (*Queries) WithTx

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

type RestorePostKeepingSlugParams

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

type RestorePostParams

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

type SetSettingParams added in v0.2.0

type SetSettingParams struct {
	Key   string
	Value string
}

type TrashPostParams

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

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 UpdatePostParams

type UpdatePostParams struct {
	Status            string
	Slug              string
	Title             string
	Content           string
	Excerpt           string
	PublishedAt       *time.Time
	UpdatedAt         time.Time
	ID                uuid.UUID
	ExpectedUpdatedAt time.Time
}

type UpsertAutosaveParams

type UpsertAutosaveParams struct {
	ID        uuid.UUID
	PostID    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