登录
首页 >  Golang >  Go问答

无法让测试适用于 INSERT 语句

来源:stackoverflow

时间:2024-04-27 18:45:36 333浏览 收藏

小伙伴们对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学习网公众号下多多回复交流;文中若有不正之处,也希望回复留言以告知!

声明:本文转载于:stackoverflow 如有侵犯,请联系study_golang@163.com删除
相关阅读
更多>
最新阅读
更多>
课程推荐
更多>