Archive: Scala mysql small application

Budget 33$ per month

Posted: 5 years ago

Closed

Description: I want a utility written in scala 2.12.8 and sbt 1.28 which could connect to a mysql database via a connection pool.

For testing (which must be included as part of the source code), we could connects with Mysql sample database "The Sakila".

This program then evalutes metadata of the databse and saves that in a database named "metadata-evaluation". The database will also exist in mysql databse.

The metadata will include table names, number of rows in each table. List of unique keys or any other keys for a column in a table. A comprehensive list of primary keys and foreign keys of a table. It should also include all columns and their data types alongside restictions.

All querries which need to executed on the test database "The Sakila" all of them must go through flywaydb in which those querries must be written in generic format so that they could be executed against any database.

All the tables in "metadata-evaluation" should conform to third nomal form.

Developer may use playframework or AKKA to accomplish the job.
Skills:
mysql,akka,applications developer,Scala programming language,software development