db

type AddTeamLeaderParams struct {
	TeamID   uuid.UUID  `json:"team_id"`
	LeaderID *uuid.UUID `json:"leader_id"`
}

type AddTeamMemberParams struct {
	TeamID *uuid.UUID `json:"team_id"`
	UserID *uuid.UUID `json:"user_id"`
}

type CreateTeamParams struct {
	TeamID   uuid.UUID   `json:"team_id"`
	Title    string      `json:"title"`
	LeaderID *uuid.UUID  `json:"leader_id"`
	Descr    pgtype.Text `json:"descr"`
}

type CreateUserParams struct {
	Email        string `json:"email"`
	Name         string `json:"name"`
	UserName     string `json:"user_name"`
	PasswordHash string `json:"password_hash"`
}

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 NullUserRole struct {
	UserRole UserRole `json:"user_role"`
	Valid    bool     `json:"valid"` // Valid is true if UserRole is not NULL
}

type Querier interface {
	AddTeamLeader(ctx context.Context, arg AddTeamLeaderParams) error
	AddTeamMember(ctx context.Context, arg AddTeamMemberParams) error
	CreateTeam(ctx context.Context, arg CreateTeamParams) (Team, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
	GetUser(ctx context.Context, userID uuid.UUID) (User, error)
	GetUsers(ctx context.Context) ([]User, error)
}

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

type SchemaMigration struct {
	Version int64 `json:"version"`
	Dirty   bool  `json:"dirty"`
}

type Team struct {
	TeamID    uuid.UUID        `json:"team_id"`
	Title     string           `json:"title"`
	Descr     pgtype.Text      `json:"descr"`
	LeaderID  *uuid.UUID       `json:"leader_id"`
	CreatedAt pgtype.Timestamp `json:"created_at"`
	UpdatedAt pgtype.Timestamp `json:"updated_at"`
}

type TeamMember struct {
	UserID *uuid.UUID `json:"user_id"`
	TeamID *uuid.UUID `json:"team_id"`
	Role   UserRole   `json:"role"`
}

type User struct {
	UserID       uuid.UUID        `json:"user_id"`
	Email        string           `json:"email"`
	PasswordHash string           `json:"password_hash"`
	UserName     string           `json:"user_name"`
	Name         string           `json:"name"`
	IsActive     pgtype.Bool      `json:"is_active"`
	CreatedAt    pgtype.Timestamp `json:"created_at"`
	UpdatedAt    pgtype.Timestamp `json:"updated_at"`
}

type UserRole string