DB-GBP功能使用探索

技术分享 2周前 (12-17) 0 999+

关注

1.DB-GPT支持的功能

2.配置StarRocks数据库

支持多种数据库链接
但是只支持一个库访问查询

3. ChatBI

数据准确性不够精准，如果用于生产需要做相关优化
查询可能会做大SQL查询，拖死web进程,无法响应

4. APP创建使用

dbgpt app install awel-flow-web-info-search dbgpt app install awel-flow-example-chat dbgpt app install awel-flow-simple-streaming-chat

安装可能因为网络问题报错，多执行几次就好了

5. 元数据库配置

 LOCAL_DB_TYPE=mysql  LOCAL_DB_USER=  LOCAL_DB_PASSWORD=  LOCAL_DB_HOST=127.0.0.1  LOCAL_DB_PORT=3306  LOCAL_DB_NAME=dbgpt

6. API 调用探索

6.1 app

app chat api 模型替换

sk-xxx https://dashscope.aliyuncs.com/compatible-mode/v1 llm model: qwen-long

6.2 datasources

1.list datasources api error

During handling of the above exception, another exception occurred:  Traceback (most recent call last):   File "D:softwarePyCharm 2023.3.5pluginspythonhelpers-propydevd_asynciopydevd_nest_asyncio.py", line 120, in run     return loop.run_until_complete(task)   File "D:softwarePyCharm 2023.3.5pluginspythonhelpers-propydevd_asynciopydevd_nest_asyncio.py", line 211, in run_until_complete     return f.result()   File "C:UsersjackAppDataLocalProgramsPythonPython310libasynciofutures.py", line 201, in result     raise self._exception.with_traceback(self._exception_tb)   File "C:UsersjackAppDataLocalProgramsPythonPython310libasynciotasks.py", line 232, in __step     result = coro.send(None)   File "C:UsersjackPycharmProjectsdbgpt-testapidatasource.py", line 12, in list_ds     res = await list_datasource(client=client)   File "C:UsersjackPycharmProjectsdbgpt-test.venvlibsite-packagesdbgptclientdatasource.py", line 120, in list_datasource     raise ClientException(f"Failed to list datasource: {e}") dbgpt.client.client.ClientException: (Failed to list datasource: (E0003) Reason: {'success': False, 'err_code': 'E0003', 'err_msg': "1 validation errors:n  {'type': 'model_attributes_type', 'loc': ('response', 'data'), 'msg': 'Input should be a valid dictionary or object to extract fields from', 'input': [DatasourceServeResponse(id=1, db_type='mysql', db_name='dbgpt_test', db_path='', db_host='', db_port=3306, db_user='', db_pwd='', comment='')]}n", 'data': None} ) Reason: None

6.3 Knowledge

通过调用create_space接口失败但是创建了多个空间

调用delete_space 删除不了空间

Traceback (most recent call last):   File "C:UsersjackPycharmProjectsdbgpt-testapiknowledge.py", line 39, in <module>     asyncio.run(delete())   File "C:UsersjackAppDataLocalProgramsPythonPython310libasynciorunners.py", line 44, in run     return loop.run_until_complete(main)   File "C:UsersjackAppDataLocalProgramsPythonPython310libasynciobase_events.py", line 649, in run_until_complete     return future.result()   File "C:UsersjackPycharmProjectsdbgpt-testapiknowledge.py", line 24, in delete     res = await delete_space(client=client, space_id='2')   File "C:UsersjackPycharmProjectsdbgpt-test.venvlibsite-packagesdbgptclientknowledge.py", line 75, in delete_space     raise ClientException(f"Failed to delete space: {e}") dbgpt.client.client.ClientException: (Failed to delete space: (E0003) Reason: {'success': False, 'err_code': 'E0003', 'err_msg': "1 validation errors:n  {'type': 'none_required', 'loc': ('response', 'data'), 'msg': 'Input should be None', 'input': SpaceServeResponse(id=2, name='test_space', vector_type='Chroma', desc='for client space', context=None, owner='dbgpt', sys_code=None, domain_type=None)}n", 'data': None} ) Reason: None

space delete error invalid space name:test_space_abc