Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Best tool for unit testing in MySQL [closed]

I've been doing a lot of sproc programming in MySQL lately.
And I must say that I like it. A lot.

However debugging these babies sucks.
Anyone know of any tools that can put some happiness in My MySQL debugging?

like image 281
Johan Avatar asked Apr 12 '11 22:04

Johan


People also ask

Should I unit test database?

No matter if you have one database or 1000 databases. The application of unit testing allows you to ensure once you write something, it can be verified and then when it needs to change you can verify that all of the tests that previously passed will continue to pass.


3 Answers

http://www.mydebugger.com/

There is a limited free version, but the full version is not too expensive either.

Here is screenshot:

enter image description here

like image 79
joe_coolish Avatar answered Oct 18 '22 23:10

joe_coolish


Have you considered using

https://github.com/hepabolu/mytap

For unit testing the db you should have something native that works in MySQL.

like image 35
Roopesh Shenoy Avatar answered Oct 18 '22 22:10

Roopesh Shenoy


For Unit Testing, you can try this: http://stk.wikidot.com/stk-unit

like image 36
Federico Razzoli Avatar answered Oct 18 '22 22:10

Federico Razzoli