/aip-mysql

Primary LanguageMakefile

The repository contains the source code for building the results databases for the AI services.

building the results databases

The repository has been setup using 'make' to build all images.

  • make build will build all images
  • make clean will erase all images

results database directory structure

The results database directory contains at minimum:

  • makefile : the commands to automate the building, cleaning, etc.
  • Dockerfile: the dockerfile creating the results database as an mysql database based on the base image
  • table.sql: the statements to create the results database and result table
  • insert.sql: an example insert of at least a single result
  • test.sql: an example query to retrieve the single result
  • README.md: documentation of the AI service results database

Adding a new results database

Adding a new results databases consists of the following steps:

  • create a new subdirectory 'ai-service-{ACRONYM}'
  • initialise the new subdirectory using the files of ai-service-EXSM
  • adapt the sql statements to match the new results database structure
  • adapt the makefile to ensure the image name is matching the {ACRONYM}
  • document the results database in the README.md

After creating and buiding the new results database, the AI service developer should test the image by e.g. using the image in a docker-compose configuration of the AI service.

base image

The base image is located in the directory ai-proficient-mysql. All commonalities that must be shared accross all results databases should be made in this image.