实体消歧（链接到实体库）

disambiguation.py

#!/usr/bin/python3
import pymysql
import json
import requests
from SimilarityEN import similarity


def findCandidates(entity):
    # 打开数据库连接
    db = pymysql.connect(host=host, port=3306,
                       user=username, passwd=password, db=dbname)
    # 使用 cursor() 方法创建一个游标对象 cursor
    cursor = db.cursor()
    # SQL 查询语句
    sql = "SELECT * FROM t_wikidata_human_content WHERE `name` LIKE " + "'" + "%" + entity + "'"
    cursor.execute(sql)
    persons = cursor.fetchall()
    candidates = []
    for person in persons:
        candidates.append({
   'wiki_id': person[1], 'name': person[2], 'description': person[3]}