bearddan2000 / groovy-cli-gradle-ssl-postgres-procedure

Creates a small database table

groovy-cli-gradle-ssl-postgres-procedure

Description

Creates a small database table called dog with an insert update delete after triggers. The trigger function fn_trigger calls sp_rolling_audit that remmoves old entries.

All output normally seen in a terminal will be in groovy-srv/log which will dump to the screen. The project may seem to hang but the logs from the container must be written to the project this can take up to 3 min.

Uses self-sign ssl.

Tech stack

• groovy
• gradle
  • log4j
  • postgres driver

Docker stack

• alpine:edge
• postgres:alpine
• gradle:jdk11

To run

sudo ./install.sh -u Creates groovy-srv/log

To stop

sudo ./install.sh -d Removes groovy-srv/log

For help

sudo ./install.sh -h

Credit

Stored procedure based on