本文整理汇总了Golang中ftnox/com/db.MConn类的典型用法代码示例。如果您正苦于以下问题:Golang MConn类的具体用法?Golang MConn怎么用?Golang MConn使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了MConn类的9个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Golang代码示例。
示例1: UpdatePayment
func UpdatePayment(c db.MConn, p *Payment) {
p.Updated = time.Now().Unix()
_, err := c.Exec(
`UPDATE payment SET blockhash=?, blockheight=?, orphaned=?, time=?, updated=? WHERE tx_id=? AND vout=?`,
p.Blockhash, p.Blockheight, p.Orphaned, p.Time, p.Updated, p.TxId, p.Vout,
)
if err != nil {
panic(err)
}
}
示例2: SaveBalance
func SaveBalance(c db.MConn, balance *Balance) *Balance {
_, err := c.Exec(
`INSERT INTO account_balance (`+BalanceModel.FieldsInsert+`)
VALUES (`+BalanceModel.Placeholders+`)`,
balance,
)
if err != nil {
panic(err)
}
return balance
}
示例3: SavePayment
func SavePayment(c db.MConn, p *Payment) (*Payment, error) {
if p.Time == 0 {
p.Time = time.Now().Unix()
}
err := c.QueryRow(
`INSERT INTO payment (`+PaymentModel.FieldsInsert+`)
VALUES (`+PaymentModel.Placeholders+`)
RETURNING id`,
p,
).Scan(&p.Id)
return p, err
}
示例4: LoadWithdrawalsByStatus
func LoadWithdrawalsByStatus(c db.MConn, coin string, status int32, limit uint) []*Withdrawal {
rows, err := c.QueryAll(Withdrawal{},
`SELECT `+WithdrawalModel.FieldsSimple+`
FROM account_withdrawal
WHERE status=? AND coin=?
ORDER BY id ASC LIMIT ?`,
status, coin, limit,
)
if err != nil {
panic(err)
}
return rows.([]*Withdrawal)
}
示例5: LoadWithdrawal
func LoadWithdrawal(c db.MConn, id int64) *Withdrawal {
var wth Withdrawal
err := c.QueryRow(
`SELECT `+WithdrawalModel.FieldsSimple+`
FROM account_withdrawal
WHERE id=?`,
id,
).Scan(&wth)
if err != nil {
panic(err)
}
return &wth
}
示例6: LoadDepositForPayment
func LoadDepositForPayment(c db.MConn, paymentId int64) *Deposit {
var dep Deposit
err := c.QueryRow(
`SELECT `+DepositModel.FieldsSimple+`
FROM account_deposit
WHERE payment_id=?`,
paymentId,
).Scan(&dep)
if err != nil {
panic(err)
}
return &dep
}
示例7: SaveDeposit
// Might throw an error if the deposit already exists.
func SaveDeposit(c db.MConn, dep *Deposit) (*Deposit, error) {
if dep.Time == 0 {
dep.Time = time.Now().Unix()
}
// Add to DB
err := c.QueryRow(
`INSERT INTO account_deposit (`+DepositModel.FieldsInsert+`)
VALUES (`+DepositModel.Placeholders+`)
RETURNING id`,
dep,
).Scan(&dep.Id)
return dep, err
}
示例8: SaveTransfer
func SaveTransfer(c db.MConn, trans *Transfer) *Transfer {
if trans.Time == 0 {
trans.Time = time.Now().Unix()
}
err := c.QueryRow(
`INSERT INTO account_transfer (`+TransferModel.FieldsInsert+`)
VALUES (`+TransferModel.Placeholders+`)
RETURNING id`,
trans,
).Scan(&trans.Id)
if err != nil {
panic(err)
}
return trans
}
示例9: SaveWithdrawal
func SaveWithdrawal(c db.MConn, wth *Withdrawal) *Withdrawal {
if wth.Time == 0 {
wth.Time = time.Now().Unix()
}
// Add to DB
err := c.QueryRow(
`INSERT INTO account_withdrawal (`+WithdrawalModel.FieldsInsert+`)
VALUES (`+WithdrawalModel.Placeholders+`)
RETURNING id`,
wth,
).Scan(&wth.Id)
if err != nil {
panic(err)
}
return wth
}