lib/my_db.py
branchxbelweb
changeset 47 2781ac85b807
parent 45 c81d480c3224
child 50 5275135955c0
--- a/lib/my_db.py	Fri Oct 24 14:19:30 2003 -0400
+++ b/lib/my_db.py	Fri Oct 24 17:04:29 2003 -0400
@@ -62,6 +62,7 @@
 			DELETE FROM users WHERE id = %d;
 			DELETE FROM bookmarks_keywords WHERE userid = %d;
 			DELETE FROM bookmarks WHERE userid = %d;
+			DELETE FROM preferences WHERE userid = %d;
 			DELETE FROM keywords WHERE userid = %d;
 			DELETE FROM db_sequence WHERE userid = %d;
 			""" % (userid,userid,userid,userid,userid))
@@ -70,7 +71,7 @@
 		self.crs.execute("""
 			SELECT p.keywords_box,
 			p.keywords_sort, p.keywords_reverse,
-			u.full_name
+			u.full_name, p.default_view
 			FROM preferences p, users u
 			WHERE u.id = %d AND p.userid = u.id;
 			""" % (self.userid,))
@@ -79,7 +80,8 @@
 		   'keywords_box' : res[0],
 		   'keywords_sort' : res[1],
 		   'keywords_reverse': res[2],
-		   'fullname': res[3]
+		   'fullname': res[3],
+		   'default_view': res[4]
 		   }
 	def set_preferences(self, prefs):
 	        if prefs['keywords_reverse']:
@@ -90,11 +92,12 @@
 			UPDATE preferences
 			SET keywords_box = %d,
 			keywords_sort = %s,
-			keywords_reverse = %s
+			keywords_reverse = %s,
+			default_view = %d
 			WHERE userid = %d;
 			""" % (prefs['keywords_box'],
 			sql_quote(prefs['keywords_sort']),
-			rev, self.userid))
+			rev, prefs['default_view'], self.userid))
 		self.crs.execute("""
 			UPDATE users
 			SET full_name = %s
@@ -322,7 +325,7 @@
 	def remove_folders(self, id, commit = 1):
 		if id == 0:
 			raise "Can't erase base folder!"
-		subs = self.get_subfolders(self, id)
+		subs = self.get_subfolders(id)
 		for sub in subs:
 			self.remove_folder(sub[0], 0)
 		self.crs.execute("""