db

package

Go to main page

Versions in this module

v1

v1.3.1

Jan 6, 2026

v1.3.0

Jan 6, 2026

Changes in this version

type Article

+ CheckOutdated bool

+ Cover string

+ LastUpdated time.Time

+ ReadTime string

+ Slug pgtype.Text

type CreateArticleParams

+ Cover string

+ type CreateCategoryTxParams struct

+ AfterCreate func() error

+ Name string

+ type CreateCategoryTxResult struct

+ Category Category

+ type DeleteCategoryTxParams struct

+ AfterDelete func() error

+ ID int64

+ type GetArticleBySlugRow struct

+ CategoryID int64

+ CategoryName pgtype.Text

+ CheckOutdated bool

+ Content string

+ Cover string

+ CreatedAt time.Time

+ DeletedAt time.Time

+ ID uuid.UUID

+ IsPublish bool

+ LastUpdated time.Time

+ Likes int32

+ Owner uuid.UUID

+ ReadTime string

+ Slug pgtype.Text

+ Summary string

+ Title string

+ UpdatedAt time.Time

+ Views int32

+ type GetArticleForUpdateRow struct

+ CategoryID int64

+ Content string

+ CreatedAt time.Time

+ DeletedAt time.Time

+ ID uuid.UUID

+ IsPublish bool

+ Likes int32

+ Owner uuid.UUID

+ Summary string

+ Title string

+ UpdatedAt time.Time

+ Views int32

type GetArticleRow

+ CheckOutdated bool

+ Cover string

+ LastUpdated time.Time

+ ReadTime string

+ Slug pgtype.Text

type ListAllArticlesRow

+ CheckOutdated bool

+ Cover string

+ LastUpdated time.Time

+ ReadTime string

+ Slug pgtype.Text

type ListArticlesRow

+ CheckOutdated bool

+ Cover string

+ LastUpdated time.Time

+ ReadTime string

+ Slug pgtype.Text

type Querier

+ GetArticleBySlug func(ctx context.Context, slug pgtype.Text) (GetArticleBySlugRow, error)

type Queries

+ func (q *Queries) GetArticleBySlug(ctx context.Context, slug pgtype.Text) (GetArticleBySlugRow, error)

type SQLStore

+ func (store *SQLStore) CreateCategoryTx(ctx context.Context, arg CreateCategoryTxParams) (CreateCategoryTxResult, error)

+ func (store *SQLStore) UpdateCategoryTx(ctx context.Context, arg UpdateCategoryTxParams) (UpdateCategoryTxResult, error)

type SearchArticlesRow

+ CheckOutdated bool

+ Cover string

+ LastUpdated time.Time

+ ReadTime string

+ Slug pgtype.Text

type Store

+ CreateCategoryTx func(ctx context.Context, arg CreateCategoryTxParams) (CreateCategoryTxResult, error)

+ UpdateCategoryTx func(ctx context.Context, arg UpdateCategoryTxParams) (UpdateCategoryTxResult, error)

type UpdateArticleParams

+ CheckOutdated pgtype.Bool

+ Cover pgtype.Text

+ LastUpdated pgtype.Timestamptz

+ ReadTime pgtype.Text

+ Slug pgtype.Text

+ type UpdateCategoryTxParams struct

+ AfterUpdate func() error

+ type UpdateCategoryTxResult struct

+ Category Category

v1.2.1

Dec 10, 2025

Changes in this version

+ type CountSearchArticlesParams struct

+ IsPublish pgtype.Bool

+ Keyword string

type Querier

+ CountSearchArticles func(ctx context.Context, arg CountSearchArticlesParams) (int64, error)

+ SearchArticles func(ctx context.Context, arg SearchArticlesParams) ([]SearchArticlesRow, error)

type Queries

+ func (q *Queries) CountSearchArticles(ctx context.Context, arg CountSearchArticlesParams) (int64, error)

+ func (q *Queries) SearchArticles(ctx context.Context, arg SearchArticlesParams) ([]SearchArticlesRow, error)

+ type SearchArticlesParams struct

+ IsPublish pgtype.Bool

+ Keyword string

+ Limit int32

+ Offset int32

+ type SearchArticlesRow struct

+ CategoryName pgtype.Text

+ CreatedAt time.Time

+ DeletedAt time.Time

+ ID uuid.UUID

+ IsPublish bool

+ Likes int32

+ Owner uuid.UUID

+ Score interface{}

+ Summary string

+ Title string

+ UpdatedAt time.Time

+ Username pgtype.Text

+ Views int32

v1.1.1

Dec 6, 2025

v1.1.0

Sep 25, 2025

Changes in this version

+ const ForeignKeyViolation

+ const UniqueViolation

+ var ErrRecordNotFound = pgx.ErrNoRows

+ var ErrUniqueViolation = &pgconn.PgError

+ func ErrorCode(err error) string

+ type Admin struct

+ CreatedAt time.Time

+ HashedPassword string

+ ID int64

+ IsActive bool

+ RoleID int64

+ UpdatedAt time.Time

+ Username string

+ type Article struct

+ CategoryID int64

+ Content string

+ CreatedAt time.Time

+ DeletedAt time.Time

+ ID uuid.UUID

+ IsPublish bool

+ Likes int32

+ Owner uuid.UUID

+ Summary string

+ Title string

+ UpdatedAt time.Time

+ Views int32

+ type Category struct

+ CreatedAt time.Time

+ ID int64

+ IsSystem bool

+ Name string

+ UpdatedAt time.Time

+ type Comment struct

+ ArticleID uuid.UUID

+ Content string

+ CreatedAt time.Time

+ DeletedAt time.Time

+ FromUserID uuid.UUID

+ ID int64

+ Likes int32

+ ParentID int64

+ ToUserID uuid.UUID

+ type CountArticlesParams struct

+ CategoryID pgtype.Int8

+ IsPublish pgtype.Bool

+ type CreateAdminParams struct

+ HashedPassword string

+ IsActive bool

+ RoleID int64

+ Username string

+ type CreateArticleParams struct

+ CategoryID int64

+ Content string

+ ID uuid.UUID

+ IsPublish bool

+ Owner uuid.UUID

+ Summary string

+ Title string

+ type CreateCommentParams struct

+ ArticleID uuid.UUID

+ Content string

+ FromUserID uuid.UUID

+ ParentID int64

+ ToUserID uuid.UUID

+ type CreateSessionParams struct

+ ClientIp string

+ ExpiresAt time.Time

+ ID uuid.UUID

+ IsBlocked bool

+ RefreshToken string

+ UserAgent string

+ UserID uuid.UUID

+ type CreateUserParams struct

+ Email string

+ FullName string

+ HashedPassword string

+ ID uuid.UUID

+ Username string

+ type CreateUserTxParams struct

+ AfterCreate func(user User) error

+ type CreateUserTxResult struct

+ User User

+ type CreateVerifyEmailParams struct

+ Email string

+ SecretCode string

+ UserID uuid.UUID

+ type DBTX interface

+ Exec func(context.Context, string, ...interface{}) (pgconn.CommandTag, error)

+ Query func(context.Context, string, ...interface{}) (pgx.Rows, error)

+ QueryRow func(context.Context, string, ...interface{}) pgx.Row

+ type DeleteArticleTxParams struct

+ AfterUpdate func(articleID uuid.UUID) error

+ ID uuid.UUID

+ type GetArticleRow struct

+ CategoryID int64

+ CategoryName pgtype.Text

+ Content string

+ CreatedAt time.Time

+ DeletedAt time.Time

+ ID uuid.UUID

+ IsPublish bool

+ Likes int32

+ Owner uuid.UUID

+ Summary string

+ Title string

+ UpdatedAt time.Time

+ Views int32

+ type ListAllArticlesParams struct

+ Limit int32

+ Offset int32

+ type ListAllArticlesRow struct

+ CategoryName pgtype.Text

+ CreatedAt time.Time

+ DeletedAt time.Time

+ ID uuid.UUID

+ IsPublish bool

+ Likes int32

+ Owner uuid.UUID

+ Summary string

+ Title string

+ UpdatedAt time.Time

+ Views int32

+ type ListArticlesByCategoryIDParams struct

+ CategoryID int64

+ Limit int32

+ Offset int32

+ type ListArticlesByCategoryIDRow struct

+ CategoryID int64

+ CreatedAt time.Time

+ DeletedAt time.Time

+ ID uuid.UUID

+ IsPublish bool

+ Likes int32

+ Name pgtype.Text

+ Owner uuid.UUID

+ Summary string

+ Title string

+ UpdatedAt time.Time

+ Username pgtype.Text

+ Views int32

+ type ListArticlesParams struct

+ CategoryID pgtype.Int8

+ IsPublish pgtype.Bool

+ Limit int32

+ Offset int32

+ type ListArticlesRow struct

+ CategoryName pgtype.Text

+ CreatedAt time.Time

+ DeletedAt time.Time

+ ID uuid.UUID

+ IsPublish bool

+ Likes int32

+ Owner uuid.UUID

+ Summary string

+ Title string

+ UpdatedAt time.Time

+ Username pgtype.Text

+ Views int32

+ type ListCategoriesCountArticlesParams struct

+ Limit int32

+ Offset int32

+ type ListCategoriesCountArticlesRow struct

+ ArticleCount int64

+ CreatedAt time.Time

+ ID int64

+ IsSystem bool

+ Name string

+ UpdatedAt time.Time

+ type ListCommentsByArticleIDRow struct

+ ArticleID uuid.UUID

+ Content string

+ CreatedAt time.Time

+ DeletedAt time.Time

+ FromUserID uuid.UUID

+ FromUserName pgtype.Text

+ ID int64

+ Likes int32

+ ParentID int64

+ ToUserID uuid.UUID

+ ToUserName pgtype.Text

+ type ListInitSysMenusRow struct

+ ID int64

+ Icon string

+ Name string

+ ParentID pgtype.Int8

+ Path string

+ Type int32

+ type Querier interface

+ AddCommentLikes func(ctx context.Context, id int64) (Comment, error)

+ CountAllArticles func(ctx context.Context) (int64, error)

+ CountArticles func(ctx context.Context, arg CountArticlesParams) (int64, error)

+ CountArticlesByCategoryID func(ctx context.Context, categoryID int64) (int64, error)

+ CountCategories func(ctx context.Context) (int64, error)

+ CreateAdmin func(ctx context.Context, arg CreateAdminParams) (Admin, error)

+ CreateArticle func(ctx context.Context, arg CreateArticleParams) (Article, error)

+ CreateCategory func(ctx context.Context, name string) (Category, error)

+ CreateComment func(ctx context.Context, arg CreateCommentParams) (Comment, error)

+ CreateSession func(ctx context.Context, arg CreateSessionParams) (Session, error)

+ CreateUser func(ctx context.Context, arg CreateUserParams) (User, error)

+ CreateVerifyEmail func(ctx context.Context, arg CreateVerifyEmailParams) (VerifyEmail, error)

+ DeleteArticle func(ctx context.Context, id uuid.UUID) error

+ DeleteCategory func(ctx context.Context, id int64) error

+ DeleteChildComments func(ctx context.Context, parentID int64) error

+ DeleteComment func(ctx context.Context, id int64) error

+ DeleteCommentsByArticleID func(ctx context.Context, articleID uuid.UUID) error

+ GetAdmin func(ctx context.Context, username string) (Admin, error)

+ GetAdminById func(ctx context.Context, id int64) (Admin, error)

+ GetArticle func(ctx context.Context, id uuid.UUID) (GetArticleRow, error)

+ GetArticleForUpdate func(ctx context.Context, id uuid.UUID) (Article, error)

+ GetCategory func(ctx context.Context, id int64) (Category, error)

+ GetCategoryByName func(ctx context.Context, name string) (Category, error)

+ GetComment func(ctx context.Context, id int64) (Comment, error)

+ GetSession func(ctx context.Context, id uuid.UUID) (Session, error)

+ GetUser func(ctx context.Context, id uuid.UUID) (User, error)

+ GetUserByUsername func(ctx context.Context, username string) (User, error)

+ IncrementArticleLikes func(ctx context.Context, id uuid.UUID) error

+ IncrementArticleViews func(ctx context.Context, id uuid.UUID) error

+ ListAllArticles func(ctx context.Context, arg ListAllArticlesParams) ([]ListAllArticlesRow, error)

+ ListAllCategories func(ctx context.Context) ([]Category, error)

+ ListArticles func(ctx context.Context, arg ListArticlesParams) ([]ListArticlesRow, error)

+ ListArticlesByCategoryID func(ctx context.Context, arg ListArticlesByCategoryIDParams) ([]ListArticlesByCategoryIDRow, error)

+ ListCategoriesCountArticles func(ctx context.Context, arg ListCategoriesCountArticlesParams) ([]ListCategoriesCountArticlesRow, error)

+ ListCommentsByArticleID func(ctx context.Context, articleID uuid.UUID) ([]ListCommentsByArticleIDRow, error)

+ ListInitSysMenus func(ctx context.Context, roleID int64) ([]ListInitSysMenusRow, error)

+ SetArticleDefaultCategoryIdByCategoryId func(ctx context.Context, categoryID int64) error

+ UpdateAdmin func(ctx context.Context, arg UpdateAdminParams) (Admin, error)

+ UpdateArticle func(ctx context.Context, arg UpdateArticleParams) (Article, error)

+ UpdateCategory func(ctx context.Context, arg UpdateCategoryParams) (Category, error)

+ UpdateUser func(ctx context.Context, arg UpdateUserParams) (User, error)

+ UpdateVerifyEmail func(ctx context.Context, arg UpdateVerifyEmailParams) (VerifyEmail, error)

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) AddCommentLikes(ctx context.Context, id int64) (Comment, error)

+ func (q *Queries) CountAllArticles(ctx context.Context) (int64, error)

+ func (q *Queries) CountArticles(ctx context.Context, arg CountArticlesParams) (int64, error)

+ func (q *Queries) CountArticlesByCategoryID(ctx context.Context, categoryID int64) (int64, error)

+ func (q *Queries) CountCategories(ctx context.Context) (int64, error)

+ func (q *Queries) CreateAdmin(ctx context.Context, arg CreateAdminParams) (Admin, error)

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

+ func (q *Queries) CreateCategory(ctx context.Context, name string) (Category, error)

+ func (q *Queries) CreateComment(ctx context.Context, arg CreateCommentParams) (Comment, error)

+ func (q *Queries) CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)

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

+ func (q *Queries) CreateVerifyEmail(ctx context.Context, arg CreateVerifyEmailParams) (VerifyEmail, error)

+ func (q *Queries) DeleteArticle(ctx context.Context, id uuid.UUID) error

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

+ func (q *Queries) DeleteChildComments(ctx context.Context, parentID int64) error

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

+ func (q *Queries) DeleteCommentsByArticleID(ctx context.Context, articleID uuid.UUID) error

+ func (q *Queries) GetAdmin(ctx context.Context, username string) (Admin, error)

+ func (q *Queries) GetAdminById(ctx context.Context, id int64) (Admin, error)

+ func (q *Queries) GetArticle(ctx context.Context, id uuid.UUID) (GetArticleRow, error)

+ func (q *Queries) GetArticleForUpdate(ctx context.Context, id uuid.UUID) (Article, error)

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

+ func (q *Queries) GetCategoryByName(ctx context.Context, name string) (Category, error)

+ func (q *Queries) GetComment(ctx context.Context, id int64) (Comment, error)

+ func (q *Queries) GetSession(ctx context.Context, id uuid.UUID) (Session, error)

+ func (q *Queries) GetUser(ctx context.Context, id uuid.UUID) (User, error)

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

+ func (q *Queries) IncrementArticleLikes(ctx context.Context, id uuid.UUID) error

+ func (q *Queries) IncrementArticleViews(ctx context.Context, id uuid.UUID) error

+ func (q *Queries) ListAllArticles(ctx context.Context, arg ListAllArticlesParams) ([]ListAllArticlesRow, error)

+ func (q *Queries) ListAllCategories(ctx context.Context) ([]Category, error)

+ func (q *Queries) ListArticles(ctx context.Context, arg ListArticlesParams) ([]ListArticlesRow, error)

+ func (q *Queries) ListArticlesByCategoryID(ctx context.Context, arg ListArticlesByCategoryIDParams) ([]ListArticlesByCategoryIDRow, error)

+ func (q *Queries) ListCategoriesCountArticles(ctx context.Context, arg ListCategoriesCountArticlesParams) ([]ListCategoriesCountArticlesRow, error)

+ func (q *Queries) ListCommentsByArticleID(ctx context.Context, articleID uuid.UUID) ([]ListCommentsByArticleIDRow, error)

+ func (q *Queries) ListInitSysMenus(ctx context.Context, roleID int64) ([]ListInitSysMenusRow, error)

+ func (q *Queries) SetArticleDefaultCategoryIdByCategoryId(ctx context.Context, categoryID int64) error

+ func (q *Queries) UpdateAdmin(ctx context.Context, arg UpdateAdminParams) (Admin, error)

+ func (q *Queries) UpdateArticle(ctx context.Context, arg UpdateArticleParams) (Article, error)

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

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

+ func (q *Queries) UpdateVerifyEmail(ctx context.Context, arg UpdateVerifyEmailParams) (VerifyEmail, error)

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

+ type Role struct

+ CreatedAt time.Time

+ Description string

+ ID int64

+ IsSystem bool

+ RoleName string

+ type RolePermission struct

+ CreatedAt time.Time

+ CreatedBy int64

+ ID int64

+ MenuID int64

+ RoleID int64

+ type SQLStore struct

+ func (store *SQLStore) CreateUserTx(ctx context.Context, arg CreateUserTxParams) (CreateUserTxResult, error)

+ func (store *SQLStore) DeleteArticleTx(ctx context.Context, arg DeleteArticleTxParams) error

+ func (store *SQLStore) DeleteCategoryTx(ctx context.Context, ID int64) error

+ func (store *SQLStore) UpdateArticleTx(ctx context.Context, arg UpdateArticleTxParams) (UpdateArticleTxResult, error)

+ func (store *SQLStore) VerifyEmailTx(ctx context.Context, arg VerifyEmailTxParams) (VerifyEmailTxResult, error)

+ type Session struct

+ ClientIp string

+ CreatedAt time.Time

+ ExpiresAt time.Time

+ ID uuid.UUID

+ IsBlocked bool

+ RefreshToken string

+ UserAgent string

+ UserID uuid.UUID

+ type Store interface

+ CreateUserTx func(ctx context.Context, arg CreateUserTxParams) (CreateUserTxResult, error)

+ DeleteArticleTx func(ctx context.Context, arg DeleteArticleTxParams) error

+ DeleteCategoryTx func(ctx context.Context, ID int64) error

+ UpdateArticleTx func(ctx context.Context, arg UpdateArticleTxParams) (UpdateArticleTxResult, error)

+ VerifyEmailTx func(ctx context.Context, arg VerifyEmailTxParams) (VerifyEmailTxResult, error)

+ func NewStore(connPool *pgxpool.Pool) Store

+ type SysMenu struct

+ CreatedAt time.Time

+ ID int64

+ Icon string

+ IsActive bool

+ Name string

+ ParentID pgtype.Int8

+ Path string

+ Sort int32

+ Type int32

+ UpdatedAt time.Time

+ type Tag struct

+ ArticleID uuid.UUID

+ CreatedAt time.Time

+ ID int64

+ Name string

+ type UpdateAdminParams struct

+ HashedPassword pgtype.Text

+ ID int64

+ IsActive pgtype.Bool

+ RoleID pgtype.Int8

+ UpdatedAt pgtype.Timestamptz

+ Username pgtype.Text

+ type UpdateArticleParams struct

+ CategoryID pgtype.Int8

+ Content pgtype.Text

+ ID uuid.UUID

+ IsPublish pgtype.Bool

+ Summary pgtype.Text

+ Title pgtype.Text

+ UpdatedAt pgtype.Timestamptz

+ type UpdateArticleTxParams struct

+ AfterUpdate func(article Article) error

+ type UpdateArticleTxResult struct

+ Article Article

+ type UpdateCategoryParams struct

+ ID int64

+ Name string

+ type UpdateUserParams struct

+ Email pgtype.Text

+ FullName pgtype.Text

+ HashedPassword pgtype.Text

+ ID uuid.UUID

+ IsEmailVerified pgtype.Bool

+ type UpdateVerifyEmailParams struct

+ ID int64

+ SecretCode string

+ type User struct

+ About string

+ CreatedAt time.Time

+ DeletedAt time.Time

+ Email string

+ FullName string

+ HashedPassword string

+ ID uuid.UUID

+ IsEmailVerified bool

+ Role string

+ UpdatedAt time.Time

+ Username string

+ type VerifyEmail struct

+ CreatedAt time.Time

+ Email string

+ ExpiredAt time.Time

+ ID int64

+ IsUsed bool

+ SecretCode string

+ UserID uuid.UUID

+ type VerifyEmailTxParams struct

+ EmailId int64

+ SecretCode string

+ type VerifyEmailTxResult struct

+ User User

+ VerifyEmail VerifyEmail

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL