#!/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]})
实体消歧(链接到实体库)
最新推荐文章于 2025-01-03 09:18:05 发布