tSQLt/Tests/DropAllClassesTests.class.sql at 77c99e9934e4f1f350ce585ca7dd4aeef344a43d · tSQLt-org/tSQLt · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
EXEC tSQLt.NewTestClass 'DropAllClassesTests';
GO

CREATE PROC DropAllClassesTests.[test DropClass not called if no test classes exist]
AS
BEGIN
    EXEC tSQLt.FakeTable 'tSQLt.TestClasses';
    EXEC tSQLt.SpyProcedure 'tSQLt.DropClass';

    EXEC tSQLt.DropAllClasses;

    EXEC tSQLt.AssertEmptyTable 'tSQLt.DropClass_SpyProcedureLog';
END;
GO
CREATE PROC DropAllClassesTests.[test that one test class results in one call to DropClass]
AS
BEGIN
    EXEC tSQLt.FakeTable 'tSQLt.TestClasses';
    EXEC tSQLt.SpyProcedure 'tSQLt.DropClass';
    EXEC('INSERT INTO tSQLt.TestClasses (Name)
          VALUES  (''MyTestClass'');');

    SELECT ClassName = Name INTO #expected FROM tSQLt.TestClasses;

    EXEC tSQLt.DropAllClasses;

    SELECT ClassName INTO #actual FROM tSQLt.DropClass_SpyProcedureLog;

    EXEC tSQLt.AssertEqualsTable '#expected', '#actual';
END;
GO
CREATE PROC DropAllClassesTests.[test that multiple test classes are all sent to DropClass]
AS
BEGIN
    EXEC tSQLt.FakeTable 'tSQLt.TestClasses';
    EXEC tSQLt.SpyProcedure 'tSQLt.DropClass';
    EXEC('INSERT INTO tSQLt.TestClasses (Name)
          VALUES  (''MyTestClass1''),
                  (''MyTestClass2''),
                  (''MyTestClass3'');');

    SELECT ClassName = Name INTO #expected FROM tSQLt.TestClasses;

    EXEC tSQLt.DropAllClasses;

    SELECT ClassName INTO #actual FROM tSQLt.DropClass_SpyProcedureLog;

    EXEC tSQLt.AssertEqualsTable '#expected', '#actual';
END;
GO