data_source.py 9.6 KB

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