// Copyright (c) 2022 Klemens D. Morgenstern
//
// Distributed under the Boost Software License, Version 1.0. (See accompanying
// file LICENSE_1_0.txt or copy at http://www.boost.org/LICENSE_1_0.txt)

#include <boost/sqlite/hooks.hpp>
#include <boost/sqlite/connection.hpp>
#include "test.hpp"

using namespace boost;

BOOST_AUTO_TEST_CASE(hooks)
{
  sqlite::connection conn(":memory:");
  conn.execute(
#include "test-db.sql"
  );

  bool called = false;
  auto l =
      [&](int op, core::string_view db, core::string_view table, sqlite3_int64 ) noexcept
      {
        BOOST_CHECK(op == SQLITE_INSERT);
        BOOST_CHECK(db == "main");
        BOOST_CHECK(table == "library");
        called = true;
      };


  sqlite::update_hook(conn, l);
  // language=sqlite
  conn.query(R"(
    insert into library ("name", "author") values
      ('mustache',(select id from author where first_name = 'peter'  and last_name = 'dimov'));
    )");

  BOOST_CHECK(called);

#if defined(SQLITE_ENABLE_PREUPDATE_HOOK)
  auto hk = [](sqlite::preupdate_context ctx,
               int op,
               const char * db_name,
               const char * table_name,
               sqlite3_int64 current_key,
               sqlite3_int64 new_key) noexcept
  {

  };

  preupdate_hook(conn, hk);
#endif
}