| LEFT | RIGHT |
|---|
| 1 // Copyright 2008, Google Inc. | 1 // Copyright 2008, Google Inc. |
| 2 // | 2 // |
| 3 // Redistribution and use in source and binary forms, with or without | 3 // Redistribution and use in source and binary forms, with or without |
| 4 // modification, are permitted provided that the following conditions are met: | 4 // modification, are permitted provided that the following conditions are met: |
| 5 // | 5 // |
| 6 // 1. Redistributions of source code must retain the above copyright notice, | 6 // 1. Redistributions of source code must retain the above copyright notice, |
| 7 // this list of conditions and the following disclaimer. | 7 // this list of conditions and the following disclaimer. |
| 8 // 2. Redistributions in binary form must reproduce the above copyright notice, | 8 // 2. Redistributions in binary form must reproduce the above copyright notice, |
| 9 // this list of conditions and the following disclaimer in the documentation | 9 // this list of conditions and the following disclaimer in the documentation |
| 10 // and/or other materials provided with the distribution. | 10 // and/or other materials provided with the distribution. |
| 11 // 3. Neither the name of Google Inc. nor the names of its contributors may be | 11 // 3. Neither the name of Google Inc. nor the names of its contributors may be |
| 12 // used to endorse or promote products derived from this software without | 12 // used to endorse or promote products derived from this software without |
| 13 // specific prior written permission. | 13 // specific prior written permission. |
| 14 // | 14 // |
| 15 // THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR IMPLIED | 15 // THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR IMPLIED |
| 16 // WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF | 16 // WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF |
| 17 // MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO | 17 // MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO |
| 18 // EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, | 18 // EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, |
| 19 // SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, | 19 // SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, |
| 20 // PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; | 20 // PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; |
| 21 // OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, | 21 // OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, |
| 22 // WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR | 22 // WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR |
| 23 // OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF | 23 // OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF |
| 24 // ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | 24 // ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
| 25 | 25 |
| 26 #include "gears/database2/statement.h" | 26 #include "gears/database2/statement.h" |
| 27 |
| 27 #include "gears/database2/transaction.h" | 28 #include "gears/database2/transaction.h" |
| 28 | 29 |
| 29 void Database2Statement::InvokeCallback(Database2Transaction *tx) { | 30 void Database2Statement::InvokeCallback(Database2Transaction *tx) { |
| 30 // for now, just return the Database2Statement | 31 // for now, just return the Database2Statement |
| 31 JsParamToSend send_argv[] = { | 32 JsParamToSend send_argv[] = { |
| 32 { JSPARAM_STRING16, &sql_statement_ } | 33 { JSPARAM_STRING16, &sql_statement_ } |
| 33 }; | 34 }; |
| 34 | 35 |
| 35 if (HasCallback()) { | 36 if (HasCallback()) { |
| 36 tx->GetJsRunner()->InvokeCallback(callback_.get(), ARRAYSIZE(send_argv), | 37 tx->GetJsRunner()->InvokeCallback(callback_.get(), ARRAYSIZE(send_argv), |
| 37 send_argv, NULL); | 38 send_argv, NULL); |
| 38 } | 39 } |
| 39 } | 40 } |
| 40 | 41 |
| 41 void Database2Statement::InvokeErrorCallback(Database2Transaction *tx, | 42 void Database2Statement::InvokeErrorCallback(Database2Transaction *tx, |
| 42 JsObject *error) { | 43 JsObject *error) { |
| 43 } | 44 } |
| 44 | 45 |
| 45 bool Database2Statement::Create(const std::string16 &sql_statement, | 46 bool Database2Statement::Create(const std::string16 &sql_statement, |
| 46 JsArray *sql_arguments, | 47 JsArray *sql_arguments, |
| 47 JsRootedCallback *callback, | 48 JsRootedCallback *callback, |
| 48 JsRootedCallback *error_callback, | 49 JsRootedCallback *error_callback, |
| 49 Database2Statement **instance) { | 50 Database2Statement **instance) { |
| 50 scoped_ptr<Database2Statement> statement(new Database2Statement()); | 51 scoped_ptr<Database2Statement> statement(new Database2Statement()); |
| 51 | 52 |
| 52 // NULL should be passed if no arguments are specified | 53 // NULL should be passed if no arguments are specified |
| 53 assert(!sql_arguments || !JsTokenIsNullOrUndefined(sql_arguments->token())); | 54 assert(!sql_arguments || !JsTokenIsNullOrUndefined(sql_arguments->token())); |
| 54 // NULL should be passed if a callback is not specified | 55 // NULL should be passed if a callback is not specified |
| 55 assert(!callback || !JsTokenIsNullOrUndefined(callback->token())); | 56 assert(!callback || !JsTokenIsNullOrUndefined(callback->token())); |
| 56 assert(!error_callback || !JsTokenIsNullOrUndefined(error_callback->token())); | 57 assert(!error_callback || !JsTokenIsNullOrUndefined(error_callback->token())); |
| 57 | 58 |
| 58 statement->sql_statement_.assign(sql_statement); | 59 statement->sql_statement_.assign(sql_statement); |
| 59 statement->callback_.reset(callback); | 60 statement->callback_.reset(callback); |
| 60 statement->error_callback_.reset(error_callback); | 61 statement->error_callback_.reset(error_callback); |
| 61 | 62 |
| 62 Database2Values *arguments; | 63 Database2Values *arguments; |
| 63 if (!Database2Values::CreateFromJsArray(sql_arguments, &arguments)) { | 64 if (!Database2Values::CreateFromJsArray(sql_arguments, &arguments)) { |
| 64 return false; | 65 return false; |
| 65 } | 66 } |
| 66 | 67 |
| 67 statement->arguments_.reset(arguments); | 68 statement->arguments_.reset(arguments); |
| 68 | 69 |
| 69 *instance = statement.release(); | 70 *instance = statement.release(); |
| 70 return true; | 71 return true; |
| 71 } | 72 } |
| 72 | 73 |
| 73 // static | 74 // static |
| 74 bool Database2Values::CreateFromJsArray(const JsArray *js_array, | 75 bool Database2Values::CreateFromJsArray(const JsArray *sql_arguments, |
| 75 Database2Values **instance) { | 76 Database2Values **instance) { |
| 76 assert(instance && *instance); | 77 scoped_ptr<Database2Values> result; |
| 77 | 78 result.reset(new Database2Values()); |
| 78 scoped_ptr<Database2Values> result(new Database2Values()); | |
| 79 | 79 |
| 80 // since the arguments are optional, they could be passed as NULL | 80 // since the arguments are optional, they could be passed as NULL |
| 81 if (js_array == NULL) { | 81 if (sql_arguments == NULL) { |
| 82 result->arguments_.reset(NULL); |
| 82 result->length_ = 0; | 83 result->length_ = 0; |
| 83 *instance = result.release(); | 84 *instance = result.release(); |
| 84 return true; | 85 return true; |
| 85 } | 86 } |
| 86 | 87 |
| 87 int len; | 88 int len; |
| 88 if (!js_array->GetLength(&len)) { | 89 if (!sql_arguments->GetLength(&len)) { |
| 89 // unable to query JsArray, someting's gone horribly wrong | 90 // unable to query JsArray, someting's gone horribly wrong |
| 90 // returning with failure will trigger an internal error | 91 // returning with failure will trigger an internal error |
| 91 assert(false); | 92 assert(false); |
| 92 return false; | 93 return false; |
| 93 } | 94 } |
| 94 | 95 |
| 95 result->length_ = len; | 96 result->length_ = len; |
| 96 // a JsArray produces one row of values | 97 |
| 97 result->StartNewRow(); | 98 result->arguments_.reset(new JsParamToSend[len]); |
| 98 Variant *row = result->rows_.back(); | |
| 99 for(int i = 0; i < len; i++) { | 99 for(int i = 0; i < len; i++) { |
| 100 switch(js_array->GetElementType(i)) { | 100 if (!SetJsParamToSend(sql_arguments, i, result->arguments_.get())) { |
| 101 case JSPARAM_INT: { | 101 // one invalid argument make the whole statement bogus |
| 102 int value; | 102 // no need to process any more parameters |
| 103 if (!js_array->GetElementAsInt(i, &value)) { | 103 // set length to only include last processed parameter |
| 104 return false; | 104 result->length_ = i; |
| 105 } | 105 return false; |
| 106 row[i].type = JSPARAM_INT; | 106 } |
| 107 row[i].int_value = value; | 107 } |
| 108 break; | 108 |
| 109 *instance = result.release(); |
| 110 return true; |
| 111 } |
| 112 |
| 113 // static |
| 114 bool Database2Values::SetJsParamToSend(const JsArray *js_array, |
| 115 int index, |
| 116 JsParamToSend *arguments) { |
| 117 assert(index >= 0 && arguments); |
| 118 JsParamToSend *param = &arguments[index]; |
| 119 param->type = js_array->GetElementType(index); |
| 120 switch(param->type) { |
| 121 case JSPARAM_INT: { |
| 122 scoped_ptr<int> value; |
| 123 value.reset(new int); |
| 124 if (js_array->GetElementAsInt(index, value.get())) { |
| 125 param->value_ptr = value.release(); |
| 126 return true; |
| 109 } | 127 } |
| 110 case JSPARAM_DOUBLE: { | 128 return false; |
| 111 double value; | 129 } |
| 112 if (!js_array->GetElementAsDouble(i, &value)) { | 130 case JSPARAM_DOUBLE: { |
| 113 return false; | 131 scoped_ptr<double> value; |
| 114 } | 132 value.reset(new double); |
| 115 row[i].type = JSPARAM_DOUBLE; | 133 if (js_array->GetElementAsDouble(index, value.get())) { |
| 116 row[i].double_value = value; | 134 param->value_ptr = value.release(); |
| 117 break; | 135 return true; |
| 118 } | 136 } |
| 119 case JSPARAM_STRING16: { | 137 return false; |
| 120 std::string16 value; | 138 } |
| 121 if (!js_array->GetElementAsString(i, &value)) { | 139 case JSPARAM_STRING16: { |
| 122 return false; | 140 scoped_ptr<std::string16> value; |
| 123 } | 141 value.reset(new std::string16()); |
| 124 row[i].type = JSPARAM_STRING16; | 142 if (js_array->GetElementAsString(index, value.get())) { |
| 125 row[i].string_value = new std::string16(value); | 143 param->value_ptr = value.release(); |
| 126 break; | 144 return true; |
| 127 } | 145 } |
| 128 case JSPARAM_NULL: { | 146 return false; |
| 147 } |
| 148 case JSPARAM_NULL: { |
| 149 param->value_ptr = NULL; |
| 150 return true; |
| 151 } |
| 152 } |
| 153 // all other types are considered invalid |
| 154 return false; |
| 155 } |
| 156 |
| 157 JsParamType Database2Values::GetType(int index) const { |
| 158 assert(index >= 0 && index < length_); |
| 159 return arguments_[index].type; |
| 160 } |
| 161 |
| 162 int Database2Values::GetAsInt(int index) const { |
| 163 assert(index >= 0 && index < length_); |
| 164 JsParamToSend param = arguments_[index]; |
| 165 assert(param.type == JSPARAM_INT); |
| 166 return *static_cast<int*>(const_cast<void*>(param.value_ptr)); |
| 167 } |
| 168 |
| 169 double Database2Values::GetAsDouble(int index) const { |
| 170 assert(index >= 0 && index < length_); |
| 171 JsParamToSend param = arguments_[index]; |
| 172 assert(param.type == JSPARAM_DOUBLE); |
| 173 return *static_cast<int*>(const_cast<void*>(param.value_ptr)); |
| 174 } |
| 175 |
| 176 std::string16 &Database2Values::GetAsString(int index) const { |
| 177 assert(index >= 0 && index < length_); |
| 178 JsParamToSend param = arguments_[index]; |
| 179 assert(param.type == JSPARAM_STRING16); |
| 180 return *static_cast<std::string16*>(const_cast<void*>(param.value_ptr)); |
| 181 } |
| 182 |
| 183 Database2Values::~Database2Values() { |
| 184 // dispose of the data, pointed to the value_ptrs |
| 185 for(int i = 0; i < length_; i++) { |
| 186 JsParamToSend param = arguments_[i]; |
| 187 if (param.value_ptr) delete param.value_ptr; |
| 188 } |
| 189 } |
| LEFT | RIGHT |
|---|
