diff options
| author | Jake Feasel <jfeasel@gmail.com> | 2012-09-10 20:42:38 -0700 |
|---|---|---|
| committer | Jake Feasel <jfeasel@gmail.com> | 2012-09-10 20:42:38 -0700 |
| commit | 4509373f3b392623a4eceaff6ed6afffb51a32f5 (patch) | |
| tree | 0ac9f11eb061393f7f97c9c939a4e38be3eb9e27 /javascripts/libs/xplans/mssql.js | |
| parent | b5ede40d9e877fbf30f46312f0f008f4ee8bad46 (diff) | |
| download | sqlfiddle-4509373f3b392623a4eceaff6ed6afffb51a32f5.zip sqlfiddle-4509373f3b392623a4eceaff6ed6afffb51a32f5.tar.gz sqlfiddle-4509373f3b392623a4eceaff6ed6afffb51a32f5.tar.bz2 | |
Initial moves
Diffstat (limited to 'javascripts/libs/xplans/mssql.js')
| -rw-r--r-- | javascripts/libs/xplans/mssql.js | 80 |
1 files changed, 80 insertions, 0 deletions
diff --git a/javascripts/libs/xplans/mssql.js b/javascripts/libs/xplans/mssql.js new file mode 100644 index 0000000..e561424 --- /dev/null +++ b/javascripts/libs/xplans/mssql.js @@ -0,0 +1,80 @@ +if (typeof (QP) == "undefined" || !QP) {
+ var QP = {}
+};
+
+(function() {
+ /* Draws the lines linking nodes in query plan diagram.
+ root - The document element in which the diagram is contained. */
+ QP.drawLines = function(root) {
+ if (root === null || root === undefined) {
+ // Try and find it ourselves
+ root = $(".qp-root").parent();
+ } else {
+ // Make sure the object passed is jQuery wrapped
+ root = $(root);
+ }
+ internalDrawLines(root);
+ };
+
+ /* Internal implementaiton of drawLines. */
+ function internalDrawLines(root) {
+ var canvas = getCanvas(root);
+ var canvasElm = canvas[0];
+
+ // Check for browser compatability
+ if (canvasElm.getContext !== null && canvasElm.getContext !== undefined) {
+ // Chrome is usually too quick with document.ready
+ window.setTimeout(function() {
+ var context = canvasElm.getContext("2d");
+
+ // The first root node may be smaller than the full query plan if using overflow
+ var firstNode = $(".qp-tr", root);
+ canvasElm.width = firstNode.outerWidth(true);
+ canvasElm.height = firstNode.outerHeight(true);
+ var offset = canvas.offset();
+
+ $(".qp-tr", root).each(function() {
+ var from = $("> * > .qp-node", $(this));
+ $("> * > .qp-tr > * > .qp-node", $(this)).each(function() {
+ drawLine(context, offset, from, $(this));
+ });
+ });
+ context.stroke();
+ }, 1);
+ }
+ }
+
+ /* Locates or creates the canvas element to use to draw lines for a given root element. */
+ function getCanvas(root) {
+ var returnValue = $("canvas", root);
+ if (returnValue.length == 0) {
+ root.prepend($("<canvas></canvas>")
+ .css("position", "absolute")
+ .css("top", 0).css("left", 0)
+ );
+ returnValue = $("canvas", root);
+ }
+ return returnValue;
+ }
+
+ /* Draws a line between two nodes.
+ context - The canvas context with which to draw.
+ offset - Canvas offset in the document.
+ from - The document jQuery object from which to draw the line.
+ to - The document jQuery object to which to draw the line. */
+ function drawLine(context, offset, from, to) {
+ var fromOffset = from.offset();
+ fromOffset.top += from.outerHeight() / 2;
+ fromOffset.left += from.outerWidth();
+
+ var toOffset = to.offset();
+ toOffset.top += to.outerHeight() / 2;
+
+ var midOffsetLeft = fromOffset.left / 2 + toOffset.left / 2;
+
+ context.moveTo(fromOffset.left - offset.left, fromOffset.top - offset.top);
+ context.lineTo(midOffsetLeft - offset.left, fromOffset.top - offset.top);
+ context.lineTo(midOffsetLeft - offset.left, toOffset.top - offset.top);
+ context.lineTo(toOffset.left - offset.left, toOffset.top - offset.top);
+ }
+})();
\ No newline at end of file |