def disableSelected(self): cats, texts = self.getSelected() DB.setRegex(Settings.get('text_regex')) DB.executemany("""update text set disabled = ifelse(disabled,NULL,1) where rowid = ? and regex_match(text) = 1""", map(lambda x:(x, ), texts)) DB.executemany("""update text set disabled = ifelse(disabled,NULL,1) where source = ? and regex_match(text) = 1""", map(lambda x:(x, ), cats)) self.update()
def disableSelected(self): cats, texts = self.getSelected() DB.setRegex(Settings.get('text_regex')) DB.executemany("""update text set disabled = ifelse(disabled,NULL,1) where rowid = ? and regex_match(text) = 1""", [(x, ) for x in texts]) DB.executemany("""update text set disabled = ifelse(disabled,NULL,1) where source = ? and regex_match(text) = 1""", [(x, ) for x in cats]) self.update()
def disableAllSelected(self): cats, texts = self.getSelected() DB.setRegex(Settings.get('text_regex')) DB.executemany( """update text set disabled = ifelse(disabled, NULL, 1) where rowid = ?""", map(lambda x: (x, ), texts)) DB.executemany( """update text set disabled = ifelse(disabled, NULL, 1) where source = ?""", map(lambda x: (x, ), cats)) self.update()
def disableSelected(self): cats, texts = self.getSelected() DB.setRegex(Settings.get("text_regex")) DB.executemany( """update text set disabled = ifelse(disabled,NULL,1) where rowid = ? and regex_match(text) = 1""", map(lambda x: (x, ), texts), ) DB.executemany( """update text set disabled = ifelse(disabled,NULL,1) where source = ? and regex_match(text) = 1""", map(lambda x: (x, ), cats), ) self.update()