db

type Admin struct {
	// 主键ID
	ID int64 `json:"id"`
	// 管理员名称
	Username string `json:"username"`
	// 密码
	HashedPassword string `json:"hashed_password"`
	// 是否激活，默认：否
	IsActive bool `json:"is_active"`
	// 角色ID，默认：2
	RoleID int64 `json:"role_id"`
	// 创建时间
	CreatedAt time.Time `json:"created_at"`
	// 更新时间
	UpdatedAt time.Time `json:"updated_at"`
}

type Article struct {
	ID uuid.UUID `json:"id"`
	// 标题
	Title string `json:"title"`
	// 摘要
	Summary string `json:"summary"`
	// 内容
	Content string `json:"content"`
	// 浏览量
	Views int32 `json:"views"`
	// 点赞数
	Likes int32 `json:"likes"`
	// 是否发布
	IsPublish bool `json:"is_publish"`
	// 拥有者
	Owner      uuid.UUID `json:"owner"`
	CreatedAt  time.Time `json:"created_at"`
	UpdatedAt  time.Time `json:"updated_at"`
	DeletedAt  time.Time `json:"deleted_at"`
	CategoryID int64     `json:"category_id"`
	// 短标识
	Slug pgtype.Text `json:"slug"`
	// 封面
	Cover string `json:"cover"`
	// 最后更新时间
	LastUpdated time.Time `json:"last_updated"`
	// 检查过时
	CheckOutdated bool `json:"check_outdated"`
	// 阅读时间
	ReadTime string `json:"read_time"`
}

type Category struct {
	ID int64 `json:"id"`
	// 分类名称
	Name string `json:"name"`
	// 是否为系统分类
	IsSystem  bool      `json:"is_system"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type Comment struct {
	ID int64 `json:"id"`
	// 评论内容
	Content string `json:"content"`
	// 文章ID
	ArticleID uuid.UUID `json:"article_id"`
	// 父评论ID
	ParentID int64 `json:"parent_id"`
	Likes    int32 `json:"likes"`
	// 评论人ID
	FromUserID uuid.UUID `json:"from_user_id"`
	// 被评论人ID
	ToUserID  uuid.UUID `json:"to_user_id"`
	CreatedAt time.Time `json:"created_at"`
	DeletedAt time.Time `json:"deleted_at"`
}

type CountArticlesParams struct {
	IsPublish  pgtype.Bool `json:"is_publish"`
	CategoryID pgtype.Int8 `json:"category_id"`
}

type CountSearchArticlesParams struct {
	Keyword   string      `json:"keyword"`
	IsPublish pgtype.Bool `json:"is_publish"`
}

type CreateAdminParams struct {
	Username       string `json:"username"`
	HashedPassword string `json:"hashed_password"`
	IsActive       bool   `json:"is_active"`
	RoleID         int64  `json:"role_id"`
}

type CreateArticleParams struct {
	ID         uuid.UUID `json:"id"`
	Title      string    `json:"title"`
	Summary    string    `json:"summary"`
	Content    string    `json:"content"`
	IsPublish  bool      `json:"is_publish"`
	Owner      uuid.UUID `json:"owner"`
	CategoryID int64     `json:"category_id"`
	Cover      string    `json:"cover"`
}

type CreateCategoryTxParams struct {
	Name        string
	AfterCreate func() error
}

type CreateCategoryTxResult struct {
	Category Category
}

type CreateCommentParams struct {
	Content    string    `json:"content"`
	ArticleID  uuid.UUID `json:"article_id"`
	ParentID   int64     `json:"parent_id"`
	FromUserID uuid.UUID `json:"from_user_id"`
	ToUserID   uuid.UUID `json:"to_user_id"`
}

type CreateSessionParams struct {
	ID           uuid.UUID `json:"id"`
	UserID       uuid.UUID `json:"user_id"`
	RefreshToken string    `json:"refresh_token"`
	UserAgent    string    `json:"user_agent"`
	ClientIp     string    `json:"client_ip"`
	IsBlocked    bool      `json:"is_blocked"`
	ExpiresAt    time.Time `json:"expires_at"`
}

type CreateUserParams struct {
	ID             uuid.UUID `json:"id"`
	Username       string    `json:"username"`
	HashedPassword string    `json:"hashed_password"`
	FullName       string    `json:"full_name"`
	Email          string    `json:"email"`
}

type CreateUserTxParams struct {
	CreateUserParams
	AfterCreate func(user User) error
}

type CreateUserTxResult struct {
	User User
}

type CreateVerifyEmailParams struct {
	UserID     uuid.UUID `json:"user_id"`
	Email      string    `json:"email"`
	SecretCode string    `json:"secret_code"`
}

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 DeleteArticleTxParams struct {
	ID          uuid.UUID
	AfterUpdate func(articleID uuid.UUID) error
}

type DeleteCategoryTxParams struct {
	ID          int64
	AfterDelete func() error
}

type GetArticleBySlugRow struct {
	ID            uuid.UUID   `json:"id"`
	Title         string      `json:"title"`
	Summary       string      `json:"summary"`
	Content       string      `json:"content"`
	IsPublish     bool        `json:"is_publish"`
	Views         int32       `json:"views"`
	Likes         int32       `json:"likes"`
	Cover         string      `json:"cover"`
	Slug          pgtype.Text `json:"slug"`
	CheckOutdated bool        `json:"check_outdated"`
	LastUpdated   time.Time   `json:"last_updated"`
	ReadTime      string      `json:"read_time"`
	Owner         uuid.UUID   `json:"owner"`
	CreatedAt     time.Time   `json:"created_at"`
	UpdatedAt     time.Time   `json:"updated_at"`
	DeletedAt     time.Time   `json:"deleted_at"`
	CategoryID    int64       `json:"category_id"`
	CategoryName  pgtype.Text `json:"category_name"`
}

type GetArticleForUpdateRow struct {
	ID         uuid.UUID `json:"id"`
	Title      string    `json:"title"`
	Summary    string    `json:"summary"`
	Content    string    `json:"content"`
	Views      int32     `json:"views"`
	Likes      int32     `json:"likes"`
	IsPublish  bool      `json:"is_publish"`
	Owner      uuid.UUID `json:"owner"`
	CreatedAt  time.Time `json:"created_at"`
	UpdatedAt  time.Time `json:"updated_at"`
	DeletedAt  time.Time `json:"deleted_at"`
	CategoryID int64     `json:"category_id"`
}

type GetArticleRow struct {
	ID            uuid.UUID   `json:"id"`
	Title         string      `json:"title"`
	Summary       string      `json:"summary"`
	Content       string      `json:"content"`
	IsPublish     bool        `json:"is_publish"`
	Views         int32       `json:"views"`
	Likes         int32       `json:"likes"`
	Cover         string      `json:"cover"`
	Slug          pgtype.Text `json:"slug"`
	CheckOutdated bool        `json:"check_outdated"`
	LastUpdated   time.Time   `json:"last_updated"`
	ReadTime      string      `json:"read_time"`
	Owner         uuid.UUID   `json:"owner"`
	CreatedAt     time.Time   `json:"created_at"`
	UpdatedAt     time.Time   `json:"updated_at"`
	DeletedAt     time.Time   `json:"deleted_at"`
	CategoryID    int64       `json:"category_id"`
	CategoryName  pgtype.Text `json:"category_name"`
}

type ListAllArticlesParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type ListAllArticlesRow struct {
	ID            uuid.UUID   `json:"id"`
	Title         string      `json:"title"`
	Summary       string      `json:"summary"`
	Views         int32       `json:"views"`
	Likes         int32       `json:"likes"`
	IsPublish     bool        `json:"is_publish"`
	Cover         string      `json:"cover"`
	Slug          pgtype.Text `json:"slug"`
	CheckOutdated bool        `json:"check_outdated"`
	LastUpdated   time.Time   `json:"last_updated"`
	ReadTime      string      `json:"read_time"`
	Owner         uuid.UUID   `json:"owner"`
	CreatedAt     time.Time   `json:"created_at"`
	UpdatedAt     time.Time   `json:"updated_at"`
	DeletedAt     time.Time   `json:"deleted_at"`
	CategoryName  pgtype.Text `json:"category_name"`
}

type ListArticlesByCategoryIDParams struct {
	CategoryID int64 `json:"category_id"`
	Limit      int32 `json:"limit"`
	Offset     int32 `json:"offset"`
}

type ListArticlesByCategoryIDRow struct {
	ID         uuid.UUID   `json:"id"`
	Title      string      `json:"title"`
	Summary    string      `json:"summary"`
	Views      int32       `json:"views"`
	Likes      int32       `json:"likes"`
	IsPublish  bool        `json:"is_publish"`
	Owner      uuid.UUID   `json:"owner"`
	CategoryID int64       `json:"category_id"`
	CreatedAt  time.Time   `json:"created_at"`
	UpdatedAt  time.Time   `json:"updated_at"`
	DeletedAt  time.Time   `json:"deleted_at"`
	Name       pgtype.Text `json:"name"`
	Username   pgtype.Text `json:"username"`
}

type ListArticlesParams struct {
	Limit      int32       `json:"limit"`
	Offset     int32       `json:"offset"`
	IsPublish  pgtype.Bool `json:"is_publish"`
	CategoryID pgtype.Int8 `json:"category_id"`
}

type ListArticlesRow struct {
	ID            uuid.UUID   `json:"id"`
	Title         string      `json:"title"`
	Summary       string      `json:"summary"`
	Views         int32       `json:"views"`
	Likes         int32       `json:"likes"`
	IsPublish     bool        `json:"is_publish"`
	Cover         string      `json:"cover"`
	Slug          pgtype.Text `json:"slug"`
	CheckOutdated bool        `json:"check_outdated"`
	LastUpdated   time.Time   `json:"last_updated"`
	ReadTime      string      `json:"read_time"`
	Owner         uuid.UUID   `json:"owner"`
	CreatedAt     time.Time   `json:"created_at"`
	UpdatedAt     time.Time   `json:"updated_at"`
	DeletedAt     time.Time   `json:"deleted_at"`
	CategoryName  pgtype.Text `json:"category_name"`
	Username      pgtype.Text `json:"username"`
}

type ListCategoriesCountArticlesRow struct {
	ID           int64     `json:"id"`
	Name         string    `json:"name"`
	IsSystem     bool      `json:"is_system"`
	ArticleCount int64     `json:"article_count"`
	CreatedAt    time.Time `json:"created_at"`
	UpdatedAt    time.Time `json:"updated_at"`
}

type ListCommentsByArticleIDRow struct {
	ID           int64       `json:"id"`
	Content      string      `json:"content"`
	ArticleID    uuid.UUID   `json:"article_id"`
	ParentID     int64       `json:"parent_id"`
	Likes        int32       `json:"likes"`
	FromUserID   uuid.UUID   `json:"from_user_id"`
	ToUserID     uuid.UUID   `json:"to_user_id"`
	CreatedAt    time.Time   `json:"created_at"`
	DeletedAt    time.Time   `json:"deleted_at"`
	FromUserName pgtype.Text `json:"from_user_name"`
	ToUserName   pgtype.Text `json:"to_user_name"`
}

type ListInitSysMenusRow struct {
	ID       int64       `json:"id"`
	Name     string      `json:"name"`
	Path     string      `json:"path"`
	Icon     string      `json:"icon"`
	Type     int32       `json:"type"`
	ParentID pgtype.Int8 `json:"parent_id"`
}

type Querier interface {
	AddCommentLikes(ctx context.Context, id int64) (Comment, error)
	CountAllArticles(ctx context.Context) (int64, error)
	CountArticles(ctx context.Context, arg CountArticlesParams) (int64, error)
	CountArticlesByCategoryID(ctx context.Context, categoryID int64) (int64, error)
	CountCategories(ctx context.Context) (int64, error)
	CountSearchArticles(ctx context.Context, arg CountSearchArticlesParams) (int64, error)
	CreateAdmin(ctx context.Context, arg CreateAdminParams) (Admin, error)
	CreateArticle(ctx context.Context, arg CreateArticleParams) (Article, error)
	CreateCategory(ctx context.Context, name string) (Category, error)
	CreateComment(ctx context.Context, arg CreateCommentParams) (Comment, error)
	CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
	CreateVerifyEmail(ctx context.Context, arg CreateVerifyEmailParams) (VerifyEmail, error)
	DeleteArticle(ctx context.Context, id uuid.UUID) error
	DeleteCategory(ctx context.Context, id int64) error
	DeleteChildComments(ctx context.Context, parentID int64) error
	DeleteComment(ctx context.Context, id int64) error
	DeleteCommentsByArticleID(ctx context.Context, articleID uuid.UUID) error
	GetAdmin(ctx context.Context, username string) (Admin, error)
	GetAdminById(ctx context.Context, id int64) (Admin, error)
	GetArticle(ctx context.Context, id uuid.UUID) (GetArticleRow, error)
	GetArticleBySlug(ctx context.Context, slug pgtype.Text) (GetArticleBySlugRow, error)
	GetArticleForUpdate(ctx context.Context, id uuid.UUID) (GetArticleForUpdateRow, error)
	GetCategory(ctx context.Context, id int64) (Category, error)
	GetCategoryByName(ctx context.Context, name string) (Category, error)
	GetComment(ctx context.Context, id int64) (Comment, error)
	GetSession(ctx context.Context, id uuid.UUID) (Session, error)
	GetUser(ctx context.Context, id uuid.UUID) (User, error)
	GetUserByUsername(ctx context.Context, username string) (User, error)
	IncrementArticleLikes(ctx context.Context, id uuid.UUID) error
	IncrementArticleViews(ctx context.Context, id uuid.UUID) error
	ListAllArticles(ctx context.Context, arg ListAllArticlesParams) ([]ListAllArticlesRow, error)
	ListAllCategories(ctx context.Context) ([]Category, error)
	ListArticles(ctx context.Context, arg ListArticlesParams) ([]ListArticlesRow, error)
	ListArticlesByCategoryID(ctx context.Context, arg ListArticlesByCategoryIDParams) ([]ListArticlesByCategoryIDRow, error)
	ListCategoriesCountArticles(ctx context.Context) ([]ListCategoriesCountArticlesRow, error)
	ListCommentsByArticleID(ctx context.Context, articleID uuid.UUID) ([]ListCommentsByArticleIDRow, error)
	ListInitSysMenus(ctx context.Context, roleID int64) ([]ListInitSysMenusRow, error)
	SearchArticles(ctx context.Context, arg SearchArticlesParams) ([]SearchArticlesRow, error)
	SetArticleDefaultCategoryIdByCategoryId(ctx context.Context, categoryID int64) error
	UpdateAdmin(ctx context.Context, arg UpdateAdminParams) (Admin, error)
	UpdateArticle(ctx context.Context, arg UpdateArticleParams) (Article, error)
	UpdateCategory(ctx context.Context, arg UpdateCategoryParams) (Category, error)
	UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)
	UpdateVerifyEmail(ctx context.Context, arg UpdateVerifyEmailParams) (VerifyEmail, error)
}

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

type Role struct {
	// 主键ID
	ID int64 `json:"id"`
	// 角色名称
	RoleName string `json:"role_name"`
	// 角色描述
	Description string `json:"description"`
	// 是否为系统角色
	IsSystem bool `json:"is_system"`
	// 创建时间
	CreatedAt time.Time `json:"created_at"`
}

type RolePermission struct {
	// 主键ID
	ID int64 `json:"id"`
	// 角色ID
	RoleID int64 `json:"role_id"`
	// 菜单ID
	MenuID int64 `json:"menu_id"`
	// 创建人ID
	CreatedBy int64 `json:"created_by"`
	// 创建时间
	CreatedAt time.Time `json:"created_at"`
}

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

type SearchArticlesParams struct {
	Limit     int32       `json:"limit"`
	Offset    int32       `json:"offset"`
	Keyword   string      `json:"keyword"`
	IsPublish pgtype.Bool `json:"is_publish"`
}

type SearchArticlesRow struct {
	ID            uuid.UUID   `json:"id"`
	Title         string      `json:"title"`
	Summary       string      `json:"summary"`
	Views         int32       `json:"views"`
	Likes         int32       `json:"likes"`
	IsPublish     bool        `json:"is_publish"`
	Cover         string      `json:"cover"`
	Slug          pgtype.Text `json:"slug"`
	CheckOutdated bool        `json:"check_outdated"`
	LastUpdated   time.Time   `json:"last_updated"`
	ReadTime      string      `json:"read_time"`
	Owner         uuid.UUID   `json:"owner"`
	CreatedAt     time.Time   `json:"created_at"`
	UpdatedAt     time.Time   `json:"updated_at"`
	DeletedAt     time.Time   `json:"deleted_at"`
	CategoryName  pgtype.Text `json:"category_name"`
	Username      pgtype.Text `json:"username"`
	Score         interface{} `json:"score"`
}

type Session struct {
	ID           uuid.UUID `json:"id"`
	UserID       uuid.UUID `json:"user_id"`
	RefreshToken string    `json:"refresh_token"`
	UserAgent    string    `json:"user_agent"`
	ClientIp     string    `json:"client_ip"`
	IsBlocked    bool      `json:"is_blocked"`
	ExpiresAt    time.Time `json:"expires_at"`
	CreatedAt    time.Time `json:"created_at"`
}

type Store interface {
	Querier
	CreateUserTx(ctx context.Context, arg CreateUserTxParams) (CreateUserTxResult, error)
	VerifyEmailTx(ctx context.Context, arg VerifyEmailTxParams) (VerifyEmailTxResult, error)
	UpdateArticleTx(ctx context.Context, arg UpdateArticleTxParams) (UpdateArticleTxResult, error)
	DeleteArticleTx(ctx context.Context, arg DeleteArticleTxParams) error
	DeleteCategoryTx(ctx context.Context, arg DeleteCategoryTxParams) error
	UpdateCategoryTx(ctx context.Context, arg UpdateCategoryTxParams) (UpdateCategoryTxResult, error)
	CreateCategoryTx(ctx context.Context, arg CreateCategoryTxParams) (CreateCategoryTxResult, error)
}

type SysMenu struct {
	// 主键ID
	ID int64 `json:"id"`
	// 菜单名称
	Name string `json:"name"`
	// 菜单路径
	Path string `json:"path"`
	// 菜单图标
	Icon string `json:"icon"`
	// 是否激活，默认：否
	IsActive bool `json:"is_active"`
	// 1：目录；2：菜单；3：按钮（事件）
	Type int32 `json:"type"`
	// 排序编号
	Sort int32 `json:"sort"`
	// 父菜单ID
	ParentID pgtype.Int8 `json:"parent_id"`
	// 创建时间
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type Tag struct {
	ID int64 `json:"id"`
	// 名称
	Name string `json:"name"`
	// 文章ID
	ArticleID uuid.UUID `json:"article_id"`
	CreatedAt time.Time `json:"created_at"`
}

type UpdateAdminParams struct {
	Username       pgtype.Text        `json:"username"`
	HashedPassword pgtype.Text        `json:"hashed_password"`
	IsActive       pgtype.Bool        `json:"is_active"`
	RoleID         pgtype.Int8        `json:"role_id"`
	UpdatedAt      pgtype.Timestamptz `json:"updated_at"`
	ID             int64              `json:"id"`
}

type UpdateArticleParams struct {
	Title         pgtype.Text        `json:"title"`
	Summary       pgtype.Text        `json:"summary"`
	Content       pgtype.Text        `json:"content"`
	IsPublish     pgtype.Bool        `json:"is_publish"`
	CategoryID    pgtype.Int8        `json:"category_id"`
	Cover         pgtype.Text        `json:"cover"`
	Slug          pgtype.Text        `json:"slug"`
	CheckOutdated pgtype.Bool        `json:"check_outdated"`
	LastUpdated   pgtype.Timestamptz `json:"last_updated"`
	ReadTime      pgtype.Text        `json:"read_time"`
	UpdatedAt     pgtype.Timestamptz `json:"updated_at"`
	ID            uuid.UUID          `json:"id"`
}

type UpdateArticleTxParams struct {
	UpdateArticleParams
	AfterUpdate func(article Article) error
}

type UpdateArticleTxResult struct {
	Article Article
}

type UpdateCategoryParams struct {
	Name string `json:"name"`
	ID   int64  `json:"id"`
}

type UpdateCategoryTxParams struct {
	UpdateCategoryParams
	AfterUpdate func() error
}

type UpdateCategoryTxResult struct {
	Category Category
}

type UpdateUserParams struct {
	HashedPassword  pgtype.Text `json:"hashed_password"`
	FullName        pgtype.Text `json:"full_name"`
	Email           pgtype.Text `json:"email"`
	IsEmailVerified pgtype.Bool `json:"is_email_verified"`
	ID              uuid.UUID   `json:"id"`
}

type UpdateVerifyEmailParams struct {
	ID         int64  `json:"id"`
	SecretCode string `json:"secret_code"`
}

type User struct {
	ID              uuid.UUID `json:"id"`
	Username        string    `json:"username"`
	HashedPassword  string    `json:"hashed_password"`
	FullName        string    `json:"full_name"`
	Email           string    `json:"email"`
	IsEmailVerified bool      `json:"is_email_verified"`
	// 介绍
	About     string    `json:"about"`
	Role      string    `json:"role"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
	DeletedAt time.Time `json:"deleted_at"`
}

type VerifyEmail struct {
	ID         int64     `json:"id"`
	UserID     uuid.UUID `json:"user_id"`
	Email      string    `json:"email"`
	SecretCode string    `json:"secret_code"`
	IsUsed     bool      `json:"is_used"`
	CreatedAt  time.Time `json:"created_at"`
	ExpiredAt  time.Time `json:"expired_at"`
}

type VerifyEmailTxParams struct {
	EmailId    int64
	SecretCode string
}

type VerifyEmailTxResult struct {
	User        User
	VerifyEmail VerifyEmail
}