cbservicermodel.go 971 B

12345678910111213141516171819202122232425262728293031323334353637
  1. package model
  2. import (
  3. "fmt"
  4. "github.com/zeromicro/go-zero/core/stores/sqlx"
  5. )
  6. var _ CbServicerModel = (*customCbServicerModel)(nil)
  7. type (
  8. // CbServicerModel is an interface to be customized, add more methods here,
  9. // and implement the added methods in customCbServicerModel.
  10. CbServicerModel interface {
  11. cbServicerModel
  12. GetServicer(openKfid, userid string) (d *CbServicer, err error)
  13. }
  14. customCbServicerModel struct {
  15. *defaultCbServicerModel
  16. }
  17. )
  18. // NewCbServicerModel returns a model for the database table.
  19. func NewCbServicerModel(conn sqlx.SqlConn) CbServicerModel {
  20. return &customCbServicerModel{
  21. defaultCbServicerModel: newCbServicerModel(conn),
  22. }
  23. }
  24. func (m *customCbServicerModel) GetServicer(openKfid, userid string) (d *CbServicer, err error) {
  25. query := fmt.Sprintf("select * from %s where `open_kfid` = ? AND `userid` = ? limit 1", m.table)
  26. var resp CbServicer
  27. err = m.conn.QueryRow(&resp, query, openKfid, userid)
  28. d = &resp
  29. return
  30. }