public void Assert_that_included_databases_are_added_to_command_text() { const string commandText = "foo " + Constants.WhereClauseAndReplaceToken + " bar"; var actual = DatabaseMetricBase.ParameterizeQuery(commandText, WhereClauseTokenEnum.WhereAnd, "token", new[] { "BigData", "LittleData", }, null); Assert.That(actual, Is.EqualTo("foo AND (token IN ('BigData', 'LittleData')) bar")); }
public void Assert_that_excluded_databases_are_added_to_command_text() { const string commandText = "foo " + Constants.WhereClauseReplaceToken + " bar"; var actual = DatabaseMetricBase.ParameterizeQuery(commandText, WhereClauseTokenEnum.Where, "token", null, new[] { "tempdb", "master", "model", "msdb", }); Assert.That(actual, Is.EqualTo("foo WHERE (token NOT IN ('tempdb', 'master', 'model', 'msdb')) bar")); }
public void Should_throw_when_replacement_token_is_missing_from_sql() { Assert.Throws <Exception>(() => DatabaseMetricBase.ParameterizeQuery("no token here", WhereClauseTokenEnum.Where, "no match", new[] { "foo" }, null)); Assert.Throws <Exception>(() => DatabaseMetricBase.ParameterizeQuery("no token here", WhereClauseTokenEnum.WhereAnd, "no match", new[] { "foo" }, null)); }