database

type Comment struct {
	ID              int32
	DebateID        sql.NullInt32
	ParentCommentID sql.NullInt32
	UserID          sql.NullInt32
	Content         string
	CreatedAt       sql.NullTime
	UpdatedAt       sql.NullTime
}

type CreateCommentParams struct {
	DebateID        sql.NullInt32
	ParentCommentID sql.NullInt32
	UserID          sql.NullInt32
	Content         string
}

type CreateDebateAnalyticsParams struct {
	DebateID        sql.NullInt32
	TotalVotes      sql.NullInt32
	TotalComments   sql.NullInt32
	EngagementScore sql.NullString
}

type CreateDebateCardParams struct {
	DebateID    sql.NullInt32
	Stance      string
	Title       string
	Description sql.NullString
	AiGenerated sql.NullBool
}

type CreateDebateParams struct {
	MatchID     string
	DebateType  string
	Headline    string
	Description sql.NullString
	AiGenerated sql.NullBool
}

type CreateLeagueParams struct {
	Name        string
	Description sql.NullString
	OwnerID     int32
	Country     sql.NullString
	Level       sql.NullInt32
	LogoUrl     sql.NullString
	Website     sql.NullString
	Founded     sql.NullInt32
}

type CreateMediaParams struct {
	MatchID  string
	MediaUrl string
}

type CreatePlayerProfileParams struct {
	UserID    int32
	TeamID    uuid.NullUUID
	Position  string
	Age       int32
	Country   string
	HeightCm  int32
	Pace      int32
	Shooting  int32
	Passing   int32
	Stamina   int32
	Dribbling int32
	Defending int32
	Physical  int32
}

type CreateTeamManagerParams struct {
	UserID     int32
	LeagueID   uuid.UUID
	TeamID     uuid.NullUUID
	Title      sql.NullString
	Experience sql.NullInt32
	Bio        sql.NullString
}

type CreateTeamParams struct {
	Name        string
	Description sql.NullString
	LeagueID    uuid.NullUUID
	ManagerID   uuid.NullUUID
	LogoUrl     sql.NullString
	City        sql.NullString
	Country     string
	Founded     sql.NullInt32
	Stadium     sql.NullString
	Capacity    sql.NullInt32
}

type CreateUserParams struct {
	Firstname string
	Lastname  string
	Email     string
	IsAdmin   bool
}

type CreateVerificationParams struct {
	PlayerProfileID uuid.UUID
	VerifierUserID  int32
}

type CreateVoteParams struct {
	DebateCardID sql.NullInt32
	UserID       sql.NullInt32
	VoteType     string
	Emoji        sql.NullString
}

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type Debate struct {
	ID          int32
	MatchID     string
	DebateType  string
	Headline    string
	Description sql.NullString
	AiGenerated sql.NullBool
	DeletedAt   sql.NullTime
	CreatedAt   sql.NullTime
	UpdatedAt   sql.NullTime
}

type DebateAnalytic struct {
	ID              int32
	DebateID        sql.NullInt32
	TotalVotes      sql.NullInt32
	TotalComments   sql.NullInt32
	EngagementScore sql.NullString
	CreatedAt       sql.NullTime
	UpdatedAt       sql.NullTime
}

type DebateCard struct {
	ID          int32
	DebateID    sql.NullInt32
	Stance      string
	Title       string
	Description sql.NullString
	AiGenerated sql.NullBool
	CreatedAt   sql.NullTime
	UpdatedAt   sql.NullTime
}

type DeleteVoteParams struct {
	DebateCardID sql.NullInt32
	UserID       sql.NullInt32
	VoteType     string
}

type GetCommentRow struct {
	ID              int32
	DebateID        sql.NullInt32
	ParentCommentID sql.NullInt32
	UserID          sql.NullInt32
	Content         string
	CreatedAt       sql.NullTime
	UpdatedAt       sql.NullTime
	Firstname       string
	Lastname        string
}

type GetCommentsRow struct {
	ID              int32
	DebateID        sql.NullInt32
	ParentCommentID sql.NullInt32
	UserID          sql.NullInt32
	Content         string
	CreatedAt       sql.NullTime
	UpdatedAt       sql.NullTime
	Firstname       string
	Lastname        string
}

type GetPlayersByLeagueRow struct {
	ID         uuid.UUID
	UserID     int32
	TeamID     uuid.NullUUID
	Position   string
	Age        int32
	Country    string
	HeightCm   int32
	Pace       int32
	Shooting   int32
	Passing    int32
	Stamina    int32
	Dribbling  int32
	Defending  int32
	Physical   int32
	IsVerified bool
	CreatedAt  time.Time
	UpdatedAt  time.Time
	Firstname  string
	Lastname   string
}

type GetPlayersByTeamRow struct {
	ID         uuid.UUID
	UserID     int32
	TeamID     uuid.NullUUID
	Position   string
	Age        int32
	Country    string
	HeightCm   int32
	Pace       int32
	Shooting   int32
	Passing    int32
	Stamina    int32
	Dribbling  int32
	Defending  int32
	Physical   int32
	IsVerified bool
	CreatedAt  time.Time
	UpdatedAt  time.Time
	Firstname  string
	Lastname   string
}

type GetTopDebatesRow struct {
	ID              int32
	MatchID         string
	DebateType      string
	Headline        string
	Description     sql.NullString
	AiGenerated     sql.NullBool
	DeletedAt       sql.NullTime
	CreatedAt       sql.NullTime
	UpdatedAt       sql.NullTime
	TotalVotes      sql.NullInt32
	TotalComments   sql.NullInt32
	EngagementScore sql.NullString
}

type GetUserVoteParams struct {
	DebateCardID sql.NullInt32
	UserID       sql.NullInt32
	VoteType     string
}

type GetVoteCountsRow struct {
	DebateCardID sql.NullInt32
	VoteType     string
	Emoji        sql.NullString
	Count        int64
}

type League struct {
	ID          uuid.UUID
	Name        string
	Description sql.NullString
	OwnerID     int32
	Country     sql.NullString
	Level       sql.NullInt32
	LogoUrl     sql.NullString
	Website     sql.NullString
	Founded     sql.NullInt32
	CreatedAt   time.Time
	UpdatedAt   time.Time
}

type ListFreeAgentsRow struct {
	ID         uuid.UUID
	UserID     int32
	TeamID     uuid.NullUUID
	Position   string
	Age        int32
	Country    string
	HeightCm   int32
	Pace       int32
	Shooting   int32
	Passing    int32
	Stamina    int32
	Dribbling  int32
	Defending  int32
	Physical   int32
	IsVerified bool
	CreatedAt  time.Time
	UpdatedAt  time.Time
	Firstname  string
	Lastname   string
	Email      string
}

type ListLeaguesParams struct {
	Column1 int32
	Column2 string
	Column3 int32
	Limit   int32
	Offset  int32
}

type ListPlayerProfilesByTeamRow struct {
	ID         uuid.UUID
	UserID     int32
	TeamID     uuid.NullUUID
	Position   string
	Age        int32
	Country    string
	HeightCm   int32
	Pace       int32
	Shooting   int32
	Passing    int32
	Stamina    int32
	Dribbling  int32
	Defending  int32
	Physical   int32
	IsVerified bool
	CreatedAt  time.Time
	UpdatedAt  time.Time
	Firstname  string
	Lastname   string
}

type ListTeamManagersParams struct {
	Column1 uuid.UUID
	Column2 uuid.UUID
	Column3 uuid.UUID
	Limit   int32
	Offset  int32
}

type ListTeamsParams struct {
	Column1 uuid.UUID
	Column2 uuid.UUID
	Limit   int32
	Offset  int32
}

type Medium struct {
	ID        int32
	MatchID   string
	MediaUrl  string
	CreatedAt time.Time
	UpdatedAt time.Time
}

type PlayerProfile struct {
	ID         uuid.UUID
	UserID     int32
	TeamID     uuid.NullUUID
	Position   string
	Age        int32
	Country    string
	HeightCm   int32
	Pace       int32
	Shooting   int32
	Passing    int32
	Stamina    int32
	Dribbling  int32
	Defending  int32
	Physical   int32
	IsVerified bool
	CreatedAt  time.Time
	UpdatedAt  time.Time
}

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

type Team struct {
	ID          uuid.UUID
	Name        string
	LeagueID    uuid.NullUUID
	State       sql.NullString
	Country     string
	CreatedAt   time.Time
	UpdatedAt   time.Time
	Description sql.NullString
	ManagerID   uuid.NullUUID
	LogoUrl     sql.NullString
	City        sql.NullString
	Founded     sql.NullInt32
	Stadium     sql.NullString
	Capacity    sql.NullInt32
}

type TeamManager struct {
	ID         uuid.UUID
	UserID     int32
	LeagueID   uuid.UUID
	TeamID     uuid.NullUUID
	Title      sql.NullString
	Experience sql.NullInt32
	Bio        sql.NullString
	CreatedAt  time.Time
	UpdatedAt  time.Time
}

type UpdateCommentParams struct {
	ID      int32
	Content string
}

type UpdateDebateAnalyticsParams struct {
	DebateID        sql.NullInt32
	TotalVotes      sql.NullInt32
	TotalComments   sql.NullInt32
	EngagementScore sql.NullString
}

type UpdateDebateCardParams struct {
	ID          int32
	Title       string
	Description sql.NullString
}

type UpdateDebateParams struct {
	ID          int32
	Headline    string
	Description sql.NullString
}

type UpdateLeagueParams struct {
	ID          uuid.UUID
	Name        string
	Description sql.NullString
	Country     sql.NullString
	Level       sql.NullInt32
	LogoUrl     sql.NullString
	Website     sql.NullString
	Founded     sql.NullInt32
}

type UpdatePlayerProfileParams struct {
	ID        uuid.UUID
	TeamID    uuid.NullUUID
	Position  string
	Age       int32
	Country   string
	HeightCm  int32
	Pace      int32
	Shooting  int32
	Passing   int32
	Stamina   int32
	Dribbling int32
	Defending int32
	Physical  int32
}

type UpdatePlayerTeamParams struct {
	ID     uuid.UUID
	TeamID uuid.NullUUID
}

type UpdatePlayerVerificationStatusParams struct {
	ID         uuid.UUID
	IsVerified bool
}

type UpdateTeamManagerParams struct {
	ID         uuid.UUID
	TeamID     uuid.NullUUID
	Title      sql.NullString
	Experience sql.NullInt32
	Bio        sql.NullString
}

type UpdateTeamParams struct {
	ID          uuid.UUID
	Name        string
	Description sql.NullString
	LeagueID    uuid.NullUUID
	ManagerID   uuid.NullUUID
	LogoUrl     sql.NullString
	City        sql.NullString
	Country     string
	Founded     sql.NullInt32
	Stadium     sql.NullString
	Capacity    sql.NullInt32
}

type UpdateUserParams struct {
	ID        int32
	Firstname string
	Lastname  string
	Email     string
	IsAdmin   bool
}

type User struct {
	ID        int32
	Firstname string
	Lastname  string
	Email     string
	CreatedAt time.Time
	UpdatedAt time.Time
	IsAdmin   bool
}

type Verification struct {
	ID              uuid.UUID
	PlayerProfileID uuid.UUID
	VerifierUserID  int32
	CreatedAt       time.Time
}

type Vote struct {
	ID           int32
	DebateCardID sql.NullInt32
	UserID       sql.NullInt32
	VoteType     string
	Emoji        sql.NullString
	CreatedAt    sql.NullTime
}