I love to build dataviz for insight discovery. I also love to put technology to the service of humanity
Public
Edited
Apr 17
1 fork
18 stars
ast = parser.parse(query)
pt = astToTree(ast.value)
// Very crude function that tries to create a d3 tree
function astToTree(pq) {
const pt = {};
pt.name = "";
pt.name += typeof pq.distinctOpt === "string" ? pq.distinctOpt + " : " : "";
pt.name += pq.type || "";
pt.name +=
typeof pq.value === "string" || typeof pq.value === "number"
? ": " + pq.value
: "";
pt.name += typeof pq === "string" || typeof pq === "number" ? pq : "";
pt.children = [];
[
"from",
"where",
"groupBy",
"orderBy",
"limit",
"partition",
"left",
"right"
].map((a) => {
pq[a] && pt.children.push(astToTree(pq[a]));
});
if (Array.isArray(pq.value)) {
pq.value.map((v) => pt.children.push(astToTree(v)));
} else if (pq.value && !(typeof pq.value === "string")) {
// pq.value is an object
pq.value && pt.children.push(astToTree(pq.value));
}
return pt;
}
import { Tree } from "@d3/tree"
import { Tree as RadialTree } from "@d3/radial-tree"
import { Icicle } from "@d3/icicle"
import {chart} with {pt as data} from "@d3/force-directed-tree"
// import {Editor} from '@cmudig/editor'
import {Editor} from "11c798ee666ebb7e" // set disabled
// import { Editor } from "11c798ee666ebb7e"
parser = require("js-sql-parser")
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
