Match a multi argument query against an expectation with an unique argument(s) about go-sqlmock

[l3pp4rd]

Hi, there is an example with unordered matching. I think that will manage your use case.

[nicwest]

Thanks!

That I think solves part of my problem, the other bit is how I differentiate between two queries without specifying all of the arguments?

[l3pp4rd]

You may catch it by regular expression on SQL without providing any argument, in that case you need to know how many of these queries will be run and just add expectations in a loop only on SQL statement. If you provide at least one argument, only in that case arguments are being matched. Nothing prevents you from expecting SQL query like: SELECT (.*) FROM things or ^INSERT INTO things

[nicwest]

Sure, but in the case that my query is SELECT * FROM things WHERE thing=? AND foobar=? and I know what thing will be but not foobar? I can think of some examples even under test conditions of where this could happen, for example a random number, a relation id, the current time, the process id, an OS specific file path, etc.

[l3pp4rd]

Ah, in that case you should use custom argument matcher for one which differs and you do not care about.