lib/my_db.py
changeset 75 4f6b7b48322f
parent 70 1798859f7f6c
equal deleted inserted replaced
74:6784c4350b41 75:4f6b7b48322f
   275 		if not res:
   275 		if not res:
   276 			res = [[0,0]]
   276 			res = [[0,0]]
   277 		return res
   277 		return res
   278 	def map_keywords(self, kws):
   278 	def map_keywords(self, kws):
   279 		"""Return a dictionnary of keywords and their ids."""
   279 		"""Return a dictionnary of keywords and their ids."""
       
   280 		if len(kws) == 0:
       
   281 			return {}
   280 		qry = """SELECT k.id, k.name
   282 		qry = """SELECT k.id, k.name
   281 			FROM keywords k
   283 			FROM keywords k
   282 			WHERE k.userid = %d """ % self.userid
   284 			WHERE k.userid = %d """ % self.userid
   283 		qry += " AND ( k.name = %s " % sql_quote(kws[0])
   285 		qry += " AND ( k.name = %s " % sql_quote(kws[0])
   284 		for kw in kws[1:]:
   286 		for kw in kws[1:]: