-
Notifications
You must be signed in to change notification settings - Fork 1
/
scratchpad.py
62 lines (47 loc) · 1.5 KB
/
scratchpad.py
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
#<<<<<<< Updated upstream
#import os
import os,requests,sqlite3,logging
## test os
import platform
print(platform.system())
logging.basicConfig(filename='bukmarker.log', level=logging.DEBUG)
# open firefox db file
conn = sqlite3.connect("C:\\Users\\Devesh\\AppData\\Roaming\\Mozilla\\Firefox\\Profiles\\x94qotzr.default-1509035816333\\places.sqlite", \
detect_types=sqlite3.PARSE_COLNAMES|sqlite3.PARSE_DECLTYPES)
conn.row_factory = sqlite3.Row
#print(conn)
c = conn.cursor()
# parent folder rows
# foreign key is null for folders
folder_bm = {}
c.execute("SELECT DISTINCT id,title FROM 'moz_bookmarks' WHERE type=2")
for row in c.fetchall():
folder_bm[row[0]] = row[1]
#print(folder_bm)
c.execute("SELECT DISTINCT fk,parent,title,dateAdded FROM 'moz_bookmarks' WHERE type=1")
# loaded bookmark dict
bm = {}
for row in c.fetchall():
res = c.execute("SELECT url FROM 'moz_places' where id={}".format(row[0]))
res = res.fetchone()
bm[res[0]] = { "title":row[2], "tags":[folder_bm[row[1]]], "date_added":row[3] }
logging.debug(" {0} ".format(row["dateAdded"]))
#print(bm)
# fetch date_added from db
#>>>>>>> Stashed changes
logfile_path = os.path.abspath(os.path.dirname(os.path.__file__))
logfilename = os.path.join(logfile_path, "bukmarker.log")
print(logfile_path)
print(os.getcwd())
env = os.environ
print(os.path.join(env.get('APPDATA'),'dev'))
def f():
yield 3
yield 5
raise StopIteration
def h():
g = []
g.extend(f())
print(g)
print(len(g))
h()