#include <gtest/gtest.h>

#include <filesystem>
#include <memory>
#include <string>
#include <system_error>

#include "libreichwein/file.h"

#include "config.h"
#include "storage.h"
#include "whiteboard.h"

namespace fs = std::filesystem;

namespace {
 const std::string testDbFilename{"./whiteboard.db3"};
}

class CompiledSQLTest: public ::testing::Test
{
protected:
 CompiledSQLTest(){
 }

 ~CompiledSQLTest() override{
 }

 void SetUp() override
 {
  std::error_code ec;
  fs::remove(testDbFilename, ec);
 }

 void TearDown() override
 {
  std::error_code ec;
  fs::remove(testDbFilename, ec);
 }

};

TEST_F(CompiledSQLTest, create)
{
 SQLite::Database db{testDbFilename, SQLite::OPEN_READWRITE | SQLite::OPEN_CREATE};

 {
  CompiledSQL stmt1{db, "CREATE TABLE documents (id VARCHAR(16) PRIMARY KEY)"};
  CompiledSQL::Guard g{stmt1};
  stmt1.execute();
 }

 {
  CompiledSQL stmt2{db, "INSERT INTO documents (id) values (?)"};
  CompiledSQL::Guard g{stmt2};
  stmt2.bind(1, "abc");
  ASSERT_TRUE(stmt2.execute());
 }

 {
  CompiledSQL stmt3{db, "SELECT id FROM documents WHERE id = ?"};
  CompiledSQL::Guard g{stmt3};
  stmt3.bind(1, "abc");
  ASSERT_TRUE(stmt3.execute());
  EXPECT_EQ(stmt3.getColumn<std::string>(0), "abc");
 }

 {
  CompiledSQL stmt4{db, "SELECT id FROM documents WHERE id = ?"};
  CompiledSQL::Guard g{stmt4};
  stmt4.bind(1, "def");
  ASSERT_FALSE(stmt4.execute());
 }

 EXPECT_TRUE(fs::exists(testDbFilename));
}