cookie.py

#!/usr/bin/env python

import sqlite3
from os import environ

def get_conn(path):
    try:
        return sqlite3.connect(path)
    except Exception as err:
        print(f"unable to open database {err}")
        exit(1)

def get_cookie(conn, name, domain):
    res = conn.execute("SELECT value FROM moz_cookies WHERE name=? AND baseDomain=?", (name, domain))                                                                    
    try:
        res.fetchone()[0]
    except:
        return "no result"


if __name__ == "__main__":

    home = environ.get("HOME")
    # TODO: add loop to iterate onto each profile
    conn = get_conn(f"{home}/.mozilla/firefox/gwcwqgnw.default/cookies.sqlite")
    print(get_cookie(conn, "datr", "facebook.com"))
    conn.close()