How to properly mock qrm.DB so that it works with jet Query method about jet HOT 2 CLOSED

Oh, I see the point behind that but that would need to refactor a bit the code. However, I tested sqlmock with go-jet and it works fine. So you can proceed closing this issue.

from jet.

My suggestion would be not to mock the database. It adds unnecessary complexity to the project, for very little or no gain at all. Also every test that mocks database can be written without mock.
For instance:

func SomeServiceMethod(db, ...) {
    ...
    customer ->   query db to get account
    ... // business logic
    orders      -> query db to get orders
    ... // business logic
}

can be replaced with:

func SomeServiceMethod(db, ...) {
   data := struct{
        model.Customer
        Orders []model.Orders
   }
   someStatement.Query(db, data)

   bussinesLogic(data)
}

func bussinesLogic(data) {
    ... // business logic
    ... // business logic
}

bussinesLogic - is tested with black box unit tests
SomeServiceMethod - is tested with service tests(tests with real db connection)

If you still want to mock db, I found this library: https://github.com/DATA-DOG/go-sqlmock, but haven't tested it yet.

from jet.