Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What tools are available for TDDD (Test Driven Database Development)?

Tags:

About a year ago, I picked up Scott Ambler's Refactoring Databases: Evolutionary Database Design. I was won over to the idea that just as you can develop your code with TDD, you probably should be covering your databases with unit tests (at least) or even writing database tests before you make a change to the schema so you do database work in a TDD style as well.

I really like the idea, and I have been doing this (OK, sometimes I do it) by hand for a while now, just writing regular unit tests that happen to connect to the database and check its structure against a given schema file. But I haven't found any good database change management tool-kits that might help automate this process. Does anyone know any?

like image 836
Sam McAfee Avatar asked Sep 30 '08 02:09

Sam McAfee


People also ask

What is the test management tool used for in TDD?

Mockito allows programmers to create and test double objects (mock objects) in automated unit tests for Test-driven Development (TDD). In simple words, Mockito is a framework that developers specifically use to write certain kinds of tests efficiently. There are also many other tools and frameworks available.

What are the 3 stages of TDD?

Red, Green and Refactor is the three phase of Test Driven Development and this the sequence that get followed while writing code.

What is TDD in database?

Test-Driven Development (TDD) is a software development process which includes test-first development. It means that the developer first writes a fully automated test case before writing the production code to fulfill that test and refactoring.

Which of the following is a Test-Driven Development TDD approach?

Test-Driven Development starts with designing and developing tests for every small functionality of an application. TDD framework instructs developers to write new code only if an automated test has failed. This avoids duplication of code. The TDD full form is Test-driven development.


1 Answers

I only know of two unit testing frameworks:

  • DBUnit
  • TSQLUnit

As for change management, these are some recommended tools:

  • Redgate SQL Compare
  • ApexSQL
  • Toad

Although I am not sure if this is really what you're looking for.

like image 109
Jon Limjap Avatar answered Oct 01 '22 22:10

Jon Limjap