Jetbrains datagrip stored procedures1/20/2024 ![]() Paths: a qualified path to the testing package (for example, testFinancialApp.test that ConvertCurrency converts using given conversion rate).įor more information about settings of the tSQLt Test configuration type, refer to tSQLt Test. tSQLt supports Microsoft SQL Server.ĭatabase: the name of a database (for example, testFinancialApp). In the Run/Debug Configurations dialog, click the Add New Configuration icon ( ) and select tSQLt Test.ĭata source: the name of a data source. With the Navigation bar visible ( View | Appearance | Navigation Bar), choose Edit Configurations from the run/debug configuration selector. Select Run | Edit Configurations from the main menu. Open the Run/Debug Configuration dialog in one of the following ways: Run tSQLt tests by using a run configuration In the schema selection window, select schemas that you created (for example, tSQLt, testFinancialApp, and FinancialApp). You can take examples from the tSQLt tutorial.Ĭlick the Execute button ( ) or press Control+Enter.Ĭlick the N of N link near the data source name. In the Database Explorer ( View | Tool Windows | Database Explorer), right-click the Microsoft SQL Server data source and select Open Query Console. For example, EXEC tSQLt.NewTestClass 'testFinancialApp'. ![]() To create a new class, use the NewTestClass procedure. In tSQLt, all tests are collected under a single class. In the file browser, navigate to the demoApp.sql from the tSQLt_demo.zip archive. Right-click the Microsoft SQL Server data source and select Run SQL Script. ![]() A link to the archive is at the beginning of this topic. Create objects to be testedįor illustration purposes, you can create the FinancialApp schema from the tSQLt tutorial at. Some procedures have the Private_ prefix and can be used only by the framework. You can use it to test stored procedures, functions, views, and triggers of a database.Īfter the installation, the tSQLt script creates the tSQLt schema that stores framework functions and procedures. ![]() TSQLt is a framework for unit testing on Microsoft SQL Server. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |