def setTime(self, aDattim):
convert = GempakConvert()
name = "dataTime"
operand = "between"
aw2Time = convert.dattimToDbtime(aDattim)
timeRange = convert.setTimeRange(aw2Time)
self.query.addParameter(name, timeRange, operand)
def setTime(self, aDattim):
convert = GempakConvert()
name = "dataTime"
operand = "between"
aw2Time = convert.dattimToDbtime(aDattim)
timeRange = convert.setTimeRange(aw2Time)
self.query.addParameter(name, timeRange, operand)
def __getDbTime(self, aDattim):
refTime = aDattim.upper().split("F")[0]
fcstTime = "%s" % (int(aDattim.upper().split("F")[1]) * 3600)
convert = GempakConvert()
refTime = convert.dattimToDbtime(refTime)
print "refTime=", refTime
print "fcstTime=", fcstTime
return refTime, fcstTime
def __getDbTime (self, aDattim):
refTime = aDattim.upper().split("F")[0]
fcstTime = "%s" % (int(aDattim.upper().split("F")[1]) * 3600)
convert = GempakConvert()
refTime = convert.dattimToDbtime(refTime)
print "refTime=", refTime
print "fcstTime=", fcstTime
return refTime, fcstTime
class GempakGridCycleQuery():
def __init__(self, aPlugin):
self.plugin = aPlugin
self.queryResults = ArrayList()
self.GSQ = GempakSqlQuery.GempakSqlQuery()
self.GSQ.setReturnText()
self.convert = GempakConvert()
#
# Set parameters of the metadata catalog query
#
def setParameters(self, aParms):
parms = aParms.split("|")
self.model = parms[0].upper()
self.cycle = self.convert.dattimToDbtime(parms[1].upper()).replace(
' ', '_')
#print "model=", self.model
#print "cycle=", self.cycle
#
# Generates a list of responses in XML format
#
def makeResponse(self):
retStr = self.convert.dbtimeToDattim((self.queryResult).split("/")[2])
#print "returning time=", retStr
return ResponseMessageGeneric(retStr)
#
# Executes the query and calls appropriate response functions
#
def execute(self):
#
# construct the SQL query to execute
#
myQuery = "SELECT datauri FROM " + self.plugin + " WHERE datauri LIKE '%" + \
self.cycle + "%' AND datauri ~* '/" + self.model + "/' LIMIT 1"
#print "myQuery:", myQuery
#
# set the SQL query
#
self.GSQ.setQuery(myQuery)
self.queryResult = self.GSQ.execute()
#print "self.queryResult=", self.queryResult
#
# process the results of the query
#
if self.queryResult is None:
return self.makeNullResponse("Query returned no results")
else:
return self.makeResponse()
def setGridIdParms(self, aGridName, *parms):
for ii in range(len(parms)):
if ii == 0:
#print "setting time to", parms[0]
convert = GempakConvert()
self.query.addParameter("dataTime", convert.dattimToDbtime(parms[0]))
elif ii == 1:
#print "setting eventName to", parms[1]
self.query.addParameter("modelInfo.eventName", parms[1])
self.gridName= aGridName
class GempakGridCycleQuery():
def __init__(self, aPlugin):
self.plugin = aPlugin
self.queryResults = ArrayList()
self.GSQ = GempakSqlQuery.GempakSqlQuery()
self.GSQ.setReturnText()
self.convert = GempakConvert()
#
# Set parameters of the metadata catalog query
#
def setParameters (self, aParms):
parms = aParms.split("|")
self.model=parms[0].upper()
self.cycle = self.convert.dattimToDbtime(parms[1].upper()).replace (' ', '_')
#print "model=", self.model
#print "cycle=", self.cycle
#
# Generates a list of responses in XML format
#
def makeResponse(self):
retStr = self.convert.dbtimeToDattim((self.queryResult).split("/")[2])
#print "returning time=", retStr
return ResponseMessageGeneric(retStr)
#
# Executes the query and calls appropriate response functions
#
def execute(self):
#
# construct the SQL query to execute
#
myQuery = "SELECT datauri FROM " + self.plugin + " WHERE datauri LIKE '%" + \
self.cycle + "%' AND datauri ~* '/" + self.model + "/' LIMIT 1"
#print "myQuery:", myQuery
#
# set the SQL query
#
self.GSQ.setQuery(myQuery)
self.queryResult = self.GSQ.execute()
#print "self.queryResult=", self.queryResult
#
# process the results of the query
#
if self.queryResult is None:
return self.makeNullResponse("Query returned no results")
else:
return self.makeResponse()
def __getDbTime (self, aDattim):
if self.pluginName == 'grib' or self.pluginName == 'ncgrib':
convert = GempakConvert()
return convert.dattimToDbtime(aDattim)
else:
return None
class AtcfTrackRequest(BaseRequest.BaseRequest):
def __init__(self):
BaseRequest.BaseRequest.__init__(self, "atcf")
self.isTechniqueSet = False
self.time = None
self.StartTime = None
self.EndTime = None
self.isTimeList = False
self.AllTimesList = []
self.TimesList = []
self.Convert = GempakConvert()
def setTime(self, aTime=None):
self.time = aTime
def setStartTime(self, aTime=None):
if aTime:
self.StartTime = aTime
else:
# set StartTime to the First Available Time
self.StartTime = self.__getFirstTime()
def setEndTime(self, aTime=None):
if aTime:
self.EndTime = aTime
else:
# set StartTime to the Last Available Time
self.EndTime = self.__getLastTime()
def setTechnique(self, aTechnique):
self.technique = aTechnique
self.isTechniqueSet = True
def execute(self):
if self.time:
self.query.addParameter("dataTime", self.time)
else:
if not self.StartTime:
self.StartTime = self.__getFirstTime()
if not self.EndTime:
self.EndTime = self.__getLastTime()
if self.StartTime and self.EndTime:
self.timeRange = self.StartTime + "--" + self.EndTime
self.query.addParameter("dataTime", self.timeRange, "between")
else:
return self.__makeNullResponse("Could not set the time range")
# get the results from the database
self.queryResults = self.query.execute()
if self.queryResults is None or self.queryResults.size() == 0:
return self.__makeNullResponse()
else:
# process the results
return self.__makeResponse()
def __getFirstTime(self):
# check if the list of available times has been calculated
if self.isTimeList:
return self.Convert.dattimToDbtime(self.AllTimesList[0])
else:
# get the list of times and return the earliest available time
self.__getTimeList()
return self.Convert.dattimToDbtime(self.AllTimesList[0])
def __getLastTime(self):
# check if the list of available times has been calculated
if self.isTimeList:
return self.Convert.dattimToDbtime(
self.AllTimesList[len(self.AllTimesList) - 1])
else:
# get the list of times and return the last available time
self.__getTimeList()
return self.Convert.dattimToDbtime(
self.AllTimesList[len(self.AllTimesList) - 1])
def __getTimePlus(self, aTime, aPlus="168"):
return self.Convert.addHours(aTime, aPlus)
# def __createTimes(self):
# if self.time:
# self.TimesList.append(self.time)
# else:
# startIndex = self.AllTimesList.index(self.StartTime)
# endIndex = self.AllTimesList.index(self.EndTime)
# self.TimesList = self.AllTimesList[startIndex:endIndex]
def __getTimeList(self):
import GempakCatalogTimeQuery
tq = GempakCatalogTimeQuery.GempakCatalogTimeQuery("atcf")
tq.setReturnText()
self.AllTimesList = tq.execute().split("|")
self.isTimeList = True
def __getDictionaries(self):
import GempakSqlQuery
# list of time cyclone ID tuples:
# eg [('2010-08-28 06:00:00.0', 'EP9'), ('2010-08-28 12:00:00.0', 'EP8')]
timeIdTupleList = []
# timeIdTqDict - is the key-value dictionary of time-Id tuple Technique List dictionary
# each time has a corresponding dictionary of ID-Technique
# eg: {('2010-08-28 06:00:00.0','AL8'):['AEMI', 'AEMN', 'AP01', 'AP02'], ('2010-08-28 12:00:00.0','AL9'):['AP11', 'AP14', 'AP18']}
timeIdTqDict = {}
# idNumberDict - is the key-value dictionary of cycloneID-basin, cycloneNumb tuple pairs
# each cycloneId has a corresponding basin-cycloneNumb tuple
# eg: {'AL8': ('AL', '8'), 'AL9': ('AL', '9')}
idNumberDict = {}
for ii in range(self.queryResults.size()):
currentRecord = self.queryResults.get(ii)
# get the time
recordTime = str(currentRecord.getDataTime())
# get basin
basin = str(currentRecord.getBasin())
# get cyclone number
cycloneNumb = str(currentRecord.getCycloneNum())
# construct cyclone ID
# eg EP9
cycloneId = basin + cycloneNumb
# construct time - cyclone ID tuple
# eg ('2010-08-21 06:00:00.0', 'EP9')
timeIdTuple = (recordTime, cycloneId)
# check time - cyclone ID tuple old or new
if timeIdTuple in timeIdTupleList:
# existing time - cyclone ID tuple - do not add to list
pass
else:
timeIdTupleList.append(timeIdTuple)
# add the basin,cycloneNumb tuple as value to the idNumberDict dictionary
# for the key cycloneId, if has not been added already
if (basin, cycloneNumb) in idNumberDict.values():
pass
else:
idNumberDict[cycloneId] = (basin, cycloneNumb)
techniqueList = []
# check if the request is for a single technique
if self.isTechniqueSet:
techniqueList.append(self.technique)
else:
# perform the db query for the records with that cyclone ID
techniqueQuery = GempakSqlQuery.GempakSqlQuery()
# set the return type to text(string)
# not a ResponseMessageGEneric object
techniqueQuery.setReturnText()
# set the separator
techniqueQuery.setSeparator("|")
# set the query text
techniqueQueryText = "SELECT DISTINCT technique FROM atcf WHERE " + \
"basin ='" + idNumberDict[cycloneId][0] + "' AND " + \
"cyclonenum ='" + idNumberDict[cycloneId][1] + "' AND " + \
"reftime='" + recordTime + "'"
techniqueQuery.setQuery(techniqueQueryText)
# execute the query
techniqueQueryResults = techniqueQuery.execute()
# create a list of techniques
techniqueList = techniqueQueryResults.split("|")
# add technique as value to the to the time,cyclone ID - technique dictionary
timeIdTqDict[timeIdTuple] = techniqueList
return idNumberDict, timeIdTqDict
def __makeResponse(self):
from gov.noaa.nws.ncep.edex.uengine.tasks.atcf import AtcfCyclone, AtcfTrack
response = ArrayList()
idNumberDict, timeIdTqDict = self.__getDictionaries()
# traverse the time,cyclone ID - technique dictionary to obtain AtcfRecords and
# construct AtcfCyclone objects
for key, value in timeIdTqDict.items():
currentTime = key[0]
cycId = key[1]
techList = value
aBasin = idNumberDict[cycId][0]
aCycloneNumb = idNumberDict[cycId][1]
# create new AtcfCyclone object
aCyclone = AtcfCyclone(cycId)
for techniqueName in techList:
bsResults = None
# CARQ case
if techniqueName == "CARQ":
# first we need to create track for the past
BaseRequest.BaseRequest.__init__(self, "atcf")
self.query.addParameter("dataTime", currentTime)
self.query.addParameter("basin", aBasin)
self.query.addParameter("cycloneNum", aCycloneNumb)
self.query.addParameter("technique", techniqueName)
self.query.addParameter("radWind", "34")
self.query.addParameter("fcstHour", "0", "<")
order = True
self.query.setSortBy("fcstHour", order)
bsResultsPast = self.query.execute()
bsResults = bsResultsPast
# second we need to create track for the future
BaseRequest.BaseRequest.__init__(self, "atcf")
timeRange = currentTime + "--" + self.__getTimePlus(
currentTime)
self.query.addParameter("dataTime", timeRange, "between")
self.query.addParameter("basin", aBasin)
self.query.addParameter("cycloneNum", aCycloneNumb)
self.query.addParameter("technique", techniqueName)
self.query.addParameter("radWind", "34")
self.query.addParameter("fcstHour", "0")
order = True
self.query.setSortBy("dataTime", order)
bsResultsFuture = self.query.execute()
count = 0
for ii in range(bsResultsFuture.size()):
recordToChange = bsResultsFuture.get(ii)
recordToChange.setFcstHour(ii * 6)
bsResults.add(recordToChange)
# non-CARQ case
else:
BaseRequest.BaseRequest.__init__(self, "atcf")
self.query.addParameter("dataTime", currentTime)
self.query.addParameter("basin", aBasin)
self.query.addParameter("cycloneNum", aCycloneNumb)
self.query.addParameter("technique", techniqueName)
order = True
self.query.setSortBy("fcstHour", order)
bsResults = self.query.execute()
if bsResults is None or bsResults.size() == 0:
pass
else:
# create new AtcfTrack object
aTrack = AtcfTrack(techniqueName, bsResults)
# add AtcfTrack object to AtcfCyclone
aCyclone.addTrack(aTrack)
# add AtcfCyclone object to the response ArrayList
response.add(ResponseMessageGeneric(aCyclone))
return response
#
# Returns a string with a response message
#
def __makeNullResponse(self,
aMessage="Database Query returned no results"):
return ResponseMessageGeneric(aMessage)
class AtcfTrackRequest(BaseRequest.BaseRequest):
def __init__(self):
BaseRequest.BaseRequest.__init__(self, "atcf")
self.isTechniqueSet = False
self.time = None
self.StartTime = None
self.EndTime = None
self.isTimeList= False
self.AllTimesList = []
self.TimesList = []
self.Convert = GempakConvert()
def setTime(self, aTime=None):
self.time = aTime
def setStartTime(self, aTime=None):
if aTime :
self.StartTime = aTime
else:
# set StartTime to the First Available Time
self.StartTime = self.__getFirstTime()
def setEndTime(self, aTime=None):
if aTime :
self.EndTime = aTime
else:
# set StartTime to the Last Available Time
self.EndTime = self.__getLastTime()
def setTechnique(self, aTechnique):
self.technique = aTechnique
self.isTechniqueSet = True
def execute(self):
if self.time:
self.query.addParameter("dataTime", self.time)
else:
if not self.StartTime:
self.StartTime = self.__getFirstTime()
if not self.EndTime:
self.EndTime = self.__getLastTime()
if self.StartTime and self.EndTime:
self.timeRange = self.StartTime + "--" + self.EndTime
self.query.addParameter("dataTime", self.timeRange, "between")
else:
return self.__makeNullResponse("Could not set the time range")
# get the results from the database
self.queryResults = self.query.execute()
if self.queryResults is None or self.queryResults.size() == 0:
return self.__makeNullResponse()
else:
# process the results
return self.__makeResponse()
def __getFirstTime(self):
# check if the list of available times has been calculated
if self.isTimeList:
return self.Convert.dattimToDbtime(self.AllTimesList[0])
else:
# get the list of times and return the earliest available time
self.__getTimeList()
return self.Convert.dattimToDbtime(self.AllTimesList[0])
def __getLastTime(self):
# check if the list of available times has been calculated
if self.isTimeList:
return self.Convert.dattimToDbtime(self.AllTimesList[len(self.AllTimesList) -1])
else:
# get the list of times and return the last available time
self.__getTimeList()
return self.Convert.dattimToDbtime(self.AllTimesList[len(self.AllTimesList) -1])
def __getTimePlus(self, aTime, aPlus="168"):
return self.Convert.addHours(aTime, aPlus)
# def __createTimes(self):
# if self.time:
# self.TimesList.append(self.time)
# else:
# startIndex = self.AllTimesList.index(self.StartTime)
# endIndex = self.AllTimesList.index(self.EndTime)
# self.TimesList = self.AllTimesList[startIndex:endIndex]
def __getTimeList(self):
import GempakCatalogTimeQuery
tq = GempakCatalogTimeQuery.GempakCatalogTimeQuery("atcf")
tq.setReturnText()
self.AllTimesList = tq.execute().split("|")
self.isTimeList =True
def __getDictionaries(self):
import GempakSqlQuery
# list of time cyclone ID tuples:
# eg [('2010-08-28 06:00:00.0', 'EP9'), ('2010-08-28 12:00:00.0', 'EP8')]
timeIdTupleList = []
# timeIdTqDict - is the key-value dictionary of time-Id tuple Technique List dictionary
# each time has a corresponding dictionary of ID-Technique
# eg: {('2010-08-28 06:00:00.0','AL8'):['AEMI', 'AEMN', 'AP01', 'AP02'], ('2010-08-28 12:00:00.0','AL9'):['AP11', 'AP14', 'AP18']}
timeIdTqDict = {}
# idNumberDict - is the key-value dictionary of cycloneID-basin, cycloneNumb tuple pairs
# each cycloneId has a corresponding basin-cycloneNumb tuple
# eg: {'AL8': ('AL', '8'), 'AL9': ('AL', '9')}
idNumberDict = {}
for ii in range(self.queryResults.size()):
currentRecord = self.queryResults.get(ii)
# get the time
recordTime = str(currentRecord.getDataTime())
# get basin
basin = str(currentRecord.getBasin())
# get cyclone number
cycloneNumb = str(currentRecord.getCycloneNum())
# construct cyclone ID
# eg EP9
cycloneId = basin + cycloneNumb
# construct time - cyclone ID tuple
# eg ('2010-08-21 06:00:00.0', 'EP9')
timeIdTuple = (recordTime, cycloneId)
# check time - cyclone ID tuple old or new
if timeIdTuple in timeIdTupleList:
# existing time - cyclone ID tuple - do not add to list
pass
else:
timeIdTupleList.append(timeIdTuple)
# add the basin,cycloneNumb tuple as value to the idNumberDict dictionary
# for the key cycloneId, if has not been added already
if (basin, cycloneNumb) in idNumberDict.values():
pass
else:
idNumberDict[cycloneId] = (basin, cycloneNumb)
techniqueList = []
# check if the request is for a single technique
if self.isTechniqueSet:
techniqueList.append(self.technique)
else:
# perform the db query for the records with that cyclone ID
techniqueQuery = GempakSqlQuery.GempakSqlQuery()
# set the return type to text(string)
# not a ResponseMessageGEneric object
techniqueQuery.setReturnText()
# set the separator
techniqueQuery.setSeparator("|")
# set the query text
techniqueQueryText = "SELECT DISTINCT technique FROM atcf WHERE " + \
"basin ='" + idNumberDict[cycloneId][0] + "' AND " + \
"cyclonenum ='" + idNumberDict[cycloneId][1] + "' AND " + \
"reftime='" + recordTime + "'"
techniqueQuery.setQuery(techniqueQueryText)
# execute the query
techniqueQueryResults = techniqueQuery.execute()
# create a list of techniques
techniqueList = techniqueQueryResults.split("|")
# add technique as value to the to the time,cyclone ID - technique dictionary
timeIdTqDict[timeIdTuple] = techniqueList
return idNumberDict, timeIdTqDict
def __makeResponse(self):
from gov.noaa.nws.ncep.edex.uengine.tasks.atcf import AtcfCyclone, AtcfTrack
response = ArrayList()
idNumberDict, timeIdTqDict = self.__getDictionaries()
# traverse the time,cyclone ID - technique dictionary to obtain AtcfRecords and
# construct AtcfCyclone objects
for key, value in timeIdTqDict.items():
currentTime = key[0]
cycId = key[1]
techList = value
aBasin = idNumberDict[cycId][0]
aCycloneNumb = idNumberDict[cycId][1]
# create new AtcfCyclone object
aCyclone = AtcfCyclone(cycId)
for techniqueName in techList:
bsResults = None
# CARQ case
if techniqueName == "CARQ":
# first we need to create track for the past
BaseRequest.BaseRequest.__init__(self, "atcf")
self.query.addParameter("dataTime", currentTime)
self.query.addParameter("basin",aBasin)
self.query.addParameter("cycloneNum",aCycloneNumb)
self.query.addParameter("technique",techniqueName)
self.query.addParameter("radWind", "34")
self.query.addParameter("fcstHour","0", "<")
order = True
self.query.setSortBy("fcstHour", order)
bsResultsPast = self.query.execute()
bsResults = bsResultsPast
# second we need to create track for the future
BaseRequest.BaseRequest.__init__(self, "atcf")
timeRange = currentTime + "--" + self.__getTimePlus(currentTime)
self.query.addParameter("dataTime", timeRange, "between")
self.query.addParameter("basin",aBasin)
self.query.addParameter("cycloneNum",aCycloneNumb)
self.query.addParameter("technique",techniqueName)
self.query.addParameter("radWind", "34")
self.query.addParameter("fcstHour","0")
order = True
self.query.setSortBy("dataTime", order)
bsResultsFuture = self.query.execute()
count = 0
for ii in range(bsResultsFuture.size()):
recordToChange = bsResultsFuture.get(ii)
recordToChange.setFcstHour(ii*6)
bsResults.add(recordToChange)
# non-CARQ case
else:
BaseRequest.BaseRequest.__init__(self, "atcf")
self.query.addParameter("dataTime", currentTime)
self.query.addParameter("basin",aBasin)
self.query.addParameter("cycloneNum",aCycloneNumb)
self.query.addParameter("technique",techniqueName)
order = True
self.query.setSortBy("fcstHour", order)
bsResults = self.query.execute()
if bsResults is None or bsResults.size() == 0:
pass
else:
# create new AtcfTrack object
aTrack = AtcfTrack(techniqueName, bsResults)
# add AtcfTrack object to AtcfCyclone
aCyclone.addTrack(aTrack)
# add AtcfCyclone object to the response ArrayList
response.add(ResponseMessageGeneric(aCyclone))
return response
#
# Returns a string with a response message
#
def __makeNullResponse(self, aMessage="Database Query returned no results"):
return ResponseMessageGeneric(aMessage)