select 'mkdir -p '|| regexp_replace(object_path, '/DICOM_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/DICOM/validatedDICOM' ||
 regexp_replace(object_path, '.*/DICOM','') || ' ' || object_path || ';' from dicom_validated_object ;

select 'mkdir -p '|| regexp_replace(object_path, '/validatorDetector_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/validatorDetector/analyzedObject' ||
 regexp_replace(object_path, '.*/validatorDetector','') || ' ' || object_path || ';' from object_for_validator_detector ;



--CDA
select 'mkdir -p '|| regexp_replace(cda_file_path, '/CDA_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/CDA/validatedCDA' ||
 regexp_replace(cda_file_path, '.*/CDA','') || ' ' || cda_file_path || ';' from cda_validated_file ;

--    select
--     ' mv /opt/EVSClient_prod/validatedObjects/CDA/validatedCDA' ||
--     regexp_replace(cda_file_path, '.*/CDA','/pdfFromCDA') || ' ' || replace(cda_file_path, 'CDA_[0-9]*.xml', '') || ';' from cda_validated_file ;

--ATNA
select 'mkdir -p '|| regexp_replace(message_file_path, '/ATNA_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/ATNA/auditMessage' ||
 regexp_replace(message_file_path, '.*/ATNA','') || ' ' || message_file_path || ';' from atna_validated_message ;

--DSUB
select 'mkdir -p '|| regexp_replace(dsub_path, '/DSUB_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/DSUB/validatedDSUB' ||
 regexp_replace(dsub_path, '.*/DSUB','') || ' ' || dsub_path || ';' from validated_dsub ;

--TLS
select 'mkdir -p '|| regexp_replace(pem_file_path, '/TLS_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/TLS/tlsCertificates' ||
 regexp_replace(pem_file_path, '.*/TLS','') || ' ' || pem_file_path || ';' from tls_validated_certificate ;


--SAML
select 'mkdir -p '|| regexp_replace(file_path, '/SAML_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/SAML/assertion' ||
 regexp_replace(file_path, '.*/SAML','') || ' ' || file_path || ';' from saml_validated_assertion ;


--SVS
select 'mkdir -p '|| regexp_replace(file_path, '/SVS_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/SVS/SVS' ||
 regexp_replace(file_path, '.*/SVS','') || ' ' || file_path || ';' from validated_svs ;

--HPD
select 'mkdir -p '|| regexp_replace(file_path, '/HPD_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/HPD/HPD' ||
 regexp_replace(file_path, '.*/HPD','') || ' ' || file_path || ';' from validated_hpd ;


--HL7v3
select 'mkdir -p '|| regexp_replace(message_file_path, '/HL7v3_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/HL7v3/validatedHL7v3' ||
 regexp_replace(message_file_path, '.*/HL7v3','') || ' ' || message_file_path || ';' from hl7v3_validated_message ;


--PDF
select 'mkdir -p '|| regexp_replace(pdf_path, '/PDF_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/PDF/validatedPDF' ||
 regexp_replace(pdf_path, '.*/PDF','') || ' ' || pdf_path || ';' from validated_pdf ;


--XDS
select 'mkdir -p '|| regexp_replace(xds_path, '/XDS_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/XDS/validatedXDS' ||
 regexp_replace(xds_path, '.*/XDS','') || ' ' || xds_path || ';' from validated_xds ;


--XDW
select 'mkdir -p '|| regexp_replace(xdw_path, '/XDW_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/XDW/validatedXDW' ||
 regexp_replace(xdw_path, '.*/XDW','') || ' ' || xdw_path || ';' from validated_xdw ;


--XML
select 'mkdir -p '|| regexp_replace(xml_path, '/ValidatedXML_.*', '') ||
 '; mv /opt/EVSClient_prod/validatedObjects/XML/validatedXML' ||
 regexp_replace(xml_path, '.*/XML','') || ' ' || xml_path || ';' from validated_xml ;