lib/my_db.py
changeset 57 31271426f879
parent 54 f74bad856bce
child 65 b975a3d7606a
equal deleted inserted replaced
56:6b31934e5b2e 57:31271426f879
    72 			u.full_name, p.default_view
    72 			u.full_name, p.default_view
    73 			FROM preferences p, users u
    73 			FROM preferences p, users u
    74 			WHERE u.id = %d AND p.userid = u.id;
    74 			WHERE u.id = %d AND p.userid = u.id;
    75 			""" % (self.userid,))
    75 			""" % (self.userid,))
    76 		res = self.crs.fetchone()
    76 		res = self.crs.fetchone()
       
    77 		rev_kw = 0
       
    78 		if (res[2]):
       
    79 			rev_kw = 1
    77 		return {
    80 		return {
    78 		   'keywords_box' : res[0],
    81 		   'keywords_box' : res[0],
    79 		   'keywords_sort' : res[1],
    82 		   'keywords_sort' : res[1],
    80 		   'keywords_reverse': res[2],
    83 		   'keywords_reverse': rev_kw,
    81 		   'fullname': res[3],
    84 		   'fullname': res[3],
    82 		   'default_view': res[4]
    85 		   'default_view': res[4]
    83 		   }
    86 		   }
    84 	def set_preferences(self, prefs):
    87 	def set_preferences(self, prefs):
    85 	        if prefs['keywords_reverse']:
    88 	        if prefs['keywords_reverse']: