Function factorCaseExpr

packages/infra/src/Store/SQL/query.ts:416–420

(unitExpr: string, toBase: string, factors: Readonly<Record<string, number>>)

      }
    }
    const factorCaseExpr = (unitExpr: string, toBase: string, factors: Readonly<Record<string, number>>) => {
      const entries = Object.entries(factors).filter(([, factor]) => Number.isFinite(factor))
      const cases = entries.map(([unit, factor]) => ` WHEN ${sqlStringLiteral(unit)} THEN ${factor}`).join("")
      return `CASE ${unitExpr} WHEN ${sqlStringLiteral(toBase)} THEN 1${cases} ELSE NULL END`
    }
    const filter = "filter" in computed ? computed.filter : []
    const whereClause = () =>
      filter.length > 0