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 40using namespace JSC; 41 42namespace WebCore { 43 44JSValue 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