Mercurial Repositories > eric / file comparison
comparison: eric6/WebBrowser/SafeBrowsing/SafeBrowsingCache.py
eric6/WebBrowser/SafeBrowsing/SafeBrowsingCache.py
- changeset 7269
- 0c63ea7f94bd
- parent 7229
- 53054eb5b15a
- child 7360
- 9190402e4505
equal
deleted
inserted
replaced
| 7268:a28338eaf694 | 7269:0c63ea7f94bd |
|---|---|
| 14 # https://github.com/afilipovich/gglsbl | 14 # https://github.com/afilipovich/gglsbl |
| 15 # | 15 # |
| 16 | 16 |
| 17 import os | 17 import os |
| 18 | 18 |
| 19 from PyQt5.QtCore import QObject, QByteArray, QCryptographicHash, \ | 19 from PyQt5.QtCore import ( |
| 20 QCoreApplication, QEventLoop | 20 QObject, QByteArray, QCryptographicHash, QCoreApplication, QEventLoop |
| 21 ) | |
| 21 from PyQt5.QtSql import QSql, QSqlDatabase, QSqlQuery | 22 from PyQt5.QtSql import QSql, QSqlDatabase, QSqlQuery |
| 22 | 23 |
| 23 from .SafeBrowsingThreatList import ThreatList | 24 from .SafeBrowsingThreatList import ThreatList |
| 24 | 25 |
| 25 | 26 |
| 669 db = QSqlDatabase.database(self.__connectionName) | 670 db = QSqlDatabase.database(self.__connectionName) |
| 670 if db.isOpen(): | 671 if db.isOpen(): |
| 671 db.transaction() | 672 db.transaction() |
| 672 try: | 673 try: |
| 673 for index in range(0, len(prefixesToRemove), batchSize): | 674 for index in range(0, len(prefixesToRemove), batchSize): |
| 674 removeBatch = \ | 675 removeBatch = prefixesToRemove[ |
| 675 prefixesToRemove[index:(index + batchSize)] | 676 index:(index + batchSize) |
| 677 ] | |
| 676 | 678 |
| 677 query = QSqlQuery(db) | 679 query = QSqlQuery(db) |
| 678 query.prepare( | 680 query.prepare( |
| 679 queryStr.format(",".join(["?"] * len(removeBatch))) | 681 queryStr.format(",".join(["?"] * len(removeBatch))) |
| 680 ) | 682 ) |
