database

type ActionTypeEnum string

type Business struct {
	gorm.Model
	PublicId       string         `gorm:"uniqueIndex;not null"`
	OwnerId        uint           `gorm:"not null"`
	Name           string         `gorm:"not null"`
	Description    string         `gorm:"not null"`
	Address        string         `gorm:"not null"`
	GPSCoordinates GPSCoordinates `gorm:"type:geography(POINT,4326);index:,type:gist"`
	NIP            string         `gorm:"unique;not null"`
	KRS            string         `gorm:"unique"`
	REGON          string         `gorm:"unique"`
	OwnerName      string         `gorm:"not null"`
	BannerImageId  string         `gorm:"unique;not null"`
	IconImageId    string         `gorm:"unique;not null"`

	ItemDefinitions []ItemDefinition `gorm:"foreignkey:BusinessId"`
	MenuImages      []MenuImage      `gorm:"foreignkey:BusinessId"`
	VirtualCards    []VirtualCard    `gorm:"foreignkey:BusinessId"`

	User *User `gorm:"foreignkey:OwnerId"`
}

type FileMetadata struct {
	gorm.Model
	PublicId    string `gorm:"uniqueIndex;not null"`
	OwnerId     uint   `gorm:"not null"`
	ContentType sql.NullString
	Uploaded    sql.NullTime

	User *User `gorm:"foreignkey:OwnerId"`
}

type GPSCoordinates geom.Point

type GormDB interface {
	AddError(err error) error
	Assign(attrs ...interface{}) (tx GormDB)
	Association(column string) *Association
	Attrs(attrs ...interface{}) (tx GormDB)
	AutoMigrate(dst ...interface{}) error
	Begin(opts ...*sql.TxOptions) GormDB
	//tldr we cant use callbacks now
	//Callback() *callbacks
	Clauses(conds ...clause.Expression) (tx GormDB)
	Commit() GormDB
	Connection(fc func(tx GormDB) error) (err error)
	Count(count *int64) (tx GormDB)
	Create(value interface{}) (tx GormDB)
	CreateInBatches(value interface{}, batchSize int) (tx GormDB)
	DB() (*sql.DB, error)
	Debug() (tx GormDB)
	Delete(value interface{}, conds ...interface{}) (tx GormDB)
	Distinct(args ...interface{}) (tx GormDB)
	Exec(sql string, values ...interface{}) (tx GormDB)
	Find(dest interface{}, conds ...interface{}) (tx GormDB)
	FindInBatches(dest interface{}, batchSize int, fc func(tx GormDB, batch int) error) GormDB
	First(dest interface{}, conds ...interface{}) (tx GormDB)
	FirstOrCreate(dest interface{}, conds ...interface{}) (tx GormDB)
	FirstOrInit(dest interface{}, conds ...interface{}) (tx GormDB)
	Get(key string) (interface{}, bool)
	Group(name string) (tx GormDB)
	Having(query interface{}, args ...interface{}) (tx GormDB)
	InnerJoins(query string, args ...interface{}) (tx GormDB)
	InstanceGet(key string) (interface{}, bool)
	InstanceSet(key string, value interface{}) GormDB
	Joins(query string, args ...interface{}) (tx GormDB)
	Last(dest interface{}, conds ...interface{}) (tx GormDB)
	Limit(limit int) (tx GormDB)
	Migrator() Migrator
	Model(value interface{}) (tx GormDB)
	Not(query interface{}, args ...interface{}) (tx GormDB)
	Offset(offset int) (tx GormDB)
	Omit(columns ...string) (tx GormDB)
	Or(query interface{}, args ...interface{}) (tx GormDB)
	Order(value interface{}) (tx GormDB)
	Pluck(column string, dest interface{}) (tx GormDB)
	Preload(query string, args ...interface{}) (tx GormDB)
	Raw(sql string, values ...interface{}) (tx GormDB)
	Rollback() GormDB
	RollbackTo(name string) GormDB
	Row() *sql.Row
	Rows() (*sql.Rows, error)
	Save(value interface{}) (tx GormDB)
	SavePoint(name string) GormDB
	Scan(dest interface{}) (tx GormDB)
	ScanRows(rows *sql.Rows, dest interface{}) error
	Scopes(funcs ...func(GormDB) GormDB) (tx GormDB)
	Select(query interface{}, args ...interface{}) (tx GormDB)
	Session(config *Session) GormDB
	Set(key string, value interface{}) GormDB
	SetupJoinTable(model interface{}, field string, joinTable interface{}) error
	Table(name string, args ...interface{}) (tx GormDB)
	Take(dest interface{}, conds ...interface{}) (tx GormDB)
	ToSQL(queryFn func(tx GormDB) GormDB) string
	Transaction(fc func(tx GormDB) error, opts ...*sql.TxOptions) (err error)
	Unscoped() (tx GormDB)
	Update(column string, value interface{}) (tx GormDB)
	UpdateColumn(column string, value interface{}) (tx GormDB)
	UpdateColumns(values interface{}) (tx GormDB)
	Updates(values interface{}) (tx GormDB)
	Use(plugin Plugin) error
	Where(query interface{}, args ...interface{}) (tx GormDB)
	WithContext(ctx context.Context) GormDB

	GetConfig() *Config
	GetError() error
	GetRowsAffected() int64
	GetStatement() *Statement
}

type GormDBImpl struct {
	Db *DB
}

type ItemDefinition struct {
	gorm.Model
	PublicId    string `gorm:"uniqueIndex;not null"`
	BusinessId  uint   `gorm:"not null"`
	Name        string `gorm:"not null"`
	Price       uint   `gorm:"not null"`
	Description string `gorm:"not null"`
	ImageId     string `gorm:"unique"`
	StartDate   sql.NullTime
	EndDate     sql.NullTime
	MaxAmount   uint
	Available   bool `gorm:"not null"`
	Withdrawn   bool `gorm:"not null"`

	OwnedItems []OwnedItem `gorm:"foreignkey:DefinitionId"`

	Business *Business `gorm:"foreignkey:BusinessId"`
}

type LocalCard struct {
	gorm.Model
	PublicId string `gorm:"uniqueIndex;not null"`
	OwnerId  uint
	Type     string
	Code     string
	Name     string

	User *User `gorm:"foreignkey:OwnerId"`
}

type MenuImage struct {
	gorm.Model
	BusinessId uint   `gorm:"uniqueIndex:menu_item_idx;not null"`
	FileId     string `gorm:"uniqueIndex:menu_item_idx;not null"`

	Business *Business `gorm:"foreignkey:BusinessId"`
}

type OwnedItem struct {
	gorm.Model
	PublicId      string `gorm:"uniqueIndex;not null"`
	DefinitionId  uint   `gorm:"not null"`
	VirtualCardId uint   `gorm:"not null"`
	Used          sql.NullTime
	Status        OwnedItemStatusEnum `gorm:"default:OWNED;not null"`

	ItemDefinition *ItemDefinition `gorm:"foreignkey:DefinitionId"`
	VirtualCard    *VirtualCard    `gorm:"foreignkey:VirtualCardId"`
}

type OwnedItemStatusEnum string

type Token struct {
	gorm.Model
	OwnerId      uint
	TokenId      string           `gorm:"uniqueIndex;not null"`
	TokenHash    string           `gorm:"not null"`
	Expires      time.Time        `gorm:"not null"`
	TokenPurpose TokenPurposeEnum `gorm:"not null"`
	Used         bool             `gorm:"default:false;not null"`
	Recalled     bool             `gorm:"default:false;not null"`

	User *User `gorm:"foreignkey:OwnerId"`
}

type TokenPurposeEnum string

type Transaction struct {
	gorm.Model
	PublicId      string               `gorm:"uniqueIndex;not null"`
	VirtualCardId uint                 `gorm:"index:code,unique,priority:1;not null"`
	Code          string               `gorm:"index:code,unique,priority:2;not null"`
	State         TransactionStateEnum `gorm:"default:STARTED;not null"`
	AddedPoints   uint

	TransactionDetails []TransactionDetail `gorm:"foreignkey:TransactionId"`

	VirtualCard *VirtualCard `gorm:"foreignkey:VirtualCardId"`
}

type TransactionDetail struct {
	gorm.Model
	TransactionId uint           `gorm:"index:transaction_detail,unique,priority:1;not null"`
	ItemId        uint           `gorm:"index:transaction_detail,unique,priority:2;not null"`
	Action        ActionTypeEnum `gorm:"default:NO_ACTION;not null"`

	Transaction *Transaction `gorm:"foreignkey:TransactionId"`
	OwnedItem   *OwnedItem   `gorm:"foreignkey:ItemId"`
}

type TransactionStateEnum string

type User struct {
	gorm.Model
	PublicId string `gorm:"uniqueIndex;not null"`
	//FirstName     string `gorm:"not null"`
	//LastName      string `gorm:"not null"`
	Email         string `gorm:"uniqueIndex;not null"`
	PasswordHash  string `gorm:"not null"`
	EmailVerified bool   `gorm:"default:false;not null"`

	Tokens        []Token        `gorm:"foreignkey:OwnerId"`
	FilesMetadata []FileMetadata `gorm:"foreignkey:OwnerId"`
	LocalCards    []LocalCard    `gorm:"foreignkey:OwnerId"`
	VirtualCards  []VirtualCard  `gorm:"foreignkey:OwnerId"`
	Business      *Business      `gorm:"foreignkey:OwnerId"`
}

type VirtualCard struct {
	gorm.Model
	PublicId   string `gorm:"uniqueIndex;not null"`
	OwnerId    uint   `gorm:"not null"`
	BusinessId uint   `gorm:"not null"`
	Points     uint   `gorm:"not null"`

	OwnedItems   []OwnedItem   `gorm:"foreignkey:VirtualCardId"`
	Transactions []Transaction `gorm:"foreignkey:VirtualCardId"`

	Business *Business `gorm:"foreignkey:BusinessId"`
	User     *User     `gorm:"foreignkey:OwnerId"`
}