db

type AdministrativeStatus string

type ClientProfile struct {
	ID uuid.UUID `json:"id"`
	// Client status set by the system admin
	Adm AdministrativeStatus `json:"adm"`
	// Client status from security service (Know Your Client)
	Kyc             KycStatus `json:"kyc"`
	Name            string    `json:"name"`
	Surname         string    `json:"surname"`
	Updated         time.Time `json:"updated"`
	Created         time.Time `json:"created"`
	Password        string    `json:"password"`
	Email           string    `json:"email"`
	PasswordUpdated time.Time `json:"password_updated"`
}

type ClientSession struct {
	ID      uuid.UUID `json:"id"`
	Sub     uuid.UUID `json:"sub"`
	Refresh string    `json:"refresh"`
	Agent   string    `json:"agent"`
	Ip      string    `json:"ip"`
	Blocked bool      `json:"blocked"`
	Expires time.Time `json:"expires"`
	Created time.Time `json:"created"`
}

type CreateClientProfileParams struct {
	ID       uuid.UUID            `json:"id"`
	Adm      AdministrativeStatus `json:"adm"`
	Kyc      KycStatus            `json:"kyc"`
	Name     string               `json:"name"`
	Surname  string               `json:"surname"`
	Password string               `json:"password"`
	Email    string               `json:"email"`
}

type CreateSessionParams struct {
	ID      uuid.UUID `json:"id"`
	Sub     uuid.UUID `json:"sub"`
	Refresh string    `json:"refresh"`
	Agent   string    `json:"agent"`
	Ip      string    `json:"ip"`
	Blocked bool      `json:"blocked"`
	Expires time.Time `json:"expires"`
}

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 GetClientPasswordByIdRow struct {
	Password        string    `json:"password"`
	PasswordUpdated time.Time `json:"password_updated"`
}

type KycStatus string

type NullAdministrativeStatus struct {
	AdministrativeStatus AdministrativeStatus `json:"administrative_status"`
	Valid                bool                 `json:"valid"` // Valid is true if AdministrativeStatus is not NULL
}

type NullKycStatus struct {
	KycStatus KycStatus `json:"kyc_status"`
	Valid     bool      `json:"valid"` // Valid is true if KycStatus is not NULL
}

type Querier interface {
	CreateClientProfile(ctx context.Context, arg CreateClientProfileParams) (uuid.UUID, error)
	CreateSession(ctx context.Context, arg CreateSessionParams) (ClientSession, error)
	DeleteClientProfile(ctx context.Context, id uuid.UUID) error
	GetClientPasswordById(ctx context.Context, id uuid.UUID) (GetClientPasswordByIdRow, error)
	GetClientProfile(ctx context.Context, id uuid.UUID) (ClientProfile, error)
	GetClientProfileByEmail(ctx context.Context, email string) (ClientProfile, error)
	GetSession(ctx context.Context, id uuid.UUID) (ClientSession, error)
	UpdateClientPassword(ctx context.Context, arg UpdateClientPasswordParams) error
	UpdateClientProfile(ctx context.Context, arg UpdateClientProfileParams) error
	UpdateClientStatus(ctx context.Context, arg UpdateClientStatusParams) error
}

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

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

type Store interface {
	Querier
}

type UpdateClientPasswordParams struct {
	ID       uuid.UUID `json:"id"`
	Password string    `json:"password"`
}

type UpdateClientProfileParams struct {
	ID      uuid.UUID   `json:"id"`
	Name    pgtype.Text `json:"name"`
	Surname pgtype.Text `json:"surname"`
	Email   pgtype.Text `json:"email"`
}

type UpdateClientStatusParams struct {
	ID  uuid.UUID                `json:"id"`
	Adm NullAdministrativeStatus `json:"adm"`
	Kyc NullKycStatus            `json:"kyc"`
}