Shell application for interacting with university database. Application has tests samples inside and prepared db scripts, which are executed with flyway.
List of available shell command (all commands require shell to be enabled (besides obviously "Enable S/I" and "Disable S/I"), which is doable by the command "Enable S/I") :
-
Enable S/I
-
Disable S/I
-
Show count of employee for department [department_name] (department_name without spaces)
-
Show the average salary for the department [department_name] (department_name without spaces)
-
Who is head of department [department_name] (department_name without spaces)
-
Show statistics of department [department_name] (department_name without spaces)
-
Global search by [template] (tempalte without spaces)