models

type Comment struct {
	ID        string    `json:"id" db:"id"`
	RootID    string    `json:"root_id" db:"root_id"`       // The entity this comment belongs to (post, product, etc.)
	ParentID  *string   `json:"parent_id" db:"parent_id"`   // Parent comment ID for threading
	UserID    string    `json:"user_id" db:"user_id"`       // External user ID
	Content   string    `json:"content" db:"content"`       // The comment text
	MediaURL  *string   `json:"media_url" db:"media_url"`   // Optional media attachment
	LinkURL   *string   `json:"link_url" db:"link_url"`     // Optional link
	Upvotes   int64     `json:"upvotes" db:"upvotes"`       // Number of upvotes
	Downvotes int64     `json:"downvotes" db:"downvotes"`   // Number of downvotes
	Score     int64     `json:"score" db:"score"`           // Calculated score (upvotes - downvotes)
	Depth     int       `json:"depth" db:"depth"`           // Depth in the comment tree
	Path      string    `json:"path" db:"path"`             // Materialized path for efficient queries
	IsDeleted bool      `json:"is_deleted" db:"is_deleted"` // Soft delete flag
	CreatedAt time.Time `json:"created_at" db:"created_at"`
	UpdatedAt time.Time `json:"updated_at" db:"updated_at"`
}

type CommentFilter struct {
	RootID    *string `json:"root_id,omitempty"`
	UserID    *string `json:"user_id,omitempty"`
	ParentID  *string `json:"parent_id,omitempty"`
	MaxDepth  *int    `json:"max_depth,omitempty"`
	SortBy    string  `json:"sort_by,omitempty"`    // "score", "created_at", "updated_at"
	SortOrder string  `json:"sort_order,omitempty"` // "asc", "desc"
	Limit     *int    `json:"limit,omitempty"`
	Offset    *int    `json:"offset,omitempty"`
}

type CommentStats struct {
	RootID      string `json:"root_id"`
	TotalCount  int64  `json:"total_count"`
	TotalScore  int64  `json:"total_score"`
	MaxDepth    int    `json:"max_depth"`
	RecentCount int64  `json:"recent_count"` // Comments in last 24 hours
}

type CommentTree struct {
	Comment  *Comment       `json:"comment"`
	Children []*CommentTree `json:"children,omitempty"`
}

type CreateCommentRequest struct {
	RootID   string  `json:"root_id" validate:"required"`
	ParentID *string `json:"parent_id"`
	UserID   string  `json:"user_id" validate:"required"`
	Content  string  `json:"content" validate:"required,min=1,max=10000"`
	MediaURL *string `json:"media_url"`
	LinkURL  *string `json:"link_url"`
}

type UpdateCommentRequest struct {
	Content  *string `json:"content,omitempty"`
	MediaURL *string `json:"media_url,omitempty"`
	LinkURL  *string `json:"link_url,omitempty"`
}

type Vote struct {
	ID        string    `json:"id" db:"id"`
	CommentID string    `json:"comment_id" db:"comment_id"`
	UserID    string    `json:"user_id" db:"user_id"`
	VoteType  VoteType  `json:"vote_type" db:"vote_type"` // 1 for upvote, -1 for downvote
	CreatedAt time.Time `json:"created_at" db:"created_at"`
	UpdatedAt time.Time `json:"updated_at" db:"updated_at"`
}

type VoteRequest struct {
	UserID   string   `json:"user_id" validate:"required"`
	VoteType VoteType `json:"vote_type" validate:"required,oneof=1 -1"`
}

type VoteType int