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
|
import logging
import sqlite3
import time
import gconf
from readbookmark import Bookmark
_logger = logging.getLogger('read-activity')
class BookmarkManager:
def __init__(self, filehash, dbpath='read.db'):
self._filehash = filehash
self._conn = sqlite3.connect(dbpath)
self._cur = self._conn.cursor()
self._bookmarks = []
self._populate_bookmarks()
def add_bookmark(self, page, title, local=1):
# locale = 0 means that this is a bookmark originally
# created by the person who originally shared the file
timestamp = time.time()
client = gconf.client_get_default()
user = client.get_string("/desktop/sugar/user/nick")
color = client.get_string("/desktop/sugar/user/color")
t = (self._filehash, page, title, timestamp, user, color, local)
self._cur.execute('insert into bookmarks values (?, ?, ?, ?, ?, ?, ?)', t)
self._conn.commit()
self._resync_bookmark_cache()
def del_bookmark(self, page):
client = gconf.client_get_default()
user = client.get_string("/desktop/sugar/user/nick")
# We delete only the locally made bookmark
t = (self._filehash, page, user)
self._cur.execute('delete from bookmarks where md5=? and page=? and user=?', t)
self._conn.commit()
self._resync_bookmark_cache()
def _populate_bookmarks(self):
# TODO: Figure out if caching the entire set of bookmarks is a good idea or not
self._cur.execute('select * from bookmarks where md5=?', (self._filehash,))
for row in self._cur:
self._bookmarks.append(Bookmark(row))
def get_bookmarks_for_page(self, page):
bookmarks = []
for bookmark in self._bookmarks:
if bookmark.belongstopage(page):
bookmarks.append(bookmark)
return bookmarks
def _resync_bookmark_cache(self):
# To be called when a new bookmark has been added/removed
self._bookmarks = []
self._populate_bookmarks()
|