datalayer

type CardTransaction struct {
	Model
	DateTime             time.Time `json:"dateTime" db:"datetime"`
	Amount               int64     `json:"amount" db:"amount"`
	CurrencyScale        int       `json:"scale" db:"currency_scale"`
	CurrencyCode         string    `json:"currencyCode" db:"currency_code"`
	Reference            string    `json:"reference" db:"reference"`
	MerchantName         string    `json:"merchantName" db:"merchant_name"`
	MerchantCity         string    `json:"merchantCity" db:"merchant_city"`
	MerchantCountryCode  string    `json:"merchantCountryCode" db:"merchant_country_code"`
	MerchantCountryName  string    `json:"merchantCountryName" db:"merchant_country_name"`
	MerchantCategoryCode string    `json:"merchantCategoryCode" db:"merchant_category_code"`
	MerchantCategoryName string    `json:"merchantCategoryName" db:"merchant_category_name"`
	UserID               int64     `json:"userID" db:"user_id"`
}

type Contact struct {
	Model
	Name   string `json:"name" db:"name"`
	Phone  string `json:"phone" db:"phone"`
	UserID int64  `json:"userID" db:"user_id"`
}

type DataLayer interface {
	// Users
	GetUserByEmail(email string) (*User, error)
	GetUserByID(id int64) (*User, error)
	CreateUser(email, password string) (int64, error)
	GetUnconfirmedUsers() ([]User, error)
	SetUserStateByID(id int64, state UserState) error

	// Contacts
	CreateContact(name, phone string, userID int64) (int64, error)
	GetContactByID(id int64) (*Contact, error)
	GetContactsByUserID(userID int64) ([]*Contact, error)

	// Transactions
	CreateCardTransaction(*CardTransaction) (int64, error)
	GetCardTransactionByID(id int64) (*CardTransaction, error)
	GetCardTransactionsByUserID(userID int64, sortable pagination.Sortable, filter filters.CardTransactionFilter) ([]*CardTransaction, error)

	// SignUpConfirmations
	CreateSignUpConfirmation(nonce string, userID int64) (int64, error)
	LookupSignUpConfirmation(nonce string) (*SignUpConfirmation, error)
}

type JsonNullTime struct {
	sql.NullTime
}

type Model struct {
	ID        int64        `json:"id" db:"id"`
	CreatedAt JsonNullTime `json:"createdAt" db:"created_at"`
	UpdatedAt JsonNullTime `json:"updatedAt" db:"updated_at"`
	DeletedAt JsonNullTime `json:"deletedAt" db:"deleted_at"`
}

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

type SignUpConfirmation struct {
	Model
	Nonce  string `json:"name" db:"nonce"`
	UserID int64  `json:"user_id" db:"user_id"`
}

type User struct {
	Model
	Email       sql.NullString `db:"email"`
	Password    sql.NullString `db:"password"`
	Role        sql.NullString `db:"role"`
	State       sql.NullString `db:"state"`
	LoggedOutAt JsonNullTime   `db:"logged_out_at"`
}

type UserState string