无法让测试适用于 INSERT 语句

小伙伴们对Golang编程感兴趣吗？是否正在学习相关知识点？如果是，那么本文《无法让测试适用于 INSERT 语句》，就很适合你，本篇文章讲解的知识点主要包括。在之后的文章中也会多多分享相关知识点，希望对大家的知识积累有所帮助！

我们花了两周令人沮丧的时间尝试使用 sqlmock 的函数和方法的每一种可能的排列，但无法对 insert 语句进行测试。这是非常基本的妈妈和流行 sql。只是使用 gorm 进行简单的插入。

要发布的代码太多，而且这里列出了许多错误和方法的排列，但我将发布最新的。

type anytime struct{}

func (a anytime) match(v driver.value) bool {
    _, ok := v.(time.time)
    return ok
}

func testinsertstoragepool(t *testing.t) {

    cases := []struct {
        givenpool    storagepool
        wantederror  error
    }{
        {
            givenpool: storagepool{
                name:   "pool1",
                poolid: "1",
                type:   "networkfilesystem",
                volumes: []volume{
                    {
                        name:      "vol01",
                        storageid: "1",
                        type:      "root",
                        volumeid:  "1",
                    },
                },
            },
            wantederror: nil,
        },
    }

    for _, c := range cases {

        db, mock, err := sqlmock.new()
        if err != nil {
            t.fatal(err)
        }

        // every attempt we make we try "postgres", "mysql" and "sqlite3" here
        db, err := gorm.open("sqlite3", db)
        if err != nil {
            t.fatal(err)
        }
        db.logmode(true)

        mock.expectbegin()
        mock.expectexec(`insert into "storage_pools"`).withargs(
            anytime{},
            anytime{},
            nil,
            0,
            0,
            "",
            "",
            "",
            0,
            0,
            0,
            "",
            c.givenpool.name,
            "",
            0,
            "",
            "",
            c.givenpool.poolid,
            "",
            "",
            "",
            c.givenpool.type,
            "",
            "").willreturnresult(sqlmock.newresult(1, 1))

        mock.expectcommit()

        err = insertstoragepool(db, &c.givenpool)
        if err != nil {
            fmt.fprintf(os.stderr, "error: %s\n", err)
        }

        if !reflect.deepequal(err, c.wantederror) {
            t.errorf("expecting errror %q, got %q", c.wantederror, err)
        }

    }

}

此尝试的错误：

$go test ./...

(/database.go:231)
[2019-12-13 09:22:48]  [0.11ms]  INSERT  INTO "storage_pools" ("created_at","updated_at","deleted_at","allocatediops","capacityiops","clusterid","clustername","created","disksizeallocated","disksizetotal","disksizeused","ipaddress","name","path","physicalsize","podid","podname","poolid","provider","scope","state","type","zoneid","zonename") VALUES ('2019-12-13 09:22:48','2019-12-13 09:22:48',NULL,0,0,'','','',0,0,0,'','POOL1','',0,'','','1','','','','NetworkFilesystem','','')
[1 rows affected or returned ]

(/database.go:231)
[2019-12-13 09:22:48]  call to ExecQuery 'INSERT  INTO "volumes" ("created_at","updated_at","deleted_at","clusterid","clustername","domainid","domain","name","path","physicalsize","podid","podname","size","state","storageid","storage","type","virtualsize","virtualmachineid","vmdisplayname","vmname","vmstate","volumeid","zoneid","zonename") VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)' with args [{Name: Ordinal:1 Value:2019-12-13 09:22:48.093749 -0800 PST m=+0.004941653} {Name: Ordinal:2 Value:2019-12-13 09:22:48.093749 -0800 PST m=+0.004941653} {Name: Ordinal:3 Value:} {Name: Ordinal:4 Value:} {Name: Ordinal:5 Value:} {Name: Ordinal:6 Value:} {Name: Ordinal:7 Value:} {Name: Ordinal:8 Value:VOL01} {Name: Ordinal:9 Value:} {Name: Ordinal:10 Value:0} {Name: Ordinal:11 Value:} {Name: Ordinal:12 Value:} {Name: Ordinal:13 Value:0} {Name: Ordinal:14 Value:} {Name: Ordinal:15 Value:1} {Name: Ordinal:16 Value:} {Name: Ordinal:17 Value:ROOT} {Name: Ordinal:18 Value:0} {Name: Ordinal:19 Value:} {Name: Ordinal:20 Value:} {Name: Ordinal:21 Value:} {Name: Ordinal:22 Value:} {Name: Ordinal:23 Value:1} {Name: Ordinal:24 Value:} {Name: Ordinal:25 Value:}], was not expected, next expectation is: ExpectedCommit => expecting transaction Commit

解决方案

错误消息告诉您在您期望的插入之后正在执行附加插入：

在您的代码中，我们可以看到您的 StoragePool 结构在切片中也有一些 volumes 。

因此，当您调用 InsertStoragePool 时，可能首先将一行插入到 storage_pools 中，然后插入 volumes 。

在添加提交的期望之前，您应该为该插入添加新的期望。

今天关于《无法让测试适用于 INSERT 语句》的内容介绍就到此结束，如果有什么疑问或者建议，可以在golang学习网公众号下多多回复交流；文中若有不正之处，也希望回复留言以告知！