Function AssertValidSQL

pkg/gosqlx/testing/testing.go:45–55

AssertValidSQL asserts that the given SQL is syntactically valid. If the SQL is invalid, the test continues but is marked as failed. Example: testing.AssertValidSQL(t, "SELECT * FROM users WHERE active = true")

(t TestingT, sql string)

//
//	testing.AssertValidSQL(t, "SELECT * FROM users WHERE active = true")
func AssertValidSQL(t TestingT, sql string) bool {
	t.Helper()

	err := gosqlx.Validate(sql)
	if err != nil {
		t.Errorf("Expected valid SQL, but got error:\n  SQL: %s\n  Error: %v",
			truncateSQL(sql), err)
		return false
	}
	return true
}

// AssertInvalidSQL asserts that the given SQL is syntactically invalid.
// If the SQL is valid, the test continues but is marked as failed.