Skip to content

Instantly share code, notes, and snippets.

View leibovic's full-sized avatar

Margaret Leibovic leibovic

  • League
  • Toronto, ON
View GitHub Profile
# 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
@rnewman
rnewman / gist:2047992
Created March 16, 2012 00:57
Possible query
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)