lib/my_db.py
branchxbelweb
changeset 50 5275135955c0
parent 47 2781ac85b807
child 52 fe0d02f344cb
--- 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