30 lines
1.0 KiB
Python
30 lines
1.0 KiB
Python
import os, signal, sys, re, pymysql,logging
|
|
import urllib.parse as urlparse
|
|
from datetime import datetime
|
|
import subprocess
|
|
|
|
conn = pymysql.connect(host='localhost', user='root', password='dlsxjvkzmdkdlakzpt!',db='searchdic', unix_socket='/var/run/mysqld/mysqld.sock', charset='utf8')
|
|
|
|
curs = conn.cursor(pymysql.cursors.DictCursor)
|
|
selectSql = "SELECT objTerm FROM synonyms GROUP BY objTerm ORDER BY objTerm ASC"
|
|
curs.execute(selectSql)
|
|
rows = curs.fetchall()
|
|
|
|
i = 0
|
|
for row in rows:
|
|
objTerm = re.sub(r"\\",r"\\\\",row['objTerm'])
|
|
subCurs = conn.cursor(pymysql.cursors.DictCursor)
|
|
selectSubSql = "SELECT synonym FROM synonyms WHERE objTerm = \"" + str(objTerm) + "\" ORDER BY upTime ASC"
|
|
subCurs.execute(selectSubSql)
|
|
subRows = subCurs.fetchall()
|
|
synonyms = ''
|
|
for subRow in subRows:
|
|
synonyms = synonyms + str(subRow['synonym']) + ","
|
|
synonyms = re.sub(r"\,$","",synonyms)
|
|
i = i + 1
|
|
logging.warning(str(i) + "\t" + str(row['objTerm']) + " => " + str(synonyms))
|
|
print(str(row['objTerm']) + " => " + str(synonyms))
|
|
|
|
conn.close()
|
|
|
|
# |