escaping subqueries and other chars about go-sqlmock HOT 4 CLOSED

closing it, if there are still some questions - reopen

from go-sqlmock.

fyi for future readers: you may find regexp.QuoteMeta helpful. It will automatically escape special regexp characters.

from go-sqlmock.

hi, sorry for the late answer. could you give an example of the query you had troubles with?
currently the query stripper does it in a simple way, by stripping only whitespace. I agree this is not a perfect solution it may be improved, cheers.

from go-sqlmock.

Well, the issue you had, most probably is because you haven't escaped regular expression special characters. See the commit reference above. And it would be a good practice to keep your query matching short, because sqlmock matches them in the given order. If you expect a query "SELECT" and an update query is fired, then a test will fail, because it matches queries in order. So you can keep them like:

sqlmock.ExpectQuery("SELECT (.*) FROM orders")
sqlmock.ExpectQuery("SELECT (.*) FROM users")
sqlmock.ExpectQuery("SELECT (.*) FROM orders")
sqlmock.ExpectExec("UPDATE orders")
sqlmock.ExpectExec("INSERT INTO products")

If queries are not fired in the same order, the test would fail.
The query stripper only strips whitespace, newlines and such and makes only a single space between sql parts.

from go-sqlmock.