Unit tests with SQL

Question

I am doing a software project, working with database and Java code and in the unit tests, we have to test the selects....I mean, the expectable is that the table that results from the selects, have to correspond with the output in the intellij.....

in a few words, how do I compare a table originated from SQL with output(system.out.println())

Possible duplicate of [Best way to test SQL queries](https://stackoverflow.com/questions/754527/best-way-to-test-sql-queries) — UninformedUser, Oct 07 '18 at 15:53

score 0 · Answer 1 · answered Oct 07 '18 at 16:06

0

You can use an embedded database for that (for example H2).

The workflow would be as follows:

Define a schema for your tables and any initial values.
Start the embedded database at the beginning of your tests and populate it with the defined schema.
Connect to the embedded database from your test code, as you would connect to any database.
Run your SQL against the embedded database.
Do asserts on the results fetched from the database.
Stop the embedded database.

You can find a H2 tutorial here: https://www.tutorialspoint.com/h2_database/h2_database_jdbc_connection.htm

answered Oct 07 '18 at 16:06

@AKSW you are right, at this point there is no question. I was providing pointers. – Oct 07 '18 at 16:37
hm, I think he's more asking about how to compare results of executing a SQL query with something else - which is a bit unclear what the other thing is, a string maybe? – UninformedUser Oct 07 '18 at 16:40
What's with the Intellij though? – Oct 07 '18 at 16:45
I'd assume just the output in the console by calling `System.out.println` – UninformedUser Oct 07 '18 at 19:12

Unit tests with SQL

1 Answers1