How do I sqlmock an empty set using golang go-sqlmock

Question

I want to test some SQL like:

select name from user where uid = ?

This is ok, I can mock it like this way:

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

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

But I want to mock the testing in which the user table does not have this uid — the select will return a Empty set

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

mysql>

How can I mock an empty table?

Andrew Whitaker · Accepted Answer · 2022-05-10 02:33:37Z

14

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

not addRow

edited May 10, 2022 at 2:33

Andrew Whitaker

126k32 gold badges296 silver badges308 bronze badges

answered May 3, 2017 at 1:55

wangze

2312 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bruno Oliveira Over a year ago

You could also not assign the NewRows() to an unused variable rows

Collectives™ on Stack Overflow

How do I sqlmock an empty set using golang go-sqlmock

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related