Automate SQL Stored Procedure Unit Testing for Code First Approach Part - 2

In the last post we have learnt how to create SQL Server Database project and how to create unit test project using that. Also we have learnt how to add unit test case and add pre test and post test scripts.If you have missed anything please follow the below link.
Link : https://codespate.blogspot.com/2020/07/automate-sql-stored-procedure-unit.html
Today we are going to add the unit test and database project to azure pipeline and automate the build and test.I am following the ef code first approach.So the database deployment will be handled by the migrations/migrator. This sql server project is useless for me. But why we have added that here is to simplify the unit test creation.

So the plan is
  1. Application and the database will be deployed through the existing pipeline
  2. We need to modify the build pipeline to build the sql unit test project
  3. After release only we can see the latest changes in the database.So we need to add the testing after the release only.
  4. Thus we need to create another stage for testing and after release that will be triggered
  5. To execute the test we need the test dlls so we need to archive that from the build and need to use in the test stage.
So to build the test project I need to modify  my build pipeline slightly.My existing pipeline tasks will look like below.
To use unit test project dlls after release I need to archive those from here and then need to extract and use it in the test stage. After adding the archive task, my pipeline tasks will look like this.
Next we need to modify our release pipeline. After release I am going to add another stage to perform the test. My release pipeline structure will look like below.
In the test stage I am extracting the test dlls from artifacts and using vstest task to run the test.
Here I am using the replace token task to replace the values from the app.config connection string and point to my dev database.After the test execution I can see the results.
Thats it.We have automated the unit testing for the stored procedures. While building the unit test and database project ,I have faced some issues and I have added a post on how to fix those.Please check that also.
Link :https://codespate.blogspot.com/2020/07/fix-sql-unit-test-build-failure-in.html

Comments

Post a Comment

Popular posts from this blog

Fix Sql Unit Test build failure in Azure Devops pipeline

Image
Recently I have faced an issue when adding the SQL DB project and SQL Unit test project to my existing .net core solution. In my local machine I am able to build successfully but the build failed in Azure devops pipeline. I got the below error when I build with .net core CLI.  Error MSB4019: The imported project "C:\Program Files\dotnet\sdk\3.1.301\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" was not found. Confirm that the expression in the Import declaration "C:\Program Files\dotnet\sdk\3.1.301\\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" is correct, and that the file exists on disk. Some of the discussions mentioned that specifying the vs SSDT path will fix the issue. So i have unloaded the project and edited the paths as below. C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\MSBuild\Microsoft\VisualStudio\v16.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets But...
Read more

Fix Cannot determine the organization name for this 'dev.azure.com' remote URL Issue Visual Studio 2019

Image
 Recently I got this error in Visual studio 2019 after an update.I am able to connect to the remote repository and clone but couldn't perform Fetch,Pull and Push. Restarting visual studio also wont give a fix for this. But finally managed to fix this by modifying some settings in the git plugin. Error :    Cannot determine the organization name for this ' dev.azure.com ' remote URL. Ensure the `credential.useHttpPath` configuration value is set, or set the organization name as the user in the remote URL '{org}@dev.azure.com'.   Fix : Go to Tools > Options > Source control > Git Global Settings Then modify the settings as shown as below : Reason For This Error : After the update,the Git plugin for visual studio also updated. Previous version of the Git plugin doesn't require these values to be set. But new version expect values for these settings.
Read more

How to call content page method from master page in ASP.NET

Image
hi,last week i had a problem with calling the content page methods from the masterpage.After spend lot of time with google finally i fond a solution for that.The solution is... In my case i have an ajax control toolkit html editor in my master page.When content loaded to the editor i have a method to trigger in master page.through that method i need to populate my content page.for populating content page i have a method in content page.but the problem is when the content is loaded i need to trigger the content page method.i dont know any other ways are available or not but my solution is first trigger the master page method and then trigger the content page method through that. my master page public partial class Falcons : System.Web.UI.MasterPage { protected void Page_Load(object sender, EventArgs e) { } //this is the method that will called from editor when content loaded protected void editor_content_load(object sender, EventArgs e...
Read more