Archive Trac dn airavata derby dump

Dn Airavata Derby Dump

Legacy Trac archive page imported from dn_airavata_derby_dump. Source: https://genapp.rocks/wiki/wiki/dn_airavata_derby_dump. Review age, links, and examples before treating as current.

dump airavata's derby database

• create dump_airavata.sql containing :

connect 'jdbc:derby://localhost/experiment_catalog';
select * from AIRAVATA.ADVANCE_INPUT_DATA_HANDLING;
select * from AIRAVATA.ADVANCE_OUTPUT_DATA_HANDLING;
select * from AIRAVATA.APPLICATION_INPUT;
select * from AIRAVATA.APPLICATION_OUTPUT;
select * from AIRAVATA.COMMUNITY_USER;
select * from AIRAVATA.COMPUTATIONAL_RESOURCE_SCHEDULING;
select * from AIRAVATA.CONFIGURATION;
select * from AIRAVATA.CONFIG_DATA;
select * from AIRAVATA.CREDENTIALS;
select * from AIRAVATA.DATA_TRANSFER_DETAIL;
select * from AIRAVATA.ERROR_DETAIL;
select * from AIRAVATA.EXPERIMENT;
select * from AIRAVATA.EXPERIMENT_INPUT;
select * from AIRAVATA.EXPERIMENT_OUTPUT;
select * from AIRAVATA.GATEWAY;
select * from AIRAVATA.GATEWAY_WORKER;
select * from AIRAVATA.JOB_DETAIL;
select * from AIRAVATA.NODE_INPUT;
select * from AIRAVATA.NODE_OUTPUT;
select * from AIRAVATA.NOTIFICATION_EMAIL;
select * from AIRAVATA.OPENJPA_SEQUENCE_TABLE;
select * from AIRAVATA.PROJECT;
select * from AIRAVATA.PROJECT_USER;
select * from AIRAVATA.QOS_PARAM;
select * from AIRAVATA.QOS_PARAMS;
select * from AIRAVATA.STATUS;
select * from AIRAVATA.TASK_DETAIL;
select * from AIRAVATA.USERS;
select * from AIRAVATA.WORKFLOW_NODE_DETAIL;
disconnect;

connect 'jdbc:derby://localhost/app_catalog';
select * from AIRAVATA.APPLICATION_DEPLOYMENT;
select * from AIRAVATA.APPLICATION_INPUT;
select * from AIRAVATA.APPLICATION_INTERFACE;
select * from AIRAVATA.APPLICATION_MODULE;
select * from AIRAVATA.APPLICATION_OUTPUT;
select * from AIRAVATA.APP_ENVIRONMENT;
select * from AIRAVATA.APP_MODULE_MAPPING;
select * from AIRAVATA.BATCH_QUEUE;
select * from AIRAVATA.COMPUTE_RESOURCE;
select * from AIRAVATA.COMPUTE_RESOURCE_FILE_SYSTEM;
select * from AIRAVATA.COMPUTE_RESOURCE_PREFERENCE;
select * from AIRAVATA.CONFIGURATION;
select * from AIRAVATA.DATA_MOVEMENT_INTERFACE;
select * from AIRAVATA.GATEWAY_PROFILE;
select * from AIRAVATA.GLOBUS_GK_ENDPOINT;
select * from AIRAVATA.GLOBUS_SUBMISSION;
select * from AIRAVATA.GRIDFTP_DATA_MOVEMENT;
select * from AIRAVATA.GRIDFTP_ENDPOINT;
select * from AIRAVATA.GSISSH_EXPORT;
select * from AIRAVATA.GSISSH_SUBMISSION;
select * from AIRAVATA.HOST_ALIAS;
select * from AIRAVATA.HOST_IPADDRESS;
select * from AIRAVATA.JOB_MANAGER_COMMAND;
select * from AIRAVATA.JOB_SUBMISSION_INTERFACE;
select * from AIRAVATA.LIBRARY_APEND_PATH;
select * from AIRAVATA.LIBRARY_PREPAND_PATH;
select * from AIRAVATA.LOCAL_DATA_MOVEMENT;
select * from AIRAVATA.LOCAL_SUBMISSION;
select * from AIRAVATA.MODULE_LOAD_CMD;
select * from AIRAVATA.POSTJOB_COMMAND;
select * from AIRAVATA.PREJOB_COMMAND;
select * from AIRAVATA.RESOURCE_JOB_MANAGER;
select * from AIRAVATA.SCP_DATA_MOVEMENT;
select * from AIRAVATA.SSH_JOB_SUBMISSION;
select * from AIRAVATA.UNICORE_DATAMOVEMENT;
select * from AIRAVATA.UNICORE_SUBMISSION;
select * from AIRAVATA.WORKFLOW;
select * from AIRAVATA.WORKFLOW_INPUT;
select * from AIRAVATA.WORKFLOW_OUTPUT;
disconnect;

• ij dump_airavata.sql > output.txt