SQL_DELIVERY_SPEC = """SELECT cmm.customer_master_master_id as dms_id,
dds.order_type,
dds.domain_name,
dds.user_name,
dds.password,
dds.port,
dds.authenticate_type,
dds.remote_initial_dir,
dds.connection_type,
dds.aws_s3_region,
dds.md5_fingerprint,
dds.ftp_pasv_mode,
dds.private_key_file,
acss.domain_name AS cloud_domain_name,
acss.user_name AS cloud_user_name,
acss.password AS cloud_password,
acss.udp_port,
acss.protocol AS cloud_protocol,
dds.gcs_config_file,
dds.file_encryption_passphrase,
dds.pubkey_passphrase,
dds.aspera_token,
dds.aws_s3_signature_version
FROM customer_master_master cmm
LEFT JOIN dms_delivery_spec dds
ON cmm.customer_master_master_id = dds.dms_master_master_id 
AND dds.order_type = order_type
LEFT JOIN aspera_cloud_storage_spec acss 
ON acss.dms_delivery_spec_id = dds.dms_delivery_spec_id
WHERE dds.dms_master_master_id IN ({})"""

SQL_DELIVERY_SPEC_ALL = """SELECT cmm.customer_master_master_id as dms_id,
dds.order_type,
dds.domain_name,
dds.user_name,
dds.password,
dds.port,
dds.authenticate_type,
dds.remote_initial_dir,
dds.connection_type,
dds.aws_s3_region,
dds.md5_fingerprint,
dds.ftp_pasv_mode,
dds.private_key_file,
acss.domain_name AS cloud_domain_name,
acss.user_name AS cloud_user_name,
acss.password AS cloud_password,
acss.udp_port,
acss.protocol AS cloud_protocol,
dds.gcs_config_file,
dds.file_encryption_passphrase,
dds.pubkey_passphrase,
dds.aspera_token,
dds.aws_s3_signature_version
FROM customer_master_master cmm
INNER JOIN dms_delivery_spec dds
ON cmm.customer_master_master_id = dds.dms_master_master_id 
AND dds.order_type = order_type
LEFT JOIN aspera_cloud_storage_spec acss 
ON acss.dms_delivery_spec_id = dds.dms_delivery_spec_id"""