sqlc

type Category struct {
	ID          int32       `db:"id" json:"id"`
	Name        string      `db:"name" json:"name"`
	Description pgtype.Text `db:"description" json:"description"`
	Color       pgtype.Text `db:"color" json:"color"`
	CreatedAt   time.Time   `db:"created_at" json:"created_at"`
	UpdatedAt   time.Time   `db:"updated_at" json:"updated_at"`
}

type Comment struct {
	ID        int32     `db:"id" json:"id"`
	Content   string    `db:"content" json:"content"`
	PostID    int32     `db:"post_id" json:"post_id"`
	UserID    int32     `db:"user_id" json:"user_id"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`
	UpdatedAt time.Time `db:"updated_at" json:"updated_at"`
}

type CreateCommentParams struct {
	Content string `db:"content" json:"content"`
	PostID  int32  `db:"post_id" json:"post_id"`
	UserID  int32  `db:"user_id" json:"user_id"`
}

type CreatePostParams struct {
	Title     string      `db:"title" json:"title"`
	Content   string      `db:"content" json:"content"`
	UserID    int32       `db:"user_id" json:"user_id"`
	Published pgtype.Bool `db:"published" json:"published"`
}

type CreateUserParams struct {
	Name  string      `db:"name" json:"name"`
	Email string      `db:"email" json:"email"`
	Age   pgtype.Int4 `db:"age" json:"age"`
}

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 GetCommentByIDRow struct {
	ID        int32     `db:"id" json:"id"`
	Content   string    `db:"content" json:"content"`
	PostID    int32     `db:"post_id" json:"post_id"`
	UserID    int32     `db:"user_id" json:"user_id"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`
	UpdatedAt time.Time `db:"updated_at" json:"updated_at"`
	UserName  string    `db:"user_name" json:"user_name"`
	UserEmail string    `db:"user_email" json:"user_email"`
}

type GetCommentsByPostIDRow struct {
	ID        int32     `db:"id" json:"id"`
	Content   string    `db:"content" json:"content"`
	PostID    int32     `db:"post_id" json:"post_id"`
	UserID    int32     `db:"user_id" json:"user_id"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`
	UpdatedAt time.Time `db:"updated_at" json:"updated_at"`
	UserName  string    `db:"user_name" json:"user_name"`
	UserEmail string    `db:"user_email" json:"user_email"`
}

type GetPostByIDRow struct {
	ID        int32       `db:"id" json:"id"`
	Title     string      `db:"title" json:"title"`
	Content   string      `db:"content" json:"content"`
	UserID    int32       `db:"user_id" json:"user_id"`
	Published pgtype.Bool `db:"published" json:"published"`
	CreatedAt time.Time   `db:"created_at" json:"created_at"`
	UpdatedAt time.Time   `db:"updated_at" json:"updated_at"`
	UserName  string      `db:"user_name" json:"user_name"`
	UserEmail string      `db:"user_email" json:"user_email"`
}

type GetPostsRow struct {
	ID        int32       `db:"id" json:"id"`
	Title     string      `db:"title" json:"title"`
	Content   string      `db:"content" json:"content"`
	UserID    int32       `db:"user_id" json:"user_id"`
	Published pgtype.Bool `db:"published" json:"published"`
	CreatedAt time.Time   `db:"created_at" json:"created_at"`
	UpdatedAt time.Time   `db:"updated_at" json:"updated_at"`
	UserName  string      `db:"user_name" json:"user_name"`
	UserEmail string      `db:"user_email" json:"user_email"`
}

type GetPublishedPostsRow struct {
	ID        int32       `db:"id" json:"id"`
	Title     string      `db:"title" json:"title"`
	Content   string      `db:"content" json:"content"`
	UserID    int32       `db:"user_id" json:"user_id"`
	Published pgtype.Bool `db:"published" json:"published"`
	CreatedAt time.Time   `db:"created_at" json:"created_at"`
	UpdatedAt time.Time   `db:"updated_at" json:"updated_at"`
	UserName  string      `db:"user_name" json:"user_name"`
	UserEmail string      `db:"user_email" json:"user_email"`
}

type Post struct {
	ID        int32       `db:"id" json:"id"`
	Title     string      `db:"title" json:"title"`
	Content   string      `db:"content" json:"content"`
	UserID    int32       `db:"user_id" json:"user_id"`
	Published pgtype.Bool `db:"published" json:"published"`
	CreatedAt time.Time   `db:"created_at" json:"created_at"`
	UpdatedAt time.Time   `db:"updated_at" json:"updated_at"`
}

type PostCategory struct {
	PostID     int32 `db:"post_id" json:"post_id"`
	CategoryID int32 `db:"category_id" json:"category_id"`
}

type PostTag struct {
	PostID int32 `db:"post_id" json:"post_id"`
	TagID  int32 `db:"tag_id" json:"tag_id"`
}

type Querier interface {
	CountCommentsByPost(ctx context.Context, postID int32) (int64, error)
	CountPosts(ctx context.Context) (int64, error)
	CountPostsByUser(ctx context.Context, userID int32) (int64, error)
	CountUsers(ctx context.Context) (int64, error)
	CreateComment(ctx context.Context, arg CreateCommentParams) (*Comment, error)
	CreatePost(ctx context.Context, arg CreatePostParams) (*Post, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (*User, error)
	DeleteComment(ctx context.Context, id int32) error
	DeletePost(ctx context.Context, id int32) error
	DeleteUser(ctx context.Context, id int32) error
	GetCommentByID(ctx context.Context, id int32) (*GetCommentByIDRow, error)
	GetCommentsByPostID(ctx context.Context, postID int32) ([]*GetCommentsByPostIDRow, error)
	GetPostByID(ctx context.Context, id int32) (*GetPostByIDRow, error)
	GetPosts(ctx context.Context) ([]*GetPostsRow, error)
	GetPostsByUserID(ctx context.Context, userID int32) ([]*Post, error)
	GetPublishedPosts(ctx context.Context) ([]*GetPublishedPostsRow, error)
	GetUserByEmail(ctx context.Context, email string) (*User, error)
	GetUserByID(ctx context.Context, id int32) (*User, error)
	GetUsers(ctx context.Context) ([]*User, error)
	UpdateComment(ctx context.Context, arg UpdateCommentParams) (*Comment, error)
	UpdatePost(ctx context.Context, arg UpdatePostParams) (*Post, error)
	UpdatePostPublished(ctx context.Context, arg UpdatePostPublishedParams) (*Post, error)
	UpdateUser(ctx context.Context, arg UpdateUserParams) (*User, error)
}

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

type Tag struct {
	ID        int32     `db:"id" json:"id"`
	Name      string    `db:"name" json:"name"`
	Slug      string    `db:"slug" json:"slug"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`
	UpdatedAt time.Time `db:"updated_at" json:"updated_at"`
}

type UpdateCommentParams struct {
	ID      int32  `db:"id" json:"id"`
	Content string `db:"content" json:"content"`
}

type UpdatePostParams struct {
	ID        int32       `db:"id" json:"id"`
	Title     string      `db:"title" json:"title"`
	Content   string      `db:"content" json:"content"`
	UserID    int32       `db:"user_id" json:"user_id"`
	Published pgtype.Bool `db:"published" json:"published"`
}

type UpdatePostPublishedParams struct {
	ID        int32       `db:"id" json:"id"`
	Published pgtype.Bool `db:"published" json:"published"`
}

type UpdateUserParams struct {
	ID    int32       `db:"id" json:"id"`
	Name  string      `db:"name" json:"name"`
	Email string      `db:"email" json:"email"`
	Age   pgtype.Int4 `db:"age" json:"age"`
}

type User struct {
	ID        int32       `db:"id" json:"id"`
	Name      string      `db:"name" json:"name"`
	Email     string      `db:"email" json:"email"`
	Age       pgtype.Int4 `db:"age" json:"age"`
	CreatedAt time.Time   `db:"created_at" json:"created_at"`
	UpdatedAt time.Time   `db:"updated_at" json:"updated_at"`
}

type UserProfile struct {
	UserID    int32       `db:"user_id" json:"user_id"`
	Bio       pgtype.Text `db:"bio" json:"bio"`
	Avatar    pgtype.Text `db:"avatar" json:"avatar"`
	Website   pgtype.Text `db:"website" json:"website"`
	Location  pgtype.Text `db:"location" json:"location"`
	BirthDate pgtype.Date `db:"birth_date" json:"birth_date"`
	CreatedAt time.Time   `db:"created_at" json:"created_at"`
	UpdatedAt time.Time   `db:"updated_at" json:"updated_at"`
}