gendb

type AddLectureToUserParams struct {
	UserID    types.UserID    `db:"user_id" json:"userId"`
	LectureID types.LectureID `db:"lecture_id" json:"lectureId"`
}

type AddLectureToUserRow struct {
	UserID    types.UserID    `db:"user_id" json:"userId"`
	LectureID types.LectureID `db:"lecture_id" json:"lectureId"`
}

type AddRoleToUserParams struct {
	UserID types.UserID `db:"user_id" json:"userId"`
	RoleID types.RoleID `db:"role_id" json:"roleId"`
}

type CreateLectureParams struct {
	Name   string      `db:"name" json:"name"`
	Code   string      `db:"code" json:"code"`
	Credit int16       `db:"credit" json:"credit"`
	Type   pgtype.Int2 `db:"type" json:"type"`
}

type CreateUserParams struct {
	Username string `db:"username" json:"username"`
	Password string `db:"password" json:"password"`
}

type CreateUserRow struct {
	ID       types.UserID `db:"id" json:"id"`
	Username string       `db:"username" json:"username"`
}

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 GetUserByUsernameRow struct {
	ID       types.UserID `db:"id" json:"id"`
	Username string       `db:"username" json:"username"`
}

type GetUserLecturesRow struct {
	Name   string      `db:"name" json:"name"`
	Code   string      `db:"code" json:"code"`
	Credit int16       `db:"credit" json:"credit"`
	Type   pgtype.Int2 `db:"type" json:"type"`
}

type GetUserRow struct {
	ID       types.UserID `db:"id" json:"id"`
	Username string       `db:"username" json:"username"`
}

type Lecture struct {
	ID     types.LectureID `db:"id" json:"id"`
	Name   string          `db:"name" json:"name"`
	Code   string          `db:"code" json:"code"`
	Credit int16           `db:"credit" json:"credit"`
	Type   pgtype.Int2     `db:"type" json:"type"`
}

type ListUsersRow struct {
	ID       types.UserID `db:"id" json:"id"`
	Username string       `db:"username" json:"username"`
}

type NullUserRoleValue struct {
	UserRoleValue UserRoleValue `json:"userRoleValue"`
	Valid         bool          `json:"valid"` // Valid is true if UserRoleValue is not NULL
}

type Querier interface {
	AddLectureToUser(ctx context.Context, arg AddLectureToUserParams) (AddLectureToUserRow, error)
	AddRoleToUser(ctx context.Context, arg AddRoleToUserParams) (UserRole, error)
	CreateLecture(ctx context.Context, arg CreateLectureParams) (Lecture, error)
	CreateRole(ctx context.Context, role types.Role) (Role, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (CreateUserRow, error)
	DeleteRole(ctx context.Context, role types.Role) (int64, error)
	GetLecture(ctx context.Context, id types.LectureID) (Lecture, error)
	GetLectureByCode(ctx context.Context, code string) (Lecture, error)
	GetRoleByName(ctx context.Context, role types.Role) (Role, error)
	GetUser(ctx context.Context, id types.UserID) (GetUserRow, error)
	GetUserByUsername(ctx context.Context, username string) (GetUserByUsernameRow, error)
	GetUserCredentialsWithUsername(ctx context.Context, username string) (User, error)
	GetUserLectures(ctx context.Context, id types.UserID) ([]GetUserLecturesRow, error)
	GetUserRoles(ctx context.Context, id types.UserID) ([]types.Role, error)
	ListLectures(ctx context.Context) ([]Lecture, error)
	ListUsers(ctx context.Context) ([]ListUsersRow, error)
	RemoveLectureFromUser(ctx context.Context, arg RemoveLectureFromUserParams) (int64, error)
	RemoveRoleFromUser(ctx context.Context, arg RemoveRoleFromUserParams) (int64, error)
	TestDeleteUser(ctx context.Context, username string) error
	UpdateToken(ctx context.Context, arg UpdateTokenParams) (UpdateTokenRow, error)
	UpdateTokenExpirationDate(ctx context.Context, arg UpdateTokenExpirationDateParams) error
	UpdateUser(ctx context.Context, arg UpdateUserParams) (UpdateUserRow, error)
}

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

type RemoveLectureFromUserParams struct {
	UserID    types.UserID    `db:"user_id" json:"userId"`
	LectureID types.LectureID `db:"lecture_id" json:"lectureId"`
}

type RemoveRoleFromUserParams struct {
	UserID types.UserID `db:"user_id" json:"userId"`
	RoleID types.RoleID `db:"role_id" json:"roleId"`
}

type Role struct {
	ID   types.RoleID `db:"id" json:"id"`
	Role types.Role   `db:"role" json:"role"`
}

type UpdateTokenExpirationDateParams struct {
	TokenExpireAt pgtype.Timestamp `db:"token_expire_at" json:"tokenExpireAt"`
	ID            types.UserID     `db:"id" json:"id"`
}

type UpdateTokenParams struct {
	Token         pgtype.Text      `db:"token" json:"token"`
	TokenExpireAt pgtype.Timestamp `db:"token_expire_at" json:"tokenExpireAt"`
	ID            types.UserID     `db:"id" json:"id"`
}

type UpdateTokenRow struct {
	Username string      `db:"username" json:"username"`
	Token    pgtype.Text `db:"token" json:"token"`
}

type UpdateUserParams struct {
	Username string       `db:"username" json:"username"`
	Password string       `db:"password" json:"password"`
	ID       types.UserID `db:"id" json:"id"`
}

type UpdateUserRow struct {
	ID       types.UserID `db:"id" json:"id"`
	Username string       `db:"username" json:"username"`
}

type User struct {
	ID            types.UserID     `db:"id" json:"id"`
	Username      string           `db:"username" json:"username"`
	Password      string           `db:"password" json:"password"`
	Token         pgtype.Text      `db:"token" json:"token"`
	TokenExpireAt pgtype.Timestamp `db:"token_expire_at" json:"tokenExpireAt"`
}

type UserLecture struct {
	ID        int64           `db:"id" json:"id"`
	UserID    types.UserID    `db:"user_id" json:"userId"`
	LectureID types.LectureID `db:"lecture_id" json:"lectureId"`
}

type UserRole struct {
	UserID types.UserID `db:"user_id" json:"userId"`
	RoleID types.RoleID `db:"role_id" json:"roleId"`
}

type UserRoleValue string