From fbe4bb98345727d190cefcfb3ec54ad9075fba9d Mon Sep 17 00:00:00 2001
From: "RamaPrasad Amaranarayana (ra5425)" <ra5425@att.com>
Date: Wed, 19 Sep 2018 17:40:40 -0400
Subject: Change Management Schedule Optimization

Adding Robot Test Scripts for Change Management Schedule Optimization

Change-Id: Id5edf9d3fb3c2390791362692c8b25f7607045c6
Issue-ID: OPTFRA-352
Signed-off-by: RamaPrasad Amaranarayana (ra5425) <ra5425@att.com>
---
 cmso-robot/robot/assets/sql/OptimizationInProgresss.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 cmso-robot/robot/assets/sql/OptimizationInProgresss.sql

(limited to 'cmso-robot/robot/assets/sql/OptimizationInProgresss.sql')

diff --git a/cmso-robot/robot/assets/sql/OptimizationInProgresss.sql b/cmso-robot/robot/assets/sql/OptimizationInProgresss.sql
new file mode 100644
index 0000000..3123ad7
--- /dev/null
+++ b/cmso-robot/robot/assets/sql/OptimizationInProgresss.sql
@@ -0,0 +1,3 @@
+SET SQL_SAFE_UPDATES = 0;
+update schedules set status = 'Pending Schedule' where status = 'Optimization in Progress';
+SET SQL_SAFE_UPDATES = 1;
\ No newline at end of file
-- 
cgit 1.2.3-korg

t.png' alt='cgit logo'/></a></td>
<td class='main'><a href='/'>index</a> : <a href='/so/'>so</a></td><td class='form'><form method='get'>
<select name='h' onchange='this.form.submit();'>
<option value='2.0.0-ONAP'>2.0.0-ONAP</option>
<option value='Custom_Workflow'>Custom_Workflow</option>
<option value='Dynamic_BPMN'>Dynamic_BPMN</option>
<option value='Istanbul'>Istanbul</option>
<option value='Java-11-upgrade1212master'>Java-11-upgrade1212master</option>
<option value='amsterdam'>amsterdam</option>
<option value='as_orchestration'>as_orchestration</option>
<option value='beijing'>beijing</option>
<option value='bpmn_infra_refactoring'>bpmn_infra_refactoring</option>
<option value='casablanca'>casablanca</option>
<option value='container_test'>container_test</option>
<option value='dublin'>dublin</option>
<option value='elalto'>elalto</option>
<option value='frankfurt'>frankfurt</option>
<option value='guilin'>guilin</option>
<option value='honolulu'>honolulu</option>
<option value='istanbul'>istanbul</option>
<option value='jakarta'>jakarta</option>
<option value='java17'>java17</option>
<option value='kohn'>kohn</option>
<option value='london'>london</option>
<option value='master' selected='selected'>master</option>
<option value='montreal'>montreal</option>
<option value='recursive-orch'>recursive-orch</option>
<option value='release-1.0.0'>release-1.0.0</option>
<option value='so-1407'>so-1407</option>
<option value='so-1408'>so-1408</option>
</select> <input type='submit' value='switch'/></form></td></tr>
<tr><td class='sub'>Service Orchestrator</td><td class='sub right'>Grokmirror user</td></tr></table>
<table class='tabs'><tr><td>
<a href='/so/about/'>about</a><a href='/so/'>summary</a><a href='/so/refs/'>refs</a><a href='/so/log/bpmn/so-bpmn-infrastructure-flows/src/test/resources/__files/CreateNetworkV2/createNetwork_queryNetworkPolicy_AAIResponse_Success.xml'>log</a><a class='active' href='/so/tree/bpmn/so-bpmn-infrastructure-flows/src/test/resources/__files/CreateNetworkV2/createNetwork_queryNetworkPolicy_AAIResponse_Success.xml'>tree</a><a href='/so/commit/bpmn/so-bpmn-infrastructure-flows/src/test/resources/__files/CreateNetworkV2/createNetwork_queryNetworkPolicy_AAIResponse_Success.xml'>commit</a><a href='/so/diff/bpmn/so-bpmn-infrastructure-flows/src/test/resources/__files/CreateNetworkV2/createNetwork_queryNetworkPolicy_AAIResponse_Success.xml'>diff</a><a href='/so/stats/bpmn/so-bpmn-infrastructure-flows/src/test/resources/__files/CreateNetworkV2/createNetwork_queryNetworkPolicy_AAIResponse_Success.xml'>stats</a></td><td class='form'><form class='right' method='get' action='/so/log/bpmn/so-bpmn-infrastructure-flows/src/test/resources/__files/CreateNetworkV2/createNetwork_queryNetworkPolicy_AAIResponse_Success.xml'>
<select name='qt'>
<option value='grep'>log msg</option>
<option value='author'>author</option>
<option value='committer'>committer</option>
<option value='range'>range</option>
</select>
<input class='txt' type='search' size='10' name='q' value=''/>
<input type='submit' value='search'/>
</form>
</td></tr></table>
<div class='path'>path: <a href='/so/tree/'>root</a>/<a href='/so/tree/bpmn'>bpmn</a>/<a href='/so/tree/bpmn/so-bpmn-infrastructure-flows'>so-bpmn-infrastructure-flows</a>/<a href='/so/tree/bpmn/so-bpmn-infrastructure-flows/src'>src</a>/<a href='/so/tree/bpmn/so-bpmn-infrastructure-flows/src/test'>test</a>/<a href='/so/tree/bpmn/so-bpmn-infrastructure-flows/src/test/resources'>resources</a>/<a href='/so/tree/bpmn/so-bpmn-infrastructure-flows/src/test/resources/__files'>__files</a>/<a href='/so/tree/bpmn/so-bpmn-infrastructure-flows/src/test/resources/__files/CreateNetworkV2'>CreateNetworkV2</a>/<a href='/so/tree/bpmn/so-bpmn-infrastructure-flows/src/test/resources/__files/CreateNetworkV2/createNetwork_queryNetworkPolicy_AAIResponse_Success.xml'>createNetwork_queryNetworkPolicy_AAIResponse_Success.xml</a></div><div class='content'>blob: 79cc14ada38a8c78a21200f4af9b44dcc02e71f8 (<a href='/so/plain/bpmn/so-bpmn-infrastructure-flows/src/test/resources/__files/CreateNetworkV2/createNetwork_queryNetworkPolicy_AAIResponse_Success.xml'>plain</a>)
<table summary='blob content' class='blob'>
<tr><td class='linenumbers'><pre><a id='n1' href='#n1'>1</a>
<a id='n2' href='#n2'>2</a>
<a id='n3' href='#n3'>3</a>
<a id='n4' href='#n4'>4</a>
<a id='n5' href='#n5'>5</a>
<a id='n6' href='#n6'>6</a>
<a id='n7' href='#n7'>7</a>
<a id='n8' href='#n8'>8</a>
<a id='n9' href='#n9'>9</a>
<a id='n10' href='#n10'>10</a>
<a id='n11' href='#n11'>11</a>
<a id='n12' href='#n12'>12</a>
<a id='n13' href='#n13'>13</a>
<a id='n14' href='#n14'>14</a>
<a id='n15' href='#n15'>15</a>
<a id='n16' href='#n16'>16</a>
<a id='n17' href='#n17'>17</a>
<a id='n18' href='#n18'>18</a>
<a id='n19' href='#n19'>19</a>
<a id='n20' href='#n20'>20</a>
<a id='n21' href='#n21'>21</a>
</pre></td>
<td class='lines'><pre><code>