Test failing as there are some extra spaces, can i do anything about it?

[Jleagle]

I have a test with:

mock.ExpectExec(`UPDATE public.project_member SET ("order", updated_at) = ($1, $2) WHERE ((project_member.project_id = $3::varchar(20)) AND (project_member.user_id = $4::varchar(20)));`).

and it's failing as the actual query is:

UPDATE public.project_member SET ("order", updated_at) = ($1, $2) WHERE ( (project_member.project_id = $3::varchar(20)) AND (project_member.user_id = $4::varchar(20)) );

Which is the same except a couple of spaces which shouldn't effect anything.

I have tried with sqlmock.New() and sqlmock.New(sqlmock.QueryMatcherOption(sqlmock.QueryMatcherEqual)).

Is there something i can do other than add spaces to the expected SQL? Im using a SQL generator so can't change the query run.

Thanks!

[official-burak]

QueryMatcherEqual still fails on those extra spaces. stripQuery only squeezes runs of whitespace, so (( and ( ( stay different.

The default matcher is a regexp, so $1 is "end of string" then 1, not a placeholder.

Strip every space instead:

compact := regexp.MustCompile(`\s+`)
db, mock, err := sqlmock.New(sqlmock.QueryMatcherOption(
	sqlmock.QueryMatcherFunc(func(expectedSQL, actualSQL string) error {
		e := compact.ReplaceAllString(expectedSQL, "")
		a := compact.ReplaceAllString(actualSQL, "")
		if e != a {
			return fmt.Errorf("sql mismatch:\nexpected %s\nactual   %s", e, a)
		}
		return nil
	}),
))

Keep $1 as literal text. Do not feed generator SQL into QueryMatcherRegexp.