--- 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