Poco::Data::MySQL

class Extractor

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, reverseTranscode, transcode, transcodeRequired

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

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

Extracts an Int8.

extract virtual

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

Extracts an UInt8.

extract virtual

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

Extracts an Int16.

extract virtual

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

Extracts an UInt16.

extract virtual

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

Extracts an Int32.

extract virtual

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

Extracts an UInt32.

extract virtual

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

Extracts an Int64.

extract virtual

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

Extracts an UInt64.

extract virtual

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

Extracts a boolean.

extract virtual

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

Extracts a float.

extract virtual

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

Extracts a double.

extract virtual

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

Extracts a single character.

extract virtual

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

Extracts a string.

extract

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

Extracts a BLOB.

extract

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

Extracts a CLOB.

extract virtual

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

Extracts a DateTime. Returns false if null was received.

extract virtual

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

Extracts a Date. Returns false if null was received.

extract virtual

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

Extracts a Time. Returns false if null was received.

extract virtual

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

Extracts a UUID. Returns false if null was received.

extract virtual

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

Extracts an Any. Returns false if null was received.

extract

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

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

extract virtual

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

Extracts a nullable nullable Int8.

extract virtual

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

Extracts a nullable nullable UInt8.

extract virtual

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

Extracts a nullable nullable Int16.

extract virtual

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

Extracts a nullable nullable UInt16.

extract virtual

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

Extracts a nullable nullable Int32.

extract virtual

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

Extracts a nullable nullable UInt32.

extract virtual

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

Extracts a nullable nullable Int64.

extract virtual

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

Extracts a nullable nullable UInt64.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < bool > & val
) override;

Extracts a nullable boolean.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < float > & val
) override;

Extracts a nullable float.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < double > & val
) override;

Extracts a nullable double.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < char > & val
) override;

Extracts a nullable single character.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < std::string > & val
) override;

Extracts a nullable string.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < UTF16String > & val
) override;

Extracts a nullable UTF16String.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < BLOB > & val
) override;

Extracts a nullable BLOB.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < CLOB > & val
) override;

Extracts a nullable CLOB.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < DateTime > & val
) override;

Extracts a nullable DateTime.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < Date > & val
) override;

Extracts a nullable Date.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < Time > & val
) override;

Extracts a nullable Time.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < UUID > & val
) override;

Extracts a nullable UUID.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < Any > & val
) override;

Extracts a nullable nullable Any.

extract virtual

bool extract(
    std::size_t pos,
    Poco::Nullable < Poco::Dynamic::Var > & val
) override;

Extracts a nullable Var.

extract virtual

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

Extracts an Int8 vector.

extract virtual

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

Extracts an Int8 deque.

extract virtual

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

Extracts an Int8 list.

extract virtual

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

Extracts an UInt8 vector.

extract virtual

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

Extracts an UInt8 deque.

extract virtual

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

Extracts an UInt8 list.

extract virtual

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

Extracts an Int16 vector.

extract virtual

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

Extracts an Int16 deque.

extract virtual

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

Extracts an Int16 list.

extract virtual

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

Extracts an UInt16 vector.

extract virtual

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

Extracts an UInt16 deque.

extract virtual

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

Extracts an UInt16 list.

extract virtual

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

Extracts an Int32 vector.

extract virtual

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

Extracts an Int32 deque.

extract virtual

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

Extracts an Int32 list.

extract virtual

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

Extracts an UInt32 vector.

extract virtual

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

Extracts an UInt32 deque.

extract virtual

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

Extracts an UInt32 list.

extract virtual

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

Extracts an Int64 vector.

extract virtual

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

Extracts an Int64 deque.

extract virtual

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

Extracts an Int64 list.

extract virtual

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

Extracts an UInt64 vector.

extract virtual

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

Extracts an UInt64 deque.

extract virtual

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

Extracts an UInt64 list.

extract virtual

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

Extracts a boolean vector.

extract virtual

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

Extracts a boolean deque.

extract virtual

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

Extracts a boolean list.

extract virtual

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

Extracts a float vector.

extract virtual

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

Extracts a float deque.

extract virtual

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

Extracts a float list.

extract virtual

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

Extracts a double vector.

extract virtual

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

Extracts a double deque.

extract virtual

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

Extracts a double list.

extract virtual

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

Extracts a character vector.

extract virtual

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

Extracts a character deque.

extract virtual

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

Extracts a character list.

extract virtual

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

Extracts a string vector.

extract virtual

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

Extracts a string deque.

extract virtual

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

Extracts a string list.

extract virtual

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

Extracts a BLOB vector.

extract virtual

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

Extracts a BLOB deque.

extract virtual

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

Extracts a BLOB list.

extract virtual

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

Extracts a CLOB vector.

extract virtual

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

Extracts a CLOB deque.

extract virtual

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

Extracts a CLOB list.

extract virtual

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

Extracts a DateTime vector.

extract virtual

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

Extracts a DateTime deque.

extract virtual

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

Extracts a DateTime list.

extract virtual

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

Extracts a Date vector.

extract virtual

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

Extracts a Date deque.

extract virtual

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

Extracts a Date list.

extract virtual

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

Extracts a Time vector.

extract virtual

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

Extracts a Time deque.

extract virtual

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

Extracts a Time list.

extract virtual

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

Extracts an Any vector.

extract virtual

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

Extracts an Any deque.

extract virtual

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

Extracts an Any list.

extract

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

Extracts a Dynamic::Var vector.

extract

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

Extracts a Dynamic::Var deque.

extract

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

Extracts a Dynamic::Var list.

isNull virtual

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

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

reset virtual

void reset() override;

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