Best tool for unit testing in MySQL [closed]

Question

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?

Bicker

There is no happiness to be found in MySQL stored procedures. You are doing it wrong. I have a longer answer^Wrant for you on that, but it will be kind of offtopic to this question, so I won't bother you with it here. – Roy

@Isotop: Thanx for making me smile, finally some glimpse of joy outside of MySQL. – Bicker

@KingCrunch MySQL stored procedural SQL. – Bicker

Didnt know, there is a real SQL-unittest tool. My question was about in which language you want to write your tests (java, ...). I think I need a closer look at mydebugger :) – Oeflein

Answer 1

http://www.mydebugger.com/

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

Here is screenshot:

Thorma

Hmm stepping through code sure sounds sweet. – Bicker

Answer 2

Have you considered using

https://github.com/hepabolu/mytap

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

Jerriejerrilee

Answer 3

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

Townsman

Answer 4

If you pefer writing your test in C++ you can use googletest:

https://code.google.com/p/googletest/

You can find a good overview on the mySQL documentation webside:

http://dev.mysql.com/doc/mysqltest/2.0/en/unit-tests-google-test.html

Hovis