我如何使用golang go-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"})

不是addRow