mysqlblog

type AddTagToPostParams struct {
	PostId int32
	TagId  int32
}

type Comments struct {
	Id        int32          `json:"id"`
	PostId    int32          `json:"post_id"`
	UserId    int32          `json:"user_id"`
	Content   string         `json:"content"`
	CreatedAt sql.NullString `json:"created_at"`
}

type CreateCommentParams struct {
	PostId  int32
	UserId  int32
	Content string
}

type CreatePostParams struct {
	UserId  int32
	Title   string
	Content sql.NullString
	Status  sql.NullString
}

type CreateTagParams struct {
	Name        string
	Description sql.NullString
}

type CreateUserParams struct {
	Email        string
	Username     string
	PasswordHash string
	Status       sql.NullString
}

type DBTX interface {
	ExecContext(ctx context.Context, query string, args ...any) (sql.Result, error)
	QueryContext(ctx context.Context, query string, args ...any) (*sql.Rows, error)
	QueryRowContext(ctx context.Context, query string, args ...any) *sql.Row
}

type GetCommentRow struct {
	Id        int32
	PostId    int32
	UserId    int32
	Content   string
	CreatedAt sql.NullString
}

type GetPostRow struct {
	Id        int32
	UserId    int32
	Title     string
	Content   sql.NullString
	Status    sql.NullString
	ViewCount *int32
	CreatedAt sql.NullString
}

type GetPostsForTagParams struct {
	TagId int32
	Limit any
}

type GetPostsForTagRow struct {
	Id        int32
	UserId    int32
	Title     string
	Content   sql.NullString
	Status    sql.NullString
	ViewCount *int32
	CreatedAt sql.NullString
}

type GetTagByNameRow struct {
	Id          int32
	Name        string
	Description sql.NullString
	CreatedAt   sql.NullString
}

type GetTagRow struct {
	Id          int32
	Name        string
	Description sql.NullString
	CreatedAt   sql.NullString
}

type GetTagsForPostRow struct {
	Id          int32
	Name        string
	Description sql.NullString
	CreatedAt   sql.NullString
}

type GetUserByEmailRow struct {
	Id           int32
	Email        string
	Username     string
	PasswordHash string
	Status       sql.NullString
	CreatedAt    sql.NullString
}

type GetUserRow struct {
	Id           int32
	Email        string
	Username     string
	PasswordHash string
	Status       sql.NullString
	CreatedAt    sql.NullString
}

type ListCommentsByPostParams struct {
	PostId int32
	Limit  any
}

type ListCommentsByPostRow struct {
	Id        int32
	PostId    int32
	UserId    int32
	Content   string
	CreatedAt sql.NullString
}

type ListCommentsByUserParams struct {
	UserId int32
	Limit  any
}

type ListCommentsByUserRow struct {
	Id        int32
	PostId    int32
	UserId    int32
	Content   string
	CreatedAt sql.NullString
}

type ListPostsByUserParams struct {
	UserId int32
	Status sql.NullString
	Limit  any
}

type ListPostsByUserRow struct {
	Id        int32
	UserId    int32
	Title     string
	Content   sql.NullString
	Status    sql.NullString
	ViewCount *int32
	CreatedAt sql.NullString
}

type ListPostsParams struct {
	Status sql.NullString
	Limit  any
}

type ListPostsRow struct {
	Id        int32
	UserId    int32
	Title     string
	Content   sql.NullString
	Status    sql.NullString
	ViewCount *int32
	CreatedAt sql.NullString
}

type ListTagsRow struct {
	Id          int32
	Name        string
	Description sql.NullString
	CreatedAt   sql.NullString
}

type ListUsersParams struct {
	Status sql.NullString
	Limit  any
}

type ListUsersRow struct {
	Id           int32
	Email        string
	Username     string
	PasswordHash string
	Status       sql.NullString
	CreatedAt    sql.NullString
}

type Posts struct {
	Id        int32          `json:"id"`
	UserId    int32          `json:"user_id"`
	Title     string         `json:"title"`
	Content   sql.NullString `json:"content"`
	Status    sql.NullString `json:"status"`
	ViewCount *int32         `json:"view_count"`
	CreatedAt sql.NullString `json:"created_at"`
}

type Querier interface {
	AddTagToPost(ctx context.Context, arg AddTagToPostParams) error
	CountCommentsByPost(ctx context.Context, postId int32) (int64, error)
	CreateComment(ctx context.Context, arg CreateCommentParams) (QueryResult, error)
	CreatePost(ctx context.Context, arg CreatePostParams) (QueryResult, error)
	CreateTag(ctx context.Context, arg CreateTagParams) (QueryResult, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (QueryResult, error)
	DeleteComment(ctx context.Context, id int32) error
	DeletePost(ctx context.Context, id int32) error
	DeleteTag(ctx context.Context, id int32) error
	GetComment(ctx context.Context, id int32) (GetCommentRow, error)
	GetPost(ctx context.Context, id int32) (GetPostRow, error)
	GetPostsForTag(ctx context.Context, arg GetPostsForTagParams) ([]GetPostsForTagRow, error)
	GetTag(ctx context.Context, id int32) (GetTagRow, error)
	GetTagByName(ctx context.Context, name string) (GetTagByNameRow, error)
	GetTagsForPost(ctx context.Context, postId int32) ([]GetTagsForPostRow, error)
	GetUser(ctx context.Context, id int32) (GetUserRow, error)
	GetUserByEmail(ctx context.Context, email string) (GetUserByEmailRow, error)
	IncrementPostViews(ctx context.Context, id int32) error
	ListCommentsByPost(ctx context.Context, arg ListCommentsByPostParams) ([]ListCommentsByPostRow, error)
	ListCommentsByUser(ctx context.Context, arg ListCommentsByUserParams) ([]ListCommentsByUserRow, error)
	ListPosts(ctx context.Context, arg ListPostsParams) ([]ListPostsRow, error)
	ListPostsByUser(ctx context.Context, arg ListPostsByUserParams) ([]ListPostsByUserRow, error)
	ListTags(ctx context.Context) ([]ListTagsRow, error)
	ListUsers(ctx context.Context, arg ListUsersParams) ([]ListUsersRow, error)
	RemoveTagFromPost(ctx context.Context, arg RemoveTagFromPostParams) error
	UpdatePost(ctx context.Context, arg UpdatePostParams) error
	WithTx(tx DBTX) *Queries
}

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

type QueryResult struct {
	LastInsertID int64
	RowsAffected int64
}

type RemoveTagFromPostParams struct {
	PostId int32
	TagId  int32
}

type Tags struct {
	Id          int32          `json:"id"`
	Name        string         `json:"name"`
	Description sql.NullString `json:"description"`
	CreatedAt   sql.NullString `json:"created_at"`
}

type UpdatePostParams struct {
	Title   string
	Content sql.NullString
	Status  sql.NullString
	Id      int32
}

type Users struct {
	Id           int32          `json:"id"`
	Email        string         `json:"email"`
	Username     string         `json:"username"`
	PasswordHash string         `json:"password_hash"`
	Status       sql.NullString `json:"status"`
	CreatedAt    sql.NullString `json:"created_at"`
}