• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
1 /*
2  * Copyright (C) 2010 Google 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  *
8  * 1.  Redistributions of source code must retain the above copyright
9  *     notice, this list of conditions and the following disclaimer.
10  * 2.  Redistributions in binary form must reproduce the above copyright
11  *     notice, this list of conditions and the following disclaimer in the
12  *     documentation and/or other materials provided with the distribution.
13  * 3.  Neither the name of Apple Computer, Inc. ("Apple") nor the names of
14  *     its contributors may be used to endorse or promote products derived
15  *     from this software without specific prior written permission.
16  *
17  * THIS SOFTWARE IS PROVIDED BY APPLE AND ITS CONTRIBUTORS "AS IS" AND ANY
18  * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
19  * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
20  * DISCLAIMED. IN NO EVENT SHALL APPLE OR ITS CONTRIBUTORS BE LIABLE FOR ANY
21  * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
22  * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
23  * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
24  * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
25  * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF
26  * THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
27  */
28 
29 #include "config.h"
30 #include "JSSQLTransactionSync.h"
31 
32 #if ENABLE(DATABASE)
33 
34 #include "ExceptionCode.h"
35 #include "JSSQLResultSet.h"
36 #include "SQLResultSet.h"
37 #include "SQLTransactionSync.h"
38 #include "SQLValue.h"
39 
40 using namespace JSC;
41 
42 namespace WebCore {
43 
executeSql(ExecState * exec)44 JSValue JSSQLTransactionSync::executeSql(ExecState* exec)
45 {
46     if (!exec->argumentCount()) {
47         setDOMException(exec, SYNTAX_ERR);
48         return jsUndefined();
49     }
50 
51     String sqlStatement = ustringToString(exec->argument(0).toString(exec));
52     if (exec->hadException())
53         return jsUndefined();
54 
55     // Now assemble the list of SQL arguments
56     Vector<SQLValue> sqlValues;
57     if (!exec->argument(1).isUndefinedOrNull()) {
58         JSObject* object = exec->argument(1).getObject();
59         if (!object) {
60             setDOMException(exec, TYPE_MISMATCH_ERR);
61             return jsUndefined();
62         }
63 
64         JSValue lengthValue = object->get(exec, exec->propertyNames().length);
65         if (exec->hadException())
66             return jsUndefined();
67         unsigned length = lengthValue.toUInt32(exec);
68         if (exec->hadException())
69             return jsUndefined();
70 
71         for (unsigned i = 0 ; i < length; ++i) {
72             JSValue value = object->get(exec, i);
73             if (exec->hadException())
74                 return jsUndefined();
75 
76             if (value.isUndefinedOrNull())
77                 sqlValues.append(SQLValue());
78             else if (value.isNumber())
79                 sqlValues.append(value.uncheckedGetNumber());
80             else {
81                 // Convert the argument to a string and append it
82                 sqlValues.append(ustringToString(value.toString(exec)));
83                 if (exec->hadException())
84                     return jsUndefined();
85             }
86         }
87     }
88 
89     ExceptionCode ec = 0;
90     JSValue result = toJS(exec, globalObject(), WTF::getPtr(m_impl->executeSQL(sqlStatement, sqlValues, ec)));
91     setDOMException(exec, ec);
92 
93     return result;
94 }
95 
96 }
97 
98 #endif // ENABLE(DATABASE)
99