.gitpod.yml

tasks:
  - init: |
      # open the readme.md document in VS code; note: thanks to the configuration in .vscode/settings.json, the document opens in markdown preview mode
      gp open README.md
      alias sql="/workspace/gitpod-oracle-database/sqlcl/bin/sql"
      wget https://download.oracle.com/otn_software/java/sqldeveloper/sqlcl-latest.zip && unzip -q sqlcl-latest.zip && 
      echo "done with download and unzip SQLcl" 
  - name: start container and run SQL*Plus session as user APP
    init: gp sync-await database-running
    command: |
      docker start oracle-database-xe  &&
      docker ps &&  
      sleep 3s && 
      echo "Oracle Database XE is running. The database is accessible at localhost, port 1521; database SID = XE and has an additional user APP/APPPW in PDB XEPDB1 " && 
      gp sync-done database-started &&
      docker exec -it oracle-database-xe sqlplus sys/TheSuperSecret1509! as sysdba
  - name: Open SQLcl for user APP
    init: |
      gp sync-await database-running
    command: |
      gp sync-await database-started &&
      /workspace/gitpod-oracle-database/sqlcl/bin/sql APP/APPPW@localhost:1521/xepdb1 

ports:

  # Oracle Database 19c EE
  - port: 1521
    onOpen: ignore
    visibility: private

vscode:
  extensions:
    - Oracle.oracledevtools