# Poco::Data::SQLite

# class Extractor

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

## Description

Extracts and converts data values form the result row returned by SQLite. 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 Aliases

### NullIndVec

using NullIndVec = std::vector < std::pair < bool, bool > >;

Type for null indicators container.

## Constructors

### Extractor

Extractor(
sqlite3_stmt * pStmt
);

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,
UTF16String & val
) override;

Throws NotImplementedException.

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,
Poco::Data::Date & val
) override;

Extracts a Date.

### extract

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

Extracts a Time.

### extract

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

Extracts a DateTime.

### extract

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

Extracts a UUID.

### extract

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

Extracts an Any.

### extract

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

Extracts a Dynamic::Var.

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

### extract

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

Extracts an Nullable<Int8>.

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

### extract

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

Extracts an Nullable<UInt8>.

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

### extract

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

Extracts an Nullable<Int16>.

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

### extract

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

Extracts an Nullable<UInt16>.

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

### extract

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

Extracts an Nullable<Int32>.

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

### extract

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

Extracts an Nullable<UInt32>.

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

### extract

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

Extracts an Nullable<Int64>.

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

### extract

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

Extracts an Nullable<UInt64>.

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

### extract

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

Extracts a Nullable<bool>.

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 single Nullable 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 < Poco::Data::BLOB > & val
) override;

Extracts a Nullable<BLOB>.

### extract

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

Extracts a Nullable<BLOB>.

### extract

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

Extracts a Nullable<Date>.

### extract

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

Extracts a :Nullable<Time>.

### extract

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

Extracts Nullable<DateTime>.

### extract

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

Extracts a Nullable<UUID>.

### extract

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

Extracts a Nullable<Any>.

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### extract

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

Throws NotImplementedException.

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

### isNull

bool isNull(
std::size_t pos,
std::size_t row = POCO_DATA_INVALID_ROW
) override;

Returns true if the current row value at pos column is null. Because of the loss of information about null-ness of the underlying database values due to the nature of SQLite engine, (once null value is converted to default value, SQLite API treats it as non-null), a null indicator container member variable is used to cache the indicators of the underlying nulls thus rendering this function idempotent. The container is a vector of [bool, bool] pairs. The vector index corresponds to the column position, the first bool value in the pair is true if the null indicator has been set and the second bool value in the pair is true if the column is actually null. The row argument, needed for connectors with bulk capabilities, is ignored in this implementation.

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

### reset

void reset() override;

Clears the cached nulls indicator vector.

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