db

package
v0.1.0 Latest Latest
Warning

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

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

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

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 CountPostsByStatusRow

type CountPostsByStatusRow struct {
	Status string
	Total  int64
}

type CountPostsParams

type CountPostsParams struct {
	Type   string
	Status string
	Search string
}

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 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) 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) 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) 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) 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) 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) TrashPost

func (q *Queries) TrashPost(ctx context.Context, arg TrashPostParams) (CorePost, 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 TrashPostParams

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

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