| 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) | |
| 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 accumulateMatches(this.database.tableNames.map(function(name) { return n
ame + " " })); | |
| 86 accumulateMatches(["SELECT ", "FROM ", "WHERE ", "LIMIT ", "DELETE FROM
", "CREATE ", "DROP ", "TABLE ", "INDEX ", "UPDATE ", "INSERT INTO ", "VALUES ("
]); | |
| 87 | |
| 88 return results; | |
| 89 }, | |
| 90 | |
| 91 _promptKeyDown: function(event) | |
| 92 { | |
| 93 switch (event.keyIdentifier) { | |
| 94 case "Enter": | |
| 95 this._enterKeyPressed(event); | |
| 96 return; | |
| 97 } | |
| 98 | |
| 99 this.prompt.handleKeyEvent(event); | |
| 100 }, | |
| 101 | |
| 102 _selectStart: function(event) | |
| 103 { | |
| 104 if (this._selectionTimeout) | |
| 105 clearTimeout(this._selectionTimeout); | |
| 106 | |
| 107 this.prompt.clearAutoComplete(); | |
| 108 | |
| 109 function moveBackIfOutside() | |
| 110 { | |
| 111 delete this._selectionTimeout; | |
| 112 if (!this.prompt.isCaretInsidePrompt() && window.getSelection().isCo
llapsed) | |
| 113 this.prompt.moveCaretToEndOfPrompt(); | |
| 114 this.prompt.autoCompleteSoon(); | |
| 115 } | |
| 116 | |
| 117 this._selectionTimeout = setTimeout(moveBackIfOutside.bind(this), 100); | |
| 118 }, | |
| 119 | |
| 120 _enterKeyPressed: function(event) | |
| 121 { | |
| 122 event.preventDefault(); | |
| 123 event.stopPropagation(); | |
| 124 | |
| 125 this.prompt.clearAutoComplete(true); | |
| 126 | |
| 127 var query = this.prompt.text; | |
| 128 if (!query.length) | |
| 129 return; | |
| 130 | |
| 131 this.prompt.history.push(query); | |
| 132 this.prompt.historyOffset = 0; | |
| 133 this.prompt.text = ""; | |
| 134 | |
| 135 function queryTransaction(tx) | |
| 136 { | |
| 137 tx.executeSql(query, null, InspectorController.wrapCallback(this._qu
eryFinished.bind(this, query)), InspectorController.wrapCallback(this._executeSq
lError.bind(this, query))); | |
| 138 } | |
| 139 | |
| 140 this.database.database.transaction(InspectorController.wrapCallback(quer
yTransaction.bind(this)), InspectorController.wrapCallback(this._queryError.bind
(this, query))); | |
| 141 }, | |
| 142 | |
| 143 _queryFinished: function(query, tx, result) | |
| 144 { | |
| 145 var dataGrid = WebInspector.panels.databases.dataGridForResult(result); | |
| 146 dataGrid.element.addStyleClass("inline"); | |
| 147 this._appendQueryResult(query, dataGrid.element); | |
| 148 | |
| 149 if (query.match(/^create /i) || query.match(/^drop table /i)) | |
| 150 WebInspector.panels.databases.updateDatabaseTables(this.database); | |
| 151 }, | |
| 152 | |
| 153 _queryError: function(query, error) | |
| 154 { | |
| 155 if (error.code == 1) | |
| 156 var message = error.message; | |
| 157 else if (error.code == 2) | |
| 158 var message = WebInspector.UIString("Database no longer has expected
version."); | |
| 159 else | |
| 160 var message = WebInspector.UIString("An unexpected error %s occured.
", error.code); | |
| 161 | |
| 162 this._appendQueryResult(query, message, "error"); | |
| 163 }, | |
| 164 | |
| 165 _executeSqlError: function(query, tx, error) | |
| 166 { | |
| 167 this._queryError(query, error); | |
| 168 }, | |
| 169 | |
| 170 _appendQueryResult: function(query, result, resultClassName) | |
| 171 { | |
| 172 var element = document.createElement("div"); | |
| 173 element.className = "database-user-query"; | |
| 174 | |
| 175 var commandTextElement = document.createElement("span"); | |
| 176 commandTextElement.className = "database-query-text"; | |
| 177 commandTextElement.textContent = query; | |
| 178 element.appendChild(commandTextElement); | |
| 179 | |
| 180 var resultElement = document.createElement("div"); | |
| 181 resultElement.className = "database-query-result"; | |
| 182 | |
| 183 if (resultClassName) | |
| 184 resultElement.addStyleClass(resultClassName); | |
| 185 | |
| 186 if (typeof result === "string" || result instanceof String) | |
| 187 resultElement.textContent = result; | |
| 188 else if (result && result.nodeName) | |
| 189 resultElement.appendChild(result); | |
| 190 | |
| 191 if (resultElement.childNodes.length) | |
| 192 element.appendChild(resultElement); | |
| 193 | |
| 194 this.element.insertBefore(element, this.promptElement); | |
| 195 this.promptElement.scrollIntoView(false); | |
| 196 } | |
| 197 } | |
| 198 | |
| 199 WebInspector.DatabaseQueryView.prototype.__proto__ = WebInspector.View.prototype
; | |
| OLD | NEW |