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()
