How to quickly and efficiently mock relational databases for tests?

Question

Java

What approaches do you use?

I tried to do it through ArrayList, but it looks somehow not very good, and it takes a long time to write.

public class DatabaseMock implements DatabaseManager {

    private List<TableRecord> table = new ArrayList<TableRecord>() {{
        add(new TableRecord(1, "name", "description"));
    }};

    @Override
    public String getName(int id) {
        for (TableRecord tableRecord : table) {
            if (tableRecord.getId() == id) {
                return tableRecord.getName();
            }
        }
        return "Noname";
    }
}

Answer 1

It is more convenient to wet through special tools. For example, using the mockito library

Answer 2

mockito is pretty handy for making stubs. But this is more for unit tests.
or
testcontainers -- for full integration tests. It is necessary that the docker was installed on the machine. This is not a database emulation - this is a real database being raised in docker. After the tests, it all dies.

Answer 3

Personally, I prefer tools like EmbeddedPostgres.
Longer than mocks, of course, but this is almost a complete analogue of work in production - the database has risen, initialized with data, we have performed the actions we need (the same insert or select of any complexity), and died.
For mocks are, of course, good, but what if we have already changed the structure of the database, but not the tests?
The code works with old mocks, everything is fine - but in real work, bang, and "everyone died" ...