Issue with mocking PrepareNamed

[jayant42]

How can i mock below.

stmt, err := Service.PrepareNamed(INSERT INTO sample (right_id,created_by)
VALUES (:right_id,:created_by) returning id`)

if err != nil {
	return err, 0
}

var id int64
err = stmt.Get(&id, payload)
if err != nil {
	return err, 0
}

type service struct {
Connection *sqlx.DB
Service
}

--Service interface

type Service interface {
Query(query string) (*sql.Rows, error)
PrepareNamed(query string) (*sqlx.NamedStmt, error)
}

`
Error at PrepareNamed as Nil pointer dereference

Test that I have written
. Mock.ExpectBegin() requestRow := sqlmock.NewRows([]string{"id"}) requestRow.AddRow(1) Mock.ExpectPrepare("INSERT INTO sample (.+)").ExpectQuery(). WillReturnRows(requestRow) shared_services.Mock.ExpectExec("INSERT INTO sample (.*)").WithArgs( "TEST", "TEST").WillReturnResult(sqlmock.NewResult(100, 1))