OLD | NEW |
1 /* | 1 /* |
2 * Copyright (C) 2007 Apple Inc. All rights reserved. | 2 * Copyright (C) 2007 Apple Inc. All rights reserved. |
3 * Copyright (C) 2010 Google Inc. All rights reserved. | 3 * Copyright (C) 2010 Google Inc. All rights reserved. |
4 * | 4 * |
5 * Redistribution and use in source and binary forms, with or without | 5 * Redistribution and use in source and binary forms, with or without |
6 * modification, are permitted provided that the following conditions | 6 * modification, are permitted provided that the following conditions |
7 * are met: | 7 * are met: |
8 * | 8 * |
9 * 1. Redistributions of source code must retain the above copyright | 9 * 1. Redistributions of source code must retain the above copyright |
10 * notice, this list of conditions and the following disclaimer. | 10 * notice, this list of conditions and the following disclaimer. |
(...skipping 46 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
57 SQLiteDatabase* database = &db->sqliteDatabase(); | 57 SQLiteDatabase* database = &db->sqliteDatabase(); |
58 | 58 |
59 SQLiteStatement statement(*database, m_statement); | 59 SQLiteStatement statement(*database, m_statement); |
60 int result = statement.prepare(); | 60 int result = statement.prepare(); |
61 if (result != SQLResultOk) { | 61 if (result != SQLResultOk) { |
62 if (result == SQLResultInterrupt) | 62 if (result == SQLResultInterrupt) |
63 exceptionState.throwDOMException(SQLDatabaseError, "Connection to th
e database interrupted."); | 63 exceptionState.throwDOMException(SQLDatabaseError, "Connection to th
e database interrupted."); |
64 else | 64 else |
65 exceptionState.throwDOMException(SyntaxError, "Could not prepare sta
tement."); | 65 exceptionState.throwDOMException(SyntaxError, "Could not prepare sta
tement."); |
66 db->setLastErrorMessage("could not prepare statement", result, database-
>lastErrorMsg()); | 66 db->setLastErrorMessage("could not prepare statement", result, database-
>lastErrorMsg()); |
67 return 0; | 67 return nullptr; |
68 } | 68 } |
69 | 69 |
70 if (statement.bindParameterCount() != m_arguments.size()) { | 70 if (statement.bindParameterCount() != m_arguments.size()) { |
71 if (db->isInterrupted()) | 71 if (db->isInterrupted()) |
72 exceptionState.throwDOMException(SQLDatabaseError, "Connection to th
e database interrupted."); | 72 exceptionState.throwDOMException(SQLDatabaseError, "Connection to th
e database interrupted."); |
73 else | 73 else |
74 exceptionState.throwDOMException(SyntaxError, "Number of '?'s in sta
tement string (" + String::number(statement.bindParameterCount()) + ") does not
match the arguments provided (" + String::number(m_arguments.size()) + ")."); | 74 exceptionState.throwDOMException(SyntaxError, "Number of '?'s in sta
tement string (" + String::number(statement.bindParameterCount()) + ") does not
match the arguments provided (" + String::number(m_arguments.size()) + ")."); |
75 db->setLastErrorMessage("number of '?'s in statement string does not mat
ch argument count"); | 75 db->setLastErrorMessage("number of '?'s in statement string does not mat
ch argument count"); |
76 return 0; | 76 return nullptr; |
77 } | 77 } |
78 | 78 |
79 for (unsigned i = 0; i < m_arguments.size(); ++i) { | 79 for (unsigned i = 0; i < m_arguments.size(); ++i) { |
80 result = statement.bindValue(i + 1, m_arguments[i]); | 80 result = statement.bindValue(i + 1, m_arguments[i]); |
81 if (result == SQLResultFull) { | 81 if (result == SQLResultFull) { |
82 exceptionState.throwDOMException(QuotaExceededError, SQLError::quota
ExceededErrorMessage); | 82 exceptionState.throwDOMException(QuotaExceededError, SQLError::quota
ExceededErrorMessage); |
83 db->setLastErrorMessage("there was not enough remaining storage spac
e"); | 83 db->setLastErrorMessage("there was not enough remaining storage spac
e"); |
84 return 0; | 84 return nullptr; |
85 } | 85 } |
86 | 86 |
87 if (result != SQLResultOk) { | 87 if (result != SQLResultOk) { |
88 exceptionState.throwDOMException(SQLDatabaseError, "Could not bind v
alue."); | 88 exceptionState.throwDOMException(SQLDatabaseError, "Could not bind v
alue."); |
89 db->setLastErrorMessage("could not bind value", result, database->la
stErrorMsg()); | 89 db->setLastErrorMessage("could not bind value", result, database->la
stErrorMsg()); |
90 return 0; | 90 return nullptr; |
91 } | 91 } |
92 } | 92 } |
93 | 93 |
94 RefPtr<SQLResultSet> resultSet = SQLResultSet::create(); | 94 RefPtr<SQLResultSet> resultSet = SQLResultSet::create(); |
95 | 95 |
96 // Step so we can fetch the column names. | 96 // Step so we can fetch the column names. |
97 result = statement.step(); | 97 result = statement.step(); |
98 if (result == SQLResultRow) { | 98 if (result == SQLResultRow) { |
99 int columnCount = statement.columnCount(); | 99 int columnCount = statement.columnCount(); |
100 SQLResultSetRowList* rows = resultSet->rows(); | 100 SQLResultSetRowList* rows = resultSet->rows(); |
101 | 101 |
102 for (int i = 0; i < columnCount; i++) | 102 for (int i = 0; i < columnCount; i++) |
103 rows->addColumn(statement.getColumnName(i)); | 103 rows->addColumn(statement.getColumnName(i)); |
104 | 104 |
105 do { | 105 do { |
106 for (int i = 0; i < columnCount; i++) | 106 for (int i = 0; i < columnCount; i++) |
107 rows->addResult(statement.getColumnValue(i)); | 107 rows->addResult(statement.getColumnValue(i)); |
108 | 108 |
109 result = statement.step(); | 109 result = statement.step(); |
110 } while (result == SQLResultRow); | 110 } while (result == SQLResultRow); |
111 | 111 |
112 if (result != SQLResultDone) { | 112 if (result != SQLResultDone) { |
113 exceptionState.throwDOMException(SQLDatabaseError, "Could not iterat
e results."); | 113 exceptionState.throwDOMException(SQLDatabaseError, "Could not iterat
e results."); |
114 db->setLastErrorMessage("could not iterate results", result, databas
e->lastErrorMsg()); | 114 db->setLastErrorMessage("could not iterate results", result, databas
e->lastErrorMsg()); |
115 return 0; | 115 return nullptr; |
116 } | 116 } |
117 } else if (result == SQLResultDone) { | 117 } else if (result == SQLResultDone) { |
118 // Didn't find anything, or was an insert. | 118 // Didn't find anything, or was an insert. |
119 if (db->lastActionWasInsert()) | 119 if (db->lastActionWasInsert()) |
120 resultSet->setInsertId(database->lastInsertRowID()); | 120 resultSet->setInsertId(database->lastInsertRowID()); |
121 } else if (result == SQLResultFull) { | 121 } else if (result == SQLResultFull) { |
122 // Quota error, the delegate will be asked for more space and this state
ment might be re-run. | 122 // Quota error, the delegate will be asked for more space and this state
ment might be re-run. |
123 exceptionState.throwDOMException(QuotaExceededError, SQLError::quotaExce
ededErrorMessage); | 123 exceptionState.throwDOMException(QuotaExceededError, SQLError::quotaExce
ededErrorMessage); |
124 db->setLastErrorMessage("there was not enough remaining storage space"); | 124 db->setLastErrorMessage("there was not enough remaining storage space"); |
125 return 0; | 125 return nullptr; |
126 } else if (result == SQLResultConstraint) { | 126 } else if (result == SQLResultConstraint) { |
127 exceptionState.throwDOMException(ConstraintError, "A constraint was viol
ated."); | 127 exceptionState.throwDOMException(ConstraintError, "A constraint was viol
ated."); |
128 db->setLastErrorMessage("statement failed due to a constraint failure"); | 128 db->setLastErrorMessage("statement failed due to a constraint failure"); |
129 return 0; | 129 return nullptr; |
130 } else { | 130 } else { |
131 exceptionState.throwDOMException(SQLDatabaseError, "Could not execute st
atement."); | 131 exceptionState.throwDOMException(SQLDatabaseError, "Could not execute st
atement."); |
132 db->setLastErrorMessage("could not execute statement", result, database-
>lastErrorMsg()); | 132 db->setLastErrorMessage("could not execute statement", result, database-
>lastErrorMsg()); |
133 return 0; | 133 return nullptr; |
134 } | 134 } |
135 | 135 |
136 resultSet->setRowsAffected(database->lastChanges()); | 136 resultSet->setRowsAffected(database->lastChanges()); |
137 return resultSet.release(); | 137 return resultSet.release(); |
138 } | 138 } |
139 | 139 |
140 } // namespace WebCore | 140 } // namespace WebCore |
OLD | NEW |