diff options
| author | Roman Bogorodskiy <bogorodskiy@gmail.com> | 2023-03-12 15:31:01 +0100 |
|---|---|---|
| committer | toofar <toofar@spalge.com> | 2023-03-13 18:34:33 +1300 |
| commit | 714ef3fc593e77d280a9e7a2c6cc149bfd0a7b66 (patch) | |
| tree | c40dda92bbda6c7c8509ee549cea7e804f9b505a | |
| parent | 2fe78b7644605c1e6622573935e7a2404922cbcd (diff) | |
| download | qutebrowser-714ef3fc593e77d280a9e7a2c6cc149bfd0a7b66.tar.gz qutebrowser-714ef3fc593e77d280a9e7a2c6cc149bfd0a7b66.zip | |
browser: history: fix queries for when DQS disabled
Recently the FreeBSD port of sqlite has DQS feature disabled by default.
Without this feature enabled, it's not allowed to use double quotes
for string literals. As such quoting is used in the history.py module,
qutebrowser fails to work on such configurations.
The fix is to use single quotes instead.
ref: #7596
| -rw-r--r-- | qutebrowser/browser/history.py | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/qutebrowser/browser/history.py b/qutebrowser/browser/history.py index d2046345f..595bd1c03 100644 --- a/qutebrowser/browser/history.py +++ b/qutebrowser/browser/history.py @@ -217,19 +217,19 @@ class WebHistory(sql.SqlTable): self.create_index('HistoryIndex', 'url') self.create_index('HistoryAtimeIndex', 'atime') self._contains_query = self.contains_query('url') - self._between_query = self.database.query('SELECT * FROM History ' - 'where not redirect ' - 'and not url like "qute://%" ' - 'and atime > :earliest ' - 'and atime <= :latest ' - 'ORDER BY atime desc') - - self._before_query = self.database.query('SELECT * FROM History ' - 'where not redirect ' - 'and not url like "qute://%" ' - 'and atime <= :latest ' - 'ORDER BY atime desc ' - 'limit :limit offset :offset') + self._between_query = self.database.query("SELECT * FROM History " + "where not redirect " + "and not url like 'qute://%' " + "and atime > :earliest " + "and atime <= :latest " + "ORDER BY atime desc") + + self._before_query = self.database.query("SELECT * FROM History " + "where not redirect " + "and not url like 'qute://%' " + "and atime <= :latest " + "ORDER BY atime desc " + "limit :limit offset :offset") def __repr__(self): return utils.get_repr(self, length=len(self)) |