engine.hpp 1.56 KB
Newer Older
louiz’'s avatar
louiz’ committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
#pragma once

/**
 * Interface to provide non-portable behaviour, specific to each
 * database engine we want to support.
 *
 * Everything else (all portable stuf) should go outside of this class.
 */

#include <database/statement.hpp>

#include <memory>
#include <string>
#include <vector>
#include <tuple>
louiz’'s avatar
louiz’ committed
16
#include <map>
louiz’'s avatar
louiz’ committed
17 18 19 20 21 22 23
#include <set>

class DatabaseEngine
{
 public:

  DatabaseEngine() = default;
24
  virtual ~DatabaseEngine() = default;
louiz’'s avatar
louiz’ committed
25 26 27 28 29 30

  DatabaseEngine(const DatabaseEngine&) = delete;
  DatabaseEngine& operator=(const DatabaseEngine&) = delete;
  DatabaseEngine(DatabaseEngine&&) = delete;
  DatabaseEngine& operator=(DatabaseEngine&&) = delete;

louiz’'s avatar
louiz’ committed
31 32 33 34
  enum class EngineType { None, Postgresql, Sqlite3, };
  virtual EngineType engine_type() const = 0;

  virtual std::map<std::string, std::string> get_all_columns_from_table(const std::string& table_name) = 0;
louiz’'s avatar
louiz’ committed
35 36 37 38 39 40 41
  virtual std::tuple<bool, std::string> raw_exec(const std::string& query) = 0;
  virtual std::unique_ptr<Statement> prepare(const std::string& query) = 0;
  virtual void extract_last_insert_rowid(Statement& statement) = 0;
  virtual std::string get_returning_id_sql_string(const std::string&)
  {
    return {};
  }
louiz’'s avatar
louiz’ committed
42 43 44 45 46 47 48 49 50 51 52
  virtual void convert_date_format(DatabaseEngine&) = 0;
  virtual std::string id_column_type() const = 0;
  virtual std::string datetime_column_type() const = 0;
  virtual long double epoch_to_floating_value(long double seconds) const = 0;
  virtual std::string escape_param_number(int nb) const
  {
    return "$" + std::to_string(nb);
  }
  virtual void init_session()
  {
  }
louiz’'s avatar
louiz’ committed
53 54 55

  int64_t last_inserted_rowid{-1};
};