cube.js 支持oceanbase 的mysql driver

因为官方mysql driver的bug，暂时issue 还没合并，所以临时开发了一个修复bug 的driver 可以直接参考使用

参考使用

  • 环境准备
version: "3"
services:
    ocenbase:
      image: oceanbase/obce-mini
      ports:
      - "2881:2881"
  • 代码集成
    .env
 
CUBEJS_DB_HOST=localhost
CUBEJS_DB_PORT=2881
CUBEJS_DB_NAME=test
CUBEJS_DB_USER=sqluser01
CUBEJS_DB_PASS=123456
CUBEJS_WEB_SOCKETS=true
CUBEJS_DEV_MODE=true
CUBEJS_DB_TYPE=mysql
CUBEJS_API_SECRET=e727de30526a5029f87a5979e88ca5a211657ccc8f67877c366f170d80b1d81fc21671e3c0dc27813522316a17572aaff371db06769eda6077f35fc36aa4afe9

package.json

{
  "name": "cubejs",
  "version": "1.0.0",
  "main": "app.js",
  "license": "MIT",
  "bin": "app.js",
  "scripts": {
    "dev": "cubejs-server"
  },
  "devDependencies": {
    "@cubejs-backend/server": "^0.28.57"
  },
  "dependencies": {
    "@dalongrong/mymysql-cubejs-driver": "^1.0.0"
  }
}

cube.js

const {MySqlDriver,MySqlQuery} = require("@dalongrong/mymysql-cubejs-driver")
module.exports = {
    dialectFactory: (dataSource) => {
        // need config  datasource  for multitenant env
        return MySqlQuery
    },
    dbType: ({ dataSource } = {}) => {
        return "mymysql"
    },
    driverFactory: ({ dataSource } = {}) => {
        return new MySqlDriver({})
    }
};
  • 效果

 

 

说明

已经push npm 私服了，可以直接使用，对于需要想体验cube.js 集成oceanbase的可以直接使用

参考资料

https://github.com/rongfengliang/cubejs-mymysql-driver
https://www.npmjs.com/package/@dalongrong/mymysql-cubejs-driver

posted on 2021-11-18 00:34  荣锋亮  阅读(94)  评论(0)  编辑  收藏  举报

导航