Beispiel #1
0
func LoadPayments(limit uint) []*Payment {
	rows, err := db.QueryAll(Payment{},
		`SELECT `+PaymentModel.FieldsSimple+` FROM payment
         ORDER BY id DESC LIMIT ?`,
		limit,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Payment)
}
Beispiel #2
0
// Loads payments associated with a given block(hash),
// regardless of orphaned/spent status.
func LoadPaymentsByBlockhash(blockhash string) []*Payment {
	rows, err := db.QueryAll(Payment{},
		`SELECT `+PaymentModel.FieldsSimple+` FROM payment
         WHERE blockhash=?`,
		blockhash,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Payment)
}
Beispiel #3
0
func LoadLastBlocks(coin string, n uint32) []*Block {
	rows, err := db.QueryAll(Block{},
		`SELECT `+BlockModel.FieldsSimple+` FROM block
         WHERE coin=? AND (status=0 OR status=1 OR status=10)
         ORDER BY height DESC LIMIT ?`,
		coin, n,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Block)
}
Beispiel #4
0
func LoadAPIKeysByUser(userId int64) []*APIKey {
	rows, err := db.QueryAll(APIKey{},
		`SELECT `+APIKeyModel.FieldsSimple+`
         FROM auth_api_key
         WHERE user_id=?`,
		userId,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*APIKey)
}
Beispiel #5
0
func LoadAddressesByMPK(mpkId int64) []*Address {
	rows, err := db.QueryAll(Address{},
		`SELECT `+AddressModel.FieldsSimple+`
         FROM address WHERE mpk_id=?
         ORDER BY (chain_path, chain_idx) ASC`,
		mpkId,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Address)
}
Beispiel #6
0
func LoadSpendablePaymentsByAmount(mpkId int64, coin string, min, max uint64, reqHeight uint32, limit uint) []*Payment {
	rows, err := db.QueryAll(Payment{},
		`SELECT `+PaymentModel.FieldsSimple+` FROM payment
         WHERE mpkId=? AND coin=? AND spent=0 AND orphaned=0 AND ?<=amount AND amount<=? AND blockheight>0 AND blockheight<=?
         ORDER BY amount ASC LIMIT ?`,
		mpkId, coin, min, max, reqHeight, limit,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Payment)
}
Beispiel #7
0
func LoadAddressesByWallet(userId int64, wallet string) []*Address {
	rows, err := db.QueryAll(Address{},
		`SELECT `+AddressModel.FieldsSimple+`
         FROM address
         WHERE user_id=? AND wallet=?`,
		userId, wallet,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Address)
}
Beispiel #8
0
func LoadWithdrawals(limit uint) []*Withdrawal {
	rows, err := db.QueryAll(Withdrawal{},
		`SELECT `+WithdrawalModel.FieldsSimple+`
         FROM account_withdrawal
         ORDER BY id DESC LIMIT ?`,
		limit,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Withdrawal)
}
Beispiel #9
0
func LoadBalancesByWallet(userId int64, wallet string) []*Balance {
	rows, err := db.QueryAll(Balance{},
		`SELECT `+BalanceModel.FieldsSimple+`
         FROM account_balance
         WHERE user_id=? AND wallet=?`,
		userId, wallet,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Balance)
}
Beispiel #10
0
func LoadWithdrawalsByUser(userId int64, coin string, limit uint) []*Withdrawal {
	rows, err := db.QueryAll(Withdrawal{},
		`SELECT `+WithdrawalModel.FieldsSimple+`
         FROM account_withdrawal
         WHERE user_id=? AND coin=?
         ORDER BY id DESC LIMIT ?`,
		userId, coin, limit,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Withdrawal)
}
Beispiel #11
0
// This is for loading pending orders upon app init,
//  for orders that were saved but didn't go through the processor.
// NOTE: don't try to add a limit // paginate here, unless you understand why this notice is here.
func LoadPendingOrdersSince(basisCoin string, coin string, startOrderId int64) []*Order {
	rows, err := db.QueryAll(Order{},
		`SELECT `+OrderModel.FieldsSimple+`
         FROM exchange_order
         WHERE basis_coin=? AND coin=? AND status=0 AND id>=?
         ORDER BY id ASC`,
		basisCoin, coin, startOrderId,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Order)
}
Beispiel #12
0
func LoadPendingOrdersByUser(userId int64, basisCoin string, coin string) (orders []*Order) {
	rows, err := db.QueryAll(Order{},
		`SELECT `+OrderModel.FieldsSimple+`
         FROM exchange_order
         WHERE status=0 AND user_id=? AND basis_coin=? AND coin=?
         ORDER BY price ASC`,
		userId, basisCoin, coin,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Order)
}
Beispiel #13
0
func LoadDepositsByWalletAndCoin(userId int64, wallet string, coin string, limit uint) []*Deposit {
	rows, err := db.QueryAll(Deposit{},
		`SELECT `+DepositModel.FieldsSimple+`
         FROM account_deposit
         WHERE user_id=? AND wallet=? AND coin=?
         ORDER BY time DESC LIMIT ?`,
		userId, wallet, coin, limit,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Deposit)
}
Beispiel #14
0
func LoadPriceLogs(market string, interval int64, startTime int64, endTime int64) []*PriceLog {
	rows, err := db.QueryAll(PriceLog{},
		`SELECT `+PriceLogModel.FieldsSimple+`
         FROM exchange_price_log
         WHERE market=? AND interval=? AND ?<=time AND time<?
         ORDER BY time ASC`,
		market, interval, startTime, endTime,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*PriceLog)
}
Beispiel #15
0
func LoadTradesByUser(userId int64, limit uint) []*Trade {
	rows, err := db.QueryAll(Trade{},
		`SELECT `+TradeModel.FieldsSimple+`
         FROM exchange_trade
         WHERE (bid_user_id=? OR ask_user_id=?)
         ORDER BY time DESC LIMIT ?`,
		userId, userId, limit,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Trade)
}
Beispiel #16
0
func LoadLastPriceLogs(market string, interval int64, limit int) []*PriceLog {
	rows, err := db.QueryAll(PriceLog{},
		`SELECT `+PriceLogModel.FieldsSimple+`
         FROM exchange_price_log
         WHERE market=? AND interval=?
         ORDER BY time DESC LIMIT ?`,
		market, interval, limit,
	)
	if err != nil {
		panic(err)
	}
	plogs := rows.([]*PriceLog)
	for i := 0; i < len(plogs)/2; i++ {
		plogs[i] = plogs[len(plogs)-1-i]
	} // time ASC order
	return plogs
}
Beispiel #17
0
// See comment for LoadLimitBids.
// To load the best asks, set minPrice to 0.
func LoadLimitAsks(basisCoin string, coin string, limit int, minPrice float64, minId int64, maxId int64) (asks []*Order, hasMore bool) {
	rows, err := db.QueryAll(Order{},
		`SELECT `+OrderModel.FieldsSimple+`
         FROM exchange_order
         WHERE basis_coin=? AND coin=? AND type='A' AND status=0 AND (price, id) > (?, ?) AND id<=?
         ORDER BY price ASC, id ASC LIMIT ?`,
		basisCoin, coin, minPrice, minId, maxId, limit+1,
	)
	if err != nil {
		panic(err)
	}
	asks = rows.([]*Order)
	if len(asks) == limit+1 {
		return asks[:len(asks)-1], true
	} else {
		return asks, false
	}
}
Beispiel #18
0
func LoadKnownAddresses(addrStrs []string) []*Address {
	if len(addrStrs) == 0 {
		return nil
	}
	var addrStrs_i []interface{}
	for _, addrStr := range addrStrs {
		addrStrs_i = append(addrStrs_i, addrStr)
	}
	// TODO: consider limitations on placeholder count. 65536?
	addrsPH := "?" + strings.Repeat(",?", len(addrStrs)-1)
	rows, err := db.QueryAll(Address{},
		`SELECT `+AddressModel.FieldsSimple+`
         FROM address WHERE address in (`+addrsPH+`)`,
		addrStrs_i...,
	)
	if err != nil {
		panic(err)
	}
	return rows.([]*Address)
}