diff options
| author | Sören Tempel <soeren+git@soeren-tempel.net> | 2021-05-26 21:59:22 +0200 |
|---|---|---|
| committer | Sören Tempel <soeren+git@soeren-tempel.net> | 2021-05-26 21:59:22 +0200 |
| commit | 662d93b8605f6c84dd228841a5c5d9eab3f59186 (patch) | |
| tree | 35f4ddeddd6447147eeae608a82a9e68f1db3384 | |
| parent | 34d7db276acc15c61e20d94bbfaee15f35552966 (diff) | |
history: simplify get_entry query even further
Since 61ca4b802c7df75de8a31c6e409eeae15190accf the explicit size check should no longer be needed, i.e. offset selects nothing already if the offset exceeds the amount of available entries.
| -rw-r--r-- | saneterm/history.py | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/saneterm/history.py b/saneterm/history.py index fba974a..01280b9 100644 --- a/saneterm/history.py +++ b/saneterm/history.py @@ -74,8 +74,7 @@ class History(): # Select an entry by the given offset. If the offset exceeds the # amount of available entries, select nothing and return None. self.__cur.execute(""" - SELECT entry FROM history WHERE exe=:exe AND - ( SELECT count(*) FROM history WHERE exe=:exe ) >= :offset + SELECT entry FROM history WHERE exe=:exe ORDER BY rowid DESC LIMIT 1 OFFSET :offset; """, {"exe": exe, "offset": offset}) |