Go sqlmock SELECT 缺少预期查询

有志者，事竟成！如果你在学习Golang，那么本文《Go sqlmock SELECT 缺少预期查询》，就很适合你！文章讲解的知识点主要包括，若是你对本文感兴趣，或者是想搞懂其中某个知识点，就请你继续往下看吧~

去这里。试图弄清楚如何使用 sql 模拟 v2。

这是我的界面：

type orderpersister interface {
    fetchorderbyid(string) (*order, error)
}

以及我对该接口的实现：

type dbpersister struct {
    config config.dbconfig
    gormdb *gorm.db
}

func (op dbpersister) fetchorderbyid(orderid string) (*order, error) {
    order := &order{}

    orderuuid, err := uuid.parse(orderid)
    if err != nil {
        return nil, err
    }

    if err := op.gormdb.table("orders").
        select(`orders.order_id,
            orders.user_id,
            orders.quantity,
            orders.status
            addresses.line_1,
            users.email`).
        joins("join addresses on addresses.address_id = orders.address_id").
        joins("join users on users.user_id = orders.user_id").
        where("orders.order_id = ?", orderuuid).
        first(order).error; err != nil {
        return nil, err
    }

    return order, nil
}

还有我的单元测试（包括设置/初始化）：

import (
    "database/sql"
    "testing"

    "github.com/google/uuid"
    "github.com/jinzhu/gorm"
    "github.com/stretchr/testify/require"
    "github.com/stretchr/testify/suite"
    "gopkg.in/data-dog/go-sqlmock.v2"
)

type suite struct {
    suite.suite
    db   *gorm.db
    mock sqlmock.sqlmock

    dbpersister orderpersister
}

func (s *suite) setupsuite() {
    var (
        db  *sql.db
        err error
    )

    db, s.mock, err = sqlmock.new()
    require.noerror(s.t(), err)

    s.db, err = gorm.open("postgres", db)
    require.noerror(
        s.t(), err)

    s.db.logmode(true)

    s.dbpersister = dbpersister{
        config: config.dbconfig{
            dbhost:     "",
            dbport:     "",
            dbname:     "",
            dbusername: "",
            dbpassword: "",
        },
        gormdb: s.db,
    }
}

func (s *suite) beforetest(_, _ string) {
    var (
        db  *sql.db
        err error
    )

    db, s.mock, err = sqlmock.new()
    require.noerror(s.t(), err)

    s.db, err = gorm.open("postgres", db)
    require.noerror(s.t(), err)

    s.db.logmode(true)
}

func (s *suite) aftertest(_, _ string) {
    require.noerror(s.t(), s.mock.expectationsweremet())
}

func testinit(t *testing.t) {
    suite.run(t, new(suite))
}

func (s *suite) testfetchorderbyid() {

  // given
    orderid := uuid.new()
  quantity := 1
  status := "ready"
    line1 := "201"
  email := "[email protected]"

  // s.mock.expectbegin()
    s.mock.expectquery(`select`).
        willreturnrows(sqlmock.newrows([]string{"orders.order_id","orders.user_id","orders.quantity","orders.status",
                "addresses.line_1","user_logins.email"}).
            addrow(sqlmock.anyarg(), sqlmock.anyarg(), quantity, status, totalexcltax, shippingexcltax,
                totaltaxamt, line1, state, zip, locality, upc, email, firstname, lastname))
    _, err := s.dbpersister.fetchorderbyid(orderid.string())
  s.mock.expectcommit()
    require.noerror(s.t(), err)
}

当运行时，测试因以下原因失败：

--- FAIL: TestInit (0.00s)
  --- FAIL: TestInit/TestFetchOrderById (0.00s)
    db_test.go:67: 
        Error Trace:    db_test.go:67
                                suite.go:137
                                panic.go:969
                                rows.go:134
                                db_test.go:99
        Error:          Received unexpected error:
                        there is a remaining expectation which was not matched: ExpectedQuery => expecting Query, QueryContext or QueryRow which:
                          - matches sql: 'SELECT'
                          - is without arguments
        Test:           TestInit/TestFetchOrderById

我要做的就是确认 gormdb 实例是使用 fetchorderbyid 函数中指定的 select 语句进行查询的。

有人知道我需要做什么才能实现这一目标并通过测试吗？

解决方案

我决定改用 Java（没有双关语）。

今天关于《Go sqlmock SELECT 缺少预期查询》的内容介绍就到此结束，如果有什么疑问或者建议，可以在golang学习网公众号下多多回复交流；文中若有不正之处，也希望回复留言以告知！