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
|
/*
* Copyright (C) 2013 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.DatabaseObject = function(id, host, name, version)
{
this._id = id;
this._host = host ? host : WebInspector.UIString("Local File");
this._name = name;
this._version = version;
};
WebInspector.DatabaseObject.prototype = {
constructor: WebInspector.DatabaseObject,
get id()
{
return this._id;
},
get host()
{
return this._host;
},
get name()
{
return this._name;
},
get version()
{
return this._version;
},
getTableNames: function(callback)
{
function sortingCallback(error, names)
{
if (!error)
callback(names.sort());
}
DatabaseAgent.getDatabaseTableNames(this._id, sortingCallback);
},
executeSQL: function(query, successCallback, errorCallback)
{
function queryCallback(columnNames, values, sqlError)
{
if (sqlError) {
var message;
switch (sqlError.code) {
case SQLException.VERSION_ERR:
message = WebInspector.UIString("Database no longer has expected version.");
break;
case SQLException.TOO_LARGE_ERR:
message = WebInspector.UIString("Data returned from the database is too large.");
break;
default:
message = WebInspector.UIString("An unexpected error occurred.");
break;
}
errorCallback(message);
return;
}
successCallback(columnNames, values);
}
function callback(error, result)
{
if (error) {
errorCallback(WebInspector.UIString("An unexpected error occurred."));
return;
}
// COMPATIBILITY (iOS 6): Newer versions of DatabaseAgent.executeSQL can delay before
// sending the results. The version on iOS 6 instead returned a transactionId that
// would be used later in the sqlTransactionSucceeded or sqlTransactionFailed events.
if ("transactionId" in result) {
if (!result.success) {
errorCallback(WebInspector.UIString("An unexpected error occurred."));
return;
}
WebInspector.DatabaseObserver._callbacks[result.transactionId] = queryCallback;
return;
}
queryCallback(result.columnNames, result.values, result.sqlError);
}
// COMPATIBILITY (iOS 6): Since the parameters of the DatabaseAgent.executeSQL callback differ
// we need the result object to lookup parameters by name.
callback.expectsResultObject = true;
DatabaseAgent.executeSQL(this._id, query, callback);
}
};
|
