linkis icon indicating copy to clipboard operation
linkis copied to clipboard

[Feature ]Linkis metadata information storage supports multiple databases

Open binbinCheng opened this issue 2 years ago • 3 comments

描述:Linkis的元数据信息存储支持多数据库

需求:将mybatis的mapper文件移动到resources/mapper/mysql/)下,在支持其它数据库时,可以新建一个子目录,如:resources/mapper/postgresql/


以jobhistory 为例 linkis-public-enhancements/linkis-jobhistory,当前linkis自身数据,只支持mysql 数据库方式。有些用户可能不是mysql,如果希望同时支持其他数据库如 PostgreSQL,这样用户可以根据自己实际使用情况选择使用

|-- main
|   |-- java
|   |-- resources
|   |   `-- mapper
|   |       `-- common
|   |           |-- JobDetailMapper.xml
|   |           `-- JobHistoryMapper.xml

需要适配
可以考虑 通过不同文件名区分 如

|-- main
|   |-- java
|   |-- resources
|   |   `-- mapper
|   |       `-- common
|   |           |-- JobDetailMapper.xml
|   |           `-- JobHistoryMapper.xml


|-- main
|   |-- java
|   |-- resources
|   |   |-- mysql
|   |   |   `-- mapper
|   |   |       `-- common
|   |   |           |-- JobDetailMapper.xml
|   |   |           `-- JobHistoryMapper.xml
|   |   `-- postgresql
|   |       `-- mapper
|   |           `-- common
|   |               |-- JobDetailMapper.xml
|   |               `-- JobHistoryMapper.xml


Description: Linkis metadata information storage supports multiple databases

Requirement description: Move the mapper file of mybatis to resources/mapper/mysql/), and create a new subdirectory when supporting other databases, such as: resources/mapper/postgresql/

binbinCheng avatar Feb 10 '23 08:02 binbinCheng

:blush: Welcome to the Apache Linkis community!!

We are glad that you are contributing by opening this issue.

Please make sure to include all the relevant context. We will be here shortly.

If you are interested in contributing to our website project, please let us know! You can check out our contributing guide on :point_right: How to Participate in Project Contribution.

Community

WeChat Assistant WeChat Public Account

Mailing Lists

Name Description Subscribe Unsubscribe Archive
[email protected] community activity information subscribe unsubscribe archive

github-actions[bot] avatar Feb 10 '23 08:02 github-actions[bot]

accept issue

rottenmu avatar Mar 15 '23 13:03 rottenmu

We adapted postgresql, #4524

sjgllgh avatar May 10 '23 02:05 sjgllgh