def keywordsWriteToSql(text,i):
conn = conMySql.openSQL()
cursor = conn.cursor()
cursor.execute("update wuhu set text_keywords = %s WHERE ID = %s",(text,i))
conn.commit()
cursor.close()
return True
def sentimentsWriteToSql(sentiments,i):
conn = conMySql.openSQL()
cursor = conn.cursor()
cursor.execute("update wuhu set text_sentiments = %s WHERE ID = %s",(sentiments,i))
conn.commit()
cursor.close()
return True
def descriptionWriteToSql(text,i):
conn = conMySql.openSQL()
cursor = conn.cursor()
cursor.execute("update wuhu set description_segment = %s WHERE ID = %s",(text,i))
conn.commit()
cursor.close()
return True
def dzdpwriteToSql(business_id,business_name,address,telephone,categories,lat,lon,avg_rating,product_grade,decoration_grade,service_grade,product_score,decoration_score,service_score):
conn = conMySql.openSQL()
cursor = conn.cursor()
cursor.execute("insert into dzdp_wuhu(BusinessId,Name,address,telephone,categories,lat,lon,avg_rating,product_grade,decoration_grade,service_grade,product_score,decoration_score,service_score) values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"
,(business_id,business_name,address,telephone,categories,lat,lon,avg_rating,product_grade,decoration_grade,service_grade,product_score,decoration_score,service_score))
conn.commit()
cursor.close()
return True
def weibowriteToSql(weiboid,text,lat,lon,title,userid,location,userdecription,gender,created_at,fax,localcity,formatted):
conn = conMySql.openSQL()
cursor = conn.cursor()
cursor.execute("insert into wuhu(weiboid,text,lat,lon,title,userid,location,userdescription,gender,created_at,fax,locality,formatted)values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"
,(weiboid,text,lat,lon,title,userid,location,userdecription,gender,created_at,fax,localcity,formatted))
conn.commit()
cursor.close()
conn.close()
return True
def getdescription(i):
db = conMySql.openSQL()
cursor = db.cursor()
cursor.execute("select userdescription from wuhu where ID=%s"%i)
textdata = cursor.fetchone()
cursor.close
if textdata[0]=='':
textdata='unknown'
try:
textdata = textdata[0].encode('utf8')
except AttributeError:
textdata="unknown"
return textdata
def count():
db = conMySql.openSQL()
cursor = db.cursor()
cursor.execute("select count(*) from wuhu")
number = cursor.fetchone()
return number
