eTutor Task-App: JDBC

This application provides a REST interface for the following task type: JDBC.

Students can submit their solution for a JDBC task. The system is responsible for compiling and executing the submitted code and evaluating it against a predefined reference solution. The evaluation includes checks for syntax correctness, output accuracy, autocommit handling, database state conformity, and proper exception handling. Instructors can configure tasks with custom SQL schemas and a reference solution.

The application supports detailed feedback with different levels of granularity and allows configurable point deductions per criterion. The system also includes support for variable declarations that are injected before execution, enabling reusable code structures across multiple submissions.

Development

In development environment, the API documentation is available at http://localhost:8081/docs.

In order to run the application in development environment, the dev profile must be activated. This can be done by setting the environment variable SPRING_PROFILES_ACTIVE to dev or by setting the profile in the IDE run configuration.

See CONTRIBUTING.md for details.

Docker

Start a new instance of the application using Docker:

docker run -p 8090:8081 \ 
  -e SPRING_DATASOURCE_URL="JDBC:postgresql://postgres:5432/etutor_JDBC" \
  -e SPRING_DATASOURCE_USERNAME=etutor_JDBC \
  -e SPRING_DATASOURCE_PASSWORD=myPwd \
  -e SPRING_FLYWAY_USER=etutor_JDBC_admin \
  -e SPRING_FLYWAY_PASSWORD=adPwd \
  -e CLIENTS_API_KEYS_0_NAME=task-administration \
  -e CLIENTS_API_KEYS_0_KEY=some-secret-key \
  -e CLIENTS_API_KEYS_0_ROLES_0=CRUD \
  -e CLIENTS_API_KEYS_0_ROLES_1=SUBMIT \
  -e CLIENTS_API_KEYS_1_NAME=moodle \
  -e CLIENTS_API_KEYS_1_KEY=another-secret-key \
  -e CLIENTS_API_KEYS_1_ROLES_0=SUBMIT \
  -e CLIENTS_API_KEYS_2_NAME=plagiarism-checker \
  -e CLIENTS_API_KEYS_2_KEY=key-for-reading-submissions \
  -e CLIENTS_API_KEYS_2_ROLES_0=READ_SUBMISSION \
  etutorplusplus/task-app-JDBC

or with Docker Compose:

version: '3.8'

services:
    task-app-JDBC:
        image: etutorplusplus/task-app-JDBC
        restart: unless-stopped
        ports:
            -   target: 8081
                published: 8090
        environment:
            SPRING_DATASOURCE_URL: JDBC:postgresql://postgres:5432/etutor_JDBC
            SPRING_DATASOURCE_USERNAME: etutor_JDBC
            SPRING_DATASOURCE_PASSWORD: myPwd
            SPRING_FLYWAY_USER: etutor_JDBC_admin
            SPRING_FLYWAY_PASSWORD: adPwd
            CLIENTS_API_KEYS_0_NAME: task-administration
            CLIENTS_API_KEYS_0_KEY: some-secret-key
            CLIENTS_API_KEYS_0_ROLES_0: CRUD
            CLIENTS_API_KEYS_0_ROLES_1: SUBMIT
            CLIENTS_API_KEYS_1_NAME: moodle
            CLIENTS_API_KEYS_1_KEY: another-secret-key
            CLIENTS_API_KEYS_1_ROLES_0: SUBMIT
            CLIENTS_API_KEYS_2_NAME: plagiarism-checker
            CLIENTS_API_KEYS_2_KEY: key-for-reading-submissions
            CLIENTS_API_KEYS_2_ROLES_0: READ_SUBMISSION

Environment Variables

In production environment, the application requires two database users:

• A database administrator user which has the permission to create the tables.
• A JPA user which has read/write access (SELECT, INSERT, UPDATE, DELETE, TRUNCATE) to the database tables.

In development environment, one user will be used for both by default.

The users must be configured via environment variables. The clients have to be configured via environment variables as well (X/Y stands for a 0-based index).

Variable	Description
SERVER_PORT	The server port.
SPRING_DATASOURCE_URL	JDBC-URL to the database
SPRING_DATASOURCE_USERNAME	The username of the JPA user.
SPRING_DATASOURCE_PASSWORD	The password of the JPA user.
SPRING_FLYWAY_USER	The username of the database administrator user.
SPRING_FLYWAY_PASSWORD	The password of the database administrator user.
CLIENTS_API_KEYS_X_NAME	The name of the client.
CLIENTS_API_KEYS_X_KEY	The API key of the client.
CLIENTS_API_KEYS_X_ROLES_Y	The role of the client.