public static String formatNumber(double number) { return formatNumber(number, ""); }
@Test public void testFormatNumberNoDigit() { assertEquals("0.0", PlanJSONDumpGenerator.formatNumber(0)); assertEquals("0.00", PlanJSONDumpGenerator.formatNumber(0.0000000001)); assertEquals("-1.0", PlanJSONDumpGenerator.formatNumber(-1.0)); assertEquals("1.00", PlanJSONDumpGenerator.formatNumber(1)); assertEquals("17.00", PlanJSONDumpGenerator.formatNumber(17)); assertEquals("17.44", PlanJSONDumpGenerator.formatNumber(17.44)); assertEquals("143.00", PlanJSONDumpGenerator.formatNumber(143)); assertEquals("143.40", PlanJSONDumpGenerator.formatNumber(143.4)); assertEquals("143.50", PlanJSONDumpGenerator.formatNumber(143.5)); assertEquals("143.60", PlanJSONDumpGenerator.formatNumber(143.6)); assertEquals("143.45", PlanJSONDumpGenerator.formatNumber(143.45)); assertEquals("143.55", PlanJSONDumpGenerator.formatNumber(143.55)); assertEquals("143.65", PlanJSONDumpGenerator.formatNumber(143.65)); assertEquals("143.66", PlanJSONDumpGenerator.formatNumber(143.655)); assertEquals("1.13 K", PlanJSONDumpGenerator.formatNumber(1126.0)); assertEquals("11.13 K", PlanJSONDumpGenerator.formatNumber(11126.0)); assertEquals("118.13 K", PlanJSONDumpGenerator.formatNumber(118126.0)); assertEquals("1.44 M", PlanJSONDumpGenerator.formatNumber(1435126.0)); }
: formatNumber(n.getEstimatedOutputSize(), "B"), true); addProperty(writer, "Est. Cardinality", n.getEstimatedNumRecords() == -1 ? "(unknown)" : formatNumber(n.getEstimatedNumRecords()), false); : formatNumber(p.getNodeCosts().getNetworkCost(), "B"), true); addProperty(writer, "Disk I/O", p.getNodeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(p.getNodeCosts().getDiskCost(), "B"), false); addProperty(writer, "CPU", p.getNodeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(p.getNodeCosts().getCpuCost(), ""), false); p.getCumulativeCosts().getNetworkCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getNetworkCost(), "B"), false); addProperty(writer, "Cumulative Disk I/O", p.getCumulativeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getDiskCost(), "B"), false); addProperty(writer, "Cumulative CPU", p.getCumulativeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getCpuCost(), ""), false);
: formatNumber(optNode.getEstimatedOutputSize(), "B")); : formatNumber(optNode.getEstimatedNumRecords())); gen.writeEndArray(); "(unknown)" : formatNumber(node.getNodeCosts().getNetworkCost(), "B")); addProperty(gen, "Disk I/O", node.getNodeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(node.getNodeCosts().getDiskCost(), "B")); addProperty(gen, "CPU", node.getNodeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(node.getNodeCosts().getCpuCost(), "")); "(unknown)" : formatNumber(node.getCumulativeCosts().getNetworkCost(), "B")); addProperty(gen, "Cumulative Disk I/O", node.getCumulativeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(node.getCumulativeCosts().getDiskCost(), "B")); addProperty(gen, "Cumulative CPU", node.getCumulativeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(node.getCumulativeCosts().getCpuCost(), ""));
public static String formatNumber(double number) { return formatNumber(number, ""); }
public static String formatNumber(double number) { return formatNumber(number, ""); }
public static String formatNumber(double number) { return formatNumber(number, ""); }
public static String formatNumber(double number) { return formatNumber(number, ""); }
: formatNumber(optNode.getEstimatedOutputSize(), "B")); : formatNumber(optNode.getEstimatedNumRecords())); gen.writeEndArray(); "(unknown)" : formatNumber(node.getNodeCosts().getNetworkCost(), "B")); addProperty(gen, "Disk I/O", node.getNodeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(node.getNodeCosts().getDiskCost(), "B")); addProperty(gen, "CPU", node.getNodeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(node.getNodeCosts().getCpuCost(), "")); "(unknown)" : formatNumber(node.getCumulativeCosts().getNetworkCost(), "B")); addProperty(gen, "Cumulative Disk I/O", node.getCumulativeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(node.getCumulativeCosts().getDiskCost(), "B")); addProperty(gen, "Cumulative CPU", node.getCumulativeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(node.getCumulativeCosts().getCpuCost(), ""));
: formatNumber(n.getEstimatedOutputSize(), "B"), true); addProperty(writer, "Est. Cardinality", n.getEstimatedNumRecords() == -1 ? "(unknown)" : formatNumber(n.getEstimatedNumRecords()), false); : formatNumber(p.getNodeCosts().getNetworkCost(), "B"), true); addProperty(writer, "Disk I/O", p.getNodeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(p.getNodeCosts().getDiskCost(), "B"), false); addProperty(writer, "CPU", p.getNodeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(p.getNodeCosts().getCpuCost(), ""), false); p.getCumulativeCosts().getNetworkCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getNetworkCost(), "B"), false); addProperty(writer, "Cumulative Disk I/O", p.getCumulativeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getDiskCost(), "B"), false); addProperty(writer, "Cumulative CPU", p.getCumulativeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getCpuCost(), ""), false);
: formatNumber(n.getEstimatedOutputSize(), "B"), true); addProperty(writer, "Est. Cardinality", n.getEstimatedNumRecords() == -1 ? "(unknown)" : formatNumber(n.getEstimatedNumRecords()), false); : formatNumber(p.getNodeCosts().getNetworkCost(), "B"), true); addProperty(writer, "Disk I/O", p.getNodeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(p.getNodeCosts().getDiskCost(), "B"), false); addProperty(writer, "CPU", p.getNodeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(p.getNodeCosts().getCpuCost(), ""), false); p.getCumulativeCosts().getNetworkCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getNetworkCost(), "B"), false); addProperty(writer, "Cumulative Disk I/O", p.getCumulativeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getDiskCost(), "B"), false); addProperty(writer, "Cumulative CPU", p.getCumulativeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getCpuCost(), ""), false);
: formatNumber(n.getEstimatedOutputSize(), "B"), true); addProperty(writer, "Est. Cardinality", n.getEstimatedNumRecords() == -1 ? "(unknown)" : formatNumber(n.getEstimatedNumRecords()), false); : formatNumber(p.getNodeCosts().getNetworkCost(), "B"), true); addProperty(writer, "Disk I/O", p.getNodeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(p.getNodeCosts().getDiskCost(), "B"), false); addProperty(writer, "CPU", p.getNodeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(p.getNodeCosts().getCpuCost(), ""), false); p.getCumulativeCosts().getNetworkCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getNetworkCost(), "B"), false); addProperty(writer, "Cumulative Disk I/O", p.getCumulativeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getDiskCost(), "B"), false); addProperty(writer, "Cumulative CPU", p.getCumulativeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getCpuCost(), ""), false);
: formatNumber(n.getEstimatedOutputSize(), "B"), true); addProperty(writer, "Est. Cardinality", n.getEstimatedNumRecords() == -1 ? "(unknown)" : formatNumber(n.getEstimatedNumRecords()), false); : formatNumber(p.getNodeCosts().getNetworkCost(), "B"), true); addProperty(writer, "Disk I/O", p.getNodeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(p.getNodeCosts().getDiskCost(), "B"), false); addProperty(writer, "CPU", p.getNodeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(p.getNodeCosts().getCpuCost(), ""), false); p.getCumulativeCosts().getNetworkCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getNetworkCost(), "B"), false); addProperty(writer, "Cumulative Disk I/O", p.getCumulativeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getDiskCost(), "B"), false); addProperty(writer, "Cumulative CPU", p.getCumulativeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(p .getCumulativeCosts().getCpuCost(), ""), false);
: formatNumber(optNode.getEstimatedOutputSize(), "B")); : formatNumber(optNode.getEstimatedNumRecords())); gen.writeEndArray(); "(unknown)" : formatNumber(node.getNodeCosts().getNetworkCost(), "B")); addProperty(gen, "Disk I/O", node.getNodeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(node.getNodeCosts().getDiskCost(), "B")); addProperty(gen, "CPU", node.getNodeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(node.getNodeCosts().getCpuCost(), "")); "(unknown)" : formatNumber(node.getCumulativeCosts().getNetworkCost(), "B")); addProperty(gen, "Cumulative Disk I/O", node.getCumulativeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(node.getCumulativeCosts().getDiskCost(), "B")); addProperty(gen, "Cumulative CPU", node.getCumulativeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(node.getCumulativeCosts().getCpuCost(), ""));
: formatNumber(optNode.getEstimatedOutputSize(), "B")); : formatNumber(optNode.getEstimatedNumRecords())); gen.writeEndArray(); "(unknown)" : formatNumber(node.getNodeCosts().getNetworkCost(), "B")); addProperty(gen, "Disk I/O", node.getNodeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(node.getNodeCosts().getDiskCost(), "B")); addProperty(gen, "CPU", node.getNodeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(node.getNodeCosts().getCpuCost(), "")); "(unknown)" : formatNumber(node.getCumulativeCosts().getNetworkCost(), "B")); addProperty(gen, "Cumulative Disk I/O", node.getCumulativeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(node.getCumulativeCosts().getDiskCost(), "B")); addProperty(gen, "Cumulative CPU", node.getCumulativeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(node.getCumulativeCosts().getCpuCost(), ""));
: formatNumber(optNode.getEstimatedOutputSize(), "B")); : formatNumber(optNode.getEstimatedNumRecords())); gen.writeEndArray(); "(unknown)" : formatNumber(node.getNodeCosts().getNetworkCost(), "B")); addProperty(gen, "Disk I/O", node.getNodeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(node.getNodeCosts().getDiskCost(), "B")); addProperty(gen, "CPU", node.getNodeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(node.getNodeCosts().getCpuCost(), "")); "(unknown)" : formatNumber(node.getCumulativeCosts().getNetworkCost(), "B")); addProperty(gen, "Cumulative Disk I/O", node.getCumulativeCosts().getDiskCost() == -1 ? "(unknown)" : formatNumber(node.getCumulativeCosts().getDiskCost(), "B")); addProperty(gen, "Cumulative CPU", node.getCumulativeCosts().getCpuCost() == -1 ? "(unknown)" : formatNumber(node.getCumulativeCosts().getCpuCost(), ""));