The Sakila database is a sample database schema and data that was originally developed by MySQL. It is intended to provide a standard schema that can be used for examples and tests.
This project is a starting point for simple examples/demos that need a somewhat realistic dataset. It provides Spring Data JPA based backend and uses TestContainers to initialize a database with the Sakila test database schema and data. It automatically starts Sakila DB docker images that come with pre-populated database. Delete the local container if you want to reset the database.
The DB entities where autogenerated using IntelliJ IDEA's JPA plugin with some manual modifications. There are also some handcrafted entities and repositories for views.
postgresql- PostgreSQL databasemysql- MySQL database
Trying to keep other differences than testcontainer configurations to the minimum.
- Docker
- Java 21+
- Maven
- Strongly suggested: JRebel or HotswapAgent (Hibernate :-) )
- Fork the repository for your own needs
- Import to your favourite IDE
- Make sure you have Docker running
- Run the
TestDemoApplicationclass from the src/test/java folder. This will start the Spring Boot application and initialize the database with TestContainers. - Utilize the "entity explorer" from the test application to browse the database state and to make limited edits during development.
- Ready? Implement your demo app to the src/main/java folder!
Screenshot of the entity explorer available for testing and development purposes:
Note, if you plan to use Vaadin for your example, you should recognise that the explorer is built with Vaadin and and its dependencies in the test scope may interfere with your app. Replace the Vaadin dependencies from the test scope with actual setup to default scope!
- Add missing entities/repositories
- Add some service classes
- Deleting existing entities (to entity explorer)
- Branches for different database types (currently only MySQL and PostgreSQL)
- Gradle branches (or both Maven and Gradle build files)