1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
|
define ([
"jQuery",
"Underscore",
"Backbone",
"Handlebars",
"FiddleEditor",
"libs/renderTerminator",
'XPlans/oracle/loadswf',
'XPlans/mssql',
"text!fiddle_backbone/templates/queryTabularOutput.html",
"text!fiddle_backbone/templates/queryPlaintextOutput.html",
"text!fiddle_backbone/templates/queryMarkdownOutput.html",
'HandlebarsHelpers/divider_display',
'HandlebarsHelpers/each_simple_value_with_index',
'HandlebarsHelpers/each_with_index',
'HandlebarsHelpers/result_display_padded',
'HandlebarsHelpers/result_display',
'HandlebarsHelpers/code_format',
'HandlebarsHelpers/add'
],
function ($,_,Backbone,Handlebars,fiddleEditor,renderTerminator,loadswf,QP,tabTemplate,plainTemplate,mdTemplate) {
var QueryView = Backbone.View.extend({
initialize: function () {
this.editor = new fiddleEditor(this.id,this.handleQueryChange, this,
_.bind(function () {
this.model.execute();
}, this));
this.outputType = "tabular";
this.compiledOutputTemplate = {};
this.compiledOutputTemplate["tabular"] = Handlebars.compile(tabTemplate);
this.compiledOutputTemplate["plaintext"] = Handlebars.compile(plainTemplate);
this.compiledOutputTemplate["markdown"] = Handlebars.compile(mdTemplate);
},
setOutputType: function (type) {
this.outputType = type;
},
handleQueryChange: function (e) {
var schemaDef = this.model.get("schemaDef");
this.model.set({
"sql":this.editor.getValue()
});
$(".sql .helpTip").css("display", (!schemaDef.get("ready") || schemaDef.get("loading") || this.model.get("sql").length) ? "none" : "block");
},
render: function () {
this.editor.setValue(this.model.get("sql"));
if (this.model.id)
this.renderOutput();
renderTerminator($(".panel.sql"), this.model.get("statement_separator"));
},
renderOutput: function() {
var thisModel = this.model;
var inspectedData = this.model.toJSON();
/* This loop determines the max width of each column, so it can be padded appropriately (if needed) */
_.each(inspectedData.sets, function (set, sidx) {
if (set.RESULTS)
{
// Initialize the column widths with the length of the headers
var columnWidths = _.map(set.RESULTS.COLUMNS, function (col) {
return col.length;
});
// then increase the width as needed if a bigger value is found in the data
_.each(set.RESULTS.DATA, function (row) {
columnWidths = _.map(row, function (col,cidx) {
return _.max([col.toString().length,columnWidths[cidx]]) ;
});
});
inspectedData.sets[sidx].RESULTS.COLUMNWIDTHS = columnWidths;
}
});
inspectedData["schemaDef"] = this.model.get("schemaDef").toJSON();
inspectedData["schemaDef"]["dbType"] = this.model.get("schemaDef").get("dbType").toJSON();
inspectedData["schemaDef"]["dbType"]["isSQLServer"] = this.model.get("schemaDef").get("dbType").get("simple_name") == "SQL Server";
inspectedData["schemaDef"]["dbType"]["isPostgreSQL"] = this.model.get("schemaDef").get("dbType").get("simple_name") == "PostgreSQL";
this.options.output_el.html(
this.compiledOutputTemplate[this.outputType](inspectedData)
);
$("script.oracle_xplan_xml").each(function () {
$(this).siblings("div.oracle_xplan")
.html(
loadswf($(this).text())
);
});
this.options.output_el.find("a.executionPlanLink").click(function (e) {
e.preventDefault();
$("i", this).toggleClass("icon-minus icon-plus");
$(this).closest(".set").find(".executionPlan").toggle();
if ($("i", this).hasClass("icon-minus") &&
thisModel.get("schemaDef").get("dbType").get("simple_name") == 'SQL Server'
)
{
QP.drawLines($(this).closest(".set").find(".executionPlan div"));
}
});
},
refresh: function () {
this.editor.refresh();
},
checkForSelectedText: function () {
if (this.editor.somethingSelected())
this.model.set("sql", this.editor.getSelection());
else
this.model.set("sql", this.editor.getValue());
}
});
return QueryView;
});
|
