Create submit route

[clamp.git] / src / test / resources / sql / four_templates_only.sql

diff --git a/src/test/resources/sql/four_templates_only.sql b/src/test/resources/sql/four_templates_only.sql
index 2a333ce..862e360 100755 (executable)
--- a/src/test/resources/sql/four_templates_only.sql
+++ b/src/test/resources/sql/four_templates_only.sql
@@ -47,7 +47,7 @@ UNLOCK TABLES;
 
 LOCK TABLES `template_doc` WRITE;
 /*!40000 ALTER TABLE `template_doc` DISABLE KEYS */;
-INSERT INTO `template_doc` VALUES ('04ebec9b-17eb-11e8-b63b-0242ac130002','04e43cfa-17eb-11e8-b63b-0242ac130002','{}',NULL,'2018-02-22 16:11:20'),('27b1a0c9-17eb-11e8-b63b-0242ac130002','27aa4250-17eb-11e8-b63b-0242ac130002','{\"global\":[{\"name\":\"service\",\"value\":[\"tosca_definitions_version: cloudify_dsl_1_3\\r\\nimports:\\r\\n- http://www.getcloudify.org/spec/cloudify/3.4/types.yaml\\r\\n- https://nexus01.research.att.com:8443/repository/solutioning01-mte2-raw/type_files/docker/2.2.0/node-type.yaml\\r\\n- https://nexus01.research.att.com:8443/repository/solutioning01-mte2-raw/type_files/relationship/1.0.0/node-type.yaml\\r\\n- http://nexus01.research.att.com:8081/repository/solutioning01-mte2-raw/type_files/dmaap/dmaap_mr.yaml\\r\\ninputs:\\r\\n  location_id:\\r\\n    type: string\\r\\n  service_id:\\r\\n    type: string\\r\\nnode_templates:\\r\\n  cdap_host_host:\\r\\n    type: dcae.nodes.StreamingAnalytics.SelectedCDAPInfrastructure\\r\\n    properties:\\r\\n      location_id:\\r\\n        get_input: location_id\\r\\n      scn_override: cdap_broker.solutioning-central.dcae.att.com\\r\\n    interfaces:\\r\\n      cloudify.interfaces.lifecycle: {}\\r\\n  tca_tca:\\r\\n    type: dcae.nodes.MicroService.cdap\\r\\n    properties:\\r\\n      app_config:\\r\\n        appDescription: DCAE Analytics Threshold Crossing Alert Application\\r\\n        appName: dcae-tca\\r\\n        tcaSubscriberOutputStreamName: TCASubscriberOutputStream\\r\\n        tcaVESAlertsTableName: TCAVESAlertsTable\\r\\n        tcaVESAlertsTableTTLSeconds: \'1728000\'\\r\\n        tcaVESMessageStatusTableName: TCAVESMessageStatusTable\\r\\n        tcaVESMessageStatusTableTTLSeconds: \'86400\'\\r\\n        thresholdCalculatorFlowletInstances: \'2\'\\r\\n      app_preferences:\\r\\n        publisherContentType: application/json\\r\\n        publisherHostName: mrlocal-mtnjftle01.homer.att.com\\r\\n        publisherHostPort: \'3905\'\\r\\n        publisherMaxBatchSize: \'10\'\\r\\n        publisherMaxRecoveryQueueSize: \'100000\'\\r\\n        publisherPollingInterval: \'20000\'\\r\\n        publisherProtocol: https\\r\\n        publisherTopicName: com.att.dcae.dmaap.mtnje2.DcaeTestVESPub\\r\\n        publisherUserName: m00502@tca.af.dcae.att.com\\r\\n        publisherUserPassword: Te5021abc\\r\\n        subscriberConsumerGroup: OpenDCAE-c12\\r\\n        subscriberConsumerId: c12\\r\\n        subscriberContentType: application/json\\r\\n        subscriberHostName: mrlocal-mtnjftle01.homer.att.com\\r\\n        subscriberHostPort: \'3905\'\\r\\n        subscriberMessageLimit: \'-1\'\\r\\n        subscriberPollingInterval: \'20000\'\\r\\n        subscriberProtocol: https\\r\\n        subscriberTimeoutMS: \'-1\'\\r\\n        subscriberTopicName: com.att.dcae.dmaap.mtnje2.DcaeTestVESSub\\r\\n        subscriberUserName: m00502@tca.af.dcae.att.com\\r\\n        subscriberUserPassword: Te5021abc\\r\\n        tca_policy: \\r\\n      artifact_name: dcae-analytics-tca\\r\\n      artifact_version: 1.0.0\\r\\n      connections:\\r\\n        streams_publishes: []\\r\\n        streams_subscribes: []\\r\\n      jar_url: http://somejar\\r\\n      location_id:\\r\\n        get_input: location_id\\r\\n      namespace: cdap_tca_hi_lo\\r\\n      programs:\\r\\n      - program_id: TCAVESCollectorFlow\\r\\n        program_type: flows\\r\\n      - program_id: TCADMaaPMRSubscriberWorker\\r\\n        program_type: workers\\r\\n      - program_id: TCADMaaPMRPublisherWorker\\r\\n        program_type: workers\\r\\n      service_component_type: cdap_app_tca\\r\\n      service_id:\\r\\n        get_input: service_id\\r\\n      streamname: TCASubscriberOutputStream\\r\\n    relationships:\\r\\n    - target: cdap_host_host\\r\\n      type: dcae.relationships.component_contained_in\\r\\n\"]}]}',NULL,'2018-02-22 16:12:18'),('3c0d7849-17eb-11e8-b63b-0242ac130002','3c02f310-17eb-11e8-b63b-0242ac130002','{\"global\":[{\"name\":\"service\",\"value\":[\"tosca_definitions_version: cloudify_dsl_1_3\\r\\nimports:\\r\\n- http://www.getcloudify.org/spec/cloudify/3.4/types.yaml\\r\\n- https://nexus01.research.att.com:8443/repository/solutioning01-mte2-raw/type_files/docker/2.2.0/node-type.yaml\\r\\n- https://nexus01.research.att.com:8443/repository/solutioning01-mte2-raw/type_files/relationship/1.0.0/node-type.yaml\\r\\n- http://nexus01.research.att.com:8081/repository/solutioning01-mte2-raw/type_files/dmaap/dmaap_mr.yaml\\r\\ninputs:\\r\\n  location_id:\\r\\n    type: string\\r\\n  service_id:\\r\\n    type: string\\r\\nnode_templates:\\r\\n  cdap_host_host:\\r\\n    type: dcae.nodes.StreamingAnalytics.SelectedCDAPInfrastructure\\r\\n    properties:\\r\\n      location_id:\\r\\n        get_input: location_id\\r\\n      scn_override: cdap_broker.solutioning-central.dcae.att.com\\r\\n    interfaces:\\r\\n      cloudify.interfaces.lifecycle: {}\\r\\n  tca_tca:\\r\\n    type: dcae.nodes.MicroService.cdap\\r\\n    properties:\\r\\n      app_config:\\r\\n        appDescription: DCAE Analytics Threshold Crossing Alert Application\\r\\n        appName: dcae-tca\\r\\n        tcaSubscriberOutputStreamName: TCASubscriberOutputStream\\r\\n        tcaVESAlertsTableName: TCAVESAlertsTable\\r\\n        tcaVESAlertsTableTTLSeconds: \'1728000\'\\r\\n        tcaVESMessageStatusTableName: TCAVESMessageStatusTable\\r\\n        tcaVESMessageStatusTableTTLSeconds: \'86400\'\\r\\n        thresholdCalculatorFlowletInstances: \'2\'\\r\\n      app_preferences:\\r\\n        publisherContentType: application/json\\r\\n        publisherHostName: mrlocal-mtnjftle01.homer.att.com\\r\\n        publisherHostPort: \'3905\'\\r\\n        publisherMaxBatchSize: \'10\'\\r\\n        publisherMaxRecoveryQueueSize: \'100000\'\\r\\n        publisherPollingInterval: \'20000\'\\r\\n        publisherProtocol: https\\r\\n        publisherTopicName: com.att.dcae.dmaap.mtnje2.DcaeTestVESPub\\r\\n        publisherUserName: m00502@tca.af.dcae.att.com\\r\\n        publisherUserPassword: Te5021abc\\r\\n        subscriberConsumerGroup: OpenDCAE-c12\\r\\n        subscriberConsumerId: c12\\r\\n        subscriberContentType: application/json\\r\\n        subscriberHostName: mrlocal-mtnjftle01.homer.att.com\\r\\n        subscriberHostPort: \'3905\'\\r\\n        subscriberMessageLimit: \'-1\'\\r\\n        subscriberPollingInterval: \'20000\'\\r\\n        subscriberProtocol: https\\r\\n        subscriberTimeoutMS: \'-1\'\\r\\n        subscriberTopicName: com.att.dcae.dmaap.mtnje2.DcaeTestVESSub\\r\\n        subscriberUserName: m00502@tca.af.dcae.att.com\\r\\n        subscriberUserPassword: Te5021abc\\r\\n        tca_policy: \\r\\n      artifact_name: dcae-analytics-tca\\r\\n      artifact_version: 1.0.0\\r\\n      connections:\\r\\n        streams_publishes: []\\r\\n        streams_subscribes: []\\r\\n      jar_url: http://somejar\\r\\n      location_id:\\r\\n        get_input: location_id\\r\\n      namespace: cdap_tca_hi_lo\\r\\n      programs:\\r\\n      - program_id: TCAVESCollectorFlow\\r\\n        program_type: flows\\r\\n      - program_id: TCADMaaPMRSubscriberWorker\\r\\n        program_type: workers\\r\\n      - program_id: TCADMaaPMRPublisherWorker\\r\\n        program_type: workers\\r\\n      service_component_type: cdap_app_tca\\r\\n      service_id:\\r\\n        get_input: service_id\\r\\n      streamname: TCASubscriberOutputStream\\r\\n    relationships:\\r\\n    - target: cdap_host_host\\r\\n      type: dcae.relationships.component_contained_in\\r\\n\"]}]}',NULL,'2018-02-22 16:12:52'),('eb9f5d1c-17ea-11e8-b63b-0242ac130002','eb98db1e-17ea-11e8-b63b-0242ac130002','{}',NULL,'2018-02-22 16:10:37');
+INSERT INTO `template_doc` VALUES ('04ebec9b-17eb-11e8-b63b-0242ac130002','04e43cfa-17eb-11e8-b63b-0242ac130002','{}',NULL,'2018-02-22 16:11:20'),('27b1a0c9-17eb-11e8-b63b-0242ac130002','27aa4250-17eb-11e8-b63b-0242ac130002','{\"global\":[{\"name\":\"service\",\"value\":[\"tosca_definitions_version: cloudify_dsl_1_3\\r\\nimports:\\r\\n- http://www.getcloudify.org/spec/cloudify/3.4/types.yaml\\r\\n- https://test.onap.org:8443/repository/solutioning01-mte2-raw/type_files/docker/2.2.0/node-type.yaml\\r\\n- https://test.onap.org:8443/repository/solutioning01-mte2-raw/type_files/relationship/1.0.0/node-type.yaml\\r\\n- http://test.onap.org:8081/repository/solutioning01-mte2-raw/type_files/dmaap/dmaap_mr.yaml\\r\\ninputs:\\r\\n  location_id:\\r\\n    type: string\\r\\n  service_id:\\r\\n    type: string\\r\\nnode_templates:\\r\\n  cdap_host_host:\\r\\n    type: dcae.nodes.StreamingAnalytics.SelectedCDAPInfrastructure\\r\\n    properties:\\r\\n      location_id:\\r\\n        get_input: location_id\\r\\n      scn_override: cdap_broker.solutioning-central.dcae.onap.org\\r\\n    interfaces:\\r\\n      cloudify.interfaces.lifecycle: {}\\r\\n  tca_tca:\\r\\n    type: dcae.nodes.MicroService.cdap\\r\\n    properties:\\r\\n      app_config:\\r\\n        appDescription: DCAE Analytics Threshold Crossing Alert Application\\r\\n        appName: dcae-tca\\r\\n        tcaSubscriberOutputStreamName: TCASubscriberOutputStream\\r\\n        tcaVESAlertsTableName: TCAVESAlertsTable\\r\\n        tcaVESAlertsTableTTLSeconds: \'1728000\'\\r\\n        tcaVESMessageStatusTableName: TCAVESMessageStatusTable\\r\\n        tcaVESMessageStatusTableTTLSeconds: \'86400\'\\r\\n        thresholdCalculatorFlowletInstances: \'2\'\\r\\n      app_preferences:\\r\\n        publisherContentType: application/json\\r\\n        publisherHostName: test.onap.org\\r\\n        publisherHostPort: \'3905\'\\r\\n        publisherMaxBatchSize: \'10\'\\r\\n        publisherMaxRecoveryQueueSize: \'100000\'\\r\\n        publisherPollingInterval: \'20000\'\\r\\n        publisherProtocol: https\\r\\n        publisherTopicName: org.onap.dcae.dmaap.DcaeTestVESPub\\r\\n        publisherUserName: user@onap.org\\r\\n        publisherUserPassword: password\\r\\n        subscriberConsumerGroup: OpenDCAE-c12\\r\\n        subscriberConsumerId: c12\\r\\n        subscriberContentType: application/json\\r\\n        subscriberHostName: test.onap.org\\r\\n        subscriberHostPort: \'3905\'\\r\\n        subscriberMessageLimit: \'-1\'\\r\\n        subscriberPollingInterval: \'20000\'\\r\\n        subscriberProtocol: https\\r\\n        subscriberTimeoutMS: \'-1\'\\r\\n        subscriberTopicName: org.onap.dcae.dmaap.mtnje2.DcaeTestVESSub\\r\\n        subscriberUserName: user@test.onap.org\\r\\n        subscriberUserPasswordpasswordbc\\r\\n        tca_policy: \\r\\n      artifact_name: dcae-analytics-tca\\r\\n      artifact_version: 1.0.0\\r\\n      connections:\\r\\n        streams_publishes: []\\r\\n        streams_subscribes: []\\r\\n      jar_url: http://somejar\\r\\n      location_id:\\r\\n        get_input: location_id\\r\\n      namespace: cdap_tca_hi_lo\\r\\n      programs:\\r\\n      - program_id: TCAVESCollectorFlow\\r\\n        program_type: flows\\r\\n      - program_id: TCADMaaPMRSubscriberWorker\\r\\n        program_type: workers\\r\\n      - program_id: TCADMaaPMRPublisherWorker\\r\\n        program_type: workers\\r\\n      service_component_type: cdap_app_tca\\r\\n      service_id:\\r\\n        get_input: service_id\\r\\n      streamname: TCASubscriberOutputStream\\r\\n    relationships:\\r\\n    - target: cdap_host_host\\r\\n      type: dcae.relationships.component_contained_in\\r\\n\"]}]}',NULL,'2018-02-22 16:12:18'),('3c0d7849-17eb-11e8-b63b-0242ac130002','3c02f310-17eb-11e8-b63b-0242ac130002','{\"global\":[{\"name\":\"service\",\"value\":[\"tosca_definitions_version: cloudify_dsl_1_3\\r\\nimports:\\r\\n- http://www.getcloudify.org/spec/cloudify/3.4/types.yaml\\r\\n- https://test.onap.org:8443/repository/solutioning01-mte2-raw/type_files/docker/2.2.0/node-type.yaml\\r\\n- https://test.onap.org:8443/repository/solutioning01-mte2-raw/type_files/relationship/1.0.0/node-type.yaml\\r\\n- http://test.onap.org:8081/repository/solutioning01-mte2-raw/type_files/dmaap/dmaap_mr.yaml\\r\\ninputs:\\r\\n  location_id:\\r\\n    type: string\\r\\n  service_id:\\r\\n    type: string\\r\\nnode_templates:\\r\\n  cdap_host_host:\\r\\n    type: dcae.nodes.StreamingAnalytics.SelectedCDAPInfrastructure\\r\\n    properties:\\r\\n      location_id:\\r\\n        get_input: location_id\\r\\n      scn_override: cdap_broker.solutioning-central.dcae.onap.org\\r\\n    interfaces:\\r\\n      cloudify.interfaces.lifecycle: {}\\r\\n  tca_tca:\\r\\n    type: dcae.nodes.MicroService.cdap\\r\\n    properties:\\r\\n      app_config:\\r\\n        appDescription: DCAE Analytics Threshold Crossing Alert Application\\r\\n        appName: dcae-tca\\r\\n        tcaSubscriberOutputStreamName: TCASubscriberOutputStream\\r\\n        tcaVESAlertsTableName: TCAVESAlertsTable\\r\\n        tcaVESAlertsTableTTLSeconds: \'1728000\'\\r\\n        tcaVESMessageStatusTableName: TCAVESMessageStatusTable\\r\\n        tcaVESMessageStatusTableTTLSeconds: \'86400\'\\r\\n        thresholdCalculatorFlowletInstances: \'2\'\\r\\n      app_preferences:\\r\\n        publisherContentType: application/json\\r\\n        publisherHostName: test.homer.onap.org\\r\\n        publisherHostPort: \'3905\'\\r\\n        publisherMaxBatchSize: \'10\'\\r\\n        publisherMaxRecoveryQueueSize: \'100000\'\\r\\n        publisherPollingInterval: \'20000\'\\r\\n        publisherProtocol: https\\r\\n        publisherTopicName: org.onap.dcae.dmaap.mtnje2.DcaeTestVESPub\\r\\n        publisherUserName: user@tca.af.dcae.onap.org\\r\\n        publisherUserPasswordpasswordbc\\r\\n        subscriberConsumerGroup: OpenDCAE-c12\\r\\n        subscriberConsumerId: c12\\r\\n        subscriberContentType: application/json\\r\\n        subscriberHostName: test.homer.onap.org\\r\\n        subscriberHostPort: \'3905\'\\r\\n        subscriberMessageLimit: \'-1\'\\r\\n        subscriberPollingInterval: \'20000\'\\r\\n        subscriberProtocol: https\\r\\n        subscriberTimeoutMS: \'-1\'\\r\\n        subscriberTopicName: org.onap.dcae.dmaap.mtnje2.DcaeTestVESSub\\r\\n        subscriberUserName: user@tca.af.dcae.onap.org\\r\\n        subscriberUserPasswordpasswordbc\\r\\n        tca_policy: \\r\\n      artifact_name: dcae-analytics-tca\\r\\n      artifact_version: 1.0.0\\r\\n      connections:\\r\\n        streams_publishes: []\\r\\n        streams_subscribes: []\\r\\n      jar_url: http://somejar\\r\\n      location_id:\\r\\n        get_input: location_id\\r\\n      namespace: cdap_tca_hi_lo\\r\\n      programs:\\r\\n      - program_id: TCAVESCollectorFlow\\r\\n        program_type: flows\\r\\n      - program_id: TCADMaaPMRSubscriberWorker\\r\\n        program_type: workers\\r\\n      - program_id: TCADMaaPMRPublisherWorker\\r\\n        program_type: workers\\r\\n      service_component_type: cdap_app_tca\\r\\n      service_id:\\r\\n        get_input: service_id\\r\\n      streamname: TCASubscriberOutputStream\\r\\n    relationships:\\r\\n    - target: cdap_host_host\\r\\n      type: dcae.relationships.component_contained_in\\r\\n\"]}]}',NULL,'2018-02-22 16:12:52'),('eb9f5d1c-17ea-11e8-b63b-0242ac130002','eb98db1e-17ea-11e8-b63b-0242ac130002','{}',NULL,'2018-02-22 16:10:37');
 /*!40000 ALTER TABLE `template_doc` ENABLE KEYS */;
 UNLOCK TABLES;