model

type BalanceSheet struct {
	Code                string    `db:"code"`
	Date                time.Time `db:"date"`
	TotalAsset          float64   `db:"total_asset"`
	TotalLiability      float64   `db:"total_liability"`
	CurrentAsset        float64   `db:"current_asset"`
	NonCurrentAsset     float64   `db:"non_current_asset"`
	CurrentLiability    float64   `db:"current_liability"`
	NonCurrentLiability float64   `db:"non_current_liability"`
	OwnersEquity        float64   `db:"owners_equity"`
	Cash                float64   `db:"cash"`
	Receivable          float64   `db:"receivable"`
	Inventory           float64   `db:"inventory"`
	OtherCurrentAsset   float64   `db:"other_current_asset"`
	Goodwill            float64   `db:"goodwill"`
	Payable             float64   `db:"payable"`
	CreatedAt           time.Time `db:"created_at"`
	UpdatedAt           time.Time `db:"updated_at"`
}

type BalanceSheets []BalanceSheet

type CashFlow struct {
	Code              string    `db:"code"`
	Date              time.Time `db:"date"`
	OperatingInflow   float64   `db:"operating_inflow"`
	OperatingOutflow  float64   `db:"operating_outflow"`
	OperatingNet      float64   `db:"operating_net"`
	InvestmentInflow  float64   `db:"investment_inflow"`
	InvestmentOutflow float64   `db:"investment_outflow"`
	InvestmentNet     float64   `db:"investment_net"`
	FinancingInflow   float64   `db:"financing_inflow"`
	FinancingOutflow  float64   `db:"financing_outflow"`
	FinancingNet      float64   `db:"financing_net"`
	InitialBalance    float64   `db:"initial_balance"`
	EndingBalance     float64   `db:"ending_balance"`
	CreatedAt         time.Time `db:"created_at"`
	UpdatedAt         time.Time `db:"updated_at"`
}

type CashFlows []CashFlow

type Holder struct {
	Code      string    `db:"code"`
	Name      string    `db:"name"`
	CreatedAt time.Time `db:"created_at"`
}

type Holders []Holder

type Holding struct {
	HolderCode string    `db:"holder_code"`
	StockCode  string    `db:"stock_code"`
	Date       time.Time `db:"date"`
	Quantity   int64     `db:"quantity"`
	Ratio      float64   `db:"ratio"`
	CreatedAt  time.Time `db:"created_at"`
	UpdatedAt  time.Time `db:"updated_at"`
}

type Holdings []Holding

type Industries []Industry

type Industry struct {
	Code string `db:"code"`
	Name string `db:"name"`
}

type KV map[string]interface{}

type Market struct {
	Code            string    `db:"code"`
	Date            time.Time `db:"date"`
	IssueVolume     int32     `db:"issue_volume"`
	MarketValue     float64   `db:"market_value"`
	NegotiableValue float64   `db:"negotiable_value"`
	TradeAmount     float64   `db:"amount"`
	PE              float64   `db:"pe"`
	TurnoverRate    float64   `db:"ex"`
	CreatedAt       time.Time `db:"created_at"`
	UpdatedAt       time.Time `db:"updated_at"`
}

type Markets []Market

type Model interface {
	TableName() string
	Columns() []string
	InsertBuilder() *sqlbuilder.InsertBuilder
	SelectBuilder() *sqlbuilder.SelectBuilder
	UpdateBuilder() *sqlbuilder.UpdateBuilder
	DeleteBuilder() *sqlbuilder.DeleteBuilder
}

type Models interface {
	SelectBuilder() *sqlbuilder.SelectBuilder
}

type OrderBy struct {
	Column string
	Asc    bool // default is false which means DESC
}

type Pagination struct {
	Offset int
	Limit  int
}

type ProfitStatement struct {
	Code                    string    `db:"code"`
	Date                    time.Time `db:"date"`
	Income                  float64   `db:"income"`
	Cost                    float64   `db:"cost"`
	OperatingCost           float64   `db:"operating_cost"`
	SellingExpense          float64   `db:"selling_expense"`
	AdminExpense            float64   `db:"admin_expense"`
	FinancialExpense        float64   `db:"financial_expense"`
	OperatingProfit         float64   `db:"operating_profit"`
	TotalProfit             float64   `db:"total_profit"`
	NetProfit               float64   `db:"net_profit"`
	OtherConsolidatedIncome float64   `db:"other_consolidated_income"`
	TotalConsolidatedIncome float64   `db:"total_consolidated_income"`
	CreatedAt               time.Time `db:"created_at"`
	UpdatedAt               time.Time `db:"updated_at"`
}

type ProfitStatements []ProfitStatement

type Result struct {
	Inserted bool
	Updated  bool
}

type Stock struct {
	Code            string    `db:"code"`
	Name            string    `db:"name"`
	MarketValue     float64   `db:"market_value"`
	NegotiableValue float64   `db:"negotiable_value"`
	OpeningPrice    float64   `db:"open"`
	ClosingPrice    float64   `db:"close"`
	BottomPrice     float64   `db:"low"`
	TopPrice        float64   `db:"high"`
	LastPrice       float64   `db:"last"`
	ChangeRate      float64   `db:"rate"`
	TurnoverRate    float64   `db:"ex"`
	TradeAmount     float64   `db:"amount"`
	TradeVolume     int64     `db:"volume"`
	PB              float64   `db:"pb"`
	PE              float64   `db:"pe"`
	IndustryCode    string    `db:"industry_code"`
	CreatedAt       time.Time `db:"created_at"`
	UpdatedAt       time.Time `db:"updated_at"`
}

type Stocks []Stock