Unit Test to Run .sql script to SQL Create Database

Posted by Lee Englestone on Stack Overflow See other posts from Stack Overflow or by Lee Englestone
Published on 2010-03-29T09:39:55Z Indexed on 2010/03/29 9:43 UTC
Read the original article Hit count: 370

Filed under:

ci

|

TDD

|

nunit

Can anyone point me in the direction of how I could get a NUnit test to run a .sql file to Create / Setup a database.

I know about the the TestFixtureSetUp and TestFixtureTearDown attributes / methods in NUnit.

So I KNOW how to call methods before and after all or each unit tests.

I'm just unsure of how to load and execute the contents of a .sql file agains a SQL Server 2005 database programatically.

Any examples?

This is part of our TDD / CI. We are wanting to create the database before and tear down the database after executing unit tests.

Cheers,

-- Lee

© Stack Overflow or respective owner

Related posts about ci

Fixing my SQL Directory NTFS ACLS

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I run my development server by boot to VHD (Windows Server 2008 R2 x64). In that instance, I also have an attached VHD (I attach via script at boot up time using Task Scheduler). That VHD I have my SQL instances installed. So, the other day, acting hasty, I chmod my ACLS – wow, what a day after… >>> More
Codeigniter: Using URIs with forms

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using URIs to direct a function in a library: $id = $this->CI->session->userdata('id'); $URI = $this->CI->uri->uri_string(); $new = "new"; if(strpos($URI, $new) === FALSE){ $method = "update"; } elseif(strpos($URI, $new) !== FALSE){ $method… >>> More
Give back full control to a user on a disk from another computer

as seen on Super User - Search for 'Super User'
I have my friend's hard drive mounted externally. After messing with the permissions with TAKEOWN so I could fix some viruses, I have full control over their drive. The problem is, now it's stuck in a "autochk not found" reboot sequence. I think the problem is that the boot sector is invisible to… >>> More
Give back full control to a user on a disk from another computer

as seen on Stack Overflow - Search for 'Stack Overflow'
I have my friend's hard drive mounted externally. After messing with the permissions with TAKEOWN so I could fix some viruses, I have full control over their drive. The problem is, now it's stuck in a "autochk not found" reboot sequence. I think the problem is that the boot sector is invisible to… >>> More
Rewrite Url with apache2

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm experimenting with CodeIgniter PHP framework, this framework works like: http://localhost:7777/~dhalsim/ci/index.php/blog So, I tried to remove index.php part from there. So far I do these: make $config['index_page'] = "index.php"; to $config['index_page'] = ""; make $config['uri_protocol']… >>> More

Related posts about TDD

TDD - How to start really thinking TDD?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been reading about Agile, XP methodologies and TDDs. I have been in projects which states it needs to do TDD, but most of the tests are somehow integration tests or during the course of project TDD is forgotten in effort to finish codes faster. So, as far as my case goes, I have written unit… >>> More
Are "TDD Tests" different to Unit Tests?

as seen on Programmers - Search for 'Programmers'
I read this article about TDD and unit testing: http://stephenwalther.com/blog/archive/2009/04/11/tdd-tests-are-not-unit-tests.aspx I think it was an excellent article. The author makes a distinction between what he calls "TDD Tests" and unit testing. They appear to be different tests to him. Previous… >>> More
Doing TDD Silverlight 4 RC using Visual Studio 2010 RC

as seen on Stack Overflow - Search for 'Stack Overflow'
First I am glad to see better TDD support in VS2010. Support for generating code stubs from my tests is ok - not as good as more mature TDD plug-ins but a good start. I am looking for some best Silverlight 4.0 TDD practices. First Question: Anyone have links, recommendations? I know the new Silverlight… >>> More
Applying Test Driven Development to a tightly coupled architecture

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I've recently been studying TDD, attended a conference and have dabbled in few tests and already I'm 100% sold, I absolutely love it TDD. As a result I've raised this with my seniors and they are prepared to give it a chance, so they have tasked me with coming up with a way to implement… >>> More
Integrating JavaScript Unit Tests with Visual Studio

as seen on Stephen Walter - Search for 'Stephen Walter'
Modern ASP.NET web applications take full advantage of client-side JavaScript to provide better interactivity and responsiveness. If you are building an ASP.NET application in the right way, you quickly end up with lots and lots of JavaScript code. When writing server code, you should be writing… >>> More