The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:
TypeScript analyticsbibusiness-intelligencebusinessintelligenceclojuredashboarddatadata-analysisdata-visualizationdatabasemetabasemysqlpostgrespostgresqlreportingslacksql-editorvisualization
import * as ML from "cljs/metabase.lib.js";
import type {
AggregationClause,
ColumnMetadata,
ExpressionArg,
ExpressionClause,
ExpressionOperator,
ExpressionOptions,
ExpressionParts,
FilterClause,
JoinCondition,
Query,
} from "./types";
type ErrorWithMessage = {
message: string;
friendly?: boolean;
};
export function expression(
query: Query,
stageIndex: number,
expressionName: string,
clause: ExpressionClause,
): Query {
return ML.expression(query, stageIndex, expressionName, clause);
}
export function withExpressionName<
Clause extends AggregationClause | ExpressionClause,
>(clause: Clause, newName: string): Clause {
return ML.with_expression_name(clause, newName);
}
export function expressions(
query: Query,
stageIndex: number,
): ExpressionClause[] {
return ML.expressions(query, stageIndex);
}
export function expressionableColumns(
query: Query,
stageIndex?: number,
expressionIndex?: number,
): ColumnMetadata[] {
return ML.expressionable_columns(query, stageIndex, expressionIndex);
}
export function expressionParts(
query: Query,
stageIndex: number,
clause: AggregationClause | ExpressionClause | FilterClause | JoinCondition,
): ExpressionParts {
return ML.expression_parts(query, stageIndex, clause);
}
export function expressionClause(
parts: ExpressionParts | ExpressionArg,
): ExpressionClause;
export function expressionClause(
operator: ExpressionOperator,
args: (
| ExpressionParts
| ExpressionArg
| AggregationClause
| ExpressionClause
| FilterClause
)[],
options?: ExpressionOptions | null,
): ExpressionClause;
export function expressionClause(
operatorOrParts: ExpressionOperator | ExpressionParts | ExpressionArg,
args?: (
| ExpressionParts
| ExpressionArg
| AggregationClause
| ExpressionClause
| FilterClause
)[],
options?: ExpressionOptions | null,
): ExpressionClause {
if (args === undefined && options === undefined) {
return ML.expression_clause(operatorOrParts);
}
return ML.expression_clause(operatorOrParts, args, options ?? null);
}
export type ExpressionMode = "expression" | "aggregation" | "filter";
export function diagnoseExpression(
query: Query,
stageIndex: number,
expressionMode: ExpressionMode,
expression: ExpressionClause,
expressionIndex?: number,
): ErrorWithMessage | null {
return ML.diagnose_expression(
query,
stageIndex,
expressionMode,
expression,
expressionIndex,
);
}