Are the unit tests run from within the .NET framework or purely in SQL server? I prefer to use the framework plus my preferred language to do unit testing.
Databases are king at set operations and tulip for logic even in 2010. The operation of parsing a delimited file is really simple in most programming languages but too much effort in TSQL; you have to write your own function to do the equivalent of string split for example.
Are you using a unit testing framework? If so, which one.
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Reply to: Automated database unit testing on VSTS
Collapse
You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
- You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
- You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
- If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Logging in...
Previously on "Automated database unit testing on VSTS"
Collapse
-
Automated database unit testing on VSTS
I’m trying to automate some unit testing of stored procedures on an SQL Server database using Visual Studio Team Suite.
The sprocs are simple SELECT statements with a couple of parameters that return a value from the table. A simple unit test for one of the sprocs from within VSTS is the following:
DECLARE @RC INT,
@fruit_id numeric(8,0),
@language_code varchar(2)
SELECT @RC = 0,
@fruit_id = 00004545,
@language_code = 'EN'
EXEC @RC = [dbo].[usp_fruit_select] @fruit_id, @language_code
SELECT RC=@RC
I have a .csv file of the full expected result sets, which runs to several hundred rows. Now I don’t want to have to create several hundred individual unit tests, I’d prefer to be able to call the parameters and the scalar result from a file that looks like this:
fruit_id; language_code; scalarValue;
00004545; EN; Apple
00004546; FR; Pomme
00004547; DE; Apfel
00004548; EN; Pear
00004549; ES; Pera
The file has been added to the test using the Data Connection String, but that’s where I come to a halt. Where/how do I recode the parameters and scalar Value to retrieve the data from the file?
Cheers,Tags: None
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Leave a comment: