File size: 9,458 Bytes
e45316c
 
 
 
 
 
8a17806
e45316c
 
 
 
 
 
 
 
 
 
 
 
 
 
8a17806
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
e45316c
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
8a17806
e45316c
 
 
 
 
 
 
 
 
 
 
8a17806
 
 
 
 
e45316c
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
import os
from pydantic import BaseModel
from tqdm import tqdm
import json
import uuid
import time
import redis
import pandas as pd
from openai import OpenAI
from langchain.embeddings.base import Embeddings
from langchain_core.documents import Document
from langchain_milvus import Milvus, BM25BuiltInFunction
from langchain_text_splitters import RecursiveCharacterTextSplitter
from langchain_classic.retrievers.parent_document_retriever import ParentDocumentRetriever
from langchain_core.stores import InMemoryStore
from dotenv import load_dotenv

# 加载 .env 文件中的环境变量, 隐藏 API Keys
load_dotenv()


# ============================================================
# Redis 缓存处理模块
# ============================================================

def get_redis_client():
    # 创建Redis连接, 使用连接池 (推荐用于生产环境)
    pool = redis.ConnectionPool(host='0.0.0.0', port=6379, db=0, password=None, max_connections=10)
    r = redis.StrictRedis(connection_pool=pool)

    # 测试连接
    try:
        r.ping()
        print("成功连接到 Redis !")
    except redis.ConnectionError:
        print("无法连接到 Redis !")

    return r


# 将 (question, answer) 问答对, 存入 redis
def cache_set(r, question: str, answer: str):
    r.hset("qa", question, answer)
    r.expire("qa", 3600)


# 通过 question, 读取存在 redis 中的 answer
def cache_get(r, question: str):
    return r.hget("qa", question)


# ============================================================
# 嵌入模型, 采用 OpenAI text-embedding-3-small
# ============================================================

class OpenAIEmbeddings(Embeddings):
    """基于 OpenAI Embedding API 的自定义嵌入类"""

    def __init__(self):
        self.client = OpenAI(api_key=os.getenv("OPENAI_API_KEY"))

    def embed_documents(self, texts):
        embeddings = []
        for text in texts:
            response = self.client.embeddings.create(
                model="text-embedding-3-small",
                input=[text],
            )
            embeddings.append(response.data[0].embedding)
        return embeddings

    def embed_query(self, text):
        # 查询文档
        return self.embed_documents([text])[0]


# ============================================================
# Milvus 向量数据库封装类 (第一路召回: JSONL 文本数据)
# ============================================================

class Milvus_vector():
    def __init__(self, uri="./milvus_agent.db"):
        self.URI = uri
        self.embeddings = OpenAIEmbeddings()

        # 定义索引类型
        self.dense_index = {
            "metric_type": "IP",
            "index_type": "IVF_FLAT",
        }
        self.sparse_index = {
            "metric_type": "BM25",
            "index_type": "SPARSE_INVERTED_INDEX"
        }

    def create_vector_store(self, docs):
        init_docs = docs[:10]
        self.vectorstore = Milvus.from_documents(
            documents=init_docs,
            embedding=self.embeddings,
            builtin_function=BM25BuiltInFunction(),  # output_field_names="sparse",
            index_params=[self.dense_index, self.sparse_index],
            vector_field=["dense", "sparse"],
            connection_args={
                "uri": self.URI,
            },
            # 支持 ("Strong", "Session", "Bounded", "Eventually")
            consistency_level="Bounded",
            drop_old=False,
        )
        print("已初始化创建 Milvus ‼")

        count = 10
        temp = []
        for doc in tqdm(docs[10:]):
            temp.append(doc)
            if len(temp) >= 5:
                self.vectorstore.aadd_documents(temp)
                count += len(temp)
                temp = []
                print(f"已插入 {count} 条数据......")
                time.sleep(1)

        print(f"总共插入 {count} 条数据......")
        print("已创建 Milvus 索引完成 ‼")

        return self.vectorstore


# ============================================================
# PDF 父子文档检索器 (第二路召回: PDF 文档数据)
# ============================================================

class Pdf_retriever():
    def __init__(self, uri="./pdf_agent.db"):
        self.URI = uri
        self.embeddings = OpenAIEmbeddings()

        # 定义索引类型
        self.dense_index = {
            "metric_type": "IP",
            "index_type": "IVF_FLAT",
        }
        self.sparse_index = {
            "metric_type": "BM25",
            "index_type": "SPARSE_INVERTED_INDEX"
        }

        self.docstore = InMemoryStore()

        # 文本分割器
        self.child_splitter = RecursiveCharacterTextSplitter(
            chunk_size=200,
            chunk_overlap=50,
            length_function=len,
            separators=["\n\n", "\n", "。", "!", "?", ";", ",", " ", ""]
        )
        self.parent_splitter = RecursiveCharacterTextSplitter(
            chunk_size=1000,
            chunk_overlap=200
        )

    def create_pdf_vector_store(self, docs):
        self.milvus_vectorstore = Milvus(
            embedding_function=self.embeddings,
            builtin_function=BM25BuiltInFunction(),
            vector_field=["dense", "sparse"],
            index_params=[
                {
                    "metric_type": "IP",
                    "index_type": "IVF_FLAT",
                },
                {
                    "metric_type": "BM25",
                    "index_type": "SPARSE_INVERTED_INDEX"
                }
            ],
            connection_args={"uri": self.URI},
            consistency_level="Bounded",
            drop_old=False,
        )

        # 设置父子文档检索器
        self.retriever = ParentDocumentRetriever(
            vectorstore=self.milvus_vectorstore,
            docstore=self.docstore,
            child_splitter=self.child_splitter,
            parent_splitter=self.parent_splitter,
        )

        # 添加文档
        count = 0
        temp = []
        for doc in tqdm(docs):
            temp.append(doc)
            if len(temp) >= 10:
                # ParentDocumentRetriever()不支持异步等待操作
                self.retriever.add_documents(temp)
                count += len(temp)
                temp = []
                print(f"已插入 {count} 条数据......")
                time.sleep(1)

        print(f"总共插入 {count} 条数据......")
        print("基于PDF文档数据的 Milvus 索引完成 ‼")

        return self.retriever


# ============================================================
# 数据预处理: 从 JSONL 文件加载文档 (第一路)
# ============================================================

def prepare_document(file_path=['./data/dialog.jsonl', './data/train.jsonl']):
    # 逐条取出文本数据, 创建嵌入张量, 然后将张量数据插入Milvus
    file_path1 = file_path[0]

    count = 0
    docs = []

    with open(file_path1, 'r', encoding='utf-8') as f:
        for line in f:
            content = json.loads(line.strip())
            prompt = content['query'] + "\n" + content['response']

            temp_doc = Document(page_content=prompt, metadata={"doc_id": str(uuid.uuid4())})
            docs.append(temp_doc)

            count += 1

    print(f"已加载 {count} 条数据!")

    return docs


# ============================================================
# 数据预处理: 从 PDF 提取结果加载文档 (第二路)
# ============================================================

def prepare_pdf_document(file_path="./pdf_output/pdf_detailed_text.xlsx"):
    df = pd.read_excel(file_path)

    # 空行直接删除, 否则后续处理报错
    df = df.dropna(subset=['text_content'])

    # 将DataFrame转换为LangChain文档
    documents = []
    for _, row in df.iterrows():
        # 确保 text_content 是字符串, 且不为 NaN
        text_content = str(row['text_content']) if pd.notna(row['text_content']) else ""

        doc = Document(
            page_content=text_content.strip(),
            metadata={"doc_id": str(uuid.uuid4())}
        )
        documents.append(doc)

    print(f"成功加载 {len(documents)} 个文档")

    return documents


# ============================================================
# 主入口: 执行数据入库流程
# ============================================================

if __name__ == "__main__":
    '''
    # 预处理即将插入 Milvus 的文档数据
    docs = prepare_document()
    print("预处理文档数据成功......")

    # 创建 Milvus 连接
    milvus_vectorstore = Milvus_vector()
    print("创建Milvus连接成功......")

    # 创建向量索引
    vectorstore = milvus_vectorstore.create_vector_store(docs)
    print("全部初始化完成, 可以开始问答了......")
    '''
    ''''
    # 将 PDF 后处理文档中的数据, 封装成Document
    docs = prepare_pdf_document()
    print("预处理 PDF 文档数据成功......")
    # print(docs[0])

    pdf_vectorstore = Pdf_retriever()
    print("创建 PDF Milvus 连接成功......")

    retriever = pdf_vectorstore.create_pdf_vector_store(docs)
    print("创建基于 Milvus 数据库的父子文档检索器成功......")
    print(retriever)
    '''
    r = get_redis_client()
    print("创建Redis连接成功......")
    print(r)

    print("全部初始化完成, 可以开始问答了......")