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