Clever Geek Handbook

Suggestions for Automatic Confirmation of MS SQL 2005 Data Entry During Build Process

I have an automated build process (Visual Build) that starts up:

Automated Smoke Test Suite (AutoIT) that injects data into a .Net WinForm application that writes to a clean boot MS SQL 2005 database.

SQL query that returns the data I want.

SELECT i.ID, i.firstname, i.lastname, i.ModDate
FROM app.Individual i
Where lastname = 'Doe'

Now what I would like to do is to confirm:

Number of rows returned (let's say it should be 1)

I.ID, i.firstname, i.lastname value (suppose should be 1, John, Doe)

Today ModDate

Values ​​that the data should be extracted from the CSV file. VisualBuild can run external applications, so only Windows XP is limited.

+1


source to share


2 answers


The TestComplete automation tool does it well: http://www.automatedqa.com/products/testcomplete/



+1


source


So why don't you use the NUnit tests project to build right after the main testing of the project? You can easily test the SQL data for the assertion there.



0


source






More articles:


All Articles