Setting up sample database in MySQL

[fruether]

Someone has to setup a MySQL database and a setup script that creates a MySQL Database, tables and data that can be used for testing purposes. As input and as database schema the test cases of WrC should be used:

• https://www.w3.org/2001/sw/rdb2rdf/test-cases/#D000-1table1column0rows

Precondition

• MySQL is running on the local machine
• SQL statements for setup and data load are in sql files on GitHub
• Make it easy to use:
  • JUNIT test case that setups the database accordingly
    • https://medium.com/singlemusic-tech/using-embedded-mysql-in-junit-tests-ca62cda8d5a0
  • On build maven automatically loads data into MySQL database e.g. something like that: https://stackoverflow.com/questions/31965222/how-insert-data-to-database-using-maven