def ADDTo_Analysis(self, nReps, rSeed, MinDepth, MaxDepth):
VersionDate = VersionTime()
y, m, d = VersionDate.year, VersionDate.month, VersionDate.day
query = "insert INTO Results_Analysis(AnalysisKey,AnalysisDate,nReps,rSeed,"
query += 'MinDepth' + US.Metres + ',MaxDepth' + US.Metres + ',VersionDate) '
query += "Values("
query += PrepForMDB(self.AnalysisKey.GetValue())
query += ","
query += "NOW()"
query += ","
query += PrepForMDB(nReps)
query += ","
query += PrepForMDB(rSeed)
query += ","
query += PrepForMDB(MinDepth)
query += ","
query += PrepForMDB(MaxDepth)
query += ","
query += "DateSerial( " + str(y) + "," + str(m) + "," + str(d) + ")"
query += ");"
try:
self.DB.Execute(query)
except:
print('\nNewMDB 87 query\n', query)
self.DB.Execute(query)
def ADDTo_Results_Header(self, RunComments, Species, nReps, rSeed,
MinDepth, MaxDepth):
VersionDate = VersionTime()
y, m, d = VersionDate.year, VersionDate.month, VersionDate.day
query = "insert INTO Results_Header(ResultKey,AnalysisDate,RunComments,Species,nReps,rSeed,MinDepth,MaxDepth,VersionDate) "
query += "Values("
query += PrepForMDB(self.AnalysisKey.GetValue())
query += ","
query += "NOW()"
query += ","
query += "'" + RunComments + "'"
query += ","
query += "'" + Species + "'"
query += ","
query += PrepForMDB(nReps)
query += ","
query += PrepForMDB(rSeed)
query += ","
query += PrepForMDB(MinDepth)
query += ","
query += PrepForMDB(MaxDepth)
query += ","
query += "DateSerial( " + str(y) + "," + str(m) + "," + str(d) + ")"
query += ");"
try:
self.DB.Execute(query)
except:
print('\nNewMDB 76 query\n', query)
self.DB.Execute(query)
def ADDTo_SurveyUsed(self, Location, Year):
query = "insert INTO Results_SurveyUsed(AnalysisKey,Location,[Year]) "
query += "Values("
query += PrepForMDB(self.AnalysisKey.GetValue())
query += "," + PrepForMDB(Location) + "',"
query += PrepForMDB(Year)
query += ");"
query = query.replace('inf', '1000')
try:
self.DB.Execute(query)
except:
print('\nNewMDB 247 query\n', query)
self.DB.Execute(query)
def ADDTo_SurveyUsed(self, SurveyTitle,Year):
query ="insert INTO Results_SurveyUsed(AnalysisKey,SurveyTitle,Yr) "
query+="Values("
query+=PrepForMDB(self.AnalysisKey.GetValue())
query+=",'"
query+=SurveyTitle
query+="',"
query+=PrepForMDB(Year)
query+=");"
try:
self.DB.Execute(query)
except:
print('\nNewMDB 267 query\n',query)
self.DB.Execute(query)
def ADDTo_EstDens(self,PopLinear, PopSpatial,BmassLinear,BmassSpatial,TranCharKey=None,SizeKey=None):
skey=SizeKey
if skey==None:skey=self.SizeRangeKey.GetValue()
tckey=TranCharKey
if tckey==None:tckey=self.TranCharKey.GetValue()
query ="insert INTO Results_EstDens(TranCharKey,SizeRangeKey, "
query+= 'PopLinear'+US.PerMetre+ ', PopSpatial'+US.PerMetreSquared+ ', BmassLinear'+US.KgPerMetre+ ', BmassSpatial'+US.KgPerMetreSquared+ ') '
query+="Values("
query+=PrepForMDB(tckey)
query+=","
query+=PrepForMDB(skey)
query+=","
query+=PrepForMDB(PopLinear)
query+=","
query+=PrepForMDB(PopSpatial)
query+=","
try:
query+=PrepForMDB(BmassLinear/1000.)
except:
query+=PrepForMDB(MinInt)
query+=","
try:
query+=PrepForMDB(BmassSpatial/1000.)
except:
query+=PrepForMDB(MinInt)
query+=");"
try:
self.DB.Execute(query)
except:
print('\nNewMDB 181 query\n',query)
self.DB.Execute(query)
def ADDTo_SizeRange(self, MinSize,MaxSize):
query ="insert INTO Results_SizeRange(AnalysisKey,SizeRangeKey, "
query+= 'MinSize'+US.Mm+ ',MaxSize'+US.Mm+ ') '
query+="Values("
query+=PrepForMDB(self.AnalysisKey.GetValue())
query+=","
query+=PrepForMDB(self.SizeRangeKey.GetValue())
query+=","
query+=PrepForMDB(MinSize)
query+=","
query+=PrepForMDB(MaxSize)
query+=");"
query=query.replace('inf','1000')
try:
self.DB.Execute(query)
except:
print('\nNewMDB 187 query\n',query)
self.DB.Execute(query)
self.SizeMap[MaxSize]= self.SizeRangeKey.GetValue()
def ADDTo_Results_OverallConfBounds(self,\
pcConfidenceLevel,\
DensityLow, DensityHigh,\
PopulationLow, PopulationHigh,\
BiomassPerMLow, BiomassPerMHigh,\
SurveyBiomassLow, SurveyBiomassHigh\
):
query = "insert INTO Results_OverallConfBounds(ROKey,ConfidenceLevel, "
query += "DensityLow, DensityHigh, "
query += "PopulationLow, PopulationHigh, "
query += "BiomassPerMLow, BiomassPerMHigh, "
query += "SurveyBiomassLow, SurveyBiomassHigh "
query += ") "
query += "Values("
query += PrepForMDB(self.ROKey.GetValue())
query += "," + PrepForMDB(pcConfidenceLevel)
query += "," + PrepForMDB(DensityLow) + "," + PrepForMDB(DensityHigh)
query += "," + PrepForMDB(PopulationLow) + "," + PrepForMDB(
PopulationHigh)
try:
query += "," + PrepForMDB(
BiomassPerMLow / 1000.) + "," + PrepForMDB(
BiomassPerMHigh / 1000.)
except:
query += "," + '-32767' + "," + '-32767'
try:
query += "," + PrepForMDB(
SurveyBiomassLow / 1000000.) + "," + PrepForMDB(
SurveyBiomassHigh / 1000000.)
except:
query += "," + '-32767' + "," + '-32767'
query += ");"
query = query.replace('None', '-32767')
try:
self.DB.Execute(query)
except:
print('\nNewMDB 407 query\n', query)
self.DB.Execute(query)
def GetValuesAsChar(self, key=None):
'''OldHeaders.GetValuesAsChar(self, key)'''
#Revise the current query to reflect the current keys
self.SetKeys(key)
if self.Nrec == 0:
return ([])
#All relevent records
result = []
self.rs.MoveFirst()
while (not (self.CheckEOF())):
CurRec = self.Get()
CurAsChar = PrepForMDB(CurRec)
result += [CurAsChar]
return (result)
def ADDTo_Results_Overall(self, Density, Population, BiomassPerM,
SurveyBioMass):
query = "insert INTO Results_Overall(ROKey, ResultKey,Density,Population,BiomassPerM,SurveyBioMass) "
query += "Values("
query += PrepForMDB(self.ROKey.GetValue(IncrementFirst=True))
query += "," + PrepForMDB(self.AnalysisKey.GetValue())
query += "," + PrepForMDB(Density)
query += "," + PrepForMDB(Population)
query += "," + PrepForMDB(BiomassPerM / 1000.)
query += "," + PrepForMDB(SurveyBioMass / 1000000.)
query += ");"
try:
self.DB.Execute(query)
except:
print('\nNewMDB 357 query\n', query)
self.DB.Execute(query)
def ADDTo_Transect(self, TranCharKey,SizeRangeKey,HeaderKey,\
TranLength,Population,Biomass):
query ="insert INTO Results_Transect(TranCharKey,SizeRangeKey,HeaderKey, "
query+='TranLength'+US.Metres+ ',Population,Biomass'+US.Kilograms+ ') '
query+="Values("
query+=PrepForMDB(TranCharKey)
query+=","+PrepForMDB(SizeRangeKey)
query+=","+PrepForMDB(HeaderKey)
query+=","+PrepForMDB(TranLength)
query+=","+PrepForMDB(Population)
query+=","+PrepForMDB(Biomass/1000) #convert from grams to kilograms
query+=");"
try:
self.DB.Execute(query)
except:
print('\nNewMDB 379 query\n',query)
self.DB.Execute(query)
def ADDTo_Results_Header(self,\
TranClassChar,RunNumber,RunComments,SurveyArea,\
NumberTransects,NumberIterations,RandomSeed,\
MinDepth,MaxDepth):
VersionDate = VersionTime()
vy, vm, vd = VersionDate.year, VersionDate.month, VersionDate.day
ct = datetime.datetime.now()
y, m, d = ct.year, ct.month, ct.day
#SurveyArea=MinInt
#if RunNumber==2:SurveyArea
query = "insert INTO Results_Header("
query += "ResultKey,Region,SurveyTitle,[Year],RunNumber,RunComments,YearRun,MonthRun,DayRun,"
query += "SurveyArea,NumberTransects, "
query += "Species,BootstrappingUsed, NumberIterations,RandomSeed,MinDepth,MaxDepth,VersionDate) "
query += "Values("
query += PrepForMDB(self.AnalysisKey.GetValue())
query += ","
try:
query += PrepForMDB(TranClassChar.GetUniqueVal('GeographicArea'))
except:
print('NewMDB 97', TranClassChar.GetUniqueVal('GeographicArea'))
query += PrepForMDB(TranClassChar.GetUniqueVal('GeographicArea'))
query += ","
try:
query += PrepForMDB(TranClassChar.GetUniqueVal('SurveyTitle'))
except:
print('NewMDB 104', TranClassChar.GetUniqueVal('SurveyTitle'))
query += PrepForMDB(TranClassChar.GetUniqueVal('SurveyTitle'))
query += ","
query += PrepForMDB(TranClassChar.GetUniqueVal('Year'))
query += ","
query += PrepForMDB(RunNumber)
query += ","
query += PrepForMDB(RunComments)
query += ","
query += PrepForMDB(y)
query += ","
query += PrepForMDB(m)
query += ","
query += PrepForMDB(d)
query += ","
query += PrepForMDB(SurveyArea / 10000) #Convert to hectares
query += ","
query += PrepForMDB(NumberTransects)
query += ","
query += PrepForMDB('84C')
query += ","
query += PrepForMDB(int(True))
query += ","
query += PrepForMDB(NumberIterations)
query += ","
query += PrepForMDB(RandomSeed)
query += ","
query += PrepForMDB(MinDepth)
query += ","
query += PrepForMDB(MaxDepth)
query += ","
query += "DateSerial( " + str(vy) + "," + str(vm) + "," + str(vd) + ")"
query += ");"
try:
self.DB.Execute(query)
except:
print('\nNewMDB 104 query\n', query)
self.DB.Execute(query)
def ADDTo_ConfInterval(self,TranCharKey,SizeRangeKey,\
pcConfidenceLevel,\
lowPopLinear, uppPopLinear,\
lowPopSpatial, uppPopSpatial,\
lowBmassLinear, uppBmassLinear,\
lowBmassSpatial, uppBmassSpatial):
query ="insert INTO Results_ConfInterval(TranCharKey,SizeRangeKey,pcConfidenceLevel, "
query+= 'lowPopLinear'+US.PerMetre+ ', uppPopLinear'+US.PerMetre+ ', '
query+= 'lowPopSpatial'+US.PerMetreSquared+ ', uppPopSpatial'+US.PerMetreSquared+ ', '
query+= 'lowBmassLinear'+US.KgPerMetre+ ', uppBmassLinear'+US.KgPerMetre+ ', '
query+= 'lowBmassSpatial'+US.KgPerMetreSquared+ ', uppBmassSpatial'+US.KgPerMetreSquared+ ') '
query+="Values("
query+=PrepForMDB(TranCharKey)
query+=","
query+=PrepForMDB(SizeRangeKey)
query+=","
query+=PrepForMDB(pcConfidenceLevel)
query+=","
query+=PrepForMDB(lowPopLinear)
query+=","
query+= PrepForMDB(uppPopLinear)
query+=","
query+=PrepForMDB(lowPopSpatial)
query+=","
query+= PrepForMDB(uppPopSpatial)
query+=","
query+=PrepForMDB(lowBmassLinear/1000.)
query+=","
try:
query+= PrepForMDB(uppBmassLinear/1000.)
except:
query+= PrepForMDB(MinInt)
query+=","
try:
query+=PrepForMDB(lowBmassSpatial/1000.)
except:
query+=PrepForMDB(MinInt)
query+=","
try:
query+= PrepForMDB(uppBmassSpatial/1000.)
except:
query+= PrepForMDB(MinInt)
query+=");"
try:
self.DB.Execute(query)
except:
print('\nNewMDB 119 query\n',query)
self.DB.Execute(query)
def ADDTo_Results_Transect(self, TransectKey,SiteKey,TransectNumber,HeaderKey,SurveyDate,MinDepth,MaxDepth,\
TranLength,NumQuadrats,NumAnimals,Density ,BiomassPerM ,ShowFactor,\
DailyFixed ,OmitTransect ,OmitTransectReason,TransectComments,GIS_Code):
#Make the rounding match old version of analysis program
iTranLength = int(round(TranLength + 1e-6))
query = "insert INTO Results_Transect(TransectKey,SiteKey,TransectNumber,HeaderKey, "
query += "[Year],[Month],[Day],MinDepth,MaxDepth, "
query += "TranLength,NumQuadrats,NumAnimals,Density,BiomassPerM ,ShowFactor, "
query += "DailyFixed,OmitTransect,OmitTransectReason ,TransectComments "
#GIS_Code left blank if there is no value
if GIS_Code != None: query += ",GIS_Code "
query += ") "
query += "Values("
query += PrepForMDB(TransectKey)
query += ","
query += PrepForMDB(SiteKey)
query += ","
query += PrepForMDB(TransectNumber)
query += ","
query += PrepForMDB(HeaderKey)
query += ","
query += PrepForMDB(SurveyDate.year) + "," + PrepForMDB(
SurveyDate.month) + "," + PrepForMDB(SurveyDate.day)
query += ","
query += PrepForMDB(MinDepth)
query += ","
query += PrepForMDB(MaxDepth)
query += ","
query += PrepForMDB(iTranLength)
query += ","
query += PrepForMDB(NumQuadrats)
query += ","
query += PrepForMDB(NumAnimals)
query += ","
query += PrepForMDB(Density)
query += ","
query += PrepForMDB(BiomassPerM)
query += ","
query += PrepForMDB(ShowFactor)
query += ","
query += PrepForMDB(DailyFixed)
query += ","
query += PrepForMDB(OmitTransect)
query += ","
query += PrepForMDB(OmitTransectReason)
query += ","
query += PrepForMDB(TransectComments)
if GIS_Code != None:
query += ","
query += PrepForMDB(GIS_Code)
query += ");"
query = query.replace('None', '-32767')
try:
self.DB.Execute(query)
except:
print('\nNewMDB 322 query\n', query)
self.DB.Execute(query)
def ADDTo_TranChar(self, SurveyTitle,SubSampleLocation,Year,StatArea,SubArea,InBed,Transect_Count,\
TransectArea,SurveyedQuadCount,intcpt,sdintcpt,mubeta,sigmabeta,sigmaepsilon):
query ="insert INTO Results_TranChar(AnalysisKey,TranCharKey,SurveyTitle,SubSampleLocation,Yr,StatArea,SubArea,InBed,"
query+='Transect_Count,TransectArea'+US.MetresSquared+ ",SurveyedQuadCount,intcpt,sdintcpt,mubeta,sigmabeta,sigmaepsilon) "
query+="Values("
query+=PrepForMDB(self.AnalysisKey.GetValue())
query+=","
query+=PrepForMDB(self.TranCharKey.GetValue())
query+=",'"
query+=SurveyTitle
query+="','"
query+=SubSampleLocation
query+="',"
query+=PrepForMDB(Year)
query+=","
query+=PrepForMDB(StatArea)
query+=","
query+=PrepForMDB(SubArea)
query+=","
query+=PrepForMDB(InBed)
query+=","
query+=PrepForMDB(Transect_Count)
query+=","
query+=PrepForMDB(TransectArea)
query+=","
query+=PrepForMDB(SurveyedQuadCount)
query+=","
query+=PrepForMDB(intcpt)
query+=","
query+=PrepForMDB(sdintcpt)
query+=","
query+=PrepForMDB(mubeta)
query+=","
query+=PrepForMDB(sigmabeta)
query+=","
query+=PrepForMDB(sigmaepsilon)
query+=");"
try:
self.DB.Execute(query)
except:
print('\nNewMDB 263 query\n',query)
self.DB.Execute(query)
self.TranCharMap+=[[SurveyTitle,SubSampleLocation,Year,StatArea,SubArea,InBed,self.TranCharKey.GetValue() ]]
self.TranCharKey.Increment()
def ADDTo_Results_Site(self,SiteNum,LOBF,MeanTranLength,SiteArea,SiteAreaSE,\
MeanWt,MeanWtSE,MeanWtSource,\
NumberTransects,Density,Population,\
BiomassPerM,SiteBioMass,AnalyzeSite):
query = "insert INTO Results_Site(ResultKey, SiteKey, SiteNumber, LOBF, MeanTranLength, "
query += "SiteArea,SiteAreaSE,MeanWt,MeanWtSE,MeanWtSource,NumberTransects,Density, "
query += "Population,BiomassPerM,SiteBioMass,AnalyzeSite) "
query += "Values("
query += PrepForMDB(self.AnalysisKey.GetValue())
query += "," + PrepForMDB(self.SiteKey.GetValue(IncrementFirst=True))
query += "," + PrepForMDB(SiteNum)
query += "," + PrepForMDB(LOBF)
query += "," + PrepForMDB(MeanTranLength)
query += "," + PrepForMDB(SiteArea / 10000.)
query += "," + PrepForMDB(SiteAreaSE / 10000.)
query += "," + PrepForMDB(MeanWt)
query += "," + PrepForMDB(MeanWtSE)
query += "," + PrepForMDB(MeanWtSource)
query += "," + PrepForMDB(NumberTransects)
query += "," + PrepForMDB(Density)
query += "," + PrepForMDB(Population)
query += "," + PrepForMDB(
BiomassPerM / 1000.) #Convert from grams to kilogram
query += "," + PrepForMDB(
SiteBioMass / 1000. / 1000.) #Convert from grams to tonnes
query += "," + PrepForMDB(int(AnalyzeSite)) #
query += ");"
query = query.replace('None', '-32767')
try:
self.DB.Execute(query)
except:
print('\nNewMDB 219 query\n', query)
print(' MeanWtSource ', )
def ADDTo_SiteConfBound(self,\
pcConfidenceLevel,\
DensityLow, DensityHigh,\
PopulationLow, PopulationHigh,\
BiomassPerMLow, BiomassPerMHigh,\
SiteBiomassLow, SiteBiomassHigh\
):
query = "insert INTO Results_SiteConfBound(SiteKey,ResultKey,ConfidenceLevel, "
query += "DensityLow, DensityHigh, "
query += "PopulationLow, PopulationHigh, "
query += "BiomassPerMLow, BiomassPerMHigh, "
query += "SiteBiomassLow, SiteBiomassHigh "
query += ") "
query += "Values("
query += PrepForMDB(self.SiteKey.GetValue())
query += ","
query += PrepForMDB(self.AnalysisKey.GetValue())
query += "," + PrepForMDB(pcConfidenceLevel)
query += "," + PrepForMDB(DensityLow) + "," + PrepForMDB(DensityHigh)
query += "," + PrepForMDB(PopulationLow) + "," + PrepForMDB(
PopulationHigh)
try:
query += "," + PrepForMDB(
BiomassPerMLow / 1000.) + "," + PrepForMDB(
BiomassPerMHigh / 1000.)
except:
query += "," + '-32767' + "," + '-32767'
try:
query += "," + PrepForMDB(
SiteBiomassLow / 1000.) + "," + PrepForMDB(
SiteBiomassHigh / 1000.)
except:
query += "," + '-32767' + "," + '-32767'
query += ");"
query = query.replace('None', '-32767')
query = query.replace('-inf', '-32767')
query = query.replace('inf', '-32767')
try:
self.DB.Execute(query)
except:
print('\nNewMDB 156 query\n', query)
self.DB.Execute(query)
def ADDTo_TranChar(self, SurveyTitle,Location,SiteNum,Year,StatArea,SubArea,InBed,Transect_Count,\
TransectArea,SurveyedQuadCount):
query = "insert INTO Results_TranChar(AnalysisKey,TranCharKey,SurveyTitle,Location,SiteNum,[Year],StatArea,SubArea,InBed,"
query += 'Transect_Count,TransectArea' + US.MetresSquared + ',SurveyedQuadCount) '
query += "Values("
query += PrepForMDB(self.AnalysisKey.GetValue())
query += ","
query += PrepForMDB(self.TranCharKey.GetValue())
query += ","
query += PrepForMDB(SurveyTitle)
query += ","
query += PrepForMDB(Location)
query += ","
query += PrepForMDB(SiteNum)
query += ","
query += PrepForMDB(Year)
query += ","
query += PrepForMDB(StatArea)
query += ","
query += PrepForMDB(SubArea)
query += ","
query += PrepForMDB(InBed)
query += ","
query += PrepForMDB(Transect_Count)
query += ","
query += PrepForMDB(TransectArea)
query += ","
query += PrepForMDB(SurveyedQuadCount)
query += ");"
query = query.replace('None', '-32768')
try:
self.DB.Execute(query)
except:
print('\nNewMDB 314 query\n', query)
self.DB.Execute(query)
self.TranCharMap += [[
SurveyTitle, Location, SiteNum, Year, StatArea, SubArea, InBed,
self.TranCharKey.GetValue()
]]
self.TranCharKey.Increment()