summaryrefslogtreecommitdiff
path: root/Source/WebInspectorUI/UserInterface/Views/DatabaseContentView.js
diff options
context:
space:
mode:
authorLorry Tar Creator <lorry-tar-importer@lorry>2015-10-15 09:45:50 +0000
committerLorry Tar Creator <lorry-tar-importer@lorry>2015-10-15 09:45:50 +0000
commite15dd966d523731101f70ccf768bba12435a0208 (patch)
treeae9cb828a24ded2585a41af3f21411523b47897d /Source/WebInspectorUI/UserInterface/Views/DatabaseContentView.js
downloadWebKitGtk-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.js177
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"
+};