Sfrgttk

Workplace intimidation due to child's chronic health condition

Why there is no EEPROM in STM32F4 MCUs

How can a kingdom keep the secret of a missing monarchy from the public?

Should corporate security training be tailored based on a users' job role?

multiple price sets?

Why does Python copy numpy arrays where the length of the dimensions are the same?

Badly designed reimbursement form. What does that say about the company?

Why is Bernie Sanders maximum accepted donation on actblue $5600?

Identical projects by students at two different colleges: still plagiarism?

How to play song that contains one guitar when we have two guitarists (or more)?

Bitcoin automatically diverted to bech32 address

How can I portray body horror and still be sensitive to people with disabilities?

Who, if anyone, was the first astronaut to return to earth in a different vessel?

Is 'bad luck' with former employees a red flag?

"Cheaper by the dozen" phrase origin?

Apparently I’m calling random numbers but nothing in call log?

Is layered encryption more secure than long passwords?

Why does XLAT mean 'translate'?

How does one use the Nerode-Myhill theorem to prove that a language is regular?

A dragon's soul trapped in a ring of mind shielding wants a new body; what magic could enable her to do so?

Does the phrase がんばする makes sense?

How to announce in an ATIS message that two parallel runways are in use?

Does limiting the number of sources help simplify the game for a new DM with new and experienced players?

The idea behind the state of Imperative languages

Reinitialize Table Values in SQL SSDT Unit Testing

Unit testing of stored proceduresDocumenting a giant web of inter-related stored procedures in an MS SQL database: What tool or format?SSDT on VS2013 for SQL Server 2012Connect SQL Server 2016 SSDT with TFSSql Server Stored Procs vs Linq with C# and unit testingWhy would I get PREEMPTIVE_OS_AUTHORIZATIONOPS using tSQLt when Working at Home?SQL Server Data Tools 15.5.0 - Script Component Validation ErrorSSIS Not Executing any Script TaskView with OPENQUERY won't build in SSDT projectMake SQL Server SSDT Database Project Reference Different in Publish Profile

 [TestClass()]

    public class SqlDatabaseSetup

    {



        [AssemblyInitialize()]

        public static void InitializeAssembly(TestContext ctx)

        {

            // Setup the test database based on setting in the

            // configuration file

            SqlDatabaseTestClass.TestService.DeployDatabaseProject();

            SqlDatabaseTestClass.TestService.GenerateData();

        }



    }

}





using Microsoft.Data.Tools.Schema.Sql.UnitTesting;

 [TestClass()]

    public class SqlDatabaseSetup

    {



        [AssemblyInitialize()]

        public static void InitializeAssembly(TestContext ctx)

        {

            // Setup the test database based on setting in the

            // configuration file

            SqlDatabaseTestClass.TestService.DeployDatabaseProject();

            SqlDatabaseTestClass.TestService.GenerateData();

        }



    }

}





using Microsoft.Data.Tools.Schema.Sql.UnitTesting;

 [TestClass()]

    public class SqlDatabaseSetup

    {



        [AssemblyInitialize()]

        public static void InitializeAssembly(TestContext ctx)

        {

            // Setup the test database based on setting in the

            // configuration file

            SqlDatabaseTestClass.TestService.DeployDatabaseProject();

            SqlDatabaseTestClass.TestService.GenerateData();

        }



    }

}





using Microsoft.Data.Tools.Schema.Sql.UnitTesting;

 [TestClass()]

    public class SqlDatabaseSetup

    {



        [AssemblyInitialize()]

        public static void InitializeAssembly(TestContext ctx)

        {

            // Setup the test database based on setting in the

            // configuration file

            SqlDatabaseTestClass.TestService.DeployDatabaseProject();

            SqlDatabaseTestClass.TestService.GenerateData();

        }



    }

}





using Microsoft.Data.Tools.Schema.Sql.UnitTesting;

1 Answer
1

active

oldest

votes

0

I have created the usp_Generate_Merge_For_Table procedure a few years ago exactly for this purpose.
It can generate a MERGE command with a Values Constructor in order to "re-initialize" the contents of a specific table.

You can find it here:

https://gist.github.com/EitanBlumin/7faba0b39c4f90d4cfa879a45f3e01eb#file-generate_merge_for_table-sql

Direct link to the raw script:

https://gist.githubusercontent.com/EitanBlumin/7faba0b39c4f90d4cfa879a45f3e01eb/raw/608177e77da0a42d686098ab10703bbba8c54d64/Generate_Merge_For_Table.sql

Simply create the procedure in your database, run it while sending it your table name as a parameter, like so:

EXEC usp_Generate_Merge_For_Table 'cities', 'dbo'

And then you can copy and paste its output in your Unit Testing project.

You can find more info and detailed instructions on how to use it here:

https://eitanblumin.com/2018/10/28/generate-merge-statement-as-a-snapshot-of-your-tables-content/

share|improve this answer

answered Dec 27 '18 at 14:54

Eitan BluminEitan Blumin

666

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f220867%2freinitialize-table-values-in-sql-ssdt-unit-testing%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

I have created the usp_Generate_Merge_For_Table procedure a few years ago exactly for this purpose.
It can generate a MERGE command with a Values Constructor in order to "re-initialize" the contents of a specific table.

You can find it here:

https://gist.github.com/EitanBlumin/7faba0b39c4f90d4cfa879a45f3e01eb#file-generate_merge_for_table-sql

Direct link to the raw script:

https://gist.githubusercontent.com/EitanBlumin/7faba0b39c4f90d4cfa879a45f3e01eb/raw/608177e77da0a42d686098ab10703bbba8c54d64/Generate_Merge_For_Table.sql

Simply create the procedure in your database, run it while sending it your table name as a parameter, like so:

EXEC usp_Generate_Merge_For_Table 'cities', 'dbo'

And then you can copy and paste its output in your Unit Testing project.

You can find more info and detailed instructions on how to use it here:

https://eitanblumin.com/2018/10/28/generate-merge-statement-as-a-snapshot-of-your-tables-content/

share|improve this answer

answered Dec 27 '18 at 14:54

Eitan BluminEitan Blumin

666

add a comment | 

0

I have created the usp_Generate_Merge_For_Table procedure a few years ago exactly for this purpose.
It can generate a MERGE command with a Values Constructor in order to "re-initialize" the contents of a specific table.

You can find it here:

https://gist.github.com/EitanBlumin/7faba0b39c4f90d4cfa879a45f3e01eb#file-generate_merge_for_table-sql

Direct link to the raw script:

https://gist.githubusercontent.com/EitanBlumin/7faba0b39c4f90d4cfa879a45f3e01eb/raw/608177e77da0a42d686098ab10703bbba8c54d64/Generate_Merge_For_Table.sql

Simply create the procedure in your database, run it while sending it your table name as a parameter, like so:

EXEC usp_Generate_Merge_For_Table 'cities', 'dbo'

And then you can copy and paste its output in your Unit Testing project.

You can find more info and detailed instructions on how to use it here:

https://eitanblumin.com/2018/10/28/generate-merge-statement-as-a-snapshot-of-your-tables-content/

share|improve this answer

answered Dec 27 '18 at 14:54

Eitan BluminEitan Blumin

666

add a comment | 

I have created the usp_Generate_Merge_For_Table procedure a few years ago exactly for this purpose.
It can generate a MERGE command with a Values Constructor in order to "re-initialize" the contents of a specific table.

You can find it here:

https://gist.github.com/EitanBlumin/7faba0b39c4f90d4cfa879a45f3e01eb#file-generate_merge_for_table-sql

Direct link to the raw script:

https://gist.githubusercontent.com/EitanBlumin/7faba0b39c4f90d4cfa879a45f3e01eb/raw/608177e77da0a42d686098ab10703bbba8c54d64/Generate_Merge_For_Table.sql

Simply create the procedure in your database, run it while sending it your table name as a parameter, like so:

EXEC usp_Generate_Merge_For_Table 'cities', 'dbo'

And then you can copy and paste its output in your Unit Testing project.

You can find more info and detailed instructions on how to use it here:

https://eitanblumin.com/2018/10/28/generate-merge-statement-as-a-snapshot-of-your-tables-content/

share|improve this answer

answered Dec 27 '18 at 14:54

Eitan BluminEitan Blumin

666

EXEC usp_Generate_Merge_For_Table 'cities', 'dbo'

share|improve this answer

answered Dec 27 '18 at 14:54

Eitan BluminEitan Blumin

666

answered Dec 27 '18 at 14:54

Eitan BluminEitan Blumin

666

answered Dec 27 '18 at 14:54

Eitan BluminEitan Blumin

666