Update to latest changes in github.com/denisenkom/go-mssqldb

[AlekSi]

github.com/denisenkom/go-mssqldb recently implemented database/sql/driver.SessionResetter interface which broke our tests due to SET IDENTITY_INSERT used by them.

[AlekSi]

@AlekseyMartynov May you take a look, please?

[AlekseyMartynov]

From debugging I understand that with SessionResetter, SET IDENTITY_INSERT must be called in each transaction (or even before each query?)

To satisfy this in tests, setIdentityInsert can be called immediately before and after Insert:

setIdentityInsert(s.T(), tx.Querier, "people", true)
s.NoError(tx.Insert(person))
setIdentityInsert(s.T(), tx.Querier, "people", false)

reform-db is more tricky. Specifically for test data in internal/test/sql, a possible solution is to combine all SQL in a single temporary file.

Interesting insight is that using one connection doesn't solve all problems:

reform/reform-db/main.go

Lines 56 to 59 in 161dee9

	// Use single connection so various session-related variables work.
	// For example: "PRAGMA foreign_keys" for SQLite3, "SET IDENTITY_INSERT" for MS SQL, etc.
	sqlDB.SetMaxIdleConns(1)
	sqlDB.SetMaxOpenConns(1)