2024年3月14日发(作者：苹果5s电池容量)
OpenAI ChatGPT通过mysql打造自己的知识库python代码
import sys, os, logging
from llama_index import GPTVectorStoreIndex
from llama_index import download_loader
onfig(stream=, level=)
ger().addHandler(Handler(stream=
out))
#数据库作为知识库文档
def sql_query():
DatabaseReader = download_loader('DatabaseReader')
reader = DatabaseReader(
scheme="mysql+pymysql", # Database Scheme
host="localhost", # Database Host
port="3306", # Database Port
user="root", # Database User
password="123456", # Database Password
dbname="lejuopen", # Database Name
)
query = f"""
SELECT
CONCAT('姓名:',name, ',年龄:', age, ',班级:',class_id) AS text
FROM student
"""
documents = _data(query=query)
index = _documents(documents)
e_t()
query_engine = _query_engine()
response = query_("名字有test的有几人")
print(response)
n['OPENAI_API_KEY'] = "YOUR API KEY"
sql_query()
发布者：admin，转转请注明出处：http://www.yc00.com/num/1710418666a1753523.html
评论列表（0条）