Cheat Sheet

Cheat Sheet

• Docker Build & Push
• Clean up XSK database

Docker Build & Push

• Local:

  cd releng/server
  docker build -t dirigiblelabs/xsk .
  docker push dirigiblelabs/xsk
  

• Cloud Foundry:

  cd releng/sap-cf
  docker build -t dirigiblelabs/xsk-cf .
  docker push dirigiblelabs/xsk-cf
  

• Kyma:

  cd releng/sap-kyma
  docker build -t dirigiblelabs/xsk-kyma . 
  docker push dirigiblelabs/xsk-kyma
  

• Developer - if you want to use a HotSwap enabled JDK:

  cd releng/developer
  docker build -t dirigiblelabs/xsk --build-arg JDK_TYPE=hotswap-jdk --build-arg USE_HOTSWAP_JDK .
  

  Using a HotSwap enabled JVM like TravaOpenJDK enables you to patch Java code while still debugging. Additional info if using IntelliJ could be found here. Have in mind the HotSwap limitations described there should not exist in the XSK as the hotswap-jdk configuration in Docker uses a Dynamic Code Evolution VM by default.

Clean up XSK database

DROP VIEW DIRIGIBLE_DISCUSSIONS_BOARD_RATING;
DROP VIEW DIRIGIBLE_DISCUSSIONS_BOARD_STATS;
DROP VIEW DIRIGIBLE_DISCUSSIONS_STATS;

DROP TABLE DIRIGIBLE_BPM;
DROP TABLE DIRIGIBLE_DATA_STRUCTURES;
DROP TABLE DIRIGIBLE_DISCUSSIONS_BOARD;
DROP TABLE DIRIGIBLE_DISCUSSIONS_BOARD_TAG;
DROP TABLE DIRIGIBLE_DISCUSSIONS_BOARD_VOTE;
DROP TABLE DIRIGIBLE_DISCUSSIONS_TAGS;
DROP TABLE DIRIGIBLE_DISCUSSIONS_USERS;
DROP TABLE DIRIGIBLE_DISCUSSIONS_COMMENT;
DROP TABLE DIRIGIBLE_EXTENSIONS;
DROP TABLE DIRIGIBLE_EXTENSION_POINTS;
DROP TABLE DIRIGIBLE_IDENTITY;
DROP TABLE DIRIGIBLE_JOBS;
DROP TABLE DIRIGIBLE_LISTENERS;
DROP TABLE DIRIGIBLE_MIGRATIONS;
DROP TABLE DIRIGIBLE_ODATA;
DROP TABLE DIRIGIBLE_ODATA_CONTAINER;
DROP TABLE DIRIGIBLE_ODATA_MAPPING;
DROP TABLE DIRIGIBLE_ODATA_SCHEMA;
DROP TABLE DIRIGIBLE_PUBLISH_LOGS;
DROP TABLE DIRIGIBLE_PUBLISH_REQUESTS;
DROP TABLE DIRIGIBLE_SECURITY_ACCESS;
DROP TABLE DIRIGIBLE_SECURITY_ROLES;
DROP TABLE DIRIGIBLE_SYNCHRONIZER_STATE;
DROP TABLE DIRIGIBLE_SYNCHRONIZER_STATE_LOG;
DROP TABLE DIRIGIBLE_WEBSOCKETS;

DROP TABLE QUARTZ_BLOB_TRIGGERS;
DROP TABLE QUARTZ_CALENDARS;
DROP TABLE QUARTZ_CRON_TRIGGERS;
DROP TABLE QUARTZ_FIRED_TRIGGERS;
DROP TABLE QUARTZ_LOCKS;
DROP TABLE QUARTZ_PAUSED_TRIGGER_GRPS;
DROP TABLE QUARTZ_SCHEDULER_STATE;
DROP TABLE QUARTZ_SIMPLE_TRIGGERS;
DROP TABLE QUARTZ_SIMPROP_TRIGGERS;
DROP TABLE QUARTZ_TRIGGERS;
DROP TABLE QUARTZ_JOB_DETAILS;

DROP TABLE XSK_DATA_STRUCTURES;
DROP TABLE XSK_IMPORTED_CSV_RECORDS;
DROP TABLE XSK_JOBS;
DROP TABLE XSK_ODATA;
DROP TABLE XSK_PRIVILEGES;
DROP TABLE XSK_SECURE_STORE_LIST;
DROP TABLE XSK_SECURITY_ACCESS;
DROP TABLE XSK_TABLE_IMPORT_TO_CSV;