$ cd /Users/sameul/Library/Application Support/Google/Chrome/Default

$ sqlite3 Cookies

SQLite version 3.19.3 2017-06-27 16:48:08

Enter ".help" for usage hints.

sqlite> .tables

cookies  meta

sqlite> .schema

CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR);

CREATE TABLE cookies (creation_utc INTEGER NOT NULL,host_key TEXT NOT NULL,name TEXT NOT NULL,value TEXT NOT NULL,path TEXT NOT NULL,expires_utc INTEGER NOT NULL,is_secure INTEGER NOT NULL,is_httponly INTEGER NOT NULL,last_access_utc INTEGER NOT NULL, has_expires INTEGER NOT NULL DEFAULT 1, is_persistent INTEGER NOT NULL DEFAULT 1,priority INTEGER NOT NULL DEFAULT 1,encrypted_value BLOB DEFAULT '',firstpartyonly INTEGER NOT NULL DEFAULT 0,UNIQUE (host_key, name, path));

$ sqlite3

SQLite version 3.19.3 2017-06-27 16:48:08

Enter ".help" for usage hints.

Connected to a transient in-memory database.

Use ".open FILENAME" to reopen on a persistent database.

sqlite> .open Cookies

sqlite> .schema --indent cookies

CREATE TABLE cookies(

  creation_utc INTEGER NOT NULL,

  host_key TEXT NOT NULL,

  name TEXT NOT NULL,

  value TEXT NOT NULL,

  path TEXT NOT NULL,

  expires_utc INTEGER NOT NULL,

  is_secure INTEGER NOT NULL,

  is_httponly INTEGER NOT NULL,

  last_access_utc INTEGER NOT NULL,

  has_expires INTEGER NOT NULL DEFAULT 1,

  is_persistent INTEGER NOT NULL DEFAULT 1,

  priority INTEGER NOT NULL DEFAULT 1,

  encrypted_value BLOB DEFAULT '',

  firstpartyonly INTEGER NOT NULL DEFAULT 0,

  UNIQUE(host_key, name, path)

);

$ python util/scrapers.py

Traceback (most recent call last):

  File "util/scrapers.py", line 3, in <module>

    from util.all_scrapers import re_scraper, bs_scraper, \

ModuleNotFoundError: No module named 'util'

$ cat ~/bash_profile

PYTHONPATH=$PYTHONPATH:/~/dev/python/scraping/code

export PYTHONPATH