2 * Copyright (C) 2008 Apple Inc. All Rights Reserved.
4 * Redistribution and use in source and binary forms, with or without
5 * modification, are permitted provided that the following conditions
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.
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.
26 WebInspector.DatabaseQueryView = function(database)
28 WebInspector.View.call(this);
30 this.database = database;
32 this.element.addStyleClass("storage-view");
33 this.element.addStyleClass("query");
34 this.element.addStyleClass("monospace");
35 this.element.tabIndex = 0;
37 this.element.addEventListener("selectstart", this._selectStart.bind(this), false);
39 this.promptElement = document.createElement("div");
40 this.promptElement.className = "database-query-prompt";
41 this.promptElement.appendChild(document.createElement("br"));
42 this.promptElement.addEventListener("keydown", this._promptKeyDown.bind(this), true);
43 this.element.appendChild(this.promptElement);
45 this.prompt = new WebInspector.TextPrompt(this.promptElement, this.completions.bind(this), " ");
48 WebInspector.DatabaseQueryView.prototype = {
49 show: function(parentElement)
51 WebInspector.View.prototype.show.call(this, parentElement);
53 function moveBackIfOutside()
55 if (!this.prompt.isCaretInsidePrompt() && window.getSelection().isCollapsed)
56 this.prompt.moveCaretToEndOfPrompt();
59 setTimeout(moveBackIfOutside.bind(this), 0);
62 completions: function(wordRange, bestMatchOnly, completionsReadyCallback)
64 var prefix = wordRange.toString().toLowerCase();
70 function accumulateMatches(textArray)
72 if (bestMatchOnly && results.length)
74 for (var i = 0; i < textArray.length; ++i) {
75 var text = textArray[i].toLowerCase();
76 if (text.length < prefix.length)
78 if (text.indexOf(prefix) !== 0)
80 results.push(textArray[i]);
86 function tableNamesCallback(tableNames)
88 accumulateMatches(tableNames.map(function(name) { return name + " " }));
89 accumulateMatches(["SELECT ", "FROM ", "WHERE ", "LIMIT ", "DELETE FROM ", "CREATE ", "DROP ", "TABLE ", "INDEX ", "UPDATE ", "INSERT INTO ", "VALUES ("]);
91 completionsReadyCallback(results);
93 this.database.getTableNames(tableNamesCallback);
96 _promptKeyDown: function(event)
98 if (isEnterKey(event)) {
99 this._enterKeyPressed(event);
104 _selectStart: function(event)
106 if (this._selectionTimeout)
107 clearTimeout(this._selectionTimeout);
109 this.prompt.clearAutoComplete();
111 function moveBackIfOutside()
113 delete this._selectionTimeout;
114 if (!this.prompt.isCaretInsidePrompt() && window.getSelection().isCollapsed)
115 this.prompt.moveCaretToEndOfPrompt();
116 this.prompt.autoCompleteSoon();
119 this._selectionTimeout = setTimeout(moveBackIfOutside.bind(this), 100);
122 _enterKeyPressed: function(event)
124 event.preventDefault();
125 event.stopPropagation();
127 this.prompt.clearAutoComplete(true);
129 var query = this.prompt.text;
133 this.prompt.history.push(query);
134 this.prompt.historyOffset = 0;
135 this.prompt.text = "";
137 this.database.executeSql(query, this._queryFinished.bind(this, query), this._queryError.bind(this, query));
140 _queryFinished: function(query, columnNames, values)
142 var dataGrid = WebInspector.panels.resources.dataGridForResult(columnNames, values);
143 var trimmedQuery = query.trim();
146 dataGrid.element.addStyleClass("inline");
147 this._appendQueryResult(trimmedQuery, dataGrid.element);
148 dataGrid.autoSizeColumns(5);
151 if (trimmedQuery.match(/^create /i) || trimmedQuery.match(/^drop table /i))
152 WebInspector.panels.resources.updateDatabaseTables(this.database);
155 _queryError: function(query, error)
158 var message = error.message;
159 else if (error.code == 2)
160 var message = WebInspector.UIString("Database no longer has expected version.");
162 var message = WebInspector.UIString("An unexpected error %s occurred.", error.code);
164 this._appendQueryResult(query, message, "error");
167 _appendQueryResult: function(query, result, resultClassName)
169 var element = document.createElement("div");
170 element.className = "database-user-query";
172 var commandTextElement = document.createElement("span");
173 commandTextElement.className = "database-query-text";
174 commandTextElement.textContent = query;
175 element.appendChild(commandTextElement);
177 var resultElement = document.createElement("div");
178 resultElement.className = "database-query-result";
181 resultElement.addStyleClass(resultClassName);
183 if (typeof result === "string" || result instanceof String)
184 resultElement.textContent = result;
185 else if (result && result.nodeName)
186 resultElement.appendChild(result);
188 if (resultElement.childNodes.length)
189 element.appendChild(resultElement);
191 this.element.insertBefore(element, this.promptElement);
192 this.promptElement.scrollIntoView(false);
196 WebInspector.DatabaseQueryView.prototype.__proto__ = WebInspector.View.prototype;