Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(28)

Side by Side Diff: sql/statement_unittest.cc

Issue 10171014: Changed to Reset(bool clear_bound_vars) (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src
Patch Set: Created 8 years, 8 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch | Annotate | Revision Log
« sql/statement.h ('K') | « sql/statement.cc ('k') | no next file » | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
1 // Copyright (c) 2011 The Chromium Authors. All rights reserved. 1 // Copyright (c) 2011 The Chromium Authors. All rights reserved.
2 // Use of this source code is governed by a BSD-style license that can be 2 // Use of this source code is governed by a BSD-style license that can be
3 // found in the LICENSE file. 3 // found in the LICENSE file.
4 4
5 #include <string> 5 #include <string>
6 6
7 #include "base/file_util.h" 7 #include "base/file_util.h"
8 #include "base/scoped_temp_dir.h" 8 #include "base/scoped_temp_dir.h"
9 #include "sql/connection.h" 9 #include "sql/connection.h"
10 #include "sql/statement.h" 10 #include "sql/statement.h"
(...skipping 102 matching lines...) Expand 10 before | Expand all | Expand 10 after
113 // Insert in the foo table the primary key. It is an error to insert 113 // Insert in the foo table the primary key. It is an error to insert
114 // something other than an number. This error causes the error callback 114 // something other than an number. This error causes the error callback
115 // handler to be called with SQLITE_MISMATCH as error code. 115 // handler to be called with SQLITE_MISMATCH as error code.
116 sql::Statement s(db().GetUniqueStatement("INSERT INTO foo (a) VALUES (?)")); 116 sql::Statement s(db().GetUniqueStatement("INSERT INTO foo (a) VALUES (?)"));
117 EXPECT_TRUE(s.is_valid()); 117 EXPECT_TRUE(s.is_valid());
118 s.BindCString(0, "bad bad"); 118 s.BindCString(0, "bad bad");
119 EXPECT_FALSE(s.Run()); 119 EXPECT_FALSE(s.Run());
120 EXPECT_EQ(SQLITE_MISMATCH, sqlite_error()); 120 EXPECT_EQ(SQLITE_MISMATCH, sqlite_error());
121 reset_error(); 121 reset_error();
122 } 122 }
123
124 TEST_F(SQLStatementTest, ResetWithoutClearingBoundVariables) {
125 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)"));
126 ASSERT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (3, 12)"));
127 ASSERT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (4, 13)"));
128
129 sql::Statement s(db().GetUniqueStatement("SELECT b FROM foo ORDER BY a ASC"));
130 ASSERT_TRUE(s.Step());
131 EXPECT_EQ(12, s.ColumnInt(0));
132 ASSERT_TRUE(s.Step());
133 EXPECT_EQ(13, s.ColumnInt(0));
134 EXPECT_FALSE(s.Step());
135
136 s.ResetWithoutClearingBoundVariables();
137 // Verify that we can get all rows again.
138 ASSERT_TRUE(s.Step());
139 EXPECT_EQ(12, s.ColumnInt(0));
140 ASSERT_TRUE(s.Step());
141 EXPECT_EQ(13, s.ColumnInt(0));
142 EXPECT_FALSE(s.Step());
143 }
OLDNEW
« sql/statement.h ('K') | « sql/statement.cc ('k') | no next file » | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698