Unit test MySQL database interactions

Question

I am writing test cases for a python code that mainly parses and interprets user input and calls business layer functions to do database interactions (inserts and selects). How can I write/plan unit test cases for it.

Does calling a dummy version of the business logic functions make sense?

score 1 · Answer 1 · answered Jul 25 '12 at 12:53

1

Yes testing you "business logic" is practical. Unit Testing for Database interaction is not. Suggest http://pyunit.sourceforge.net/

answered Jul 25 '12 at 12:53

Dane Balia

5,271
5
32
57

score 1 · Answer 2 · edited May 23 '17 at 12:20

1

If you use dummy business logic, what do you end up testing then? Your business logic is really what you should be unit testing.

You should using mocking to simulate user input and avoid database interactions. Have a look at my answer to How to mock an HTTP request in a unit testing scenario in Python.

edited May 23 '17 at 12:20

Community

1
1

answered Jul 25 '12 at 13:02

Rodrigue

3,617
2
37
49

Unit test MySQL database interactions

2 Answers2