About

Provides a library to fetch entries from Google Myactivity and a utility program to fetch google music listen history.

Install

go get -u github.com/jpathy/google-myactivity/gmusic_activity

Needs sqlite3 library installed.

Usage

Needs Google chrome/chromium with Chrome DevTools Protocol support. Additionally the user-data-dir provided must have logged in session to google account. If using default user-data-dir (absence of the flag), no instance of chrome should be running without debugging-port.

$ gmusic_activity --help
NAME:
   gmusicactivity - Manage google music activities

USAGE:
   gmusic_activity [global options] command [command options] [arguments...]

VERSION:
   0.1.0

COMMANDS:
     get, g   Fetch activities related to google music and write to stdout
     help, h  Shows a list of commands or help for one command

GLOBAL OPTIONS:
   --chrome-path value     Google chrome executable path
   --user-data-dir value   Google chrome user data directory
   --debugging-port value  Google chrome debugging port to listen on
   --timeout value         Specify a timeout in seconds; 0 means wait until done (default: 0)
   --help, -h              show help
   --version, -v           print the version

$ gmusic_activity get --help
NAME:
   gmusic_activity get - Fetch activities related to google music and write to stdout

USAGE:
   gmusic_activity get [command options] [arguments...]

OPTIONS:
   --file FILE   write results to FILE sqlite db instead of stdout
   --all         Fetches all activities; Default behaviour is to fetch new activities since last fetch present in DB(if --file not given this flag does nothing)
   --from value  Unix epoch in milliseconds to fetch activities from (default: 0)
   --to value    Unix epoch in milliseconds to fetch activities upto (default: 0)

Example

$ gmusic_activity --timeout 20 g --from 1510255950000
Listened to Yeha-Noha (Wishes Of Happiness And Prosperity) (Mendelsohn Edit) by Sacred Spirit on Sat, 11 Nov 2017 07:11:34 IST
Listened to Lacrimosa - Day of Tears by Zbigniew Preisner on Sat, 11 Nov 2017 07:07:03 IST
Listened to Sweet Rain by Bill Douglas on Sat, 11 Nov 2017 07:02:56 IST
Listened to Dekalog I - Part 5 by Zbigniew Preisner on Sat, 11 Nov 2017 06:58:22 IST
Listened to The Primal Gods by Dagda on Sat, 11 Nov 2017 06:50:39 IST
Listened to Adiemus: Cantus inaequalis by Adiemus on Sat, 11 Nov 2017 06:48:18 IST
...

Sqlite Schema

sqlite> .schema gmusic_listens
CREATE TABLE gmusic_listens(id INTEGER PRIMARY KEY, track TEXT NOT NULL, artist TEXT, UNIQUE(track, artist) ON CONFLICT IGNORE);
CREATE INDEX gmusic_track_idx ON gmusic_listens(track);
CREATE INDEX gmusic_artist_idx ON gmusic_listens(artist);
sqlite> .schema gmusic_listens_timestamp
CREATE TABLE gmusic_listens_timestamp(time INTEGER NOT NULL, listens_id REFERENCES gmusic_listens(id) ON DELETE CASCADE ON UPDATE CASCADE, UNIQUE(time, listens_id) ON CONFLICT IGNORE);
CREATE INDEX gmusic_listens_ts_idx ON gmusic_listens_timestamp(listens_id);