26 """ % (sql_quote(name),)) |
26 """ % (sql_quote(name),)) |
27 return self.crs.fetchone() |
27 return self.crs.fetchone() |
28 def create_user(self, name): |
28 def create_user(self, name): |
29 id = self.get_next_id('users') |
29 id = self.get_next_id('users') |
30 self.crs.execute(""" |
30 self.crs.execute(""" |
31 INSERT INTO users(id, name) |
31 INSERT INTO users(id, name, full_name) |
32 VALUES (%d, %s); |
32 VALUES (%d, %s, %s); |
33 """ % (id, sql_quote(name))) |
33 """ % (id, sql_quote(name), sql_quote(name))) |
34 self.crs.execute(""" |
34 self.crs.execute(""" |
35 INSERT INTO keywords(id, userid, name) |
35 INSERT INTO keywords(id, userid, name) |
36 VALUES (0, %d, '--'); |
36 VALUES (0, %d, '--'); |
37 """ %(id,)) |
37 """ %(id,)) |
38 self.crs.execute(""" |
38 self.crs.execute(""" |
58 DELETE FROM db_sequence WHERE userid = %d; |
58 DELETE FROM db_sequence WHERE userid = %d; |
59 """ % (userid,userid,userid,userid,userid)) |
59 """ % (userid,userid,userid,userid,userid)) |
60 self.cnx.commit() |
60 self.cnx.commit() |
61 def get_preferences(self): |
61 def get_preferences(self): |
62 self.crs.execute(""" |
62 self.crs.execute(""" |
63 SELECT keywords_box, |
63 SELECT p.keywords_box, |
64 keywords_sort, keywords_reverse |
64 p.keywords_sort, p.keywords_reverse, |
65 FROM preferences WHERE userid = %d; |
65 u.full_name |
|
66 FROM preferences p, users u |
|
67 WHERE u.id = %d AND p.userid = u.id; |
66 """ % (self.userid,)) |
68 """ % (self.userid,)) |
67 res = self.crs.fetchone() |
69 res = self.crs.fetchone() |
68 return { |
70 return { |
69 'keywords_box' : res[0], |
71 'keywords_box' : res[0], |
70 'keywords_sort' : res[1], |
72 'keywords_sort' : res[1], |
71 'keywords_reverse': res[2] |
73 'keywords_reverse': res[2], |
|
74 'fullname': res[3] |
72 } |
75 } |
73 def set_preferences(self, prefs): |
76 def set_preferences(self, prefs): |
74 if prefs['keywords_reverse']: |
77 if prefs['keywords_reverse']: |
75 rev = 'TRUE' |
78 rev = 'TRUE' |
76 else: |
79 else: |
82 keywords_reverse = %s |
85 keywords_reverse = %s |
83 WHERE userid = %d; |
86 WHERE userid = %d; |
84 """ % (prefs['keywords_box'], |
87 """ % (prefs['keywords_box'], |
85 sql_quote(prefs['keywords_sort']), |
88 sql_quote(prefs['keywords_sort']), |
86 rev, self.userid)) |
89 rev, self.userid)) |
|
90 self.crs.execute(""" |
|
91 UPDATE users |
|
92 SET full_name = %s |
|
93 WHERE id = %d; |
|
94 """ % (sql_quote(prefs["fullname"]), |
|
95 self.userid)) |
87 self.cnx.commit() |
96 self.cnx.commit() |
88 def add_bookmark(self, bk): |
97 def add_bookmark(self, bk): |
89 id = self.get_next_id('bookmarks') |
98 id = self.get_next_id('bookmarks') |
90 self.crs.execute(""" |
99 self.crs.execute(""" |
91 INSERT INTO bookmarks(id, userid, url, name, ldesc, added) |
100 INSERT INTO bookmarks(id, userid, url, name, ldesc, added) |