SQliteHelpersTests.cpp File Reference

#include <catch2/catch.hpp>
#include "sqlite/Connection.h"

Include dependency graph for SQliteHelpersTests.cpp:

Go to the source code of this file.

Functions
	TEST_CASE ("SQLiteHelpers", "")

Function Documentation

TEST_CASE()

TEST_CASE	(	"SQLiteHelpers"	,
		""
	)

Definition at line 11 of file SQliteHelpersTests.cpp.

{
   using namespace audacity::sqlite;
 
   auto connection = Connection::Open(":memory:", OpenMode::Memory);
   REQUIRE(connection);
   REQUIRE(connection->CheckTableExists("test") == false);
   REQUIRE(!!connection->Execute(
      "CREATE TABLE test (id INTEGER PRIMARY KEY, name TEXT);"));
   REQUIRE(connection->CheckTableExists("test") == true);
   REQUIRE(!!connection->Execute("INSERT INTO test (name) VALUES ('test1');"));
 
   {
      auto stmt =
         connection->CreateStatement("INSERT INTO test (name) VALUES (?);");
 
      REQUIRE(stmt);
      auto& ctx = stmt->Prepare();
      ctx.Bind(1, "test2");
      auto run1 = ctx.Run();
      REQUIRE(run1.IsOk());
      REQUIRE(run1.HasRows() == false);
 
      ctx.Bind(1, "test3");
      auto run2 = ctx.Run();
      REQUIRE(run2.IsOk());
      REQUIRE(run2.HasRows() == false);
   }
 
   {
      auto stmt = connection->CreateStatement("SELECT * FROM test;");
 
      REQUIRE(stmt);
      auto run = stmt->Prepare().Run();
 
      REQUIRE(run.IsOk());
      REQUIRE(run.HasRows() == true);
 
      int rowId = 1;
 
      for (auto row : run)
      {
         int id;
         std::string name;
 
         REQUIRE(row.Get(0, id));
         REQUIRE(row.Get(1, name));
         REQUIRE(!row.Get(2, id));
 
         REQUIRE(rowId == id);
         REQUIRE(name == "test" + std::to_string(rowId));
 
         ++rowId;
      }
 
      REQUIRE(rowId == 4);
   }
}

References id, and name.