mysql - 我如何使用 golang go-sqlmock sqlmock 空集

Question

我想测试一些 SQL:

select name from user where uid = ?

没关系，我可以这样模拟它:

rows := sqlmock.NewRows([]string{“name"}).AddRow(“info")

did = "1234"
mock.ExpectPrepare(“select name from user where uid = ?").ExpectQuery().
       WithArgs(uid).
       WillReturnRows(rows)

但是我想模拟用户表没有这个 uid 的测试——select 将返回一个空集

mysql> select * from user where uid = “887";
Empty set (0.00 sec)

mysql>

如何模拟一个空表？

Answer 1

rows := sqlmock.NewRows([]string{“name"})

不是添加行