예제 #1
0
        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"));
        }
예제 #2
0
        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"));
        }
예제 #3
0
 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));
 }