sql_dialect.h

Go to the documentation of this file.

// BSD 3-Clause License
// Copyright (c) 2025, 🍀☀🌕🌥 🌊
// See the LICENSE file in the project root for full license information.
 
#pragma once
 
#include "../database_types.h"
#include <string>
#include <string_view>
#include <memory>
#include <vector>
 
namespace database::query {
 
class sql_dialect {
public:
    virtual ~sql_dialect() = default;
 
    virtual std::string placeholder(int index) const = 0;
 
    virtual std::string quote_identifier(std::string_view name) const = 0;
 
    virtual std::string escape_string(std::string_view str) const = 0;
 
    virtual std::string returning_clause(std::string_view column = "") const = 0;
 
    virtual std::string upsert_clause(
        const std::vector<std::string>& conflict_columns,
        const std::vector<std::string>& update_columns) const = 0;
 
    virtual std::string limit_clause(size_t limit, size_t offset) const = 0;
 
    virtual std::string auto_increment() const = 0;
 
    virtual std::string current_timestamp() const = 0;
 
    virtual std::string concat_operator() const = 0;
 
    virtual bool supports_feature(const std::string& feature) const = 0;
 
    static std::unique_ptr<sql_dialect> create(database_types type);
};
 
class postgresql_dialect : public sql_dialect {
public:
    std::string placeholder(int index) const override;
    std::string quote_identifier(std::string_view name) const override;
    std::string escape_string(std::string_view str) const override;
    std::string returning_clause(std::string_view column = "") const override;
    std::string upsert_clause(
        const std::vector<std::string>& conflict_columns,
        const std::vector<std::string>& update_columns) const override;
    std::string limit_clause(size_t limit, size_t offset) const override;
    std::string auto_increment() const override;
    std::string current_timestamp() const override;
    std::string concat_operator() const override;
    bool supports_feature(const std::string& feature) const override;
};
 
class sqlite_dialect : public sql_dialect {
public:
    std::string placeholder(int index) const override;
    std::string quote_identifier(std::string_view name) const override;
    std::string escape_string(std::string_view str) const override;
    std::string returning_clause(std::string_view column = "") const override;
    std::string upsert_clause(
        const std::vector<std::string>& conflict_columns,
        const std::vector<std::string>& update_columns) const override;
    std::string limit_clause(size_t limit, size_t offset) const override;
    std::string auto_increment() const override;
    std::string current_timestamp() const override;
    std::string concat_operator() const override;
    bool supports_feature(const std::string& feature) const override;
};
 
} // namespace database::query