Best tool for unit testing in MySQL

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?

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. — Isotopp, Apr 13 '11 at 00:15
@Isotop: Thanx for making me smile, finally some glimpse of joy outside of MySQL. — Johan, Apr 13 '11 at 06:55
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 :) — KingCrunch, Apr 14 '11 at 07:31

score 6 · Accepted Answer · answered Apr 12 '11 at 22:35

6

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

Here is screenshot:

enter image description here

answered Apr 12 '11 at 22:35

joe_coolish

score 6 · Answer 2 · edited Jul 08 '18 at 04:43

6

Have you considered using

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

edited Jul 08 '18 at 04:43

Paul Campbell

answered Apr 30 '11 at 08:05

Roopesh Shenoy

score 2 · Answer 3 · answered Apr 24 '13 at 16:19

2

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

answered Apr 24 '13 at 16:19

Federico Razzoli

score 0 · Answer 4 · answered Feb 11 '15 at 15:34

0

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

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

answered Feb 11 '15 at 15:34

janine

4 Answers4