如何使用带有可变数量参数的go-sqlmock WithArgs（）？

I use go-sqlmock ( https://godoc.org/github.com/DATA-DOG/go-sqlmock ) to test a function that receives a variable number of arguments (I simplified the function for the sake of simplicity and stripped out most of the code):

func getHits(db *sql.DB, actions ...string) (hits []Hit, err error) {
   // ...
   query := `select * from table where action in (?,?)`
   rows, err := db.Query(query, actions)
   // ...
The tests look like that:
// rows := ...
actions := []string{"click", "event"}
mock.ExpectQuery(`^select .*`).WithArgs(actions).WillReturnRows(rows)
hits, err := getHits(db, actions...)
if mockErr := mock.ExpectationsWereMet(); mockErr != nil {
    log.Fatalf("there were unfulfilled expections: %s", mockErr)
Then I get this output:
2017/12/21 10:38:23 there were unfulfilled expections: there is a remaining expectation which was not matched: ExpectedQuery => expecting Query or QueryRow which:
- matches sql: '^select .*'
- is with arguments:
  0 - [click event]
- should return rows: ...
If I change the tests like this:
mock.ExpectQuery(`^select .*`).WithArgs(actions[0], actions[1]).WillReturnRows(rows)
Then I get this output:
2017/12/21 10:44:41 there were unfulfilled expections: there is a remaining expectation which was not matched: ExpectedQuery => expecting Query or QueryRow which:
- matches sql: '^select .*'
- is with arguments:
  0 - click
  1 - event
- should return rows:
The only I can make it pass is by calling :
db.Query(query, actions[0], actions[1])
which is what I obviously don't want to do as I don't know the number of actions...
Does anyone have an idea on how I could fix or debug this ?
        0 提建议
     
 微信扫一扫
 
 
点击复制链接
 
 分享
 
 邀请回答
    
 
 
编辑 收藏 删除 结题
 
 
收藏 举报
  
追加酬金 (90%的用户在追加酬金后获得了解决方案)
 
 
当前问题酬金
 
¥ 0 
            (可追加 ¥500）
          
 
 
支付方式
 
 
扫码支付 
 
 
   
 
 
 
 
加载中...
      
 

          
 
提供问题酬金的用户不参与问题酬金结算和分配
 

            支付即为同意
            《付费问题酬金结算规则》
  
结题 再想想
 
删除 再等等