Poco::Data::PostgreSQL

class Binder

File Information

Library: Data/PostgreSQL
Package: PostgreSQL
Header: Poco/Data/PostgreSQL/Binder.h

Description

Binds INPUT (only) placeholders in the sql query to the provided values. Allows data type mapping at statement execution time.

Inheritance

Direct Base Classes: Poco::Data::AbstractBinder

All Base Classes: Poco::Data::AbstractBinder

Member Summary

Member Functions: bind, bindVector, size, updateBindVectorToCurrentValues

Inherited Functions: bind, isInBound, isOutBound, reset, toString

Types Aliases

Ptr

using Ptr = SharedPtr < Binder >;

Constructors

Binder

Binder();

Creates the Binder.

Destructor

~Binder virtual

virtual ~Binder();

Destroys the Binder.

Member Functions

bind virtual

virtual void bind(
    std::size_t pos,
    const Poco::Int8 & val,
    Direction dir = PD_IN
);

Binds an Int8.

bind virtual

virtual void bind(
    std::size_t pos,
    const Poco::UInt8 & val,
    Direction dir = PD_IN
);

Binds an UInt8.

bind virtual

virtual void bind(
    std::size_t pos,
    const Poco::Int16 & val,
    Direction dir = PD_IN
);

Binds an Int16.

bind virtual

virtual void bind(
    std::size_t pos,
    const Poco::UInt16 & val,
    Direction dir = PD_IN
);

Binds an UInt16.

bind virtual

virtual void bind(
    std::size_t pos,
    const Poco::Int32 & val,
    Direction dir = PD_IN
);

Binds an Int32.

bind virtual

virtual void bind(
    std::size_t pos,
    const Poco::UInt32 & val,
    Direction dir = PD_IN
);

Binds an UInt32.

bind virtual

virtual void bind(
    std::size_t pos,
    const Poco::Int64 & val,
    Direction dir = PD_IN
);

Binds an Int64.

bind virtual

virtual void bind(
    std::size_t pos,
    const Poco::UInt64 & val,
    Direction dir = PD_IN
);

Binds an UInt64.

bind virtual

virtual void bind(
    std::size_t pos,
    const long & val,
    Direction dir = PD_IN
);

Binds a long.

bind virtual

virtual void bind(
    std::size_t pos,
    const unsigned long & val,
    Direction dir = PD_IN
);

Binds an unsigned long.

bind virtual

virtual void bind(
    std::size_t pos,
    const bool & val,
    Direction dir = PD_IN
);

Binds a boolean.

bind virtual

virtual void bind(
    std::size_t pos,
    const float & val,
    Direction dir = PD_IN
);

Binds a float.

bind virtual

virtual void bind(
    std::size_t pos,
    const double & val,
    Direction dir = PD_IN
);

Binds a double.

bind virtual

virtual void bind(
    std::size_t pos,
    const char & val,
    Direction dir = PD_IN
);

Binds a single character.

bind virtual

virtual void bind(
    std::size_t pos,
    const std::string & val,
    Direction dir = PD_IN
);

Binds a string.

bind virtual

virtual void bind(
    std::size_t pos,
    const Poco::Data::BLOB & val,
    Direction dir = PD_IN
);

Binds a BLOB.

bind virtual

virtual void bind(
    std::size_t pos,
    const Poco::Data::CLOB & val,
    Direction dir = PD_IN
);

Binds a CLOB.

bind virtual

virtual void bind(
    std::size_t pos,
    const DateTime & val,
    Direction dir = PD_IN
);

Binds a DateTime.

bind virtual

virtual void bind(
    std::size_t pos,
    const Date & val,
    Direction dir = PD_IN
);

Binds a Date.

bind virtual

virtual void bind(
    std::size_t pos,
    const Time & val,
    Direction dir = PD_IN
);

Binds a Time.

bind virtual

virtual void bind(
    std::size_t pos,
    const UUID & val,
    Direction dir = PD_IN
);

Binds a UUID.

bind virtual

virtual void bind(
    std::size_t pos,
    const NullData & val,
    Direction dir = PD_IN
);

Binds a null.

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < Poco::Int8 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < Poco::Int8 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < Poco::Int8 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < Poco::UInt8 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < Poco::UInt8 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < Poco::UInt8 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < Poco::Int16 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < Poco::Int16 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < Poco::Int16 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < Poco::UInt16 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < Poco::UInt16 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < Poco::UInt16 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < Poco::Int32 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < Poco::Int32 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < Poco::Int32 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < Poco::UInt32 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < Poco::UInt32 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < Poco::UInt32 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < Poco::Int64 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < Poco::Int64 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < Poco::Int64 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < Poco::UInt64 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < Poco::UInt64 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < Poco::UInt64 > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < bool > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < bool > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < bool > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < float > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < float > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < float > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < double > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < double > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < double > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < char > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < char > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < char > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < BLOB > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < BLOB > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < BLOB > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < CLOB > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < CLOB > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < CLOB > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < DateTime > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < DateTime > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < DateTime > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < Date > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < Date > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < Date > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < Time > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < Time > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < Time > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < NullData > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < NullData > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < NullData > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::vector < std::string > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::deque < std::string > & val,
    Direction dir = PD_IN
);

bind virtual

virtual void bind(
    std::size_t pos,
    const std::list < std::string > & val,
    Direction dir = PD_IN
);

bindVector

InputParameterVector bindVector() const;

Return the vector of bound parameters.

size

std::size_t size() const;

Return count of bound parameters

updateBindVectorToCurrentValues

void updateBindVectorToCurrentValues();

obtain the current version of the bound data and update the internal representation

Securely control IoT edge devices from anywhere   Connect a Device