diff options
| author | Lorry Tar Creator <lorry-tar-importer@lorry> | 2015-10-15 09:45:50 +0000 |
|---|---|---|
| committer | Lorry Tar Creator <lorry-tar-importer@lorry> | 2015-10-15 09:45:50 +0000 |
| commit | e15dd966d523731101f70ccf768bba12435a0208 (patch) | |
| tree | ae9cb828a24ded2585a41af3f21411523b47897d /Source/WebInspectorUI/UserInterface/Views/DatabaseContentView.js | |
| download | WebKitGtk-tarball-e15dd966d523731101f70ccf768bba12435a0208.tar.gz | |
webkitgtk-2.10.2webkitgtk-2.10.2
Diffstat (limited to 'Source/WebInspectorUI/UserInterface/Views/DatabaseContentView.js')
| -rw-r--r-- | Source/WebInspectorUI/UserInterface/Views/DatabaseContentView.js | 177 |
1 files changed, 177 insertions, 0 deletions
diff --git a/Source/WebInspectorUI/UserInterface/Views/DatabaseContentView.js b/Source/WebInspectorUI/UserInterface/Views/DatabaseContentView.js new file mode 100644 index 000000000..d03812407 --- /dev/null +++ b/Source/WebInspectorUI/UserInterface/Views/DatabaseContentView.js @@ -0,0 +1,177 @@ +/* + * Copyright (C) 2013, 2015 Apple Inc. All rights reserved. + * + * Redistribution and use in source and binary forms, with or without + * modification, are permitted provided that the following conditions + * are met: + * 1. Redistributions of source code must retain the above copyright + * notice, this list of conditions and the following disclaimer. + * 2. Redistributions in binary form must reproduce the above copyright + * notice, this list of conditions and the following disclaimer in the + * documentation and/or other materials provided with the distribution. + * + * THIS SOFTWARE IS PROVIDED BY APPLE INC. AND ITS CONTRIBUTORS ``AS IS'' + * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, + * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR + * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL APPLE INC. OR ITS CONTRIBUTORS + * BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR + * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF + * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS + * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN + * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) + * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF + * THE POSSIBILITY OF SUCH DAMAGE. + */ + +WebInspector.DatabaseContentView = class DatabaseContentView extends WebInspector.ContentView +{ + constructor(representedObject) + { + super(representedObject); + + this.database = representedObject; + + this.element.classList.add("storage-view", "query", "monospace"); + + this._promptElement = document.createElement("div"); + this._promptElement.classList.add("database-query-prompt"); + this.element.appendChild(this._promptElement); + + this.prompt = new WebInspector.ConsolePrompt(this, "text/x-sql"); + this._promptElement.appendChild(this.prompt.element); + + this.element.addEventListener("click", this._messagesClicked.bind(this), true); + } + + // Public + + shown() + { + this.prompt.shown(); + } + + updateLayout() + { + this.prompt.updateLayout(); + + var results = this.element.querySelectorAll(".database-query-result"); + for (var i = 0; i < results.length; ++i) { + var resultElement = results[i]; + if (resultElement.dataGrid) + resultElement.dataGrid.updateLayout(); + } + } + + saveToCookie(cookie) + { + cookie.type = WebInspector.ContentViewCookieType.Database; + cookie.host = this.representedObject.host; + cookie.name = this.representedObject.name; + } + + consolePromptCompletionsNeeded(prompt, defaultCompletions, base, prefix, suffix) + { + var results = []; + + prefix = prefix.toLowerCase(); + + function accumulateMatches(textArray) + { + for (var i = 0; i < textArray.length; ++i) { + var lowerCaseText = textArray[i].toLowerCase(); + if (lowerCaseText.startsWith(prefix)) + results.push(textArray[i]); + } + } + + function tableNamesCallback(tableNames) + { + accumulateMatches(tableNames); + accumulateMatches(["SELECT", "FROM", "WHERE", "LIMIT", "DELETE FROM", "CREATE", "DROP", "TABLE", "INDEX", "UPDATE", "INSERT INTO", "VALUES"]); + + this.prompt.updateCompletions(results, " "); + } + + this.database.getTableNames(tableNamesCallback.bind(this)); + } + + consolePromptTextCommitted(prompt, query) + { + this.database.executeSQL(query, this._queryFinished.bind(this, query), this._queryError.bind(this, query)); + } + + // Private + + _messagesClicked() + { + this.prompt.focus(); + } + + _queryFinished(query, columnNames, values) + { + var dataGrid = WebInspector.DataGrid.createSortableDataGrid(columnNames, values); + var trimmedQuery = query.trim(); + + if (dataGrid) { + dataGrid.element.classList.add("inline"); + this._appendViewQueryResult(trimmedQuery, dataGrid); + dataGrid.autoSizeColumns(5); + } + + if (trimmedQuery.match(/^create /i) || trimmedQuery.match(/^drop table /i)) + this.dispatchEventToListeners(WebInspector.DatabaseContentView.Event.SchemaUpdated, this.database); + } + + _queryError(query, error) + { + if (error.message) + var message = error.message; + else if (error.code === 2) + var message = WebInspector.UIString("Database no longer has expected version."); + else + var message = WebInspector.UIString("An unexpected error %s occurred.").format(error.code); + + this._appendErrorQueryResult(query, message); + } + + _appendViewQueryResult(query, view) + { + var resultElement = this._appendQueryResult(query); + + // Add our DataGrid with the results to the database query result div. + resultElement.dataGrid = view; + resultElement.appendChild(view.element); + + this._promptElement.scrollIntoView(false); + } + + _appendErrorQueryResult(query, errorText) + { + var resultElement = this._appendQueryResult(query); + resultElement.classList.add("error"); + resultElement.textContent = errorText; + + this._promptElement.scrollIntoView(false); + } + + _appendQueryResult(query) + { + var element = document.createElement("div"); + element.className = "database-user-query"; + this.element.insertBefore(element, this._promptElement); + + var commandTextElement = document.createElement("span"); + commandTextElement.className = "database-query-text"; + commandTextElement.textContent = query; + element.appendChild(commandTextElement); + + var resultElement = document.createElement("div"); + resultElement.className = "database-query-result"; + element.appendChild(resultElement); + return resultElement; + } +}; + +WebInspector.DatabaseContentView.Event = { + SchemaUpdated: "SchemaUpdated" +}; |
