Open
Description
The following two test annotations could be a path to parameterized tests.
Reporting on the backend (tSQLt.TestResult) still needs to be figured out.
GO
--[@tSQLt:Parameter](‘someparameter’,’,’,‘13,14,15,16,17’)
--[@tSQLt:Parameter](‘someotherparm’,’|’,‘abc|def|g,|hi’)
CREATE PROCEDURE [testclass].[test that something]
@someparameter INT,
@someotherparm NVARCHAR(MAX)
AS
BEGIN
EXEC tSQLt.Fail;
END;
GO
CREATE VIEW testclass.table
AS
SELECT *
FROM(VALUES(13),(14),(15),(16))X.someparameter
CROSS JOIN (VALUES(‘abc’),(‘def’),(‘g,hi’))Y.someotherparm
GO
--[@tSQLt:ParameterTable](‘testclass.table’)
CREATE PROCEDURE [testclass].[test that something]
@someparameter INT,
@someotherparm NVARCHAR(MAX)
AS
BEGIN
EXEC tSQLt.Fail;
END;
GO