 ---------------------------------
 -- Notification Configurations --
 ---------------------------------
-INSERT INTO cnfgn VALUES ('herd.notification.sqs.outgoing.queue.name', '@SqsOutgoingQueue', NULL);
-INSERT INTO cnfgn VALUES ('herd.notification.sqs.incoming.queue.name', '@SqsIncomingQueue', NULL);
+INSERT INTO cnfgn VALUES ('herd.notification.sqs.outgoing.queue.name', :'SqsOutgoingQueue', NULL);
+INSERT INTO cnfgn VALUES ('herd.notification.sqs.incoming.queue.name', :'SqsIncomingQueue', NULL);
 INSERT INTO cnfgn VALUES ('herd.notification.sqs.enabled', 'false', NULL);
-

﻿/*
* Copyright 2015 herd contributors
*
* Licensed under the Apache License, Version 2.0 (the "License");

----------------------------
-- Configure parameters   --
----------------------------
\set SpringDatabase 'POSTGRESQL'
\set HibernateDialect 'org.hibernate.dialect.PostgreSQL9Dialect'
\set QuartzDelegate 'org.quartz.impl.jdbcjobstore.PostgreSQLDelegate'
\set EnvName ''
\set HttpProxyHost ''
\set HttpProxyPort ''
\set S3Endpoint ''
\set S3ManagedBucket ''
\set S3LoadingDockBucket ''
\set S3ExternalBucket ''

-- Staging bucket is where the various herd scripts are stored
\set S3StagingBucketAndKeyPrefix 'bucket-name/key-prefix'

\set IamUploaderArn ''
\set IamDownloaderArn ''
\set KmsLoadingDockArn ''
\set KmsExternalArn ''
\set OozieWorkflowLocation 'HERD_SCRIPTS/emr/bootstrap/herd_oozie_wrapper/'
\set OozieHdfsCopyScript 's3_hdfs_copy_script.sh'
\set OozieSecurityGroup ''
\set SqsIncomingQueue ''
\set SqsOutgoingQueue ''

------------------------------------------------------
-- Configure Storage Attributes for managed buckets --
------------------------------------------------------
INSERT INTO strge_atrbt VALUES (nextval('strge_atrbt_seq'), 'S3_MANAGED', 'bucket.name', :'S3ManagedBucket', current_timestamp, 'SYSTEM');
INSERT INTO strge_atrbt VALUES (nextval('strge_atrbt_seq'), 'S3_MANAGED_LOADING_DOCK', 'bucket.name', :'S3LoadingDockBucket', current_timestamp, 'SYSTEM');
INSERT INTO strge_atrbt VALUES (nextval('strge_atrbt_seq'), 'S3_MANAGED_EXTERNAL', 'bucket.name', :'S3ExternalBucket', current_timestamp, 'SYSTEM');
INSERT INTO strge_atrbt VALUES (nextval('strge_atrbt_seq'), 'S3_MANAGED', 's3.endpoint', :'S3Endpoint', current_timestamp, 'SYSTEM');
INSERT INTO strge_atrbt VALUES (nextval('strge_atrbt_seq'), 'S3_MANAGED_LOADING_DOCK', 's3.endpoint', :'S3Endpoint', current_timestamp, 'SYSTEM');
INSERT INTO strge_atrbt VALUES (nextval('strge_atrbt_seq'), 'S3_MANAGED_EXTERNAL', 's3.endpoint', :'S3Endpoint', current_timestamp, 'SYSTEM');


-------------------------
-- Name of Environment --
-------------------------
INSERT INTO cnfgn VALUES ('herd.environment', :'EnvName', NULL);
INSERT INTO cnfgn VALUES ('s3.staging.resources.base', :'EnvName', NULL);

-------------------
-- Database Type --
-------------------
INSERT INTO cnfgn VALUES ('org.springframework.orm.jpa.vendor.Database', :'SpringDatabase', NULL);
INSERT INTO cnfgn VALUES ('hibernate.dialect', :'HibernateDialect', NULL);
INSERT INTO cnfgn VALUES ('org.quartz.jobStore.driverDelegateClass', :'QuartzDelegate', NULL);

-----------------------
-- Proxy Information --
-----------------------
INSERT INTO cnfgn VALUES ('http.proxy.hostname', :'HttpProxyHost', NULL);
INSERT INTO cnfgn VALUES ('http.proxy.port', :'HttpProxyPort', NULL);

--------------------------------
-- Large File System Security --
--------------------------------
INSERT INTO cnfgn VALUES ('aws.loading.dock.uploader.role.arn', :'IamUploaderArn', NULL);
INSERT INTO cnfgn VALUES ('aws.external.downloader.role.arn', :'IamDownloaderArn', NULL);
INSERT INTO cnfgn VALUES ('aws.kms.loading.dock.key.id', :'KmsLoadingDockArn', NULL);
INSERT INTO cnfgn VALUES ('aws.kms.external.key.id', :'KmsExternalArn', NULL);

------------------
-- Bucket Names --
------------------
INSERT INTO cnfgn VALUES ('s3.managed.bucket.name', :'S3ManagedBucket', NULL);
INSERT INTO cnfgn VALUES ('s3.staging.bucket.name', :'S3StagingBucketAndKeyPrefix', NULL);
INSERT INTO cnfgn VALUES ('s3.endpoint', :'S3Endpoint', NULL);

------------------------------
-- Oozie Scripts and Config --
------------------------------
INSERT INTO cnfgn VALUES ('emr.oozie.herd.wrapper.workflow.s3.location', :'OozieWorkflowLocation', NULL);
INSERT INTO cnfgn VALUES ('emr.s3.hdfs.copy.script', :'OozieHdfsCopyScript', NULL);
INSERT INTO cnfgn VALUES ('emr.herd.support.security.group', :'OozieSecurityGroup', NULL);

----------------------
-- Disable security --
