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