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.
28 * @extends {WebInspector.VBox}
30 WebInspector.DatabaseTableView = function(database, tableName)
32 WebInspector.VBox.call(this);
34 this.database = database;
35 this.tableName = tableName;
37 this.element.classList.add("storage-view");
38 this.element.classList.add("table");
40 this.refreshButton = new WebInspector.StatusBarButton(WebInspector.UIString("Refresh"), "refresh-storage-status-bar-item");
41 this.refreshButton.addEventListener("click", this._refreshButtonClicked, this);
44 WebInspector.DatabaseTableView.prototype = {
52 return [this.refreshButton.element];
56 * @param {string} tableName
59 _escapeTableName: function(tableName)
61 return tableName.replace(/\"/g, "\"\"");
66 this.database.executeSql("SELECT * FROM \"" + this._escapeTableName(this.tableName) + "\"", this._queryFinished.bind(this), this._queryError.bind(this));
69 _queryFinished: function(columnNames, values)
71 this.detachChildViews();
72 this.element.removeChildren();
74 var dataGrid = WebInspector.DataGrid.createSortableDataGrid(columnNames, values);
76 this._emptyView = new WebInspector.EmptyView(WebInspector.UIString("The ā%sā\ntable is empty.", this.tableName));
77 this._emptyView.show(this.element);
80 dataGrid.show(this.element);
81 dataGrid.autoSizeColumns(5);
84 _queryError: function(error)
86 this.detachChildViews();
87 this.element.removeChildren();
89 var errorMsgElement = document.createElement("div");
90 errorMsgElement.className = "storage-table-error";
91 errorMsgElement.textContent = WebInspector.UIString("An error occurred trying to\nread the ā%sā table.", this.tableName);
92 this.element.appendChild(errorMsgElement);
95 _refreshButtonClicked: function(event)
100 __proto__: WebInspector.VBox.prototype