def save_trie_mysql(email_trie): sql_handler = mysql_handler('scam', 'scam', 'test') sql_handler.connect() for word in email_trie: parameter = "('" + word + "'," + str(email_trie.__getitem__(word)) + ")" #print "parameter: ", parameter; try: result = sql_handler.do_query("insert into email_trie values" + parameter)#TODO compose a insert trie query except: continue sql_handler.disconnect()
def demo(): word1 = "business" word2 = "enterprise" #refer to: ''' print("Getting synonyms for " + word1) print(thes.synonyms(word1)) print("Getting scored synonyms for " + word1) print(thes.synonyms(word1)) print("Getting synonyms from simN.lsp (noun subsection) for " + word1) print(thes.synonyms(word1, fileid="simN.lsp")) print("Getting scored synonyms for " + word1) print(thes.scored_synonyms(word1) print("Similarity score for %s and %s:" % (word1, word2)) print(thes.similarity(word1, word2)) ''' sql_handler = mysql_handler('scam', 'scam', 'test') sql_handler.connect() result = sql_handler.do_query('select key_word from email_trie\ where occur_time > 30', True) for line in result: kw = line[0] print "searching for synonyms for key_word: ", kw synonyms = thes.scored_synonyms(kw) for field in synonyms: field_name = field[0] for syn_score in field[1]: syn = syn_score[0] score = syn_score[1] param = '("' + kw + '","' + field_name + '","' + syn + '",' + str(score) + ')' print "executing: insert into synonyms (key_word, field_name, syn, score) values " + param try: sql_handler.do_query("insert into synonyms (key_word, field_name, syn, score) values " + param) except: continue
#!/usr/bin/python # -*- coding: utf-8 -*- from mysql_handler import * if __name__ == "__main__": sql_handler = mysql_handler() sql_handler.connect() result = sql_handler.do_query("SELECT ID,OurEmail from Emails", True) if result: for row in result: print row[0], '**', row[1] else: print "No Result" sql_handler.disconnect()