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 31#if ENABLE(SQL_DATABASE) 32 33#include "JSSQLTransactionSync.h" 34 35#include "ExceptionCode.h" 36#include "JSSQLResultSet.h" 37#include "SQLResultSet.h" 38#include "SQLTransactionSync.h" 39#include "SQLValue.h" 40 41using namespace JSC; 42 43namespace WebCore { 44 45JSValue JSSQLTransactionSync::executeSql(ExecState* exec) 46{ 47 if (!exec->argumentCount()) { 48 setDOMException(exec, SYNTAX_ERR); 49 return jsUndefined(); 50 } 51 52 String sqlStatement = exec->argument(0).toString(exec)->value(exec); 53 if (exec->hadException()) 54 return jsUndefined(); 55 56 // Now assemble the list of SQL arguments 57 Vector<SQLValue> sqlValues; 58 if (!exec->argument(1).isUndefinedOrNull()) { 59 JSObject* object = exec->argument(1).getObject(); 60 if (!object) { 61 setDOMException(exec, TYPE_MISMATCH_ERR); 62 return jsUndefined(); 63 } 64 65 JSValue lengthValue = object->get(exec, exec->propertyNames().length); 66 if (exec->hadException()) 67 return jsUndefined(); 68 unsigned length = lengthValue.toUInt32(exec); 69 if (exec->hadException()) 70 return jsUndefined(); 71 72 for (unsigned i = 0 ; i < length; ++i) { 73 JSValue value = object->get(exec, i); 74 if (exec->hadException()) 75 return jsUndefined(); 76 77 if (value.isUndefinedOrNull()) 78 sqlValues.append(SQLValue()); 79 else if (value.isNumber()) 80 sqlValues.append(value.asNumber()); 81 else { 82 // Convert the argument to a string and append it 83 sqlValues.append(value.toString(exec)->value(exec)); 84 if (exec->hadException()) 85 return jsUndefined(); 86 } 87 } 88 } 89 90 ExceptionCode ec = 0; 91 JSValue result = toJS(exec, globalObject(), WTF::getPtr(m_impl->executeSQL(sqlStatement, sqlValues, ec))); 92 setDOMException(exec, ec); 93 94 return result; 95} 96 97} // namespace WebCore 98 99#endif // ENABLE(SQL_DATABASE) 100