def __init__(self, mode, uuid=None, new_uuid=None, onlyClassified=False): super().__init__() self.mode = mode self.local_cn = get_local_connection() self.remote_cn = get_remote_connection() self.new_uuid = new_uuid self.uuid = uuid self.d = self.draw_progress_dialog() self.onlyClassified = onlyClassified
def updateDefinition(uuid, definition, oc): remote_sql = QSqlQuery(get_remote_connection()) if oc: remote_sql.prepare(update_definition_query_OC) else: remote_sql.prepare(update_definition_query) remote_sql.bindValue(":uuid", uuid.__str__()) remote_sql.bindValue(":definition", definition.__str__()) if remote_sql.exec_(): return True else: return False
def checkTerminExists(uuid, oc): remote_sql = QSqlQuery(get_remote_connection()) if oc: remote_sql.prepare(get_definition_query_OC) else: remote_sql.prepare(get_definition_query) remote_sql.bindValue(":uuid", uuid.__str__()) if remote_sql.exec_(): if remote_sql.next(): return True else: return False else: return False
def getDefinition(uuid, oc): remote_sql = QSqlQuery(get_remote_connection()) if oc: remote_sql.prepare(get_definition_query_OC) else: remote_sql.prepare(get_definition_query) remote_sql.bindValue(":uuid", uuid.__str__()) if remote_sql.exec_(): if remote_sql.next(): definition = remote_sql.value(0).__str__() definition = definition.replace(' ', ' ') definition = definition.replace(' </A>', '</A> ') fs = re.findall(r'<[Aa][^>]*> ', definition) for f in fs: new_f = f.strip() definition = definition.replace(f, new_f) return definition else: return None else: return None
def fill_fields(self): query = QSqlQuery(get_remote_connection()) if self.onlyClassified: query.prepare(get_name_and_short_def_query_OC) else: query.prepare(get_name_and_short_def_query) query.bindValue(':uuid', self.uuid) if query.exec_(): if query.next(): self.mainWordLabel.setText('Ссылка на термин: <b>' + query.value(0) + "</b>") short_def = remove_all_tags(query.value(1)) if len(query.value(1)) < 299: self.definitionLabel.setText("Определение: " + short_def) else: self.definitionLabel.setText("Определение: " + short_def + '...') else: self.mainWordLabel.setText('Термин не найден') self.definitionLabel.setText("Возможно термин, на который ведет данная ссылка был удален или" " Вы подключились к другой БД. Пожалуйста, обновите список терминов.") else: print(query.lastError().text()) print(query.lastQuery())
def __init__(self): super().__init__() self.insert_link_attempts = 0 self.RefreshThread = None self.local_cn = get_local_connection() self.remote_cn = get_remote_connection() self.setupUi(self) self.onlyClassified = False self.onlyClassifiedCheck.clicked.connect(self.switchOnlyClassified) self.terminNameLabel.setWordWrap(True) self.root = QTreeWidgetItem(self.terminsTreeWidget, ['description']) self.terminsTreeWidget.setRootIndex( self.terminsTreeWidget.indexFromItem(self.root)) self.refreshTerminsListBtn.clicked.connect(self.refresh_termins_list) self.statusbar.showMessage('Версия программы: ' + Config.VERSION, -1) self.terminsPerPageComboBos.currentIndexChanged.connect( partial(self.show_termins_in_list, 1)) self.searchLineEdit.textChanged.connect( partial(self.show_termins_in_list, 1)) self.showLinkedCheck.clicked.connect( partial(self.show_termins_in_list, 1)) self.root_brokenlinks = QTreeWidgetItem(self.brokenLinksTree, ['description']) self.brokenLinksTree.setRootIndex( self.brokenLinksTree.indexFromItem(self.root_brokenlinks)) self.brokenlinksComboBox.currentIndexChanged.connect( partial(self.show_brokenlinks_in_list, 1)) self.brokenlinksSearhLine.textChanged.connect( partial(self.show_brokenlinks_in_list, 1)) self.show_termins_in_list(1) self.show_brokenlinks_in_list(1) self.brokenLinksTree.itemClicked.connect( self.brokenLinksTree_itemClicked) # self.terminsTreeWidget.itemClicked.connect(self.termin_tree_itemClicked) self.terminsTreeWidget.itemSelectionChanged.connect( self.termin_tree_itemClicked) self.refreshTerminListAction.triggered.connect( self.refresh_termins_list) self.clearTerminsListAction.triggered.connect(self.clear_termins_list) self.insertLinkBtn.clicked.connect(self.insert_link) self.saveBtn.clicked.connect(self.saveToDB) self.continueBtn.clicked.connect(self.saveAndContimue) self.passBtn.clicked.connect(self.passTerminBtn) self.currentPage = 1 self.current_uuid = None self.decomposeLinksCheck.clicked.connect( partial(self.textEdit.decompose_deleted_link), self.decomposeLinksCheck.isChecked()) self.BLD = None # BrokenLinksDeleter self.brokenLinkOkBtn.clicked.connect(self.brockenlink_ok_btn) self.deleteAllBrokenBtn.clicked.connect(self.delete_All_Broken_Btn) self.seectReplacementBrokenLinkBtn.clicked.connect( self.select_link_for_replace) self.brokenLinksNewUuid = None self.settingsAction.triggered.connect(self.openSettings)
def reconnect(self): print("RECON") self.remote_cn = get_remote_connection()