One function
Firefox in browser-history/browser-history
The author described this change as “[CODE][FIX] Fix incomplete history while fetching from Firefox”. It counts as a record because the check below fails on the code as it stood at d32b04466 and passes on 57196a659, with nothing else changed between the two runs.
Fix saved2020-10-01
Sharing licenceApache-2.0 · LICENSE
Change size+3 −3
What the code was meant to do, written into the code itself as a docstring
Mozilla Firefox Browser Supported platforms: * Windows * Linux * Mac OS Profile support: Yes
The change
| 19 | 19 | ||
| 20 | 20 | history_file = "places.sqlite" | |
| 21 | 21 | history_SQL = """SELECT | |
| 22 | - | datetime(last_visit_date/1000000, 'unixepoch', 'localtime') AS 'visit_time', | |
| 22 | + | datetime(visit_date/1000000, 'unixepoch', 'localtime') AS 'visit_time', | |
| 23 | 23 | url | |
| 24 | - | FROM moz_historyvisits NATURAL JOIN moz_places WHERE | |
| 25 | - | last_visit_date IS NOT NULL AND url LIKE 'http%' AND title IS NOT NULL""" | |
| 24 | + | FROM moz_historyvisits INNER JOIN moz_places ON moz_historyvisits.place_id = moz_places.id | |
| 25 | + | WHERE visit_date IS NOT NULL AND url LIKE 'http%' AND title IS NOT NULL""" |
The check that tells the two apart
fail→pass·tests/test_browsers.py::test_firefox_linux
Check file tests/test_browsers.py, taken without changes from the fix and copied onto the older code, so the exact same check runs against both versions.
Origin and history
The code before itd32b0446672472589c867314f57efcf972f2a1f7
Broken version dated2020-09-29
Modulebrowser_history.browsers
Units changedFirefox
Fingerprinted55269297b7668b
Checked2026-08-18 by goldset/0.1
Every field above is generated by our program. None of it is written by hand.