Example #1
0
        public void template_should_leave_temporary_tables_intact()
        {
            var tableText = "CREATE TABLE #r";

            var result = new CreateAlterTemplate(new SqlObject(new ProcedureQuery(), "Test"));
            result.AddText(tableText);
            Assert.That(result.TemplatedProcedure(), Is.StringContaining(tableText));
        }
Example #2
0
        public void should_template_my_sproc_with_leading_white_spaces()
        {
            var createText = "  \t \t CREATE         PROCEDURE [dbo].[Procy]   ";

            var sproc = new CreateAlterTemplate(new SqlObject(new ProcedureQuery(), "Hello"));

            sproc.AddText(createText);
            Assert.That(sproc.TemplatedProcedure(), Is.Not.StringContaining(createText));
        }
Example #3
0
        public void should_pick_up_procedures_defined_as_PROC()
        {
            var createText = "CREATE    PROC [dbo].[aProceddure]";

            var sproc = new CreateAlterTemplate((new SqlObject(new ProcedureQuery(), "Hello")));

            sproc.AddText(createText);
            Assert.That(sproc.TemplatedProcedure(), Is.Not.StringContaining(createText));
            Console.WriteLine(sproc.TemplatedProcedure());
        }