OLD | NEW |
| (Empty) |
1 /* | |
2 * Copyright (C) 2008 Apple Inc. All Rights Reserved. | |
3 * | |
4 * Redistribution and use in source and binary forms, with or without | |
5 * modification, are permitted provided that the following conditions | |
6 * are met: | |
7 * 1. Redistributions of source code must retain the above copyright | |
8 * notice, this list of conditions and the following disclaimer. | |
9 * 2. Redistributions in binary form must reproduce the above copyright | |
10 * notice, this list of conditions and the following disclaimer in the | |
11 * documentation and/or other materials provided with the distribution. | |
12 * | |
13 * THIS SOFTWARE IS PROVIDED BY APPLE INC. ``AS IS'' AND ANY | |
14 * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE | |
15 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR | |
16 * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL APPLE INC. OR | |
17 * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, | |
18 * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, | |
19 * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR | |
20 * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY | |
21 * OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT | |
22 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE | |
23 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | |
24 */ | |
25 | |
26 WebInspector.DatabaseQueryView = function(database) | |
27 { | |
28 WebInspector.View.call(this); | |
29 | |
30 this.database = database; | |
31 | |
32 this.element.addStyleClass("storage-view"); | |
33 this.element.addStyleClass("query"); | |
34 this.element.tabIndex = 0; | |
35 | |
36 this.element.addEventListener("selectstart", this._selectStart.bind(this), f
alse); | |
37 | |
38 this.promptElement = document.createElement("div"); | |
39 this.promptElement.className = "database-query-prompt"; | |
40 this.promptElement.appendChild(document.createElement("br")); | |
41 this.promptElement.handleKeyEvent = this._promptKeyDown.bind(this); | |
42 this.element.appendChild(this.promptElement); | |
43 | |
44 this.prompt = new WebInspector.TextPrompt(this.promptElement, this.completio
ns.bind(this), " "); | |
45 } | |
46 | |
47 WebInspector.DatabaseQueryView.prototype = { | |
48 show: function(parentElement) | |
49 { | |
50 WebInspector.View.prototype.show.call(this, parentElement); | |
51 | |
52 function moveBackIfOutside() | |
53 { | |
54 if (!this.prompt.isCaretInsidePrompt() && window.getSelection().isCo
llapsed) | |
55 this.prompt.moveCaretToEndOfPrompt(); | |
56 } | |
57 | |
58 setTimeout(moveBackIfOutside.bind(this), 0); | |
59 }, | |
60 | |
61 completions: function(wordRange, bestMatchOnly, completionsReadyCallback) | |
62 { | |
63 var prefix = wordRange.toString().toLowerCase(); | |
64 if (!prefix.length) | |
65 return; | |
66 | |
67 var results = []; | |
68 | |
69 function accumulateMatches(textArray) | |
70 { | |
71 if (bestMatchOnly && results.length) | |
72 return; | |
73 for (var i = 0; i < textArray.length; ++i) { | |
74 var text = textArray[i].toLowerCase(); | |
75 if (text.length < prefix.length) | |
76 continue; | |
77 if (text.indexOf(prefix) !== 0) | |
78 continue; | |
79 results.push(textArray[i]); | |
80 if (bestMatchOnly) | |
81 return; | |
82 } | |
83 } | |
84 | |
85 function tableNamesCallback(tableNames) | |
86 { | |
87 accumulateMatches(tableNames.map(function(name) { return name + " "
})); | |
88 accumulateMatches(["SELECT ", "FROM ", "WHERE ", "LIMIT ", "DELETE F
ROM ", "CREATE ", "DROP ", "TABLE ", "INDEX ", "UPDATE ", "INSERT INTO ", "VALUE
S ("]); | |
89 | |
90 completionsReadyCallback(results); | |
91 } | |
92 this.database.getTableNames(tableNamesCallback); | |
93 }, | |
94 | |
95 _promptKeyDown: function(event) | |
96 { | |
97 switch (event.keyIdentifier) { | |
98 case "Enter": | |
99 this._enterKeyPressed(event); | |
100 return; | |
101 } | |
102 | |
103 this.prompt.handleKeyEvent(event); | |
104 }, | |
105 | |
106 _selectStart: function(event) | |
107 { | |
108 if (this._selectionTimeout) | |
109 clearTimeout(this._selectionTimeout); | |
110 | |
111 this.prompt.clearAutoComplete(); | |
112 | |
113 function moveBackIfOutside() | |
114 { | |
115 delete this._selectionTimeout; | |
116 if (!this.prompt.isCaretInsidePrompt() && window.getSelection().isCo
llapsed) | |
117 this.prompt.moveCaretToEndOfPrompt(); | |
118 this.prompt.autoCompleteSoon(); | |
119 } | |
120 | |
121 this._selectionTimeout = setTimeout(moveBackIfOutside.bind(this), 100); | |
122 }, | |
123 | |
124 _enterKeyPressed: function(event) | |
125 { | |
126 event.preventDefault(); | |
127 event.stopPropagation(); | |
128 | |
129 this.prompt.clearAutoComplete(true); | |
130 | |
131 var query = this.prompt.text; | |
132 if (!query.length) | |
133 return; | |
134 | |
135 this.prompt.history.push(query); | |
136 this.prompt.historyOffset = 0; | |
137 this.prompt.text = ""; | |
138 | |
139 this.database.executeSql(query, this._queryFinished.bind(this, query), t
his._queryError.bind(this, query)); | |
140 }, | |
141 | |
142 _queryFinished: function(query, result) | |
143 { | |
144 var dataGrid = WebInspector.panels.storage.dataGridForResult(result); | |
145 if (!dataGrid) | |
146 return; | |
147 dataGrid.element.addStyleClass("inline"); | |
148 this._appendQueryResult(query, dataGrid.element); | |
149 | |
150 if (query.match(/^create /i) || query.match(/^drop table /i)) | |
151 WebInspector.panels.storage.updateDatabaseTables(this.database); | |
152 }, | |
153 | |
154 _queryError: function(query, error) | |
155 { | |
156 if (error.code == 1) | |
157 var message = error.message; | |
158 else if (error.code == 2) | |
159 var message = WebInspector.UIString("Database no longer has expected
version."); | |
160 else | |
161 var message = WebInspector.UIString("An unexpected error %s occurred
.", error.code); | |
162 | |
163 this._appendQueryResult(query, message, "error"); | |
164 }, | |
165 | |
166 _appendQueryResult: function(query, result, resultClassName) | |
167 { | |
168 var element = document.createElement("div"); | |
169 element.className = "database-user-query"; | |
170 | |
171 var commandTextElement = document.createElement("span"); | |
172 commandTextElement.className = "database-query-text"; | |
173 commandTextElement.textContent = query; | |
174 element.appendChild(commandTextElement); | |
175 | |
176 var resultElement = document.createElement("div"); | |
177 resultElement.className = "database-query-result"; | |
178 | |
179 if (resultClassName) | |
180 resultElement.addStyleClass(resultClassName); | |
181 | |
182 if (typeof result === "string" || result instanceof String) | |
183 resultElement.textContent = result; | |
184 else if (result && result.nodeName) | |
185 resultElement.appendChild(result); | |
186 | |
187 if (resultElement.childNodes.length) | |
188 element.appendChild(resultElement); | |
189 | |
190 this.element.insertBefore(element, this.promptElement); | |
191 this.promptElement.scrollIntoView(false); | |
192 } | |
193 } | |
194 | |
195 WebInspector.DatabaseQueryView.prototype.__proto__ = WebInspector.View.prototype
; | |
OLD | NEW |