--- a/lib/my_db.py	Tue Oct 07 11:10:52 2003 -0400
+++ b/lib/my_db.py	Tue Oct 07 12:50:30 2003 -0400
@@ -43,16 +43,48 @@
 			INSERT INTO db_sequence(seq_name, userid, nextid)
 			VALUES ('bookmarks', %d, 0);
 			""" %(id,))
+		self.crs.execute("""
+			INSERT INTO preferences(userid)
+			VALUES (%d);
+			""" %(id,))
 		self.cnx.commit()
 		return id
 	def delete_user(self, userid):
-		self.crs_execute("""
+		self.crs.execute("""
 			DELETE FROM users WHERE id = %d;
 			DELETE FROM bookmarks_keywords WHERE userid = %d;
 			DELETE FROM bookmarks WHERE userid = %d;
 			DELETE FROM keywords WHERE userid = %d;
 			DELETE FROM db_sequence WHERE userid = %d;
 			""" % (userid,userid,userid,userid,userid))
+		self.cnx.commit()
+	def get_preferences(self):
+		self.crs.execute("""
+			SELECT keywords_box,
+			keywords_sort, keywords_reverse
+			FROM preferences WHERE userid = %d;
+			""" % (self.userid,))
+		res = self.crs.fetchone()
+		return {
+		   'keywords_box' : res[0],
+		   'keywords_sort' : res[1],
+		   'keywords_reverse': res[2]
+		   }
+	def set_preferences(self, prefs):
+	        if prefs['keywords_reverse']:
+			rev = 'TRUE'
+		else:
+			rev = 'FALSE'
+		self.crs.execute("""
+			UPDATE preferences
+			SET keywords_box = %d,
+			keywords_sort = %s,
+			keywords_reverse = %s
+			WHERE userid = %d;
+			""" % (prefs['keywords_box'],
+			sql_quote(prefs['keywords_sort']),
+			rev, self.userid))
+		self.cnx.commit()
 	def add_bookmark(self, bk):
 		id = self.get_next_id('bookmarks')
 		self.crs.execute("""