1/* 2 * Copyright (C) 2007 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 * 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 31#if ENABLE(SQL_DATABASE) 32 33#include "JSSQLTransaction.h" 34 35#include "DOMWindow.h" 36#include "ExceptionCode.h" 37#include "JSSQLStatementCallback.h" 38#include "JSSQLStatementErrorCallback.h" 39#include "JSDOMWindowCustom.h" 40#include "SQLTransaction.h" 41 42using namespace JSC; 43 44namespace WebCore { 45 46JSValue JSSQLTransaction::executeSql(ExecState* exec) 47{ 48 if (!exec->argumentCount()) { 49 setDOMException(exec, SYNTAX_ERR); 50 return jsUndefined(); 51 } 52 53 String sqlStatement = exec->argument(0).toString(exec)->value(exec); 54 if (exec->hadException()) 55 return jsUndefined(); 56 57 // Now assemble the list of SQL arguments 58 Vector<SQLValue> sqlValues; 59 if (!exec->argument(1).isUndefinedOrNull()) { 60 JSObject* object = exec->argument(1).getObject(); 61 if (!object) { 62 setDOMException(exec, TYPE_MISMATCH_ERR); 63 return jsUndefined(); 64 } 65 66 JSValue lengthValue = object->get(exec, exec->propertyNames().length); 67 if (exec->hadException()) 68 return jsUndefined(); 69 unsigned length = lengthValue.toUInt32(exec); 70 if (exec->hadException()) 71 return jsUndefined(); 72 73 for (unsigned i = 0 ; i < length; ++i) { 74 JSValue value = object->get(exec, i); 75 if (exec->hadException()) 76 return jsUndefined(); 77 78 if (value.isUndefinedOrNull()) 79 sqlValues.append(SQLValue()); 80 else if (value.isNumber()) 81 sqlValues.append(value.asNumber()); 82 else { 83 // Convert the argument to a string and append it 84 sqlValues.append(value.toString(exec)->value(exec)); 85 if (exec->hadException()) 86 return jsUndefined(); 87 } 88 } 89 } 90 91 RefPtr<SQLStatementCallback> callback; 92 if (!exec->argument(2).isUndefinedOrNull()) { 93 JSObject* object = exec->argument(2).getObject(); 94 if (!object) { 95 setDOMException(exec, TYPE_MISMATCH_ERR); 96 return jsUndefined(); 97 } 98 99 callback = JSSQLStatementCallback::create(object, jsCast<JSDOMGlobalObject*>(globalObject())); 100 } 101 102 RefPtr<SQLStatementErrorCallback> errorCallback; 103 if (!exec->argument(3).isUndefinedOrNull()) { 104 JSObject* object = exec->argument(3).getObject(); 105 if (!object) { 106 setDOMException(exec, TYPE_MISMATCH_ERR); 107 return jsUndefined(); 108 } 109 110 errorCallback = JSSQLStatementErrorCallback::create(object, jsCast<JSDOMGlobalObject*>(globalObject())); 111 } 112 113 ExceptionCode ec = 0; 114 m_impl->executeSQL(sqlStatement, sqlValues, callback.release(), errorCallback.release(), ec); 115 setDOMException(exec, ec); 116 117 return jsUndefined(); 118} 119 120} // namespace WebCore 121 122#endif // ENABLE(SQL_DATABASE) 123