go-sqlmock icon indicating copy to clipboard operation
go-sqlmock copied to clipboard

Problem while INSERTING

Open RajivBobble opened this issue 4 years ago • 1 comments

This is the Error I'm getting all expectations were already fulfilled, call to database transaction Begin was not expected

I have a code in my go lang

var userRoles models.UserRole
userRoles.UserID = userID
userRoles.RoleID = id
db.Create(&userRoles)

And This Query is generated INSERT INTO user_roles (user_id,role_id,created_at,updated_at) VALUES (1,1,2020-05-08 13:35:59,2020-05-08 13:35:59) While mocking with this code with WithArgs() and Without WithArgs()

mock.ExpectBegin()
mock.ExpectExec("INSERT INTO \"u").WithArgs(1, 1, sqlmock.AnyArg(), sqlmock.AnyArg()).WillReturnResult(sqlmock.NewResult(1, 1))
mock.ExpectCommit()

I have also tried this mock.ExpectQuery("INSERT INTO user.*").WithArgs(1,1,sqlmock.AnyArg()sqlmock.AnyArg()).WillReturnRows(row) Getting same error

RajivBobble avatar May 08 '20 08:05 RajivBobble

@RajivBobble I'm happy to help, but I'll need a more complete example. Could you provide more of the relevant code?

rmulley avatar Sep 15 '20 19:09 rmulley