postgresqldb

type AddTagToPostParams struct {
	PostId  *uuid.UUID
	PostId2 *uuid.UUID
}

type Comments struct {
	Id          uuid.UUID
	PostId      *uuid.UUID
	UserId      *uuid.UUID
	Commentbody pgtype.Text
	Likes       pgtype.Int4
	CreatedAt   pgtype.Timestamptz
}

type CreateCommentParams struct {
	PostId  *uuid.UUID
	PostId2 *uuid.UUID
	PostId3 pgtype.Text
}

type CreateCommentRow struct {
	Id          uuid.UUID
	PostId      *uuid.UUID
	UserId      *uuid.UUID
	Commentbody pgtype.Text
	Likes       pgtype.Int4
	CreatedAt   *time.Time
}

type CreatePostParams struct {
	UserId  *uuid.UUID
	UserId2 pgtype.Text
	UserId3 pgtype.Text
	UserId4 pgtype.Text
	UserId5 pgtype.Bool
	UserId6 *time.Time
}

type CreatePostRow struct {
	Id          uuid.UUID
	UserId      *uuid.UUID
	Title       pgtype.Text
	Postbody    pgtype.Text
	Categories  pgtype.Text
	ViewCount   pgtype.Int4
	Rating      *decimal.Decimal
	IsPublished pgtype.Bool
	PublishedAt *time.Time
	CreatedAt   *time.Time
	UpdatedAt   *time.Time
}

type CreateTagParams struct {
	Tagname  pgtype.Text
	Tagname2 pgtype.Text
}

type CreateTagRow struct {
	Id             uuid.UUID
	Tagname        pgtype.Text
	Tagdescription pgtype.Text
	CreatedAt      *time.Time
}

type CreateUserParams struct {
	Username  pgtype.Text
	Username2 pgtype.Text
	Username3 *[]byte
	Username4 pgtype.Text
}

type CreateUserRow struct {
	Id        uuid.UUID
	Username  pgtype.Text
	Useremail pgtype.Text
	Metadata  *[]byte
	Tags      pgtype.Text
	IsActive  pgtype.Bool
	CreatedAt *time.Time
	UpdatedAt *time.Time
}

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 GetCommentByIdRow struct {
	Id          uuid.UUID
	PostId      *uuid.UUID
	UserId      *uuid.UUID
	Commentbody pgtype.Text
	Likes       pgtype.Int4
	CreatedAt   *time.Time
}

type GetPopularPostsRow struct {
	Id          uuid.UUID
	UserId      *uuid.UUID
	Title       pgtype.Text
	Postbody    pgtype.Text
	Categories  pgtype.Text
	ViewCount   pgtype.Int4
	Rating      *decimal.Decimal
	IsPublished pgtype.Bool
	PublishedAt *time.Time
	CreatedAt   *time.Time
	UpdatedAt   *time.Time
}

type GetPostByIdRow struct {
	Id          uuid.UUID
	UserId      *uuid.UUID
	Title       pgtype.Text
	Postbody    pgtype.Text
	Categories  pgtype.Text
	ViewCount   pgtype.Int4
	Rating      *decimal.Decimal
	IsPublished pgtype.Bool
	PublishedAt *time.Time
	CreatedAt   *time.Time
	UpdatedAt   *time.Time
}

type GetPostsForTagRow struct {
	Id          uuid.UUID
	UserId      *uuid.UUID
	Title       pgtype.Text
	Postbody    pgtype.Text
	Categories  pgtype.Text
	ViewCount   pgtype.Int4
	Rating      *decimal.Decimal
	IsPublished pgtype.Bool
	PublishedAt *time.Time
	CreatedAt   *time.Time
	UpdatedAt   *time.Time
}

type GetTagByIdRow struct {
	Id             uuid.UUID
	Tagname        pgtype.Text
	Tagdescription pgtype.Text
	CreatedAt      *time.Time
}

type GetTagByNameRow struct {
	Id             uuid.UUID
	Tagname        pgtype.Text
	Tagdescription pgtype.Text
	CreatedAt      *time.Time
}

type GetTagsForPostRow struct {
	Id             uuid.UUID
	Tagname        pgtype.Text
	Tagdescription pgtype.Text
	CreatedAt      *time.Time
}

type GetUserByEmailRow struct {
	Id        uuid.UUID
	Username  pgtype.Text
	Useremail pgtype.Text
	Metadata  *[]byte
	Tags      pgtype.Text
	IsActive  pgtype.Bool
	CreatedAt *time.Time
	UpdatedAt *time.Time
}

type GetUserByIdRow struct {
	Id        uuid.UUID
	Username  pgtype.Text
	Useremail pgtype.Text
	Metadata  *[]byte
	Tags      pgtype.Text
	IsActive  pgtype.Bool
	CreatedAt *time.Time
	UpdatedAt *time.Time
}

type GetUserStatsRow struct {
	Id           uuid.UUID
	Username     pgtype.Text
	PostCount    int64
	CommentCount int64
	TotalViews   int32
}

type ListActiveUsersRow struct {
	Id        uuid.UUID
	Username  pgtype.Text
	Useremail pgtype.Text
	Metadata  *[]byte
	Tags      pgtype.Text
	IsActive  pgtype.Bool
	CreatedAt *time.Time
	UpdatedAt *time.Time
}

type ListCommentsByPostRow struct {
	Id          uuid.UUID
	PostId      *uuid.UUID
	UserId      *uuid.UUID
	Commentbody pgtype.Text
	Likes       pgtype.Int4
	CreatedAt   *time.Time
}

type ListCommentsByUserRow struct {
	Id          uuid.UUID
	PostId      *uuid.UUID
	UserId      *uuid.UUID
	Commentbody pgtype.Text
	Likes       pgtype.Int4
	CreatedAt   *time.Time
}

type ListPostsByUserRow struct {
	Id          uuid.UUID
	UserId      *uuid.UUID
	Title       pgtype.Text
	Postbody    pgtype.Text
	Categories  pgtype.Text
	ViewCount   pgtype.Int4
	Rating      *decimal.Decimal
	IsPublished pgtype.Bool
	PublishedAt *time.Time
	CreatedAt   *time.Time
	UpdatedAt   *time.Time
}

type ListPostsRow struct {
	Id          uuid.UUID
	UserId      *uuid.UUID
	Title       pgtype.Text
	Postbody    pgtype.Text
	Categories  pgtype.Text
	ViewCount   pgtype.Int4
	Rating      *decimal.Decimal
	IsPublished pgtype.Bool
	PublishedAt *time.Time
	CreatedAt   *time.Time
	UpdatedAt   *time.Time
}

type ListPublishedPostsRow struct {
	Id          uuid.UUID
	UserId      *uuid.UUID
	Title       pgtype.Text
	Postbody    pgtype.Text
	Categories  pgtype.Text
	ViewCount   pgtype.Int4
	Rating      *decimal.Decimal
	IsPublished pgtype.Bool
	PublishedAt *time.Time
	CreatedAt   *time.Time
	UpdatedAt   *time.Time
}

type ListTagsRow struct {
	Id             uuid.UUID
	Tagname        pgtype.Text
	Tagdescription pgtype.Text
	CreatedAt      *time.Time
}

type ListUsersRow struct {
	Id        uuid.UUID
	Username  pgtype.Text
	Useremail pgtype.Text
	Metadata  *[]byte
	Tags      pgtype.Text
	IsActive  pgtype.Bool
	CreatedAt *time.Time
	UpdatedAt *time.Time
}

type Posts struct {
	Id          uuid.UUID
	UserId      *uuid.UUID
	Title       pgtype.Text
	Postbody    pgtype.Text
	Categories  pgtype.Text
	ViewCount   pgtype.Int4
	Rating      *decimal.Decimal
	IsPublished pgtype.Bool
	PublishedAt pgtype.Timestamptz
	CreatedAt   pgtype.Timestamptz
	UpdatedAt   pgtype.Timestamptz
}

type Querier interface {
	AddTagToPost(ctx context.Context, arg AddTagToPostParams) error
	CreateComment(ctx context.Context, arg CreateCommentParams) (CreateCommentRow, error)
	CreatePost(ctx context.Context, arg CreatePostParams) (CreatePostRow, error)
	CreateTag(ctx context.Context, arg CreateTagParams) (CreateTagRow, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (CreateUserRow, error)
	DeleteComment(ctx context.Context, id uuid.UUID) error
	DeletePost(ctx context.Context, id uuid.UUID) error
	DeleteTag(ctx context.Context, id uuid.UUID) error
	DeleteUser(ctx context.Context, id uuid.UUID) error
	GetCommentById(ctx context.Context, id uuid.UUID) (GetCommentByIdRow, error)
	GetPopularPosts(ctx context.Context, limit any) ([]GetPopularPostsRow, error)
	GetPostById(ctx context.Context, id uuid.UUID) (GetPostByIdRow, error)
	GetPostsForTag(ctx context.Context, tagId *uuid.UUID) ([]GetPostsForTagRow, error)
	GetTagById(ctx context.Context, id uuid.UUID) (GetTagByIdRow, error)
	GetTagByName(ctx context.Context, tagname pgtype.Text) (GetTagByNameRow, error)
	GetTagsForPost(ctx context.Context, postId *uuid.UUID) ([]GetTagsForPostRow, error)
	GetUserByEmail(ctx context.Context, useremail pgtype.Text) (GetUserByEmailRow, error)
	GetUserById(ctx context.Context, id uuid.UUID) (GetUserByIdRow, error)
	GetUserStats(ctx context.Context, id uuid.UUID) (GetUserStatsRow, error)
	IncrementPostViews(ctx context.Context, id uuid.UUID) error
	LikeComment(ctx context.Context, id uuid.UUID) error
	ListActiveUsers(ctx context.Context) ([]ListActiveUsersRow, error)
	ListCommentsByPost(ctx context.Context, postId *uuid.UUID) ([]ListCommentsByPostRow, error)
	ListCommentsByUser(ctx context.Context, userId *uuid.UUID) ([]ListCommentsByUserRow, error)
	ListPosts(ctx context.Context) ([]ListPostsRow, error)
	ListPostsByUser(ctx context.Context, userId *uuid.UUID) ([]ListPostsByUserRow, error)
	ListPublishedPosts(ctx context.Context) ([]ListPublishedPostsRow, error)
	ListTags(ctx context.Context) ([]ListTagsRow, error)
	ListUsers(ctx context.Context) ([]ListUsersRow, error)
	RemoveTagFromPost(ctx context.Context, arg RemoveTagFromPostParams) error
	SearchPostsByCategory(ctx context.Context, any any) ([]SearchPostsByCategoryRow, error)
	SearchUsersByMetadata(ctx context.Context, p any) ([]SearchUsersByMetadataRow, error)
	SearchUsersByTag(ctx context.Context, any any) ([]SearchUsersByTagRow, error)
	UpdateComment(ctx context.Context, arg UpdateCommentParams) (UpdateCommentRow, error)
	UpdatePost(ctx context.Context, arg UpdatePostParams) (UpdatePostRow, error)
	UpdateTag(ctx context.Context, arg UpdateTagParams) (UpdateTagRow, error)
	UpdateUser(ctx context.Context, arg UpdateUserParams) (UpdateUserRow, error)
	WithTx(tx DBTX) *Queries
}

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

type QueryResult struct {
	LastInsertID int64
	RowsAffected int64
}

type RemoveTagFromPostParams struct {
	PostId *uuid.UUID
	TagId  *uuid.UUID
}

type SearchPostsByCategoryRow struct {
	Id          uuid.UUID
	UserId      *uuid.UUID
	Title       pgtype.Text
	Postbody    pgtype.Text
	Categories  pgtype.Text
	ViewCount   pgtype.Int4
	Rating      *decimal.Decimal
	IsPublished pgtype.Bool
	PublishedAt *time.Time
	CreatedAt   *time.Time
	UpdatedAt   *time.Time
}

type SearchUsersByMetadataRow struct {
	Id        uuid.UUID
	Username  pgtype.Text
	Useremail pgtype.Text
	Metadata  *[]byte
	Tags      pgtype.Text
	IsActive  pgtype.Bool
	CreatedAt *time.Time
	UpdatedAt *time.Time
}

type SearchUsersByTagRow struct {
	Id        uuid.UUID
	Username  pgtype.Text
	Useremail pgtype.Text
	Metadata  *[]byte
	Tags      pgtype.Text
	IsActive  pgtype.Bool
	CreatedAt *time.Time
	UpdatedAt *time.Time
}

type Tags struct {
	Id             uuid.UUID
	Tagname        pgtype.Text
	Tagdescription pgtype.Text
	CreatedAt      pgtype.Timestamptz
}

type UpdateCommentParams struct {
	Commentbody pgtype.Text
	Id          uuid.UUID
}

type UpdateCommentRow struct {
	Id          uuid.UUID
	PostId      *uuid.UUID
	UserId      *uuid.UUID
	Commentbody pgtype.Text
	Likes       pgtype.Int4
	CreatedAt   *time.Time
}

type UpdatePostParams struct {
	Title       pgtype.Text
	Postbody    pgtype.Text
	Categories  pgtype.Text
	IsPublished pgtype.Bool
	PublishedAt any
	Id          uuid.UUID
}

type UpdatePostRow struct {
	Id          uuid.UUID
	UserId      *uuid.UUID
	Title       pgtype.Text
	Postbody    pgtype.Text
	Categories  pgtype.Text
	ViewCount   pgtype.Int4
	Rating      *decimal.Decimal
	IsPublished pgtype.Bool
	PublishedAt *time.Time
	CreatedAt   *time.Time
	UpdatedAt   *time.Time
}

type UpdateTagParams struct {
	Tagname        pgtype.Text
	Tagdescription pgtype.Text
	Id             uuid.UUID
}

type UpdateTagRow struct {
	Id             uuid.UUID
	Tagname        pgtype.Text
	Tagdescription pgtype.Text
	CreatedAt      *time.Time
}

type UpdateUserParams struct {
	Username  pgtype.Text
	Useremail pgtype.Text
	Metadata  *[]byte
	Tags      pgtype.Text
	Id        uuid.UUID
}

type UpdateUserRow struct {
	Id        uuid.UUID
	Username  pgtype.Text
	Useremail pgtype.Text
	Metadata  *[]byte
	Tags      pgtype.Text
	IsActive  pgtype.Bool
	CreatedAt *time.Time
	UpdatedAt *time.Time
}

type Users struct {
	Id        uuid.UUID
	Username  pgtype.Text
	Useremail pgtype.Text
	Metadata  *[]byte
	Tags      pgtype.Text
	IsActive  pgtype.Bool
	CreatedAt pgtype.Timestamptz
	UpdatedAt pgtype.Timestamptz
}