Skip to content

WithArgs doesn't work properly #275

Open
@glenshappy

Description

@glenshappy

Hi, guys, i wrote one pice of code as below, but i couldn't use WithArgs like this:
mock.ExpectQuery(query2).WithArgs(122).WillReturnRows(rs2),so i have to use it like this:

query2:= "SELECT (.+) as count FROM payment p, purchase_order po WHERE p.order_id = po.id AND p.order_id = "+strconv.Itoa(orderId)+" ORDER BY p.payment_date DESC "

Is there anything wrong with this code?Thx

`

func TestOrderList(t *testing.T) {
t.Parallel()
orderModel := CreateOrderFactory(t)
defer db.Close()

var orderId = 122

rs1 := sqlmock.NewRows([]string{"id", "order_id","user_id"}).AddRow(12, orderId,133)
rs2 := sqlmock.NewRows([]string{"count"}).AddRow(1223)

query1 := "SELECT p.*, po.user_id FROM payment p, purchase_order po"

query2:= "SELECT (.+) as count FROM payment p, purchase_order po WHERE p.order_id = po.id AND p.order_id = "+strconv.Itoa(orderId)+" ORDER BY p.payment_date DESC "

mock.ExpectQuery(query1).WillReturnRows(rs1)

mock.ExpectQuery(query2).WillReturnRows(rs2)


count, l := orderModel.List(orderId, 1, -1, 12,11, "[email protected]", "d","d")


if err := mock.ExpectationsWereMet(); err != nil {
	t.Fatalf("there were unfulfilled expectations: %s", err)
}

}

`

Metadata

Metadata

Assignees

No one assigned

    Labels

    needs-infoMore information was requested to address this item

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions