repository

type CreateStateDto struct {
	Id      uuid.UUID `db:"id"`
	Name    string    `db:"name"`
	Context string    `db:"context"`
}

type CreateUserDto struct {
	Id      uuid.UUID    `db:"id"`
	Name    string       `db:"name"`
	Login   string       `db:"login"`
	ChatId  types.ChatId `db:"chat_id"`
	StateId uuid.UUID    `db:"state_id"`
}

type JokeDb struct {
	Id          uuid.UUID      `db:"id"`
	Name        sql.NullString `db:"name"`
	Text        sql.NullString `db:"text"`
	Author      sql.NullString `db:"author"`
	Explanation sql.NullString `db:"explanation"`
}

type JokeDbDto struct {
	Id          uuid.UUID
	Name        string
	Text        string
	Author      string
	Explanation string
}

type JokeQuery struct {
	Offset int
}

type JokeRepository interface {
	Add(interface{}) (uuid.UUID, error)
	Remove(interface{})
	Edit(interface{})
	GetList(interface{})
	Count(interface{}) (int, error)
	GetOne(JokeQuery) (JokeDbDto, error)
	UpdateContext(uuid.UUID, string) error
}

type Repository struct {
	Conn            *sqlx.DB
	UserRepository  UserRepository
	StateRepository StateRepository
	JokeRepository  JokeRepository
}

type StateDbDto struct {
	Id      uuid.UUID
	Name    string
	Context string
}

type StateRepository interface {
	Add(query CreateStateDto) (uuid.UUID, error)
	Remove(interface{})
	Edit(interface{})
	GetList(interface{})
}

type UserDb struct {
	Id      uuid.UUID      `db:"id"`
	Name    sql.NullString `db:"name"`
	Login   sql.NullString `db:"login"`
	ChatId  types.ChatId   `db:"chat_id"`
	StateId uuid.UUID      `db:"state_id"`
	State   StateDbDto     `db:"state"`
}

type UserDbDto struct {
	Id      uuid.UUID
	Name    string
	Login   string
	ChatId  types.ChatId
	StateId uuid.UUID
	State   StateDbDto
}

type UserListQuery struct {
	Pagination utils.QueryPagination
	Name       string
	State      string
}

type UserQuery struct {
	Login  string
	ChatId types.ChatId
}

type UserRepository interface {
	Add(query CreateUserDto) (uuid.UUID, error)
	Remove(interface{})
	Edit(interface{})
	GetList(query UserListQuery) UsersDbMetaDto
	GetOne(query UserQuery) (UserDbDto, error)
	SetNewStateUUID(userUUID uuid.UUID, stateUUID uuid.UUID) error
}

type UsersDbMetaDto struct {
	Data []UserDbDto
	Meta utils.Pagination
}