data_source.py 12 KB

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