dbx

package
v0.0.0-...-63cad89 Latest Latest
Warning

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

 Go to latest Published: Sep 30, 2023 License: AGPL-3.0 Imports: 8 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type AddTopicToMediaItemParams 

type AddTopicToMediaItemParams struct {
	MediaItemID uuid.UUID
	TopicID     uuid.UUID
}

type ConfirmTopicForMediaItemParams 

type ConfirmTopicForMediaItemParams struct {
	MediaItemID uuid.UUID
	TopicID     uuid.UUID
}

type CountSearchedMediaItemsParams 

type CountSearchedMediaItemsParams struct {
	UserID uuid.UUID
	Query  string
}

type CountSearchedTopicsParams 

type CountSearchedTopicsParams struct {
	UserID uuid.UUID
	Query  string
}

type CreateMediaItemParams 

type CreateMediaItemParams struct {
	UserID      uuid.UUID
	ItemType    MediaItemType
	Title       string
	Url         string
	PublishedAt pgtype.Timestamp
}

type CreateTopicParams 

type CreateTopicParams struct {
	UserID      uuid.UUID
	Title       string
	Description string
	Keywords    []string
}

type CreateUserParams 

type CreateUserParams struct {
	Name              string
	Username          string
	EncryptedPassword string
}

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 DeleteMediaItemParams 

type DeleteMediaItemParams struct {
	MediaItemID uuid.UUID
	UserID      uuid.UUID
}

type FetchMediaItemForUserParams 

type FetchMediaItemForUserParams struct {
	MediaItemID uuid.UUID
	UserID      uuid.UUID
}

type FetchMediaItemTopicsForMediaItemParams 

type FetchMediaItemTopicsForMediaItemParams struct {
	MediaItemID uuid.UUID
	UserID      uuid.UUID
}

type FetchMediaItemTopicsForMediaItemsParams 

type FetchMediaItemTopicsForMediaItemsParams struct {
	MediaItemIds []uuid.UUID
	UserID       uuid.UUID
}

type FetchMediaItemsByIDParams 

type FetchMediaItemsByIDParams struct {
	MediaItemIds []uuid.UUID
	UserID       uuid.UUID
}

type FetchTopicsByIDParams 

type FetchTopicsByIDParams struct {
	TopicIds []uuid.UUID
	UserID   uuid.UUID
}

type MarkVideoMediaItemAsProcessedParams 

type MarkVideoMediaItemAsProcessedParams struct {
	VideoFilePath     string
	ThumbnailFilePath string
	SubtitleFilePaths []string
	Transcript        string
	Title             string
	Metadata          dbtypes.JSON
	PublishedAt       pgtype.Timestamp
	MediaItemID       uuid.UUID
}

type MediaItem 

type MediaItem struct {
	ID                uuid.UUID
	UserID            uuid.UUID
	Title             string
	Url               string
	ItemType          MediaItemType
	PublishedAt       pgtype.Timestamp
	CreatedAt         pgtype.Timestamp
	UpdatedAt         pgtype.Timestamp
	State             MediaItemState
	VideoFilePath     pgtype.Text
	ThumbnailFilePath pgtype.Text
	SubtitleFilePaths []string
	Transcript        pgtype.Text
	Metadata          dbtypes.JSON
}

type MediaItemState 

type MediaItemState string
const (
	MediaItemStatePending    MediaItemState = "pending"
	MediaItemStateProcessing MediaItemState = "processing"
	MediaItemStateProcessed  MediaItemState = "processed"
	MediaItemStateFailed     MediaItemState = "failed"
)

func (*MediaItemState) Scan 

func (e *MediaItemState) Scan(src interface{}) error

type MediaItemTopic 

type MediaItemTopic struct {
	ID          uuid.UUID
	MediaItemID uuid.UUID
	TopicID     uuid.UUID
	ConfirmedAt pgtype.Timestamp
	CreatedAt   pgtype.Timestamp
	UpdatedAt   pgtype.Timestamp
}

type MediaItemType 

type MediaItemType string
const (
	MediaItemTypeVideo   MediaItemType = "video"
	MediaItemTypeAudio   MediaItemType = "audio"
	MediaItemTypeArticle MediaItemType = "article"
)

func (*MediaItemType) Scan 

func (e *MediaItemType) Scan(src interface{}) error

type NullMediaItemState 

type NullMediaItemState struct {
	MediaItemState MediaItemState
	Valid          bool // Valid is true if MediaItemState is not NULL
}

func (*NullMediaItemState) Scan 

func (ns *NullMediaItemState) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullMediaItemState) Value 

func (ns NullMediaItemState) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type NullMediaItemType 

type NullMediaItemType struct {
	MediaItemType MediaItemType
	Valid         bool // Valid is true if MediaItemType is not NULL
}

func (*NullMediaItemType) Scan 

func (ns *NullMediaItemType) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullMediaItemType) Value 

func (ns NullMediaItemType) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) AddTopicToMediaItem 

func (q *Queries) AddTopicToMediaItem(ctx context.Context, arg AddTopicToMediaItemParams) error

func (*Queries) ConfirmTopicForMediaItem 

func (q *Queries) ConfirmTopicForMediaItem(ctx context.Context, arg ConfirmTopicForMediaItemParams) error

func (*Queries) CountSearchedMediaItems 

func (q *Queries) CountSearchedMediaItems(ctx context.Context, arg CountSearchedMediaItemsParams) (int64, error)

func (*Queries) CountSearchedTopics 

func (q *Queries) CountSearchedTopics(ctx context.Context, arg CountSearchedTopicsParams) (int64, error)

func (*Queries) CreateMediaItem 

func (q *Queries) CreateMediaItem(ctx context.Context, arg CreateMediaItemParams) (MediaItem, error)

func (*Queries) CreateTopic 

func (q *Queries) CreateTopic(ctx context.Context, arg CreateTopicParams) (Topic, error)

func (*Queries) CreateUser 

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)

func (*Queries) DeleteMediaItem 

func (q *Queries) DeleteMediaItem(ctx context.Context, arg DeleteMediaItemParams) error

func (*Queries) FetchMediaItem 

func (q *Queries) FetchMediaItem(ctx context.Context, mediaItemID uuid.UUID) (MediaItem, error)

func (*Queries) FetchMediaItemForUser 

func (q *Queries) FetchMediaItemForUser(ctx context.Context, arg FetchMediaItemForUserParams) (MediaItem, error)

func (*Queries) FetchMediaItemTopicsForMediaItem 

func (q *Queries) FetchMediaItemTopicsForMediaItem(ctx context.Context, arg FetchMediaItemTopicsForMediaItemParams) ([]MediaItemTopic, error)

func (*Queries) FetchMediaItemTopicsForMediaItems 

func (q *Queries) FetchMediaItemTopicsForMediaItems(ctx context.Context, arg FetchMediaItemTopicsForMediaItemsParams) ([]MediaItemTopic, error)

func (*Queries) FetchMediaItemsByID 

func (q *Queries) FetchMediaItemsByID(ctx context.Context, arg FetchMediaItemsByIDParams) ([]MediaItem, error)

func (*Queries) FetchTopicsByID 

func (q *Queries) FetchTopicsByID(ctx context.Context, arg FetchTopicsByIDParams) ([]Topic, error)

func (*Queries) FetchUserByUsername 

func (q *Queries) FetchUserByUsername(ctx context.Context, username string) (User, error)

func (*Queries) MarkMediaItemAsProcessing 

func (q *Queries) MarkMediaItemAsProcessing(ctx context.Context, mediaItemID uuid.UUID) error

func (*Queries) MarkVideoMediaItemAsProcessed 

func (q *Queries) MarkVideoMediaItemAsProcessed(ctx context.Context, arg MarkVideoMediaItemAsProcessedParams) error

func (*Queries) RemoveTopicFromMediaItem 

func (q *Queries) RemoveTopicFromMediaItem(ctx context.Context, arg RemoveTopicFromMediaItemParams) error

func (*Queries) ScanMediaItemForTopics 

func (q *Queries) ScanMediaItemForTopics(ctx context.Context, mediaItemID uuid.UUID) ([]Topic, error)

func (*Queries) SearchMediaItems 

func (q *Queries) SearchMediaItems(ctx context.Context, arg SearchMediaItemsParams) ([]MediaItem, error)

func (*Queries) SearchTopics 

func (q *Queries) SearchTopics(ctx context.Context, arg SearchTopicsParams) ([]Topic, error)

func (*Queries) UpdateTopicKeywords 

func (q *Queries) UpdateTopicKeywords(ctx context.Context, arg UpdateTopicKeywordsParams) (Topic, error)

func (*Queries) WithTx 

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

type RemoveTopicFromMediaItemParams 

type RemoveTopicFromMediaItemParams struct {
	MediaItemID uuid.UUID
	TopicID     uuid.UUID
}

type SchemaMigration 

type SchemaMigration struct {
	Version int64
	Dirty   bool
}

type SearchMediaItemsParams 

type SearchMediaItemsParams struct {
	UserID     uuid.UUID
	Query      string
	PageOffset int32
	PageLimit  int32
}

type SearchTopicsParams 

type SearchTopicsParams struct {
	UserID     uuid.UUID
	Query      string
	PageOffset int32
	PageLimit  int32
}

type Topic 

type Topic struct {
	ID          uuid.UUID
	UserID      uuid.UUID
	Name        string
	Description string
	CreatedAt   pgtype.Timestamp
	UpdatedAt   pgtype.Timestamp
}

type TopicKeyword 

type TopicKeyword struct {
	ID        uuid.UUID
	TopicID   uuid.UUID
	Label     string
	CreatedAt pgtype.Timestamp
	UpdatedAt pgtype.Timestamp
}

type UpdateTopicKeywordsParams 

type UpdateTopicKeywordsParams struct {
	Keywords []string
	UserID   uuid.UUID
	TopicID  uuid.UUID
}

type User 

type User struct {
	ID                uuid.UUID
	Name              string
	Username          string
	EncryptedPassword string
	CreatedAt         pgtype.Timestamp
	UpdatedAt         pgtype.Timestamp
}

Source Files

View all Source files

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.