# 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, operator =, 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

~Extractor() override;

Destroys the Extractor.

## Member Functions

### extract

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

Extracts an Int8.

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

### extract

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

Extracts an UInt8.

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

### extract

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

Extracts an Int16.

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

### extract

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

Extracts an UInt16.

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

### extract

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

Extracts an Int32.

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

### extract

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

Extracts an UInt32.

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

### extract

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

Extracts an Int64.

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

### extract

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

Extracts an UInt64.

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

### extract

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

Extracts a boolean.

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

### extract

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

Extracts a float.

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

### extract

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

Extracts a double.

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

### extract

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

Extracts a single character.

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

### extract

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

Extracts a string.

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

### 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

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

Extracts a DateTime. Returns false if null was received.

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

### extract

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

Extracts a Date. Returns false if null was received.

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

### extract

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

Extracts a Time. Returns false if null was received.

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

### extract

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

Extracts a UUID. Returns false if null was received.

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

### extract

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

Extracts an Any. Returns false if null was received.

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

### extract

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

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

### extract

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

Extracts a nullable nullable Int8.

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

### extract

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

Extracts a nullable nullable UInt8.

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

### extract

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

Extracts a nullable nullable Int16.

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

### extract

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

Extracts a nullable nullable UInt16.

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

### extract

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

Extracts a nullable nullable Int32.

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

### extract

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

Extracts a nullable nullable UInt32.

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

### extract

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

Extracts a nullable nullable Int64.

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

### extract

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

Extracts a nullable nullable UInt64.

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

### extract

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

Extracts a nullable boolean.

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

### extract

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

Extracts a nullable float.

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

### extract

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

Extracts a nullable double.

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

### extract

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

Extracts a nullable single character.

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

### extract

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

Extracts a nullable string.

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

### extract

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

Extracts a nullable UTF16String.

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

### extract

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

Extracts a nullable BLOB.

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

### extract

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

Extracts a nullable CLOB.

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

### extract

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

Extracts a nullable DateTime.

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

### extract

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

Extracts a nullable Date.

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

### extract

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

Extracts a nullable Time.

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

### extract

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

Extracts a nullable UUID.

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

### extract

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

Extracts a nullable nullable Any.

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

### extract

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

Extracts a nullable Var.

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

### extract

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

Extracts an Int8 vector.

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

### extract

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

Extracts an Int8 deque.

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

### extract

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

Extracts an Int8 list.

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

### extract

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

Extracts an UInt8 vector.

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

### extract

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

Extracts an UInt8 deque.

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

### extract

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

Extracts an UInt8 list.

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

### extract

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

Extracts an Int16 vector.

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

### extract

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

Extracts an Int16 deque.

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

### extract

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

Extracts an Int16 list.

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

### extract

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

Extracts an UInt16 vector.

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

### extract

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

Extracts an UInt16 deque.

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

### extract

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

Extracts an UInt16 list.

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

### extract

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

Extracts an Int32 vector.

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

### extract

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

Extracts an Int32 deque.

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

### extract

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

Extracts an Int32 list.

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

### extract

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

Extracts an UInt32 vector.

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

### extract

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

Extracts an UInt32 deque.

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

### extract

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

Extracts an UInt32 list.

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

### extract

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

Extracts an Int64 vector.

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

### extract

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

Extracts an Int64 deque.

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

### extract

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

Extracts an Int64 list.

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

### extract

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

Extracts an UInt64 vector.

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

### extract

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

Extracts an UInt64 deque.

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

### extract

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

Extracts an UInt64 list.

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

### extract

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

Extracts a boolean vector.

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

### extract

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

Extracts a boolean deque.

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

### extract

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

Extracts a boolean list.

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

### extract

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

Extracts a float vector.

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

### extract

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

Extracts a float deque.

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

### extract

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

Extracts a float list.

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

### extract

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

Extracts a double vector.

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

### extract

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

Extracts a double deque.

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

### extract

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

Extracts a double list.

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

### extract

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

Extracts a character vector.

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

### extract

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

Extracts a character deque.

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

### extract

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

Extracts a character list.

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

### extract

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

Extracts a string vector.

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

### extract

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

Extracts a string deque.

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

### extract

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

Extracts a string list.

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

### extract

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

Extracts a BLOB vector.

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

### extract

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

Extracts a BLOB deque.

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

### extract

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

Extracts a BLOB list.

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

### extract

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

Extracts a CLOB vector.

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

### extract

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

Extracts a CLOB deque.

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

### extract

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

Extracts a CLOB list.

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

### extract

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

Extracts a DateTime vector.

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

### extract

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

Extracts a DateTime deque.

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

### extract

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

Extracts a DateTime list.

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

### extract

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

Extracts a Date vector.

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

### extract

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

Extracts a Date deque.

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

### extract

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

Extracts a Date list.

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

### extract

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

Extracts a Time vector.

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

### extract

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

Extracts a Time deque.

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

### extract

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

Extracts a Time list.

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

### extract

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

Extracts an Any vector.

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

### extract

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

Extracts an Any deque.

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

### extract

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

Extracts an Any list.

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

### 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

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

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

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

### operator =

Extractor & operator = (
const Extractor & param16
) = delete;

### reset

void reset() override;

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

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