def saveTerms(term, v, score):
entity = sqlHelper.sql_queryRows('terms',"WHERE `term` LIKE '%s' AND `v_j` = '%d'" %(term, v))
if (len(entity) == 0):
# insert)
conn = sqlHelper.sqlConnect()
cursor = conn.cursor()
try:
cursor.execute("""INSERT INTO terms(term, v_j, score) VALUES(%s, %s, %s) """, (term, str(v), str(score)))
conn.commit()
except :
conn.rollback()
conn.close()
cursor.close()
else:
conn = sqlHelper.sqlConnect()
cursor = conn.cursor()
try:
cursor.execute(
"""UPDATE terms set score = %s WHERE term LIKE %s AND v_j = %s """,
(str(score), term, str(v))
)
conn.commit()
except :
conn.rollback()
conn.close()
cursor.close()
# update
return
def getTermScore(term, v):
result = sqlHelper.sql_queryRows('terms',"WHERE term LIKE '%s' AND v_j='%s'" % (term,str(v)))
return result[0][3]
def getDocsByClass(v):
return sqlHelper.sql_queryRows('training_data','WHERE v = %s' %(v))
def readDocsByClass(v):
return sqlHelper.sql_queryRows('training_data','WHERE v = ' + v)
def readTrainingDataToArray():
return sqlHelper.sql_queryRows('training_data','')
