BRGVersion:6
revision:$Revision$
UUID:af1774f0-8c70-4c8b-8fbb-4fdc218074f4
timestamp:1490962799
baselib:core
baselib:inFlow
baselib:lal1

begin:graphprops
propdef:DbUser|string|1||None
propdef:DbPassword|string|1||None
propdef:DbUrl|string|1||None
propdef:DbDriver|string|1||None
prop:DbUser=laeAutomationUser
prop:DbPassword=lavastorm
prop:DbUrl=jdbc:h2:tcp://localhost:9092/{{%ls.brain.home%}}/data/automationDb;MVCC=true;IFEXISTS=TRUE
prop:DbDriver=org.h2.Driver
end:graphprops

libnode:Execute_JDBC_Script
bretype:core::JDBC Execute
editor:Label=Execute JDBC Script
editor:handle=53f48b6d771c2896
editor:sortkey=53f48b6d771c2896
prop:Classpaths=<<EOX
{{%ls.brain.home%}}/h2/bin/h2-1.3.174.jar
EOX
editor:XY=100,60
editor:propdef=Classpaths|text|General||None
editor:propdef=SqlQuery|filename|SQL|ls.brain.node.java.SQLRunner.SQLQuery|None
editor:propoverride=SqlQueryFieldBindings|0
end:Execute_JDBC_Script

libnode:Query_H2_DB
bretype:core::JDBC Query
editor:Label=Query H2 DB
editor:handle=53fb530919654e99
editor:sortkey=53fb530919654e99
output:@439f475045133ba6/=
prop:Classpaths=<<EOX
{{%ls.brain.home%}}/h2/bin/h2-1.3.174.jar
EOX
editor:XY=100,160
editor:propdef=Classpaths|text|General||None
end:Query_H2_DB

libnode:JDBC_Execute_H2
bretype:core::JDBC Execute
editor:Label=JDBC Execute H2
editor:handle=5582e5d422f763ef
editor:sortkey=5582e5d422f763ef
prop:Classpaths=<<EOX
{{%ls.brain.home%}}/h2/bin/h2-1.3.174.jar
EOX
editor:XY=200,450
editor:propdef=Classpaths|text|General||None
end:JDBC_Execute_H2

node:Query_H2_DB_for_ExecPlans
bretype:::Query H2 DB
editor:Label=Query H2 DB for ExecPlans
editor:handle=5582de454b1d6f47
editor:sortkey=53fb551c3323581a_2
output:@439f475045133ba6/=
prop:SqlQuery=<<EOX
select * from DEPLOY_EXECUTION_PLANS
WHERE STATUS='R'
EOX
editor:XY=150,30
end:Query_H2_DB_for_ExecPlans

node:Update_ExecPlan_Status_2
bretype:::JDBC Execute H2
editor:Label=Update ExecPlan Status
editor:handle=56f94c617ac061fd
editor:sortkey=5582e84a3e521b36_2
input:56f94cc675a35eff/out1=Query_H2_DB_for_ExecPlans.439f475045133ba6
prop:SqlQuery=<<EOX
UPDATE DEPLOY_EXECUTION_PLANS SET STATUS = 'C' WHERE ID=?
EOX
prop:SqlQueryFieldBindings=ID
editor:XY=250,30
end:Update_ExecPlan_Status_2

node:Query_H2_DB_for_Execution_Runs
bretype:::Query H2 DB
editor:Label=Query H2 DB for Execution Runs
editor:handle=5582e8e4691142f2
editor:sortkey=5582e8e4691142f2
output:@439f475045133ba6/=
prop:SqlQuery=<<EOX
SELECT * FROM DEPLOY_EXECUTION_RUNS
WHERE STATUS='R'
EOX
editor:XY=150,150
end:Query_H2_DB_for_Execution_Runs

node:Query_H2_DB_for_Runs
bretype:::Query H2 DB
editor:Label=Query H2 DB for Runs
editor:handle=5582e8e7075c3879
editor:sortkey=5582e8e7075c3879
output:@439f475045133ba6/=
prop:SqlQuery=<<EOX
SELECT * FROM DEPLOY_RUN
WHERE STATUS='R'
EOX
editor:XY=150,270
end:Query_H2_DB_for_Runs

node:Update_Run_Status_2
bretype:::JDBC Execute H2
editor:Label=Update Run Status
editor:handle=56f94c612a856051
editor:sortkey=5582eb7e59120929_2
input:56f94cca14de3b70/out1=Query_H2_DB_for_Runs.439f475045133ba6
prop:SqlQuery=<<EOX
UPDATE DEPLOY_RUN SET STATUS='C' WHERE ID=?
EOX
prop:SqlQueryFieldBindings=ID
editor:XY=250,270
end:Update_Run_Status_2

node:Update_Execution_Run_Status_2
bretype:::JDBC Execute H2
editor:Label=Update Execution Run Status
editor:handle=56f94c616a4721d8
editor:sortkey=5582eb807a313e61_2
input:56f94cc87ea44579/out1=Query_H2_DB_for_Execution_Runs.439f475045133ba6
prop:SqlQuery=<<EOX
UPDATE DEPLOY_EXECUTION_RUNS SET STATUS='C' WHERE ID=?
EOX
prop:SqlQueryFieldBindings=ID
editor:XY=250,150
end:Update_Execution_Run_Status_2