| OLD | NEW |
| 1 // Copyright 2014 The Chromium Authors. All rights reserved. | 1 // Copyright 2014 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 <stddef.h> | 5 #include <stddef.h> |
| 6 | 6 |
| 7 #include "base/bind.h" | 7 #include "base/bind.h" |
| 8 #include "base/strings/string_util.h" | 8 #include "base/strings/string_util.h" |
| 9 #include "base/strings/utf_string_conversions.h" | 9 #include "base/strings/utf_string_conversions.h" |
| 10 #include "sql/connection.h" | 10 #include "sql/connection.h" |
| (...skipping 11 matching lines...) Expand all Loading... |
| 22 | 22 |
| 23 static void CheckDetailsAreEqual(const DatabaseDetails& d1, | 23 static void CheckDetailsAreEqual(const DatabaseDetails& d1, |
| 24 const DatabaseDetails& d2) { | 24 const DatabaseDetails& d2) { |
| 25 EXPECT_EQ(d1.origin_identifier, d2.origin_identifier); | 25 EXPECT_EQ(d1.origin_identifier, d2.origin_identifier); |
| 26 EXPECT_EQ(d1.database_name, d2.database_name); | 26 EXPECT_EQ(d1.database_name, d2.database_name); |
| 27 EXPECT_EQ(d1.description, d2.description); | 27 EXPECT_EQ(d1.description, d2.description); |
| 28 EXPECT_EQ(d1.estimated_size, d2.estimated_size); | 28 EXPECT_EQ(d1.estimated_size, d2.estimated_size); |
| 29 } | 29 } |
| 30 | 30 |
| 31 static bool DatabasesTableIsEmpty(sql::Connection* db) { | 31 static bool DatabasesTableIsEmpty(sql::Connection* db) { |
| 32 sql::Statement statement(db->GetCachedStatement( | 32 sql::Statement statement( |
| 33 SQL_FROM_HERE, "SELECT COUNT(*) FROM Databases")); | 33 db->GetCachedStatement(SQL_FROM_HERE, "SELECT COUNT(*) FROM Databases")); |
| 34 return (statement.is_valid() && statement.Step() && !statement.ColumnInt(0)); | 34 return (statement.is_valid() && statement.Step() && !statement.ColumnInt(0)); |
| 35 } | 35 } |
| 36 | 36 |
| 37 TEST(DatabasesTableTest, TestIt) { | 37 TEST(DatabasesTableTest, TestIt) { |
| 38 // Initialize the 'Databases' table. | 38 // Initialize the 'Databases' table. |
| 39 sql::Connection db; | 39 sql::Connection db; |
| 40 | 40 |
| 41 sql::test::ScopedErrorExpecter expecter; | 41 sql::test::ScopedErrorExpecter expecter; |
| 42 // TODO(shess): Suppressing SQLITE_CONSTRAINT because the code | 42 // TODO(shess): Suppressing SQLITE_CONSTRAINT because the code |
| 43 // expects that and handles the resulting error. Consider revising | 43 // expects that and handles the resulting error. Consider revising |
| (...skipping 14 matching lines...) Expand all Loading... |
| 58 DatabaseDetails details_in1; | 58 DatabaseDetails details_in1; |
| 59 DatabaseDetails details_out1; | 59 DatabaseDetails details_out1; |
| 60 details_in1.origin_identifier = "origin1"; | 60 details_in1.origin_identifier = "origin1"; |
| 61 details_in1.database_name = ASCIIToUTF16("db1"); | 61 details_in1.database_name = ASCIIToUTF16("db1"); |
| 62 details_in1.description = ASCIIToUTF16("description_db1"); | 62 details_in1.description = ASCIIToUTF16("description_db1"); |
| 63 details_in1.estimated_size = 100; | 63 details_in1.estimated_size = 100; |
| 64 | 64 |
| 65 // Updating details for this database should fail. | 65 // Updating details for this database should fail. |
| 66 EXPECT_FALSE(databases_table.UpdateDatabaseDetails(details_in1)); | 66 EXPECT_FALSE(databases_table.UpdateDatabaseDetails(details_in1)); |
| 67 EXPECT_FALSE(databases_table.GetDatabaseDetails( | 67 EXPECT_FALSE(databases_table.GetDatabaseDetails( |
| 68 details_in1.origin_identifier, | 68 details_in1.origin_identifier, details_in1.database_name, &details_out1)); |
| 69 details_in1.database_name, | |
| 70 &details_out1)); | |
| 71 | 69 |
| 72 // Inserting details for this database should pass. | 70 // Inserting details for this database should pass. |
| 73 EXPECT_TRUE(databases_table.InsertDatabaseDetails(details_in1)); | 71 EXPECT_TRUE(databases_table.InsertDatabaseDetails(details_in1)); |
| 74 EXPECT_TRUE(databases_table.GetDatabaseDetails( | 72 EXPECT_TRUE(databases_table.GetDatabaseDetails( |
| 75 details_in1.origin_identifier, | 73 details_in1.origin_identifier, details_in1.database_name, &details_out1)); |
| 76 details_in1.database_name, | |
| 77 &details_out1)); | |
| 78 EXPECT_EQ(1, databases_table.GetDatabaseID(details_in1.origin_identifier, | 74 EXPECT_EQ(1, databases_table.GetDatabaseID(details_in1.origin_identifier, |
| 79 details_in1.database_name)); | 75 details_in1.database_name)); |
| 80 | 76 |
| 81 // Check that the details were correctly written to the database. | 77 // Check that the details were correctly written to the database. |
| 82 CheckDetailsAreEqual(details_in1, details_out1); | 78 CheckDetailsAreEqual(details_in1, details_out1); |
| 83 | 79 |
| 84 // Check that inserting a duplicate row fails. | 80 // Check that inserting a duplicate row fails. |
| 85 EXPECT_FALSE(databases_table.InsertDatabaseDetails(details_in1)); | 81 EXPECT_FALSE(databases_table.InsertDatabaseDetails(details_in1)); |
| 86 | 82 |
| 87 // Insert details for another database with the same origin. | 83 // Insert details for another database with the same origin. |
| (...skipping 32 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 120 | 116 |
| 121 // Get the list of all origins: should be "origin1" and "origin2". | 117 // Get the list of all origins: should be "origin1" and "origin2". |
| 122 std::vector<std::string> origins_out; | 118 std::vector<std::string> origins_out; |
| 123 EXPECT_TRUE(databases_table.GetAllOriginIdentifiers(&origins_out)); | 119 EXPECT_TRUE(databases_table.GetAllOriginIdentifiers(&origins_out)); |
| 124 EXPECT_EQ(size_t(2), origins_out.size()); | 120 EXPECT_EQ(size_t(2), origins_out.size()); |
| 125 EXPECT_EQ(details_in1.origin_identifier, origins_out[0]); | 121 EXPECT_EQ(details_in1.origin_identifier, origins_out[0]); |
| 126 EXPECT_EQ(details_in3.origin_identifier, origins_out[1]); | 122 EXPECT_EQ(details_in3.origin_identifier, origins_out[1]); |
| 127 | 123 |
| 128 // Delete an origin and check that it's no longer in the table. | 124 // Delete an origin and check that it's no longer in the table. |
| 129 origins_out.clear(); | 125 origins_out.clear(); |
| 130 EXPECT_TRUE(databases_table.DeleteOriginIdentifier( | 126 EXPECT_TRUE( |
| 131 details_in3.origin_identifier)); | 127 databases_table.DeleteOriginIdentifier(details_in3.origin_identifier)); |
| 132 EXPECT_TRUE(databases_table.GetAllOriginIdentifiers(&origins_out)); | 128 EXPECT_TRUE(databases_table.GetAllOriginIdentifiers(&origins_out)); |
| 133 EXPECT_EQ(size_t(1), origins_out.size()); | 129 EXPECT_EQ(size_t(1), origins_out.size()); |
| 134 EXPECT_EQ(details_in1.origin_identifier, origins_out[0]); | 130 EXPECT_EQ(details_in1.origin_identifier, origins_out[0]); |
| 135 | 131 |
| 136 // Deleting an origin that doesn't have any record in this table should fail. | 132 // Deleting an origin that doesn't have any record in this table should fail. |
| 137 EXPECT_FALSE(databases_table.DeleteOriginIdentifier("unknown_origin")); | 133 EXPECT_FALSE(databases_table.DeleteOriginIdentifier("unknown_origin")); |
| 138 | 134 |
| 139 // Delete the details for 'db1' and check that they're no longer there. | 135 // Delete the details for 'db1' and check that they're no longer there. |
| 140 EXPECT_TRUE(databases_table.DeleteDatabaseDetails( | 136 EXPECT_TRUE(databases_table.DeleteDatabaseDetails( |
| 141 details_in1.origin_identifier, details_in1.database_name)); | 137 details_in1.origin_identifier, details_in1.database_name)); |
| 142 EXPECT_FALSE(databases_table.GetDatabaseDetails( | 138 EXPECT_FALSE(databases_table.GetDatabaseDetails( |
| 143 details_in1.origin_identifier, | 139 details_in1.origin_identifier, details_in1.database_name, &details_out1)); |
| 144 details_in1.database_name, | |
| 145 &details_out1)); | |
| 146 | 140 |
| 147 // Check that trying to delete a record that doesn't exist fails. | 141 // Check that trying to delete a record that doesn't exist fails. |
| 148 EXPECT_FALSE(databases_table.DeleteDatabaseDetails( | 142 EXPECT_FALSE(databases_table.DeleteDatabaseDetails( |
| 149 "unknown_origin", ASCIIToUTF16("unknown_database"))); | 143 "unknown_origin", ASCIIToUTF16("unknown_database"))); |
| 150 | 144 |
| 151 ASSERT_TRUE(expecter.SawExpectedErrors()); | 145 ASSERT_TRUE(expecter.SawExpectedErrors()); |
| 152 } | 146 } |
| 153 | 147 |
| 154 } // namespace content | 148 } // namespace content |
| OLD | NEW |