Sails CubeJS Glue
this package is intended to make a glue for cubejs and sails framework.
With this method, you can still use sails's functionalities like policy as it is.
Installation
to install is just straight forward:
- with npm:
npm i sails-cubejs-glue - with yarn:
yarn add sails-cubejs-glue
Example Action
this is lazy method, that do everything one the action. (bootstrap and proxying).
Althought its better idea to use sails's hook for bootstrapping and action only proxying, this example is enough:
ON api/controllers/cube.js:
/* api/controllers/cube.js */ var glue = ; var cubeApp = null;const schemas = fileName: 'Orders.js' content: ` cube('Orders', { sql: 'SELECT * FROM orders', measures: { countAll: { type: 'count' }, } }); ` moduleexports = async { if cubeApp === null cubeApp = await glue; gluereq res;} ON config/routes.js add the graphql route:
moduleexportsroutes = ... '/cube/*': action: 'cube' ; Connecting to Database
As cubejs's documentation: https://cube.dev/docs/connecting-to-the-database.
Example in environment variables:
CUBEJS_DB_TYPE=mongobi
CUBEJS_API_SECRET=123123
CUBEJS_DB_HOST=localhost
CUBEJS_DB_PORT=3307
CUBEJS_DB_USER=
CUBEJS_DB_PASS=
CUBEJS_DB_NAME=app
Drivers Dependencies
quoted from @cubejs-backend/server-core/core/index.js
const DriverDependencies = postgres: '@cubejs-backend/postgres-driver' mysql: '@cubejs-backend/mysql-driver' mssql: '@cubejs-backend/mssql-driver' athena: '@cubejs-backend/athena-driver' jdbc: '@cubejs-backend/jdbc-driver' mongobi: '@cubejs-backend/mongobi-driver' bigquery: '@cubejs-backend/bigquery-driver' redshift: '@cubejs-backend/postgres-driver' clickhouse: '@cubejs-backend/clickhouse-driver' hive: '@cubejs-backend/hive-driver' snowflake: '@cubejs-backend/snowflake-driver' prestodb: '@cubejs-backend/prestodb-driver' oracle: '@cubejs-backend/oracle-driver';License
MIT