result['PopDens'] += [[CB[i], pPopDens[i], pPopDens[-i - 1]]]
result['BioDens'] += [[CB[i], pBioDens[i], pBioDens[-i - 1]]]
return (result)
def SelectGood(criteria, orilist):
n = len(criteria)
result = [orilist[i] for i in range(n) if criteria[i]]
return (result)
if __name__ == "__main__":
import sys
from InputOutputMDB import dataODB, resultODB
from NewMDB import NewMDB
inMDB = dataODB(
prompt="Select input database file",
DefaultDirec="H:\AnalysisPrograms2013\PyFunctions\Geoduck\SampleAIP",
FileExt="Access Files (*.mdb *.accdb)")
resultODB = resultODB(
prompt="Select output database file",
DefaultDirec="H:\AnalysisPrograms2013\PyFunctions\Geoduck\SampleAIP",
FileExt="Access Files (*.mdb *.accdb)")
app = QtGui.QApplication(sys.argv)
Dialog = QtGui.QDialog()
ui = MainWindow(Dialog, inMDB, resultODB)
Dialog.show()
sys.exit(app.exec_())
self.OUTmdb.ADDTo_SizeRange(1+self.UppSizeBnd[x-1],self.UppSizeBnd[x] )
for sy in self.SelectedSurveys:
self.OUTmdb.ADDTo_SurveyUsed(sy[0],sy[1])
def SelectedSurveystoDict(self):
'''Convert self.SelectedSurveys as a list of dictionaries'''
if isinstance(self.SelectedSurveys[0],dict):
return(self.SelectedSurveys)
result=[{'Location':t[0], 'Year':t[1]} for t in self.SelectedSurveys]
return(result)
if __name__ == "__main__":
import sys
inMDB=dataODB(prompt="Select input database file",DefaultDirec="d:\\scratch\\", FileExt="Access Files (*.mdb *.accdb)")
resultODB=resultODB(prompt="Select output database file",DefaultDirec="d:\\scratch\\", FileExt="Access Files (*.mdb *.accdb)")
app = QtGui.QApplication(sys.argv)
Dialog = QtGui.QDialog()
ui = Ui_Dialog(Dialog,inMDB,resultODB)
Dialog.show()
sys.exit(app.exec_())
#write the 103-query to the output as a table
o103=OldHeaders(self.inMDB.MDBfile,TableName='103-All_Beds_w_Area_MeanWt_DenCat_QRegion' )
o103.CreateHeadersTable(self.OUTmdb)
o103.CopyRecordToNew(self.OUTmdb)
#write the 205-query to the output as a table
o205=OldHeaders(self.inMDB.MDBfile,TableName='205-CurrentDen_on_Surveyed_Beds_w_DenCat_QRegion' )
o205.CreateHeadersTable(self.OUTmdb)
o205.CopyRecordToNew(self.OUTmdb)
#write 401-Dprime_on_SurveyedBeds_w_QuotaCalcRegion to the output as a table
o401=OldHeaders(self.inMDB.MDBfile,TableName='401-Dprime_on_SurveyedBeds_w_QuotaCalcRegion' )
o401.CreateHeadersTable(self.OUTmdb)
o401.CopyRecordToNew(self.OUTmdb)
if __name__ == "__main__":
import sys
from InputOutputMDB import dataODB,resultODB
from NewMDB import NewMDB
inMDB=dataODB(prompt="Select input database file",DefaultDirec="H:\QuotaCalcs\data", FileExt="Access Files (*.mdb *.accdb)")
resultODB=resultODB(prompt="Select output database file",DefaultDirec="H:\QuotaCalcs\data", FileExt="Access Files (*.mdb *.accdb)")
app = QtGui.QApplication(sys.argv)
ui = QuotaCalcsMain(inMDB,resultODB)
ui.show()
sys.exit(app.exec_())