/*
 * @project      The CERN Tape Archive (CTA)
 * @copyright    Copyright © 2021-2022 CERN
 * @license      This program is free software, distributed under the terms of the GNU General Public
 *               Licence version 3 (GPL Version 3), copied verbatim in the file "COPYING". You can
 *               redistribute it and/or modify it under the terms of the GPL Version 3, or (at your
 *               option) any later version.
 *
 *               This program is distributed in the hope that it will be useful, but WITHOUT ANY
 *               WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A
 *               PARTICULAR PURPOSE. See the GNU General Public License for more details.
 *
 *               In applying this licence, CERN does not waive the privileges and immunities
 *               granted to it by virtue of its status as an Intergovernmental Organization or
 *               submit itself to any jurisdiction.
 */

#pragma once
#include "rdbms/Login.hpp"
#include "rdbms/ConnPool.hpp"

namespace cta::catalogue {

  /**
   * This class is used to create a InMemory SQLiteSchema from sql statements
   * 
   * @param sqliteConn the connection of the InMemory SQLite schema
   */
  class SQLiteSchemaInserter {
  public:
    /**
     * Constructor
     * @param sqliteConn the connection of the InMemory SQLite schema
     */
    explicit SQLiteSchemaInserter(rdbms::Conn& sqliteConn);
    /**
     * Transform and insert the schema statements passed in parameter into the
     * InMemory SQLite database
     */
    void insert(const std::list<std::string> &schemaStatements);    
    virtual ~SQLiteSchemaInserter() = default;
    
  private:
    cta::rdbms::Conn & m_sqliteCatalogueConn;
    /**
     * Execute all the statements passed in parameter against the InMemory SQLite database 
     * @param statements the statements to execute in the InMemory SQLite database
     */
    void executeStatements(const std::list<std::string> &statements);
  };
  
} // namespace cta::catalogue