|
| 1 | +#!/bin/bash |
| 2 | +set -ev |
| 3 | +cd $(dirname $(readlink -f $0)) |
| 4 | + |
| 5 | +PROJECT_FILE="utPLSQL-demo-project" |
| 6 | +git clone -b develop --single-branch https://github.com/utPLSQL/utPLSQL-demo-project.git |
| 7 | + |
| 8 | +cat > demo_project.sh.tmp <<EOF |
| 9 | +sqlplus -S -L sys/oracle@//127.0.0.1:1521/xe AS SYSDBA <<SQL |
| 10 | +create user ${DB_USER} identified by ${DB_PASS} quota unlimited on USERS default tablespace USERS; |
| 11 | +grant create session, create procedure, create type, create table, create sequence, create view to ${DB_USER}; |
| 12 | +grant select any dictionary to ${DB_USER}; |
| 13 | +exit |
| 14 | +SQL |
| 15 | +
|
| 16 | +cd ${PROJECT_FILE} |
| 17 | +sqlplus -S -L ${DB_USER}/${DB_PASS}@//127.0.0.1:1521/xe <<SQL |
| 18 | +whenever sqlerror exit failure rollback |
| 19 | +whenever oserror exit failure rollback |
| 20 | +
|
| 21 | +@source/award_bonus/employees_test.sql |
| 22 | +@source/award_bonus/award_bonus.prc |
| 23 | +
|
| 24 | +@source/between_string/betwnstr.fnc |
| 25 | +
|
| 26 | +@source/remove_rooms_by_name/rooms.sql |
| 27 | +@source/remove_rooms_by_name/remove_rooms_by_name.prc |
| 28 | +
|
| 29 | +@test/award_bonus/test_award_bonus.pks |
| 30 | +@test/award_bonus/test_award_bonus.pkb |
| 31 | +
|
| 32 | +@test/between_string/test_betwnstr.pks |
| 33 | +@test/between_string/test_betwnstr.pkb |
| 34 | +
|
| 35 | +@test/remove_rooms_by_name/test_remove_rooms_by_name.pks |
| 36 | +@test/remove_rooms_by_name/test_remove_rooms_by_name.pkb |
| 37 | +
|
| 38 | +exit |
| 39 | +SQL |
| 40 | +EOF |
| 41 | + |
| 42 | +docker cp ./$PROJECT_FILE $ORACLE_VERSION:/$PROJECT_FILE |
| 43 | +docker cp ./demo_project.sh.tmp $ORACLE_VERSION:/demo_project.sh |
| 44 | +docker exec $ORACLE_VERSION bash demo_project.sh |
0 commit comments