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_())