213 DELETE FROM bookmarks_keywords |
213 DELETE FROM bookmarks_keywords |
214 WHERE keyword = %d AND userid = %d; |
214 WHERE keyword = %d AND userid = %d; |
215 DELETE FROM keywords |
215 DELETE FROM keywords |
216 WHERE id = %d AND userid = %d; |
216 WHERE id = %d AND userid = %d; |
217 """ % (id, self.userid, id, self.userid)) |
217 """ % (id, self.userid, id, self.userid)) |
|
218 self.cnx.commit() |
|
219 def add_keywords(self, add_id, into_id): |
|
220 self.crs.execute(""" |
|
221 INSERT INTO bookmarks_keywords (userid, |
|
222 bookmark, keyword) |
|
223 SELECT (%d, %d, bookmark) |
|
224 WHERE keyword = %d |
|
225 AND userid = %d |
|
226 AND bookmark NOT IN |
|
227 (SELECT bookmark FROM bookmarks_keywords |
|
228 WHERE userid = %d AND keyword = %d ) |
|
229 ; |
|
230 """ % (self.userid, into_id, add_id, self.userid, |
|
231 self.userid, into_id)) |
218 self.cnx.commit() |
232 self.cnx.commit() |
219 def merge_keywords(self, merge_id, into_id): |
233 def merge_keywords(self, merge_id, into_id): |
220 self.crs.execute(""" |
234 self.crs.execute(""" |
221 UPDATE bookmarks_keywords |
235 UPDATE bookmarks_keywords |
222 SET keyword = %d |
236 SET keyword = %d |