Poco::Data::MySQL

class Extractor

File Information

Library: Data/MySQL
Package: MySQL
Header: Poco/Data/MySQL/Extractor.h

Description

Extracts and converts data values from the result row returned by MySQL. If NULL is received, the incoming val value is not changed and false is returned

Inheritance

Direct Base Classes: Poco::Data::AbstractExtractor

All Base Classes: Poco::Data::AbstractExtractor

Member Summary

Member Functions: extract, isNull, reset

Inherited Functions: extract, isNull, reset

Types

Ptr

typedef SharedPtr < Extractor > Ptr;

Constructors

Extractor

Extractor(
    StatementExecutor & st,
    ResultMetadata & md
);

Creates the Extractor.

Destructor

~Extractor virtual

virtual ~Extractor();

Destroys the Extractor.

Member Functions

extract virtual

virtual bool extract(
    std::size_t pos,
    Poco::Int8 & val
);

Extracts an Int8.

extract virtual

virtual bool extract(
    std::size_t pos,
    Poco::UInt8 & val
);

Extracts an UInt8.

extract virtual

virtual bool extract(
    std::size_t pos,
    Poco::Int16 & val
);

Extracts an Int16.

extract virtual

virtual bool extract(
    std::size_t pos,
    Poco::UInt16 & val
);

Extracts an UInt16.

extract virtual

virtual bool extract(
    std::size_t pos,
    Poco::Int32 & val
);

Extracts an Int32.

extract virtual

virtual bool extract(
    std::size_t pos,
    Poco::UInt32 & val
);

Extracts an UInt32.

extract virtual

virtual bool extract(
    std::size_t pos,
    Poco::Int64 & val
);

Extracts an Int64.

extract virtual

virtual bool extract(
    std::size_t pos,
    Poco::UInt64 & val
);

Extracts an UInt64.

extract virtual

virtual bool extract(
    std::size_t pos,
    long & val
);

Extracts a long. Returns false if null was received.

extract virtual

virtual bool extract(
    std::size_t pos,
    unsigned long & val
);

Extracts an unsigned long. Returns false if null was received.

extract virtual

virtual bool extract(
    std::size_t pos,
    bool & val
);

Extracts a boolean.

extract virtual

virtual bool extract(
    std::size_t pos,
    float & val
);

Extracts a float.

extract virtual

virtual bool extract(
    std::size_t pos,
    double & val
);

Extracts a double.

extract virtual

virtual bool extract(
    std::size_t pos,
    char & val
);

Extracts a single character.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::string & val
);

Extracts a string.

extract virtual

virtual bool extract(
    std::size_t pos,
    Poco::Data::BLOB & val
);

Extracts a BLOB.

extract virtual

virtual bool extract(
    std::size_t pos,
    Poco::Data::CLOB & val
);

Extracts a CLOB.

extract virtual

virtual bool extract(
    std::size_t pos,
    DateTime & val
);

Extracts a DateTime. Returns false if null was received.

extract virtual

virtual bool extract(
    std::size_t pos,
    Date & val
);

Extracts a Date. Returns false if null was received.

extract virtual

virtual bool extract(
    std::size_t pos,
    Time & val
);

Extracts a Time. Returns false if null was received.

extract virtual

virtual bool extract(
    std::size_t pos,
    UUID & val
);

Extracts a UUID. Returns false if null was received.

extract virtual

virtual bool extract(
    std::size_t pos,
    Any & val
);

Extracts an Any. Returns false if null was received.

extract virtual

virtual bool extract(
    std::size_t pos,
    Dynamic::Var & val
);

Extracts a Dynamic::Var. Returns false if null was received.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < Poco::Int8 > & val
);

Extracts an Int8 vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < Poco::Int8 > & val
);

Extracts an Int8 deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < Poco::Int8 > & val
);

Extracts an Int8 list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < Poco::UInt8 > & val
);

Extracts an UInt8 vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < Poco::UInt8 > & val
);

Extracts an UInt8 deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < Poco::UInt8 > & val
);

Extracts an UInt8 list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < Poco::Int16 > & val
);

Extracts an Int16 vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < Poco::Int16 > & val
);

Extracts an Int16 deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < Poco::Int16 > & val
);

Extracts an Int16 list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < Poco::UInt16 > & val
);

Extracts an UInt16 vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < Poco::UInt16 > & val
);

Extracts an UInt16 deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < Poco::UInt16 > & val
);

Extracts an UInt16 list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < Poco::Int32 > & val
);

Extracts an Int32 vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < Poco::Int32 > & val
);

Extracts an Int32 deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < Poco::Int32 > & val
);

Extracts an Int32 list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < Poco::UInt32 > & val
);

Extracts an UInt32 vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < Poco::UInt32 > & val
);

Extracts an UInt32 deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < Poco::UInt32 > & val
);

Extracts an UInt32 list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < Poco::Int64 > & val
);

Extracts an Int64 vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < Poco::Int64 > & val
);

Extracts an Int64 deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < Poco::Int64 > & val
);

Extracts an Int64 list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < Poco::UInt64 > & val
);

Extracts an UInt64 vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < Poco::UInt64 > & val
);

Extracts an UInt64 deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < Poco::UInt64 > & val
);

Extracts an UInt64 list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < long > & val
);

Extracts a long vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < long > & val
);

Extracts a long deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < long > & val
);

Extracts a long list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < bool > & val
);

Extracts a boolean vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < bool > & val
);

Extracts a boolean deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < bool > & val
);

Extracts a boolean list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < float > & val
);

Extracts a float vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < float > & val
);

Extracts a float deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < float > & val
);

Extracts a float list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < double > & val
);

Extracts a double vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < double > & val
);

Extracts a double deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < double > & val
);

Extracts a double list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < char > & val
);

Extracts a character vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < char > & val
);

Extracts a character deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < char > & val
);

Extracts a character list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < std::string > & val
);

Extracts a string vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < std::string > & val
);

Extracts a string deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < std::string > & val
);

Extracts a string list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < BLOB > & val
);

Extracts a BLOB vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < BLOB > & val
);

Extracts a BLOB deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < BLOB > & val
);

Extracts a BLOB list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < CLOB > & val
);

Extracts a CLOB vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < CLOB > & val
);

Extracts a CLOB deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < CLOB > & val
);

Extracts a CLOB list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < DateTime > & val
);

Extracts a DateTime vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < DateTime > & val
);

Extracts a DateTime deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < DateTime > & val
);

Extracts a DateTime list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < Date > & val
);

Extracts a Date vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < Date > & val
);

Extracts a Date deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < Date > & val
);

Extracts a Date list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < Time > & val
);

Extracts a Time vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < Time > & val
);

Extracts a Time deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < Time > & val
);

Extracts a Time list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < Any > & val
);

Extracts an Any vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < Any > & val
);

Extracts an Any deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < Any > & val
);

Extracts an Any list.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::vector < Dynamic::Var > & val
);

Extracts a Dynamic::Var vector.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::deque < Dynamic::Var > & val
);

Extracts a Dynamic::Var deque.

extract virtual

virtual bool extract(
    std::size_t pos,
    std::list < Dynamic::Var > & val
);

Extracts a Dynamic::Var list.

isNull virtual

virtual bool isNull(
    std::size_t col,
    std::size_t row
);

Returns true if the value at [col,row] position is null.

reset virtual

virtual void reset();

Resets any information internally cached by the extractor. ///////// /////////

Securely control IoT edge devices from anywhere   Connect a Device