Misc. warning fixes/cleanup

sql/test/test_helpers.cc

 // Copyright 2013 The Chromium Authors. All rights reserved.
 // Use of this source code is governed by a BSD-style license that can be
 // found in the LICENSE file.
 
 #include "sql/test/test_helpers.h"
 
 #include <string>
 
 #include "base/files/file_util.h"
 #include "base/files/scoped_file.h"
@@ skipping 74 matching lines @@
   if (1u != fread(header, sizeof(header), 1, file.get()))
     return false;
 
   int64 db_size = 0;
   if (!base::GetFileSize(db_path, &db_size))
     return false;
 
   const unsigned page_size = ReadBigEndian(header + kPageSizeOffset, 2);
 
   // One larger than the expected size.
-  const unsigned page_count = (db_size + page_size) / page_size;
+  const unsigned page_count =
+      static_cast<unsigned>((db_size + page_size) / page_size);
   WriteBigEndian(page_count, header + kPageCountOffset, 4);
 
   // Update change count so outstanding readers know the info changed.
   // Both spots must match for the page count to be considered valid.
   unsigned change_count = ReadBigEndian(header + kFileChangeCountOffset, 4);
   WriteBigEndian(change_count + 1, header + kFileChangeCountOffset, 4);
   WriteBigEndian(change_count + 1, header + kVersionValidForOffset, 4);
 
   if (0 != fseek(file.get(), 0, SEEK_SET))
     return false;
@@ skipping 99 matching lines @@
 bool CountTableRows(sql::Connection* db, const char* table, size_t* count) {
   // TODO(shess): Table should probably be quoted with [] or "".  See
   // http://www.sqlite.org/lang_keywords.html .  Meanwhile, odd names
   // will throw an error.
   std::string sql = "SELECT COUNT(*) FROM ";
   sql += table;
   sql::Statement s(db->GetUniqueStatement(sql.c_str()));
   if (!s.Step())
     return false;
 
-  *count = s.ColumnInt64(0);
+  *count = static_cast<size_t>(s.ColumnInt64(0));
   return true;
 }
 
 bool CreateDatabaseFromSQL(const base::FilePath& db_path,
                            const base::FilePath& sql_path) {
   if (base::PathExists(db_path) || !base::PathExists(sql_path))
     return false;
 
   std::string sql;
   if (!base::ReadFileToString(sql_path, &sql))
@@ skipping 16 matching lines @@
   sql::Statement statement(db->GetUniqueStatement("PRAGMA integrity_check"));
 
   // SQLite should always return a row of data.
   EXPECT_TRUE(statement.Step());
 
   return statement.ColumnString(0);
 }
 
 }  // namespace test
 }  // namespace sql