Archive Trac dn airavata 0 16 derby dump

Dn Airavata 0 16 Derby Dump

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

dump airavata's 0.16.0 derby database

• create dump_airavata.sql containing :

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.DATA_STORAGE_PREFERENCE;
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;

connect 'jdbc:derby://localhost/experiment_catalog';
select * from AIRAVATA.COMMUNITY_USER;
select * from AIRAVATA.CONFIGURATION;
select * from AIRAVATA.CREDENTIALS;
select * from AIRAVATA.EXPERIMENT;
select * from AIRAVATA.EXPERIMENT_ERROR;
select * from AIRAVATA.EXPERIMENT_INPUT;
select * from AIRAVATA.EXPERIMENT_OUTPUT;
select * from AIRAVATA.EXPERIMENT_STATUS;
select * from AIRAVATA.GATEWAY;
select * from AIRAVATA.GATEWAY_WORKER;
select * from AIRAVATA.JOB;
select * from AIRAVATA.JOB_STATUS;
select * from AIRAVATA.PROCESS;
select * from AIRAVATA.PROCESS_ERROR;
select * from AIRAVATA.PROCESS_INPUT;
select * from AIRAVATA.PROCESS_OUTPUT;
select * from AIRAVATA.PROCESS_RESOURCE_SCHEDULE;
select * from AIRAVATA.PROCESS_STATUS;
select * from AIRAVATA.PROJECT;
select * from AIRAVATA.PROJECT_USER;
select * from AIRAVATA.TASK;
select * from AIRAVATA.TASK_ERROR;
select * from AIRAVATA.TASK_STATUS;
select * from AIRAVATA.USERS;
select * from AIRAVATA.USER_CONFIGURATION_DATA;
disconnect;
}

 * ij dump_airavata.sql > output.txt