Skip to content

implement parameterized tests #120

Open
@mbt1

Description

@mbt1

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions