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.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt8.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int16.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt16.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int32.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt32.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int64.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt64.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a long. Returns false if null was received.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

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

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a boolean.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a float.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a double.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a single character.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a string.

See also: Poco::Data::AbstractExtractor::extract()

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.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a Date. Returns false if null was received.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a Time. Returns false if null was received.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a UUID. Returns false if null was received.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Any. Returns false if null was received.

See also: Poco::Data::AbstractExtractor::extract()

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.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int8 deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int8 list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt8 vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt8 deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt8 list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int16 vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int16 deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int16 list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt16 vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt16 deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt16 list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int32 vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int32 deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int32 list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt32 vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt32 deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt32 list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int64 vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int64 deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Int64 list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt64 vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt64 deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an UInt64 list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a long vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a long deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a long list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a boolean vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a boolean deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a boolean list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a float vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a float deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a float list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a double vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a double deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a double list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a character vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a character deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a character list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a string vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a string deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a string list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a BLOB vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a BLOB deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a BLOB list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a CLOB vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a CLOB deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a CLOB list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a DateTime vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a DateTime deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a DateTime list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a Date vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a Date deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a Date list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a Time vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a Time deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts a Time list.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Any vector.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Any deque.

See also: Poco::Data::AbstractExtractor::extract()

extract virtual

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

Extracts an Any list.

See also: Poco::Data::AbstractExtractor::extract()

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.

See also: Poco::Data::AbstractExtractor::isNull()

reset virtual

virtual void reset();

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

See also: Poco::Data::AbstractExtractor::reset()

Securely control IoT edge devices from anywhere   Connect a Device