postgresql

package
v0.0.0-...-e38dd13 Latest Latest
Warning

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

 Go to latest Published: Jul 31, 2023 License: Apache-2.0 Imports: 4 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Article 

type Article struct {
	ID      int64
	Title   string
	Excerpt string
	Content string
	UserID  int64
	// draft, published, archived
	Status    string
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt sql.NullTime
}

type ArticlesCategory 

type ArticlesCategory struct {
	ArticleID  int64
	CategoryID int64
}

type ArticlesLabel 

type ArticlesLabel struct {
	ArticleID int64
	LabelID   int64
}

type Category 

type Category struct {
	ID        int64
	Name      string
	ParentID  int64
	Color     int32
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt sql.NullTime
}

type CountUserParams 

type CountUserParams struct {
	Username string
	Nickname string
}

type CreateArticleCategoryParams 

type CreateArticleCategoryParams struct {
	ArticleID  int64
	CategoryID int64
}

type CreateArticleLabelParams 

type CreateArticleLabelParams struct {
	ArticleID int64
	LabelID   int64
}

type CreateArticleParams 

type CreateArticleParams struct {
	Title   string
	Excerpt string
	Content string
	UserID  int64
}

type CreateCategoryParams 

type CreateCategoryParams struct {
	Name     string
	ParentID int64
	Color    int32
}

type CreateLabelParams 

type CreateLabelParams struct {
	Name  string
	Color int32
}

type CreateUserParams 

type CreateUserParams struct {
	Username string
	Password string
	Email    string
	Nickname string
}

type DBTX 

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DeleteArticleCategoryParams 

type DeleteArticleCategoryParams struct {
	ArticleID  int64
	CategoryID int64
}

type DeleteArticleLabelParams 

type DeleteArticleLabelParams struct {
	ArticleID int64
	LabelID   int64
}

type GetArticleCategoryParams 

type GetArticleCategoryParams struct {
	ArticleID  int64
	CategoryID int64
}

type GetArticleLabelParams 

type GetArticleLabelParams struct {
	ArticleID int64
	LabelID   int64
}

type Label 

type Label struct {
	ID        int64
	Name      string
	Color     int32
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt sql.NullTime
}

type ListArticleParams 

type ListArticleParams struct {
	Limit  int32
	Offset int32
	Title  string
}

type ListCategoryParams 

type ListCategoryParams struct {
	Limit  int32
	Offset int32
	Name   string
}

type ListLabelParams 

type ListLabelParams struct {
	Limit  int32
	Offset int32
	Name   string
}

type ListUserParams 

type ListUserParams struct {
	Limit    int32
	Offset   int32
	Username string
	Nickname string
}

type Querier 

type Querier interface {
	CountArticle(ctx context.Context, title string) (int64, error)
	CountCategory(ctx context.Context, name string) (int64, error)
	CountLabel(ctx context.Context, name string) (int64, error)
	CountUser(ctx context.Context, arg CountUserParams) (int64, error)
	CreateArticle(ctx context.Context, arg CreateArticleParams) (Article, error)
	CreateArticleCategory(ctx context.Context, arg CreateArticleCategoryParams) (ArticlesCategory, error)
	CreateArticleLabel(ctx context.Context, arg CreateArticleLabelParams) (ArticlesLabel, error)
	CreateCategory(ctx context.Context, arg CreateCategoryParams) (Category, error)
	CreateLabel(ctx context.Context, arg CreateLabelParams) (Label, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
	DeleteArticle(ctx context.Context, id int64) error
	DeleteArticleCategory(ctx context.Context, arg DeleteArticleCategoryParams) error
	DeleteArticleLabel(ctx context.Context, arg DeleteArticleLabelParams) error
	DeleteCategory(ctx context.Context, id int64) error
	DeleteLabel(ctx context.Context, id int64) error
	DeleteUser(ctx context.Context, id int64) error
	GetArticle(ctx context.Context, id int64) (Article, error)
	GetArticleCategory(ctx context.Context, arg GetArticleCategoryParams) (ArticlesCategory, error)
	GetArticleLabel(ctx context.Context, arg GetArticleLabelParams) (ArticlesLabel, error)
	GetArticlesByCategoryID(ctx context.Context, categoryID int64) ([]ArticlesCategory, error)
	GetArticlesByLabelID(ctx context.Context, labelID int64) ([]ArticlesLabel, error)
	GetCategoriesByArticleID(ctx context.Context, articleID int64) ([]ArticlesCategory, error)
	GetCategory(ctx context.Context, id int64) (Category, error)
	GetLabel(ctx context.Context, id int64) (Label, error)
	GetLabelsByArticleID(ctx context.Context, articleID int64) ([]ArticlesLabel, error)
	GetUser(ctx context.Context, id int64) (User, error)
	GetUserByEmail(ctx context.Context, email string) (User, error)
	GetUserByUsername(ctx context.Context, username string) (User, error)
	ListArticle(ctx context.Context, arg ListArticleParams) ([]Article, error)
	ListCategory(ctx context.Context, arg ListCategoryParams) ([]Category, error)
	ListLabel(ctx context.Context, arg ListLabelParams) ([]Label, error)
	ListUser(ctx context.Context, arg ListUserParams) ([]User, error)
	TreeCategory(ctx context.Context) ([]TreeCategoryRow, error)
	UpdateCategory(ctx context.Context, arg UpdateCategoryParams) (Category, error)
	UpdateLabel(ctx context.Context, arg UpdateLabelParams) (Label, error)
	UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)
}

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) CountArticle 

func (q *Queries) CountArticle(ctx context.Context, title string) (int64, error)

func (*Queries) CountCategory 

func (q *Queries) CountCategory(ctx context.Context, name string) (int64, error)

func (*Queries) CountLabel 

func (q *Queries) CountLabel(ctx context.Context, name string) (int64, error)

func (*Queries) CountUser 

func (q *Queries) CountUser(ctx context.Context, arg CountUserParams) (int64, error)

func (*Queries) CreateArticle 

func (q *Queries) CreateArticle(ctx context.Context, arg CreateArticleParams) (Article, error)

func (*Queries) CreateArticleCategory 

func (q *Queries) CreateArticleCategory(ctx context.Context, arg CreateArticleCategoryParams) (ArticlesCategory, error)

func (*Queries) CreateArticleLabel 

func (q *Queries) CreateArticleLabel(ctx context.Context, arg CreateArticleLabelParams) (ArticlesLabel, error)

func (*Queries) CreateCategory 

func (q *Queries) CreateCategory(ctx context.Context, arg CreateCategoryParams) (Category, error)

func (*Queries) CreateLabel 

func (q *Queries) CreateLabel(ctx context.Context, arg CreateLabelParams) (Label, error)

func (*Queries) CreateUser 

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

func (*Queries) DeleteArticle 

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

func (*Queries) DeleteArticleCategory 

func (q *Queries) DeleteArticleCategory(ctx context.Context, arg DeleteArticleCategoryParams) error

func (*Queries) DeleteArticleLabel 

func (q *Queries) DeleteArticleLabel(ctx context.Context, arg DeleteArticleLabelParams) error

func (*Queries) DeleteCategory 

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

func (*Queries) DeleteLabel 

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

func (*Queries) DeleteUser 

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

func (*Queries) GetArticle 

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

func (*Queries) GetArticleCategory 

func (q *Queries) GetArticleCategory(ctx context.Context, arg GetArticleCategoryParams) (ArticlesCategory, error)

func (*Queries) GetArticleLabel 

func (q *Queries) GetArticleLabel(ctx context.Context, arg GetArticleLabelParams) (ArticlesLabel, error)

func (*Queries) GetArticlesByCategoryID 

func (q *Queries) GetArticlesByCategoryID(ctx context.Context, categoryID int64) ([]ArticlesCategory, error)

func (*Queries) GetArticlesByLabelID 

func (q *Queries) GetArticlesByLabelID(ctx context.Context, labelID int64) ([]ArticlesLabel, error)

func (*Queries) GetCategoriesByArticleID 

func (q *Queries) GetCategoriesByArticleID(ctx context.Context, articleID int64) ([]ArticlesCategory, error)

func (*Queries) GetCategory 

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

func (*Queries) GetLabel 

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

func (*Queries) GetLabelsByArticleID 

func (q *Queries) GetLabelsByArticleID(ctx context.Context, articleID int64) ([]ArticlesLabel, error)

func (*Queries) GetUser 

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

func (*Queries) GetUserByEmail 

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

func (*Queries) GetUserByUsername 

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

func (*Queries) ListArticle 

func (q *Queries) ListArticle(ctx context.Context, arg ListArticleParams) ([]Article, error)

func (*Queries) ListCategory 

func (q *Queries) ListCategory(ctx context.Context, arg ListCategoryParams) ([]Category, error)

func (*Queries) ListLabel 

func (q *Queries) ListLabel(ctx context.Context, arg ListLabelParams) ([]Label, error)

func (*Queries) ListUser 

func (q *Queries) ListUser(ctx context.Context, arg ListUserParams) ([]User, error)

func (*Queries) TreeCategory 

func (q *Queries) TreeCategory(ctx context.Context) ([]TreeCategoryRow, error)

func (*Queries) UpdateCategory 

func (q *Queries) UpdateCategory(ctx context.Context, arg UpdateCategoryParams) (Category, error)

func (*Queries) UpdateLabel 

func (q *Queries) UpdateLabel(ctx context.Context, arg UpdateLabelParams) (Label, error)

func (*Queries) UpdateUser 

func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)

func (*Queries) WithTx 

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

type Repository 

type Repository interface {
	Querier
	ExecTx(ctx context.Context, fn func(Querier) error) error
}

func NewStore 

func NewStore(db *sql.DB) Repository

type Store 

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

func (*Store) ExecTx 

func (store *Store) ExecTx(ctx context.Context, fn func(Querier) error) error

type TreeCategoryRow 

type TreeCategoryRow struct {
	ID       int64
	Name     string
	ParentID int64
	Color    int32
	Level    int16
}

type UpdateCategoryParams 

type UpdateCategoryParams struct {
	ID       int64
	Name     sql.NullString
	ParentID sql.NullInt64
	Color    sql.NullInt32
}

type UpdateLabelParams 

type UpdateLabelParams struct {
	ID    int64
	Name  sql.NullString
	Color sql.NullInt32
}

type UpdateUserParams 

type UpdateUserParams struct {
	ID       int64
	Nickname sql.NullString
	Avatar   sql.NullString
	Password sql.NullString
}

type User 

type User struct {
	ID        int64
	Username  string
	Password  string
	Email     string
	Nickname  string
	Avatar    sql.NullString
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt sql.NullTime
}

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.