当我尝试使用SQLMock模拟Postgres插入并 Gorm.io 时,我收到一个错误,指出查询不是预期的。我试图用它来包装和转义我的字符串,但它不起作用。我添加并删除了参数和结果,但错误继续出现regexp.QuoteMeta()
如何通过 SQLMock 设置预期的查询?
我给你原始的PostgresQuery和UserModel
//RAW QUERY
INSERT INTO "users" ("id","name","surname","birthdate","company","custom_claims","deleted") VALUES ($1,$2,$3,$4,$5,$6,$7)' with args [{Name: Ordinal:1 Value:my_user_id} {Name: Ordinal:2 Value:<nil>} {Name: Ordinal:3 Value:<nil>} {Name: Ordinal:4 Value:<nil>} {Name: Ordinal:5 Value:<nil>} {Name: Ordinal:6 Value:<nil>} {Name: Ordinal:7 Value:<nil>}]
//Gorm model
type User struct {
ID string `gorm:"primaryKey"`
Name *string
Surname *string
Birthdate *time.Time
Company *string
CustomClaims *json.RawMessage
Deleted gorm.DeletedAt
}
func (repository Repository) CreateUser(user users.User) (*users.User, error) {
newUser := toRepositoryModel(user)
err := repository.db.Create(newUser).Error //db -> *gorm.DB
//....
}
//TEST
const expectedQuery = `INSERT INTO "users" ("id","name","surname","birthdate","company","custom_claims","deleted") VALUES ($1,$2,$3,$4,$5,$6,$7)' with args [{Name: Ordinal:1 Value:my_user_id} {Name: Ordinal:2 Value:<nil>} {Name: Ordinal:3 Value:<nil>} {Name: Ordinal:4 Value:<nil>} {Name: Ordinal:5 Value:<nil>} {Name: Ordinal:6 Value:<nil>} {Name: Ordinal:7 Value:<nil>}]`
suite.mock.ExpectQuery(regexp.QuoteMeta(experctedQuery)) //HOW SHOULD BE MODIFIED?
user, err2 := postgres.CreateUser(users.User{
ID: ID,
})
largeQ
相关分类