41 """ %(id,)) |
41 """ %(id,)) |
42 self.crs.execute(""" |
42 self.crs.execute(""" |
43 INSERT INTO db_sequence(seq_name, userid, nextid) |
43 INSERT INTO db_sequence(seq_name, userid, nextid) |
44 VALUES ('bookmarks', %d, 0); |
44 VALUES ('bookmarks', %d, 0); |
45 """ %(id,)) |
45 """ %(id,)) |
|
46 self.crs.execute(""" |
|
47 INSERT INTO preferences(userid) |
|
48 VALUES (%d); |
|
49 """ %(id,)) |
46 self.cnx.commit() |
50 self.cnx.commit() |
47 return id |
51 return id |
48 def delete_user(self, userid): |
52 def delete_user(self, userid): |
49 self.crs_execute(""" |
53 self.crs.execute(""" |
50 DELETE FROM users WHERE id = %d; |
54 DELETE FROM users WHERE id = %d; |
51 DELETE FROM bookmarks_keywords WHERE userid = %d; |
55 DELETE FROM bookmarks_keywords WHERE userid = %d; |
52 DELETE FROM bookmarks WHERE userid = %d; |
56 DELETE FROM bookmarks WHERE userid = %d; |
53 DELETE FROM keywords WHERE userid = %d; |
57 DELETE FROM keywords WHERE userid = %d; |
54 DELETE FROM db_sequence WHERE userid = %d; |
58 DELETE FROM db_sequence WHERE userid = %d; |
55 """ % (userid,userid,userid,userid,userid)) |
59 """ % (userid,userid,userid,userid,userid)) |
|
60 self.cnx.commit() |
|
61 def get_preferences(self): |
|
62 self.crs.execute(""" |
|
63 SELECT keywords_box, |
|
64 keywords_sort, keywords_reverse |
|
65 FROM preferences WHERE userid = %d; |
|
66 """ % (self.userid,)) |
|
67 res = self.crs.fetchone() |
|
68 return { |
|
69 'keywords_box' : res[0], |
|
70 'keywords_sort' : res[1], |
|
71 'keywords_reverse': res[2] |
|
72 } |
|
73 def set_preferences(self, prefs): |
|
74 if prefs['keywords_reverse']: |
|
75 rev = 'TRUE' |
|
76 else: |
|
77 rev = 'FALSE' |
|
78 self.crs.execute(""" |
|
79 UPDATE preferences |
|
80 SET keywords_box = %d, |
|
81 keywords_sort = %s, |
|
82 keywords_reverse = %s |
|
83 WHERE userid = %d; |
|
84 """ % (prefs['keywords_box'], |
|
85 sql_quote(prefs['keywords_sort']), |
|
86 rev, self.userid)) |
|
87 self.cnx.commit() |
56 def add_bookmark(self, bk): |
88 def add_bookmark(self, bk): |
57 id = self.get_next_id('bookmarks') |
89 id = self.get_next_id('bookmarks') |
58 self.crs.execute(""" |
90 self.crs.execute(""" |
59 INSERT INTO bookmarks(id, userid, url, name, ldesc, added) |
91 INSERT INTO bookmarks(id, userid, url, name, ldesc, added) |
60 VALUES (%d, %d, %s, %s, %s, %s); |
92 VALUES (%d, %d, %s, %s, %s, %s); |