diff -r 57932e991854 -r 5275135955c0 lib/my_db.py --- a/lib/my_db.py Fri Oct 24 17:51:57 2003 -0400 +++ b/lib/my_db.py Fri Oct 24 17:55:22 2003 -0400 @@ -216,6 +216,20 @@ WHERE id = %d AND userid = %d; """ % (id, self.userid, id, self.userid)) self.cnx.commit() + def add_keywords(self, add_id, into_id): + self.crs.execute(""" + INSERT INTO bookmarks_keywords (userid, + bookmark, keyword) + SELECT (%d, %d, bookmark) + WHERE keyword = %d + AND userid = %d + AND bookmark NOT IN + (SELECT bookmark FROM bookmarks_keywords + WHERE userid = %d AND keyword = %d ) + ; + """ % (self.userid, into_id, add_id, self.userid, + self.userid, into_id)) + self.cnx.commit() def merge_keywords(self, merge_id, into_id): self.crs.execute(""" UPDATE bookmarks_keywords