prepared_stmt.hxx

#pragma once
 
#include <StormByte/database/prepared_stmt.hxx>
#include <vector>
#include <string>
#include <memory>
 
// forward-declare the libpq connection struct without including libpq-fe.h
struct pg_conn;
 
namespace StormByte::Database::Postgres {
    class STORMBYTE_DATABASE_PUBLIC PreparedSTMT final: public StormByte::Database::PreparedSTMT {
        friend class Postgres;
        public:
            PreparedSTMT(const PreparedSTMT& other)                         = delete;
 
            PreparedSTMT(PreparedSTMT&& other) noexcept                     = default;
 
            ~PreparedSTMT() noexcept override                               = default;
 
            PreparedSTMT& operator=(const PreparedSTMT& other)              = delete;
 
            PreparedSTMT& operator=(PreparedSTMT&& other) noexcept          = default;
 
        private:
            struct pg_conn* m_conn;                                         
            std::string m_stmt_name;                                        
 
            // parameter storage
            std::vector<const char*> m_param_values;                        
            std::vector<int> m_param_lengths;                               
            std::vector<int> m_param_formats;                               
            std::vector<std::string> m_string_storage;                      
            std::vector<std::vector<char>> m_blob_storage;                  
 
            PreparedSTMT(const std::string& name, const std::string& query);
 
            PreparedSTMT(std::string&& name, std::string&& query) noexcept;
 
            void                                                            Bind(const int& index, const std::nullptr_t& value) noexcept override;
 
            void                                                            Bind(const int& index, const int& value) noexcept override;
 
            void                                                            Bind(const int& index, const unsigned int& value) noexcept override;
 
            void                                                            Bind(const int& index, const int64_t& value) noexcept override;
 
            void                                                            Bind(const int& index, const uint64_t& value) noexcept override;
 
            void                                                            Bind(const int& index, const double& value) noexcept override;
 
            void                                                            Bind(const int& index, bool value) noexcept override;
 
            void                                                            Bind(const int& index, const std::string& value) noexcept override;
 
            void                                                            Bind(const int& index, const std::vector<std::byte>& value) noexcept override;
 
            ExpectedRows                                                    DoExecute() override;
 
            void                                                            Reset() noexcept override;
        };
}