Hi , The following test will fail: <div class="snippet-clipboard

ExpectQuery in prepared statement fails if the argument is "2" ( or, putatively greater than 1) about go-sqlmock HOT 3 CLOSED

data-dog commented on May 13, 2024

ExpectQuery in prepared statement fails if the argument is "2" ( or, putatively greater than 1)

from go-sqlmock.

Comments (3)

l3pp4rd commented on May 13, 2024

Yes, you are not doing it right in this case. The previous issue was valid, this isn't.

There are two ways, one to expect the query on that statement (which is more straightforward)

package main

import (
    "testing"

    "github.com/stretchr/testify/assert"
    sqlmock "gopkg.in/DATA-DOG/go-sqlmock.v1"
)

func TestPrepare(t *testing.T) {
    db, mock, mErr := sqlmock.New()
    assert.NoError(t, mErr)
    defer db.Close()

    mock.ExpectPrepare("^SELECT id FROM test WHERE id=\\$1$").ExpectQuery().WithArgs("2")

    testFunction(db)

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

or make a next expectation for query, by repeating the query string

package main

import (
    "testing"

    "github.com/stretchr/testify/assert"
    sqlmock "gopkg.in/DATA-DOG/go-sqlmock.v1"
)

func TestPrepare(t *testing.T) {
    db, mock, mErr := sqlmock.New()
    assert.NoError(t, mErr)
    defer db.Close()

        mock.ExpectPrepare("^SELECT id FROM test WHERE id=\\$1$")
    mock.ExpectQuery("^SELECT id FROM test WHERE id=\\$1$").WithArgs("2")

    testFunction(db)

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