Cheat Sheet

• Docker Build & Push
• Clean up XSK database
• Chrome Extensions
• Integration Tests

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;

Chrome Extensions

To Visualize XML install chrome extension xml-tree It will be used when showing xml related data, for example as *.xsodata.

Integration Tests

• Main focus is to test against PostgreSQL, MySQL and SAP HANA Cloud.
• There is a specific name pattern for each integration test (ending in ITTest).
• The itests profile is to be run as follows:

  mvn verify -Pitests "-Dhana.url=jdbcUrl" "-Dhana.username=jdbcUsername" "-Dhana.password=jdbcPassword"
  

  Note that you have to provide the credentials of your own HANA Cloud instance and more importantly to wrap them in quotes! Otherwise you might not be able to connect to the db instance due some special characters in respective db properties.