This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# pip install pypdf2 | |
# Thanks to sphilp for updates | |
######## | |
# USAGE: | |
######## | |
# You will need to enter your email creds so you can receive the bonus statements | |
# which you can then review, edit, and forward (sending directly could be dangerous) | |
# | |
# This is pigging backing on gmail's API to send the email to yourself |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATED: | |
-- Obviously select something more useful than favicon_url, which will always be null. | |
SELECT bid, url, title, visits, hid, i.favicon_url AS favicon_url | |
FROM | |
( | |
-- Bookmarks without history. | |
SELECT b._id AS bid, b.url AS url, b.title AS title, -1 AS visits, -1 AS hid | |
FROM bookmarks b | |
WHERE b.folder = 0 AND b.url NOT IN (SELECT url FROM history) |