CubeJS

# http://localhost:4000
docker run -p 4000:4000 -p 15432:15432 \
  -v ${PWD}/cube:/cube/conf \
  -e CUBEJS_DEV_MODE=true \
  cubejs/cube:alpine

CUBEJS_DB_TYPE=postgres
CUBEJS_DB_HOST=192.168.1.2
CUBEJS_DB_PORT=5432
CUBEJS_DB_NAME=demo
CUBEJS_DB_USER=demo
CUBEJS_DB_PASS=
CUBEJS_DB_SSL=false

### Load data
POST http://localhost:4000/cubejs-api/v1/load
Content-Type: application/json

{"query": {"measures":["Users.count"]}}

### SQL
GET http://localhost:4000/cubejs-api/v1/sql?query={"measures":["Users.count"]}

### Meta
GET http://localhost:4000/cubejs-api/v1/meta

### Trigger refresh
GET http://localhost:4000/cubejs-api/v1/run-scheduled-refresh?queryingOptions={"timezone":"UTC"}

### ready
GET http://localhost:4000/readyz

### live
GET http://localhost:4000/livez

{
  "measures": ["Stories.count"],
  "dimensions": ["Stories.category"],
  "filters": [
    {
      // dimension or measure
      "member": "Stories.isDraft",
      // 支持的操作 - 类型也会影响
      // equals, notEquals, contains, notContains
      // gt, gte, lt, lte
      // set, notSet
      // inDateRange, notInDateRange, beforeDate, afterDate
      "operator": "equals",
      // date YYYY-MM-DD
      "values": ["No"]
    },
    // 逻辑
    {
      "or": [{ "and": [] }]
    }
  ],
  "timeDimensions": [
    {
      "dimension": "Stories.time",
      // 支持相对值
      // today, yesterday, tomorrow, last year, next month, last 6 months, last week
      // 支持特殊范围
      // from N days ago to now or from now to N days from now
      "dateRange": ["2015-01-01", "2015-12-31"],
      "granularity": "month",
      // 比较
      "compareDateRange": ["this week", ["2020-05-21", "2020-05-28"]]
    }
  ],
  "limit": 100,
  "offset": 50,
  // order: {"Stories.time": "asc"}
  "order": [
    ["Stories.time", "asc"],
    ["Stories.count", "asc"]
  ],
  "timezone": "Asia/Shanghai"
}

# -d postgres, mysql, athena, mongobi, bigquery, redshift, mssql, clickhouse, snowflake, presto, druid
# -t docker, express, serverless, serverless-aws
npx -y cubejs-cli create demo-cube -d postgres
cd demo-cube
npx cubejs-cli server --debug

cubejs generate -t users,user_profiles
# Geneate JWT
# -e 1 day, 30 days
# -s CUBEJS_API_SECRET
# -u USER_CONTEXT
# CUBEJS_DEV_MODE
# token -e "30 days" -p appId=1 -p userId=2 -u tenantId=12

docker run --rm -it \
  -p 4000:4000 \
  -v $PWD:/cube/conf \
  cubejs/cube:v0.28.59-alpine

cube(`Users`, {
  measures: {
    count: {
      type: `count`,
    },
    // before
    ratio: {
      sql: `sum(${CUBE}.amount) / ${count}`,
      type: `number`,
    },
    // after
    // 因此也可以直接写函数
    ratio: {
      sql: (CUBE, count) => `sum(${CUBE}.amount) / ${count}`,
      type: `number`,
    },
  },
});