TemporaryTable.h

// (c) Copyright 2022 CERN for the benefit of the LHCb Collaboration.
//
// This software is distributed under the terms of the GNU General Public
// Licence version 3 (GPL Version 3), copied verbatim in the file "LICENCE".
//
// 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
 
// STL
#include <string>
#include <vector>
 
// SQLamarr
#include "SQLamarr/BaseSqlInterface.h"
#include "SQLamarr/db_functions.h"
#include "SQLamarr/Transformer.h"
 
 
 
namespace SQLamarr
{
  class TemporaryTable: public BaseSqlInterface, public Transformer
  {
    public:
      TemporaryTable (
          SQLite3DB& db,
          const std::string& output_table,
          const std::vector<std::string>& columns,
          const std::vector<std::string>& select_statements,
          bool make_persistent = false
            //   the table "persistent"
          );
     
      TemporaryTable (
          SQLite3DB& db,
          const std::string& output_table,
          const std::vector<std::string>& columns,
          const std::string& select_statement,
          bool make_persistent = false
            //   the table "persistent"
          );
 
 
      void execute () override;
 
    private:
      // Name of the output temporary table
      const std::string m_output_table;
 
      // Name of the output temporary table
      const std::vector<std::string> m_columns;
 
      // Select statement
      const std::vector<std::string> m_select_statements;
 
    private: 
      std::string compose_create_query() const;
      std::string compose_delete_query() const;
      std::string compose_insert_query(const std::string& st) const;
      bool m_make_persistent;
  };
}