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 are
6 * met:
7 *
8 *     * Redistributions of source code must retain the above copyright
9 * notice, this list of conditions and the following disclaimer.
10 *     * Redistributions in binary form must reproduce the above
11 * copyright notice, this list of conditions and the following disclaimer
12 * in the documentation and/or other materials provided with the
13 * distribution.
14 *     * Neither the name of Google Inc. nor the names of its
15 * contributors may be used to endorse or promote products derived from
16 * this software without specific prior written permission.
17 *
18 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
19 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
20 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
21 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
22 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
23 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
24 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
25 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
26 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
27 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
28 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
29 */
30
31#include "config.h"
32#include "V8SQLTransactionSync.h"
33
34#include "V8SQLResultSet.h"
35#include "bindings/v8/ExceptionState.h"
36#include "bindings/v8/V8Binding.h"
37#include "core/dom/ExceptionCode.h"
38#include "modules/webdatabase/sqlite/SQLValue.h"
39#include "modules/webdatabase/DatabaseSync.h"
40#include "modules/webdatabase/SQLResultSet.h"
41#include "wtf/Vector.h"
42
43using namespace WTF;
44
45namespace WebCore {
46
47void V8SQLTransactionSync::executeSqlMethodCustom(const v8::FunctionCallbackInfo<v8::Value>& info)
48{
49    if (!info.Length()) {
50        setDOMException(SyntaxError, info.GetIsolate());
51        return;
52    }
53
54    V8TRYCATCH_FOR_V8STRINGRESOURCE_VOID(V8StringResource<>, statement, info[0]);
55
56    Vector<SQLValue> sqlValues;
57
58    if (info.Length() > 1 && !isUndefinedOrNull(info[1])) {
59        if (!info[1]->IsObject()) {
60            setDOMException(TypeMismatchError, info.GetIsolate());
61            return;
62        }
63
64        uint32_t sqlArgsLength = 0;
65        v8::Local<v8::Object> sqlArgsObject = info[1]->ToObject();
66        V8TRYCATCH_VOID(v8::Local<v8::Value>, length, sqlArgsObject->Get(v8AtomicString(info.GetIsolate(), "length")));
67
68        if (isUndefinedOrNull(length))
69            sqlArgsLength = sqlArgsObject->GetPropertyNames()->Length();
70        else
71            sqlArgsLength = length->Uint32Value();
72
73        for (unsigned int i = 0; i < sqlArgsLength; ++i) {
74            v8::Handle<v8::Integer> key = v8::Integer::New(i, info.GetIsolate());
75            V8TRYCATCH_VOID(v8::Local<v8::Value>, value, sqlArgsObject->Get(key));
76
77            if (value.IsEmpty() || value->IsNull())
78                sqlValues.append(SQLValue());
79            else if (value->IsNumber()) {
80                V8TRYCATCH_VOID(double, sqlValue, value->NumberValue());
81                sqlValues.append(SQLValue(sqlValue));
82            } else {
83                V8TRYCATCH_FOR_V8STRINGRESOURCE_VOID(V8StringResource<>, sqlValue, value);
84                sqlValues.append(SQLValue(sqlValue));
85            }
86        }
87    }
88
89    SQLTransactionSync* transaction = V8SQLTransactionSync::toNative(info.Holder());
90
91    ExceptionState exceptionState(info.Holder(), info.GetIsolate());
92    v8::Handle<v8::Value> result = toV8(transaction->executeSQL(statement, sqlValues, exceptionState), info.Holder(), info.GetIsolate());
93    if (exceptionState.throwIfNeeded())
94        return;
95
96    v8SetReturnValue(info, result);
97}
98
99} // namespace WebCore
100