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
