cursor.execute(sql,SearchTerm_id) except MySQLdb.Error, e: print "Error %d: %s" % (e.args[0], e.args[1]) db.commit() # retrieve data from temp table into object # assume re-ranking already done in SQL, so just need to take top 10 rows sql = """SELECT * from t_scoring ORDER BY score desc, status_date desc LIMIT 0,10""" try: cursor.execute(sql) except MySQLdb.Error, e: print "Error %d: %s" % (e.args[0], e.args[1]) r = cursor.fetchall() retval = {} for i in range(cursor.rowcount): retval[i] = Result() retval[i].statusid = r[i][0] retval[i].score = r[i][1] retval[i].text = r[i][2] retval[i].geo_lat = r[i][3] retval[i].geo_lon = r[i][4] retval[i].from_user = r[i][5] retval[i].profile_image_url = r[i][6] retval[i].created_at = r[i][7] retval[i].SearchTermID = r[i][8] # sql = """DROP TABLE IF EXISTS t_scoring""" # cursor.execute(sql) cursor.close() db.close() return retval