From 22f370322412074174cde20ecfd14ec03657ab63 Mon Sep 17 00:00:00 2001
From: lyg <1543117173@qq.com>
Date: 星期一, 07 七月 2025 16:20:25 +0800
Subject: [PATCH] 生成数据库
---
knowledgebase/db/doc_db_models.py | 28 ++++++++++++++++++++++++++--
1 files changed, 26 insertions(+), 2 deletions(-)
diff --git a/knowledgebase/db/doc_db_models.py b/knowledgebase/db/doc_db_models.py
index e5a11ea..80ea1a0 100644
--- a/knowledgebase/db/doc_db_models.py
+++ b/knowledgebase/db/doc_db_models.py
@@ -6,6 +6,7 @@
# @description: 鏂囨。鏁版嵁搴撴ā鍨�
from sqlalchemy import create_engine, Column, DateTime, Integer, Text, ForeignKey
+from sqlalchemy.dialects.mysql import LONGTEXT
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship
from sqlalchemy.orm import sessionmaker, scoped_session
@@ -22,6 +23,7 @@
"""
__tablename__ = 't_paragraphs'
id = Column(Integer, primary_key=True)
+ # text = Column(LONGTEXT)
text = Column(Text)
title_level = Column(Integer)
title_num = Column(Text)
@@ -120,16 +122,38 @@
is_del = Column(Integer)
-def init_doc_db():
+# class TTmPacket(Base):
+# __tablename__ = 't_tm_packets'
+# id = Column(Integer, primary_key=True)
+# name = Column(Text)
+# code = Column(Text)
+# apid = Column(Integer)
+# is_del = Column(Integer)
+#
+#
+# class TTmPacketParagraphLink(Base):
+# __tablename__ = 't_tm_packet_paragraph_links'
+# id = Column(Integer, primary_key=True)
+# tm_packet_id = Column(Integer, ForeignKey('t_tm_packets.id'))
+# paragraph_id = Column(Integer, ForeignKey('t_paragraphs.id'))
+# tm_packet = relationship("TTmPacket", foreign_keys=[tm_packet_id], uselist=False)
+# paragraph = relationship("TParagraph", foreign_keys=[paragraph_id], uselist=False)
+# is_del = Column(Integer)
+
+
+def init_doc_db(project_path):
"""
鍒濆鍖栨枃妗ｆ暟鎹簱
:return: 鏁版嵁搴搒ession瀹炰緥
"""
# mysql
Log.info("杩炴帴骞跺垵濮嬪寲鏂囨。鏁版嵁搴�...")
- engine = create_engine('mysql+pymysql://root:123456@192.168.3.145:3306/knowledgebase', echo=False)
+ # engine = create_engine('mysql+pymysql://root:123456@10.74.15.171:3306/knowledgebase_xx25', echo=False)
+ engine = create_engine(f'sqlite:///{project_path}/docs/doc_db.db', echo=False)
Base.metadata.create_all(engine)
SessionFactory = sessionmaker(bind=engine)
Session = scoped_session(SessionFactory)
session = Session()
return session
+
+# _xx25
\ No newline at end of file
--
Gitblit v1.9.1