dbx

package
v0.0.0-...-21415ec Latest Latest
Warning

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

 Go to latest Published: Oct 22, 2023 License: AGPL-3.0-or-later Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Bookmark 

type Bookmark struct {
	ID        int64
	UserID    int64
	Url       string
	Title     pgtype.Text
	Html      pgtype.Text
	FilePath  pgtype.Text
	Status    BookmarkStatus
	CreatedAt pgtype.Timestamptz
	UpdatedAt pgtype.Timestamptz
	Category  pgtype.Text
	DeletedAt pgtype.Timestamptz
}

type BookmarkStatus 

type BookmarkStatus string
const (
	BookmarkStatusPending  BookmarkStatus = "pending"
	BookmarkStatusFetched  BookmarkStatus = "fetched"
	BookmarkStatusArchived BookmarkStatus = "archived"
)

func (*BookmarkStatus) Scan 

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

type CountBookmarksSearchResultsParams 

type CountBookmarksSearchResultsParams struct {
	UserID int64
	Query  string
}

type CreateBookmarkParams 

type CreateBookmarkParams struct {
	UserID int64
	Url    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 FetchArchivedBookmarksListParams 

type FetchArchivedBookmarksListParams struct {
	UserID     int64
	PageOffset int32
	PageLimit  int32
}

type FetchBookmarksListParams 

type FetchBookmarksListParams struct {
	UserID     int64
	PageOffset int32
	PageLimit  int32
}

type MarkBookmarkFetchedParams 

type MarkBookmarkFetchedParams struct {
	FilePath string
	ID       int64
}

type NullBookmarkStatus 

type NullBookmarkStatus struct {
	BookmarkStatus BookmarkStatus
	Valid          bool // Valid is true if BookmarkStatus is not NULL
}

func (*NullBookmarkStatus) Scan 

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

Scan implements the Scanner interface.

func (NullBookmarkStatus) Value 

func (ns NullBookmarkStatus) 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) ArchiveBookmark 

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

func (*Queries) CountArchivedBookmarksList 

func (q *Queries) CountArchivedBookmarksList(ctx context.Context, userID int64) (int64, error)

func (*Queries) CountBookmarksList 

func (q *Queries) CountBookmarksList(ctx context.Context, userID int64) (int64, error)

func (*Queries) CountBookmarksSearchResults 

func (q *Queries) CountBookmarksSearchResults(ctx context.Context, arg CountBookmarksSearchResultsParams) (int64, error)

func (*Queries) CreateBookmark 

func (q *Queries) CreateBookmark(ctx context.Context, arg CreateBookmarkParams) (Bookmark, error)

func (*Queries) CreateUser 

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

func (*Queries) DeleteBookmarks 

func (q *Queries) DeleteBookmarks(ctx context.Context, agehours int32) error

func (*Queries) FetchArchivedBookmarksList 

func (q *Queries) FetchArchivedBookmarksList(ctx context.Context, arg FetchArchivedBookmarksListParams) ([]Bookmark, error)

func (*Queries) FetchBookmarkByID 

func (q *Queries) FetchBookmarkByID(ctx context.Context, id int64) (Bookmark, error)

func (*Queries) FetchBookmarksList 

func (q *Queries) FetchBookmarksList(ctx context.Context, arg FetchBookmarksListParams) ([]Bookmark, error)

func (*Queries) FetchCategories 

func (q *Queries) FetchCategories(ctx context.Context, userID int64) ([]pgtype.Text, error)

func (*Queries) FetchUserByUsername 

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

func (*Queries) MarkBookmarkFetched 

func (q *Queries) MarkBookmarkFetched(ctx context.Context, arg MarkBookmarkFetchedParams) error

func (*Queries) SearchBookmarks 

func (q *Queries) SearchBookmarks(ctx context.Context, arg SearchBookmarksParams) ([]Bookmark, error)

func (*Queries) UnarchiveBookmark 

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

func (*Queries) UpdateBookmarkCategory 

func (q *Queries) UpdateBookmarkCategory(ctx context.Context, arg UpdateBookmarkCategoryParams) error

func (*Queries) UpdateBookmarkDetails 

func (q *Queries) UpdateBookmarkDetails(ctx context.Context, arg UpdateBookmarkDetailsParams) error

func (*Queries) WithTx 

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

type SchemaMigration 

type SchemaMigration struct {
	Version int64
	Dirty   bool
}

type SearchBookmarksParams 

type SearchBookmarksParams struct {
	UserID     int64
	Query      string
	PageOffset int32
	PageLimit  int32
}

type UpdateBookmarkCategoryParams 

type UpdateBookmarkCategoryParams struct {
	Category string
	ID       int64
}

type UpdateBookmarkDetailsParams 

type UpdateBookmarkDetailsParams struct {
	Title string
	Html  string
	ID    int64
}

type User 

type User struct {
	ID                int64
	Username          pgtype.Text
	Name              string
	EncryptedPassword string
	CreatedAt         pgtype.Timestamptz
	UpdatedAt         pgtype.Timestamptz
}

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.