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','')