data_source.py 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270
  1. import datetime
  2. import json
  3. from flask import request
  4. from flask_login import current_user
  5. from flask_restful import Resource, marshal_with, reqparse
  6. from werkzeug.exceptions import NotFound
  7. from controllers.console import api
  8. from controllers.console.setup import setup_required
  9. from controllers.console.wraps import account_initialization_required
  10. from core.indexing_runner import IndexingRunner
  11. from core.rag.extractor.entity.extract_setting import ExtractSetting
  12. from core.rag.extractor.notion_extractor import NotionExtractor
  13. from extensions.ext_database import db
  14. from fields.data_source_fields import integrate_list_fields, integrate_notion_info_list_fields
  15. from libs.login import login_required
  16. from models.dataset import Document
  17. from models.source import DataSourceOauthBinding
  18. from services.dataset_service import DatasetService, DocumentService
  19. from tasks.document_indexing_sync_task import document_indexing_sync_task
  20. class DataSourceApi(Resource):
  21. @setup_required
  22. @login_required
  23. @account_initialization_required
  24. @marshal_with(integrate_list_fields)
  25. def get(self):
  26. # get workspace data source integrates
  27. data_source_integrates = (
  28. db.session.query(DataSourceOauthBinding)
  29. .filter(
  30. DataSourceOauthBinding.tenant_id == current_user.current_tenant_id,
  31. DataSourceOauthBinding.disabled == False,
  32. )
  33. .all()
  34. )
  35. base_url = request.url_root.rstrip("/")
  36. data_source_oauth_base_path = "/console/api/oauth/data-source"
  37. providers = ["notion"]
  38. integrate_data = []
  39. for provider in providers:
  40. # existing_integrate = next((ai for ai in data_source_integrates if ai.provider == provider), None)
  41. existing_integrates = filter(lambda item: item.provider == provider, data_source_integrates)
  42. if existing_integrates:
  43. for existing_integrate in list(existing_integrates):
  44. integrate_data.append(
  45. {
  46. "id": existing_integrate.id,
  47. "provider": provider,
  48. "created_at": existing_integrate.created_at,
  49. "is_bound": True,
  50. "disabled": existing_integrate.disabled,
  51. "source_info": existing_integrate.source_info,
  52. "link": f"{base_url}{data_source_oauth_base_path}/{provider}",
  53. }
  54. )
  55. else:
  56. integrate_data.append(
  57. {
  58. "id": None,
  59. "provider": provider,
  60. "created_at": None,
  61. "source_info": None,
  62. "is_bound": False,
  63. "disabled": None,
  64. "link": f"{base_url}{data_source_oauth_base_path}/{provider}",
  65. }
  66. )
  67. return {"data": integrate_data}, 200
  68. @setup_required
  69. @login_required
  70. @account_initialization_required
  71. def patch(self, binding_id, action):
  72. binding_id = str(binding_id)
  73. action = str(action)
  74. data_source_binding = DataSourceOauthBinding.query.filter_by(id=binding_id).first()
  75. if data_source_binding is None:
  76. raise NotFound("Data source binding not found.")
  77. # enable binding
  78. if action == "enable":
  79. if data_source_binding.disabled:
  80. data_source_binding.disabled = False
  81. data_source_binding.updated_at = datetime.datetime.now(datetime.timezone.utc).replace(tzinfo=None)
  82. db.session.add(data_source_binding)
  83. db.session.commit()
  84. else:
  85. raise ValueError("Data source is not disabled.")
  86. # disable binding
  87. if action == "disable":
  88. if not data_source_binding.disabled:
  89. data_source_binding.disabled = True
  90. data_source_binding.updated_at = datetime.datetime.now(datetime.timezone.utc).replace(tzinfo=None)
  91. db.session.add(data_source_binding)
  92. db.session.commit()
  93. else:
  94. raise ValueError("Data source is disabled.")
  95. return {"result": "success"}, 200
  96. class DataSourceNotionListApi(Resource):
  97. @setup_required
  98. @login_required
  99. @account_initialization_required
  100. @marshal_with(integrate_notion_info_list_fields)
  101. def get(self):
  102. dataset_id = request.args.get("dataset_id", default=None, type=str)
  103. exist_page_ids = []
  104. # import notion in the exist dataset
  105. if dataset_id:
  106. dataset = DatasetService.get_dataset(dataset_id)
  107. if not dataset:
  108. raise NotFound("Dataset not found.")
  109. if dataset.data_source_type != "notion_import":
  110. raise ValueError("Dataset is not notion type.")
  111. documents = Document.query.filter_by(
  112. dataset_id=dataset_id,
  113. tenant_id=current_user.current_tenant_id,
  114. data_source_type="notion_import",
  115. enabled=True,
  116. ).all()
  117. if documents:
  118. for document in documents:
  119. data_source_info = json.loads(document.data_source_info)
  120. exist_page_ids.append(data_source_info["notion_page_id"])
  121. # get all authorized pages
  122. data_source_bindings = DataSourceOauthBinding.query.filter_by(
  123. tenant_id=current_user.current_tenant_id, provider="notion", disabled=False
  124. ).all()
  125. if not data_source_bindings:
  126. return {"notion_info": []}, 200
  127. pre_import_info_list = []
  128. for data_source_binding in data_source_bindings:
  129. source_info = data_source_binding.source_info
  130. pages = source_info["pages"]
  131. # Filter out already bound pages
  132. for page in pages:
  133. if page["page_id"] in exist_page_ids:
  134. page["is_bound"] = True
  135. else:
  136. page["is_bound"] = False
  137. pre_import_info = {
  138. "workspace_name": source_info["workspace_name"],
  139. "workspace_icon": source_info["workspace_icon"],
  140. "workspace_id": source_info["workspace_id"],
  141. "pages": pages,
  142. }
  143. pre_import_info_list.append(pre_import_info)
  144. return {"notion_info": pre_import_info_list}, 200
  145. class DataSourceNotionApi(Resource):
  146. @setup_required
  147. @login_required
  148. @account_initialization_required
  149. def get(self, workspace_id, page_id, page_type):
  150. workspace_id = str(workspace_id)
  151. page_id = str(page_id)
  152. data_source_binding = DataSourceOauthBinding.query.filter(
  153. db.and_(
  154. DataSourceOauthBinding.tenant_id == current_user.current_tenant_id,
  155. DataSourceOauthBinding.provider == "notion",
  156. DataSourceOauthBinding.disabled == False,
  157. DataSourceOauthBinding.source_info["workspace_id"] == f'"{workspace_id}"',
  158. )
  159. ).first()
  160. if not data_source_binding:
  161. raise NotFound("Data source binding not found.")
  162. extractor = NotionExtractor(
  163. notion_workspace_id=workspace_id,
  164. notion_obj_id=page_id,
  165. notion_page_type=page_type,
  166. notion_access_token=data_source_binding.access_token,
  167. tenant_id=current_user.current_tenant_id,
  168. )
  169. text_docs = extractor.extract()
  170. return {"content": "\n".join([doc.page_content for doc in text_docs])}, 200
  171. @setup_required
  172. @login_required
  173. @account_initialization_required
  174. def post(self):
  175. parser = reqparse.RequestParser()
  176. parser.add_argument("notion_info_list", type=list, required=True, nullable=True, location="json")
  177. parser.add_argument("process_rule", type=dict, required=True, nullable=True, location="json")
  178. parser.add_argument("doc_form", type=str, default="text_model", required=False, nullable=False, location="json")
  179. parser.add_argument(
  180. "doc_language", type=str, default="English", required=False, nullable=False, location="json"
  181. )
  182. args = parser.parse_args()
  183. # validate args
  184. DocumentService.estimate_args_validate(args)
  185. notion_info_list = args["notion_info_list"]
  186. extract_settings = []
  187. for notion_info in notion_info_list:
  188. workspace_id = notion_info["workspace_id"]
  189. for page in notion_info["pages"]:
  190. extract_setting = ExtractSetting(
  191. datasource_type="notion_import",
  192. notion_info={
  193. "notion_workspace_id": workspace_id,
  194. "notion_obj_id": page["page_id"],
  195. "notion_page_type": page["type"],
  196. "tenant_id": current_user.current_tenant_id,
  197. },
  198. document_model=args["doc_form"],
  199. )
  200. extract_settings.append(extract_setting)
  201. indexing_runner = IndexingRunner()
  202. response = indexing_runner.indexing_estimate(
  203. current_user.current_tenant_id,
  204. extract_settings,
  205. args["process_rule"],
  206. args["doc_form"],
  207. args["doc_language"],
  208. )
  209. return response, 200
  210. class DataSourceNotionDatasetSyncApi(Resource):
  211. @setup_required
  212. @login_required
  213. @account_initialization_required
  214. def get(self, dataset_id):
  215. dataset_id_str = str(dataset_id)
  216. dataset = DatasetService.get_dataset(dataset_id_str)
  217. if dataset is None:
  218. raise NotFound("Dataset not found.")
  219. documents = DocumentService.get_document_by_dataset_id(dataset_id_str)
  220. for document in documents:
  221. document_indexing_sync_task.delay(dataset_id_str, document.id)
  222. return 200
  223. class DataSourceNotionDocumentSyncApi(Resource):
  224. @setup_required
  225. @login_required
  226. @account_initialization_required
  227. def get(self, dataset_id, document_id):
  228. dataset_id_str = str(dataset_id)
  229. document_id_str = str(document_id)
  230. dataset = DatasetService.get_dataset(dataset_id_str)
  231. if dataset is None:
  232. raise NotFound("Dataset not found.")
  233. document = DocumentService.get_document(dataset_id_str, document_id_str)
  234. if document is None:
  235. raise NotFound("Document not found.")
  236. document_indexing_sync_task.delay(dataset_id_str, document_id_str)
  237. return 200
  238. api.add_resource(DataSourceApi, "/data-source/integrates", "/data-source/integrates/<uuid:binding_id>/<string:action>")
  239. api.add_resource(DataSourceNotionListApi, "/notion/pre-import/pages")
  240. api.add_resource(
  241. DataSourceNotionApi,
  242. "/notion/workspaces/<uuid:workspace_id>/pages/<uuid:page_id>/<string:page_type>/preview",
  243. "/datasets/notion-indexing-estimate",
  244. )
  245. api.add_resource(DataSourceNotionDatasetSyncApi, "/datasets/<uuid:dataset_id>/notion/sync")
  246. api.add_resource(
  247. DataSourceNotionDocumentSyncApi, "/datasets/<uuid:dataset_id>/documents/<uuid:document_id>/notion/sync"
  248. )