import sqlite3, os, shutil

src_cookies = os.path.expandvars(r'%LOCALAPPDATA%\Google\Chrome\User Data\Default\Network\Cookies')
dst_cookies = r'C:\Projects\Historical\content\browser_profiles\chrome_mirsixabcf2\Default\Network\Cookies'

print('Source exists:', os.path.exists(src_cookies))
print('Dest exists:', os.path.exists(dst_cookies))

tmp_src = 'downloads/tmp_src_cookies.sqlite'
tmp_dst = 'downloads/tmp_dst_cookies.sqlite'
shutil.copy2(src_cookies, tmp_src)
shutil.copy2(dst_cookies, tmp_dst)

def check_db(path, label):
    conn = sqlite3.connect(path)
    c = conn.cursor()
    c.execute("SELECT host_key, name, length(encrypted_value) FROM cookies WHERE host_key LIKE '%google%' OR host_key LIKE '%youtube%'")
    rows = c.fetchall()
    print(f'=== {label} === ({len(rows)} matching cookies)')
    for r in rows[:10]:
        print(' ', r)
    conn.close()

check_db(tmp_src, 'SOURCE CHROME')
check_db(tmp_dst, 'COPIED PROFILE')
