diff options
| author | toofar <toofar@spalge.com> | 2023-03-13 10:59:26 +1300 |
|---|---|---|
| committer | toofar <toofar@spalge.com> | 2023-03-13 11:12:53 +1300 |
| commit | 72d8e0bf3a999180bababa0bc9ed1d2b927d7b33 (patch) | |
| tree | 3758a9cbaacaf738ef850baf29a9d6fdd3ac17f9 | |
| parent | b65984f92014d7bcdeada913b0ef0086936198fe (diff) | |
| parent | d7e9a5115318743509c3aaf3b582a316eb9c5716 (diff) | |
| download | qutebrowser-72d8e0bf3a999180bababa0bc9ed1d2b927d7b33.tar.gz qutebrowser-72d8e0bf3a999180bababa0bc9ed1d2b927d7b33.zip | |
Merge pull request #7612 from novel/novel-fix-sqlite-quotes
browser: history: fix queries for when DQS disabled
SQLite in FreeBSD no longer support double quotes around values in SQL queries.
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)) |