models

type Account struct {
	ID            int64    `json:"id"`
	Name          string   `json:"name"`
	Balance       float64  `json:"balance"`
	Currency      Currency `json:"currency"`
	Status        string   `json:"status"`
	ShowInSummary bool     `json:"show_in_summary"`
	UserID        int64    `json:"-"`
}

type AccountStorage interface {
	Insert(name string, userID int64, currencyID int64, status string, showInSummary bool) (int64, error)
	All(userID int64, filters Filters) ([]*Account, Metadata, error)
}

type AuthSession struct {
	ID        int64
	UserID    int64
	Token     string
	ExpiredAt *time.Time
	CreatedAt *time.Time
	UpdatedAt *time.Time
}

type AuthSessionStorage interface {
	Insert(userID int64, token string) (int64, error)
	Get(id int64) (*AuthSession, error)
	GetByToken(token string) (*AuthSession, error)
	Delete(id int64) error
}

type Category struct {
	ID           int64        `json:"id"`
	Name         string       `json:"name"`
	CategoryType CategoryType `json:"category_type"`
	UserID       int64        `json:"-"`
	Inactive     bool         `json:"inactive"`
	UpdatedAt    *time.Time   `json:"-"`
}

type CategoryStorage interface {
	Insert(name string, categoryType CategoryType, userID int64, inactive bool) (int64, error)
	All(userID int64, filters Filters) ([]*Category, Metadata, error)
}

type CategoryType struct {
	ID   int64  `json:"id"`
	Name string `json:"name"`
}

type Currency struct {
	ID   int64  `json:"id"`
	Name string `json:"name"`
	Unit string `json:"unit"`
}

type Filters struct {
	Page     int
	PageSize int
}

type Metadata struct {
	CurrentPage  int `json:"current_page,omitempty"`
	PageSize     int `json:"page_size,omitempty"`
	FirstPage    int `json:"first_page,omitempty"`
	LastPage     int `json:"last_page,omitempty"`
	TotalRecords int `json:"total_records,omitempty"`
}

type Models struct {
	Accounts     AccountStorage
	AuthSessions AuthSessionStorage
	Categories   CategoryStorage
	Users        UserStorage
	Transactions TransactionStorage
}

type Transaction struct {
	ID        int64      `json:"id"`
	Amount    float64    `json:"amount"`
	Comment   string     `json:"comment"`
	UserID    int64      `json:"-"`
	Category  Category   `json:"category"`
	Account   Account    `json:"account"`
	CreatedAt *time.Time `json:"created_at"`
	UpdatedAt *time.Time `json:"-"`
}

type TransactionStorage interface {
	Insert(amount float64, comment string, userID, categoryID, accountID int64) (int64, error)
	All(userID int64, filters Filters) ([]*Transaction, Metadata, error)
}

type User struct {
	ID                int64
	Email             string
	EncryptedPassword []byte
	CreatedAt         *time.Time
	UpdatedAt         *time.Time
	ConfirmedAt       mysql.NullTime // https://medium.com/aubergine-solutions/how-i-handled-null-possible-values-from-database-rows-in-golang-521fb0ee267
}

type UserStorage interface {
	Authenticate(email, password string) (string, error)
	Confirm(id int64) error
	Get(id int64) (*User, error)
	GetByEmail(email string) (*User, error)
	Insert(email, password string) (int64, error)
	Delete(id int64) error
}