"""SELECT ScenarioVersion
FROM PortCon..tpc_psa_scenarios s
inner join
PortCon..tpc_psa_scenario_items i
ON
s.ScenarioID = i.ScenarioID and
s.ModifiedOn = i.CreatedOn
WHERE
s.ScenarioName = CAST(? as varchar(60))""",
ScenarioName)
latest_version = result.fetchone()
latest_version = latest_version.ScenarioVersion
watchers[ScenarioName] = latest_version
if Version == 0 or Version is None: Version = latest_version
if latest_version > Version:
return latest_version
for i in range(0, int(max_wait / interval)):
with watchlock:
if watchers[ScenarioName] > Version:
print "Watch fired for", ScenarioName, "ver", watchers[
ScenarioName]
return watchers[ScenarioName]
time.sleep(interval + random.randint(-5, 5))
raise Exception("Timeout waiting for change in Scenario " + ScenarioName)
psa_app = create_application(psa_server, "")
#!/usr/bin/env python
import logging
logging.basicConfig(level=logging.DEBUG)
from wsgiref.simple_server import make_server
import os, sys
sys.path.append(os.path.abspath(os.path.join(os.path.dirname(__file__), '..')))
from pyws.adapters._wsgi import create_application
from server import server
httpd = make_server('127.0.0.1', 8000, create_application(server, 'api/'))
httpd.serve_forever()
with dblock:
result.execute("""SELECT ScenarioVersion
FROM PortCon..tpc_psa_scenarios s
inner join
PortCon..tpc_psa_scenario_items i
ON
s.ScenarioID = i.ScenarioID and
s.ModifiedOn = i.CreatedOn
WHERE
s.ScenarioName = CAST(? as varchar(60))""", ScenarioName)
latest_version = result.fetchone()
latest_version = latest_version.ScenarioVersion
watchers[ScenarioName] = latest_version
if Version == 0 or Version is None: Version = latest_version
if latest_version > Version:
return latest_version
for i in range(0,int(max_wait/interval)):
with watchlock:
if watchers[ScenarioName] > Version:
print "Watch fired for",ScenarioName,"ver",watchers[ScenarioName]
return watchers[ScenarioName]
time.sleep(interval + random.randint(-5,5))
raise Exception("Timeout waiting for change in Scenario "+ScenarioName)
psa_app = create_application(psa_server, "")
