call to Rollback transaction, was not expected, next expectation is: ExpectedQuery => expecting Query, QueryContext or QueryRow

[skhaz]

Question

I am trying to test this code

package main

import (
    "database/sql"
    "database/sql/driver"
    "regexp"
    "time"

    "github.com/DATA-DOG/go-sqlmock"
    "github.com/google/uuid"
    "gorm.io/driver/postgres"
    "gorm.io/gorm"
)

type Workspace struct {
    ID        uuid.UUID      `gorm:"type:uuid;default:uuid_generate_v4()" json:"id"`
    Name      string         `gorm:"not null,type:text" json:"name"`
    CreatedAt time.Time      `gorm:"autoCreateTime" json:"create_time"`
    UpdatedAt time.Time      `gorm:"autoUpdateTime" json:"update_time"`
    DeletedAt gorm.DeletedAt `gorm:"index,->" json:"-"`
}

type WorkspaceRepository struct {
    db *gorm.DB
}

func (r *WorkspaceRepository) Configure(db *gorm.DB) {
    r.db = db
}

func (r *WorkspaceRepository) Delete(id any) (bool, error) {
    if err := r.db.Delete(&Workspace{}, "id = ?", id).Error; err != nil {
        return false, err
    }

    return true, nil
}

func setup() (conn *sql.DB, mock sqlmock.Sqlmock, repository WorkspaceRepository, err error) {
    conn, mock, err = sqlmock.New()
    if err != nil {
        return
    }

    dialector := postgres.New(postgres.Config{Conn: conn, PreferSimpleProtocol: true})
    db, err := gorm.Open(dialector, &gorm.Config{})
    if err != nil {
        return
    }

    repository = WorkspaceRepository{}

    repository.Configure(db)

    return
}

type AnyTime struct{}

func (a AnyTime) Match(v driver.Value) bool {
    _, ok := v.(time.Time)
    return ok
}

func main() {
    conn, mock, repository, err := setup()
    if err != nil {
        panic(err)
    }

    defer conn.Close()

    id := "31645053-7f8c-4769-ba94-b8948f478540"

    mock.ExpectBegin()
    mock.ExpectQuery(regexp.QuoteMeta(`UPDATE "workspaces" SET`)).WithArgs(AnyTime{}, id)
    mock.ExpectCommit()

    _, err = repository.Delete(id)
    if err != nil {
        panic(err)
    }

    err = mock.ExpectationsWereMet()
    if err != nil {
        panic(err)
    }
}

However I get this error, I do not know what I am doing wrong, my expectations match

2022/07/04 11:22:02 /home/ubuntu/workspace/personal/main.go:32 call to ExecQuery 'UPDATE "workspaces" SET "deleted_at"=$1 WHERE id = $2 AND "workspaces"."deleted_at" IS NULL' with args [{Name: Ordinal:1 Value:2022-07-04 11:22:02.304708 -0300 -03} {Name: Ordinal:2 Value:31645053-7f8c-4769-ba94-b8948f478540}], was not expected, next expectation is: ExpectedQuery => expecting Query, QueryContext or QueryRow which:
  - matches sql: 'UPDATE "workspaces" SET'
  - is with arguments:
    0 - {}
    1 - 31645053-7f8c-4769-ba94-b8948f478540; call to Rollback transaction, was not expected, next expectation is: ExpectedQuery => expecting Query, QueryContext or QueryRow which:
  - matches sql: 'UPDATE "workspaces" SET'
  - is with arguments:
    0 - {}
    1 - 31645053-7f8c-4769-ba94-b8948f478540
[0.168ms] [rows:0] UPDATE "workspaces" SET "deleted_at"='2022-07-04 11:22:02.304' WHERE id = '31645053-7f8c-4769-ba94-b8948f478540' AND "workspaces"."deleted_at" IS NULL
panic: call to ExecQuery 'UPDATE "workspaces" SET "deleted_at"=$1 WHERE id = $2 AND "workspaces"."deleted_at" IS NULL' with args [{Name: Ordinal:1 Value:2022-07-04 11:22:02.304708 -0300 -03} {Name: Ordinal:2 Value:31645053-7f8c-4769-ba94-b8948f478540}], was not expected, next expectation is: ExpectedQuery => expecting Query, QueryContext or QueryRow which:
  - matches sql: 'UPDATE "workspaces" SET'
  - is with arguments:
    0 - {}
    1 - 31645053-7f8c-4769-ba94-b8948f478540; call to Rollback transaction, was not expected, next expectation is: ExpectedQuery => expecting Query, QueryContext or QueryRow which:
  - matches sql: 'UPDATE "workspaces" SET'
  - is with arguments:
    0 - {}
    1 - 31645053-7f8c-4769-ba94-b8948f478540

goroutine 1 [running]:
main.main()
        /home/ubuntu/workspace/personal/main.go:81 +0x1da
exit status 2