• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
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
26WebInspector.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.addStyleClass("monospace");
35    this.element.tabIndex = 0;
36
37    this.element.addEventListener("selectstart", this._selectStart.bind(this), false);
38
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);
44
45    this.prompt = new WebInspector.TextPrompt(this.promptElement, this.completions.bind(this), " ");
46}
47
48WebInspector.DatabaseQueryView.prototype = {
49    show: function(parentElement)
50    {
51        WebInspector.View.prototype.show.call(this, parentElement);
52
53        function moveBackIfOutside()
54        {
55            if (!this.prompt.isCaretInsidePrompt() && window.getSelection().isCollapsed)
56                this.prompt.moveCaretToEndOfPrompt();
57        }
58
59        setTimeout(moveBackIfOutside.bind(this), 0);
60    },
61
62    completions: function(wordRange, bestMatchOnly, completionsReadyCallback)
63    {
64        var prefix = wordRange.toString().toLowerCase();
65        if (!prefix.length)
66            return;
67
68        var results = [];
69
70        function accumulateMatches(textArray)
71        {
72            if (bestMatchOnly && results.length)
73                return;
74            for (var i = 0; i < textArray.length; ++i) {
75                var text = textArray[i].toLowerCase();
76                if (text.length < prefix.length)
77                    continue;
78                if (text.indexOf(prefix) !== 0)
79                    continue;
80                results.push(textArray[i]);
81                if (bestMatchOnly)
82                    return;
83            }
84        }
85
86        function tableNamesCallback(tableNames)
87        {
88            accumulateMatches(tableNames.map(function(name) { return name + " " }));
89            accumulateMatches(["SELECT ", "FROM ", "WHERE ", "LIMIT ", "DELETE FROM ", "CREATE ", "DROP ", "TABLE ", "INDEX ", "UPDATE ", "INSERT INTO ", "VALUES ("]);
90
91            completionsReadyCallback(results);
92        }
93        this.database.getTableNames(tableNamesCallback);
94    },
95
96    _promptKeyDown: function(event)
97    {
98        if (isEnterKey(event)) {
99            this._enterKeyPressed(event);
100            return;
101        }
102    },
103
104    _selectStart: function(event)
105    {
106        if (this._selectionTimeout)
107            clearTimeout(this._selectionTimeout);
108
109        this.prompt.clearAutoComplete();
110
111        function moveBackIfOutside()
112        {
113            delete this._selectionTimeout;
114            if (!this.prompt.isCaretInsidePrompt() && window.getSelection().isCollapsed)
115                this.prompt.moveCaretToEndOfPrompt();
116            this.prompt.autoCompleteSoon();
117        }
118
119        this._selectionTimeout = setTimeout(moveBackIfOutside.bind(this), 100);
120    },
121
122    _enterKeyPressed: function(event)
123    {
124        event.preventDefault();
125        event.stopPropagation();
126
127        this.prompt.clearAutoComplete(true);
128
129        var query = this.prompt.text;
130        if (!query.length)
131            return;
132
133        this.prompt.history.push(query);
134        this.prompt.historyOffset = 0;
135        this.prompt.text = "";
136
137        this.database.executeSql(query, this._queryFinished.bind(this, query), this._queryError.bind(this, query));
138    },
139
140    _queryFinished: function(query, columnNames, values)
141    {
142        var dataGrid = WebInspector.panels.resources.dataGridForResult(columnNames, values);
143        var trimmedQuery = query.trim();
144
145        if (dataGrid) {
146            dataGrid.element.addStyleClass("inline");
147            this._appendQueryResult(trimmedQuery, dataGrid.element);
148            dataGrid.autoSizeColumns(5);
149        }
150
151        if (trimmedQuery.match(/^create /i) || trimmedQuery.match(/^drop table /i))
152            WebInspector.panels.resources.updateDatabaseTables(this.database);
153    },
154
155    _queryError: function(query, error)
156    {
157        if (error.message)
158            var message = error.message;
159        else if (error.code == 2)
160            var message = WebInspector.UIString("Database no longer has expected version.");
161        else
162            var message = WebInspector.UIString("An unexpected error %s occurred.", error.code);
163
164        this._appendQueryResult(query, message, "error");
165    },
166
167    _appendQueryResult: function(query, result, resultClassName)
168    {
169        var element = document.createElement("div");
170        element.className = "database-user-query";
171
172        var commandTextElement = document.createElement("span");
173        commandTextElement.className = "database-query-text";
174        commandTextElement.textContent = query;
175        element.appendChild(commandTextElement);
176
177        var resultElement = document.createElement("div");
178        resultElement.className = "database-query-result";
179
180        if (resultClassName)
181            resultElement.addStyleClass(resultClassName);
182
183        if (typeof result === "string" || result instanceof String)
184            resultElement.textContent = result;
185        else if (result && result.nodeName)
186            resultElement.appendChild(result);
187
188        if (resultElement.childNodes.length)
189            element.appendChild(resultElement);
190
191        this.element.insertBefore(element, this.promptElement);
192        this.promptElement.scrollIntoView(false);
193    }
194}
195
196WebInspector.DatabaseQueryView.prototype.__proto__ = WebInspector.View.prototype;
197