def browseSqlFile( self ): setting = '/Upload/FilePath' startDir = Config.get(setting) filterstr = "SQL files (*.sql);; All files (*.*)" filename = self.uSqlFile.text() if filename == '': filename = Upload.defaultNewFilename() dlg = QFileDialog(self,"Select SQL file",startDir,filterstr) dlg.selectFile( filename ) dlg.setConfirmOverwrite(True) if dlg.exec_() == QDialog.Accepted and len(dlg.selectedFiles()) == 1: filename = dlg.selectedFiles()[0] self.uSqlFile.setText(filename) Config.set(setting, QFileInfo(filename).absolutePath())
def createSqlFile(self, clicked): item = self.uUploadView.selectedItem() if not item: return upl_id = int(item["upl_id"]) if not upl_id: return upload = Upload(upl_id) setting = "/Upload/FilePath" startDir = Config.get(setting) filterstr = "SQL files (*.sql);; All files (*.*)" filename = upload.filename() if not filename: filename = upload.defaultFilename() dlg = QFileDialog(self, "Select SQL file", startDir, filterstr) dlg.selectFile(filename) dlg.setConfirmOverwrite(True) if dlg.exec_() == QDialog.Accepted and len(dlg.selectedFiles()) == 1: filename = dlg.selectedFiles()[0] upload.writeSql(str(filename)) QMessageBox.information( self, "Address upload created", "SQL for the upload has been written to\n" + filename )
def load(self): self._uploadModel.setList(Upload.list())