def setupDB(self, filename): try: databaseschema.setupDatabase(filename) self.filename = filename except NotImplementedError: QMessageBox.information(self, 'Log In - Open production file', 'Wrong file!!!', QMessageBox.Ok) return False except exc.ArgumentError: QMessageBox.information(self, '%s - Open database', 'Could not successfully open new database.', QMessageBox.Ok) return False db_version = functions.dLookup(databaseschema.Settings.value_1, databaseschema.Settings.setting == '__version__') if not db_version: QMessageBox.information(self, 'Open Database', 'v: %s, db: %s \n Wrong Database File, ' \ 'please contact administrator' % (__version__, db_version), QMessageBox.Ok) self.closeDB() return False elif db_version != __version__: progress = QProgressDialog('Updating File', 'Cancel', 0, 100) progress.setCancelButton(None) progress.show() progress.setValue(50) functions.updateDb(progress, __version__, db_version) return True else: return True
def creatNewFile(self): filename = QFileDialog.getSaveFileName(self, 'New Database - Specify file name') if not filename: return if not '.sqlite' in filename: filename += '.sqlite' databaseschema.setupDatabase(str(filename)) databaseschema.createLists()