1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
/*
* 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._prompt = new WebInspector.ConsolePrompt(this, "text/x-sql");
this.addSubview(this._prompt);
this.element.addEventListener("click", this._messagesClicked.bind(this), true);
}
// Public
shown()
{
// FIXME: remove once <https://webkit.org/b/150741> is fixed.
this._prompt.shown();
}
saveToCookie(cookie)
{
cookie.type = WebInspector.ContentViewCookieType.Database;
cookie.host = this.representedObject.host;
cookie.name = this.representedObject.name;
}
consolePromptCompletionsNeeded(prompt, defaultCompletions, base, prefix, suffix)
{
let results = [];
prefix = prefix.toLowerCase();
function accumulateMatches(textArray)
{
for (let text of textArray) {
if (text.toLowerCase().startsWith(prefix))
results.push(text);
}
}
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)
{
let trimmedQuery = query.trim();
let queryView = new WebInspector.DatabaseUserQuerySuccessView(trimmedQuery, columnNames, values);
this.insertSubviewBefore(queryView, this._prompt);
if (queryView.dataGrid)
queryView.dataGrid.autoSizeColumns(5);
this._prompt.element.scrollIntoView(false);
if (trimmedQuery.match(/^create /i) || trimmedQuery.match(/^drop table /i))
this.dispatchEventToListeners(WebInspector.DatabaseContentView.Event.SchemaUpdated, this.database);
}
_queryError(query, error)
{
let message;
if (error.message)
message = error.message;
else if (error.code === 2)
message = WebInspector.UIString("Database no longer has expected version.");
else
message = WebInspector.UIString("An unexpected error %s occurred.").format(error.code);
let queryView = new WebInspector.DatabaseUserQueryErrorView(query, message);
this.insertSubviewBefore(queryView, this._prompt);
this._prompt.element.scrollIntoView(false);
}
};
WebInspector.DatabaseContentView.Event = {
SchemaUpdated: "SchemaUpdated"
};
|
