1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
|
import os
import sqlite3
import sys
from datetime import datetime
# platform_table maps the name of user's OS to a platform code
platform_table = {
'linux': 0,
'linux2': 0,
'darwin': 1,
'cygwin': 2,
'win32': 2,
}
# it supports Linux, MacOS, and Windows platforms.
try:
user_platformcode = platform_table[sys.platform]
except KeyError:
class NotAvailableOS(Exception):
pass
raise NotAvailableOS("It does not support your OS.")
def get_username() -> str:
"""
Get username based on their local computers
"""
platform_code = user_platformcode
cwd_path = os.getcwd()
cwd_path_list = []
# if it is a macOS
if platform_code == 1:
cwd_path_list = cwd_path.split('/')
# if it is a windows
elif platform_code == 2:
cwd_path_list = cwd_path.split('\\')
# if it is a linux
else:
cwd_path_list = cwd_path.split('/')
return cwd_path_list[2]
def get_database_paths() -> dict:
"""
Get paths to the database of browsers and store them in a dictionary.
It returns a dictionary: its key is the name of browser in str and its value is the path to database in str.
"""
platform_code = user_platformcode
browser_path_dict = dict()
# if it is a macOS
if platform_code == 1:
cwd_path = os.getcwd()
cwd_path_list = cwd_path.split('/')
# it creates string paths to broswer databases
abs_safari_path = os.path.join('/', cwd_path_list[1], cwd_path_list[2], 'Library', 'Safari', 'History.db')
abs_chrome_path = os.path.join('/', cwd_path_list[1], cwd_path_list[2], 'Library', 'Application Support', 'Google/Chrome/Default', 'History')
abs_firefox_path = os.path.join('/', cwd_path_list[1], cwd_path_list[2], 'Library', 'Application Support', 'Firefox/Profiles')
# check whether the databases exist
if os.path.exists(abs_safari_path):
browser_path_dict['safari'] = abs_safari_path
if os.path.exists(abs_chrome_path):
browser_path_dict['chrome'] = abs_chrome_path
if os.path.exists(abs_firefox_path):
firefox_dir_list = os.listdir(abs_firefox_path)
# it looks for a directory that ends '.default'
for f in firefox_dir_list:
if f.find('.default') > 0:
abs_firefox_path = os.path.join(abs_firefox_path, f, 'places.sqlite')
# check whether the firefox database exists
if os.path.exists(abs_firefox_path):
browser_path_dict['firefox'] = abs_firefox_path
# if it is a windows
if platform_code == 2:
homepath = os.path.expanduser("~")
abs_chrome_path = os.path.join(homepath, 'AppData', 'Local', 'Google', 'Chrome', 'User Data', 'Default', 'History')
abs_firefox_path = os.path.join(homepath, 'AppData', 'Roaming', 'Mozilla', 'Firefox', 'Profiles')
# it creates string paths to broswer databases
if os.path.exists(abs_chrome_path):
browser_path_dict['chrome'] = abs_chrome_path
if os.path.exists(abs_firefox_path):
firefox_dir_list = os.listdir(abs_firefox_path)
for f in firefox_dir_list:
if f.find('.default') > 0:
abs_firefox_path = os.path.join(abs_firefox_path, f, 'places.sqlite')
if os.path.exists(abs_firefox_path):
browser_path_dict['firefox'] = abs_firefox_path
# if it is a linux and it has only a firefox
if platform_code == 0:
cwd_path = os.getcwd()
cwd_path_list = cwd_path.split('/')
# it creates string paths to broswer databases
abs_firefox_path = os.path.join('/', cwd_path_list[1], cwd_path_list[2], '.mozilla', 'firefox')
# check whether the path exists
if os.path.exists(abs_firefox_path):
firefox_dir_list = os.listdir(abs_firefox_path)
# it looks for a directory that ends '.default'
for f in firefox_dir_list:
if f.find('.default') > 0:
abs_firefox_path = os.path.join(abs_firefox_path, f, 'places.sqlite')
# check whether the firefox database exists
if os.path.exists(abs_firefox_path):
browser_path_dict['firefox'] = abs_firefox_path
return browser_path_dict
def get_browserhistory() -> dict:
"""Get the user's browsers history by using sqlite3 module to connect to the dabases.
It returns a dictionary: its key is a name of browser in str and its value is a list of
tuples, each tuple contains four elements, including url, title, and visited_time.
Example
-------
>>> import browserhistory as bh
>>> dict_obj = bh.get_browserhistory()
>>> dict_obj.keys()
>>> dict_keys(['safari', 'chrome', 'firefox'])
>>> dict_obj['safari'][0]
>>> ('https://mail.google.com', 'Mail', '2018-08-14 08:27:26')
"""
# browserhistory is a dictionary that stores the query results based on the name of browsers.
browserhistory = {}
# call get_database_paths() to get database paths.
paths2databases = get_database_paths()
for browser, path in paths2databases.items():
try:
conn = sqlite3.connect(path)
cursor = conn.cursor()
_SQL = ''
# SQL command for browsers' database table
if browser == 'chrome':
_SQL = """SELECT url, title, datetime((last_visit_time/1000000)-11644473600, 'unixepoch', 'localtime')
AS last_visit_time FROM urls ORDER BY last_visit_time DESC"""
elif browser == 'firefox':
_SQL = """SELECT url, title, datetime((visit_date/1000000), 'unixepoch', 'localtime') AS visit_date
FROM moz_places INNER JOIN moz_historyvisits on moz_historyvisits.place_id = moz_places.id ORDER BY visit_date DESC"""
elif browser == 'safari':
_SQL = """SELECT url, title, datetime(visit_time + 978307200, 'unixepoch', 'localtime')
FROM history_visits INNER JOIN history_items ON history_items.id = history_visits.history_item ORDER BY visit_time DESC"""
else:
pass
# query_result will store the result of query
query_result = []
try:
cursor.execute(_SQL)
query_result = cursor.fetchall()
except sqlite3.OperationalError:
print('* Notification * ')
print('Please Completely Close ' + browser.upper() + ' Window')
except Exception as err:
print(err)
# close cursor and connector
cursor.close()
conn.close()
# put the query result based on the name of browsers.
browserhistory[browser] = query_result
except sqlite3.OperationalError:
print('* ' + browser.upper() + ' Database Permission Denied.')
return browserhistory
|
