def refreshDatabase(self, notepad):
self.l.debug('Refreshing database {}'.format(self.dbFile))
self.conn.execute('''
DELETE FROM pageref''')
self.conn.execute('''
DELETE FROM page''')
# TODO: We need a Notepad instance here.
# Then the following code to search through a notepad can be moved into the Notepad class:
for root, dirnames, filenames in os.walk(self.rootDir):
for filename in fnmatch.filter(filenames, '*.xml'):
pageId = urllib.parse.unquote(filename)[:-4]
stmt = '''
INSERT INTO page VALUES(?)'''
self.conn.execute(stmt, (pageId, ) )
page = LocalPage(notepad, pageId)
page.load()
# print('\n"{}"'.format(pageId))
for childLink in page.getLinks():
# print(' => "{}"'.format(childLink))
stmt = '''
INSERT INTO pageref VALUES(?, ?)'''
self.conn.execute(stmt, (pageId, childLink))
# print()
self.conn.commit()
def startSearch(self, searchText):
self.aborted = False
print('Starting search operation "{}" on {} ...'.format(searchText, self.notepad.getName()))
for pageId in self.pageList:
if self.aborted:
return
page = LocalPage(self.notepad, pageId)
imp = XMLImporter(page.getPageDir(), page.getFilename(), None)
topFrame = imp.importModel()
contents = topFrame.getPlainText()
if re.search(searchText, contents, re.IGNORECASE):
self.addMatch.emit(pageId)
self.searchDone.emit()
def startSearch(self, searchText):
self.aborted = False
print('Starting search operation "{}" on {} ...'.format(
searchText, self.notepad.getName()))
for pageId in self.pageList:
if self.aborted:
return
page = LocalPage(self.notepad, pageId)
imp = XMLImporter(page.getPageDir(), page.getFilename(), None)
topFrame = imp.importModel()
contents = topFrame.getPlainText()
if re.search(searchText, contents, re.IGNORECASE):
self.addMatch.emit(pageId)
self.searchDone.emit()
def getPage(self, pageId):
result = LocalPage(self, pageId)
result.load()
return result
