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