# Poco::Data::Test

# class SQLExecutor

Library:
Package:
Header: Poco/Data/Test/SQLExecutor.h

## Inheritance

Direct Base Classes: CppUnit::TestCase

All Base Classes: CppUnit::TestCase

## Member Summary

Member Functions: affectedRows, any, asynchronous, autoCommit, autoPtrComplexTypeVector, blob, blobContainer, blobStmt, combinedIllegalLimits, combinedLimits, complexType, complexTypeDeque, complexTypeList, complexTypeTuple, complexTypeVector, connection, date, dateTime, doBulkPerformance, doubles, dynamicAny, emptyDB, encoding, execute, filter, floats, illegalRange, insertDeque, insertEmptyDeque, insertEmptyList, insertEmptyVector, insertList, insertSingleBulk, insertSingleBulkVec, insertVector, internalBulkExtraction, internalBulkExtractionUTF16, internalExtraction, internalStorageType, limitOnce, limitPrepare, limitZero, limits, lowerLimitFail, lowerLimitOk, mapComplex, mapComplexUnique, multiMapComplex, multiSetComplex, multiSetSimple, multipleResults, nullBulk, nullable, nullableImpl, nulls, prepare, ranges, reconnect, recordSet, rowIterator, selectIntoSingle, selectIntoSingleFail, selectIntoSingleStep, session, sessionPool, sessionTransaction, sessionTransactionNoAutoCommit, setComplex, setComplexUnique, setSimple, setTransactionIsolation, sharedPtrComplexTypeVector, simpleAccess, simpleAccessDeque, simpleAccessList, simpleAccessVector, singleSelect, sqlChannel, sqlLogger, stdOptional, stdTupleWithOptional, stdVectorBool, time, transaction, transactionIsolation, transactor, tupleVector, tuples, unicode, uuids, zeroRows

## Enumerations

### DataBinding

PB_IMMEDIATE

PB_AT_EXEC

### DataExtraction

DE_MANUAL

DE_BOUND

## Constructors

### SQLExecutor

SQLExecutor(
const std::string & name,
Poco::Data::Session * pSession,
Poco::Data::Session * pEncSession = nullptr,
bool numberedPlaceHolders = false
);

## Destructor

### ~SQLExecutor

~SQLExecutor() override;

## Member Functions

### affectedRows

void affectedRows(
const std::string & whereClause = ""
);

### any

void any();

### asynchronous

void asynchronous(
int rowCount = 500
);

### autoCommit

void autoCommit();

### autoPtrComplexTypeVector

void autoPtrComplexTypeVector();

### blob

void blob(
int bigSize = 1024,
const std::string & blobPlaceholder = "?"
);

### blobContainer

template < typename C1, typename C2 > void blobContainer(
int size
);

### blobStmt

void blobStmt();

### combinedIllegalLimits

void combinedIllegalLimits();

### combinedLimits

void combinedLimits();

### complexType

void complexType();

### complexTypeDeque

void complexTypeDeque();

### complexTypeList

void complexTypeList();

### complexTypeTuple

void complexTypeTuple();

### complexTypeVector

void complexTypeVector();

### connection

template < typename C > void connection(
C & c,
const std::string & connectString
);

### date

void date();

### dateTime

void dateTime();

### doBulkPerformance

void doBulkPerformance(
Poco::UInt32 size
);

### doubles

void doubles();

### dynamicAny

void dynamicAny();

### emptyDB

void emptyDB();

### encoding

void encoding(
const std::string & dbConnString
);

### execute

void execute(
const std::string & sql
);

Execute a query.

### filter

void filter(
const std::string & query = "SELECT * FROM Vectors ORDER BY int0 ASC",
const std::string & intFldName = "int0"
);

### floats

void floats();

### illegalRange

void illegalRange();

### insertDeque

void insertDeque();

### insertEmptyDeque

void insertEmptyDeque();

### insertEmptyList

void insertEmptyList();

### insertEmptyVector

void insertEmptyVector();

### insertList

void insertList();

### insertSingleBulk

void insertSingleBulk();

### insertSingleBulkVec

void insertSingleBulkVec();

### insertVector

void insertVector();

### internalBulkExtraction

void internalBulkExtraction();

### internalBulkExtractionUTF16

void internalBulkExtractionUTF16();

### internalExtraction

void internalExtraction();

### internalStorageType

void internalStorageType();

### limitOnce

void limitOnce();

### limitPrepare

void limitPrepare();

### limitZero

void limitZero();

### limits

void limits();

### lowerLimitFail

void lowerLimitFail();

### lowerLimitOk

void lowerLimitOk();

### mapComplex

void mapComplex();

### mapComplexUnique

void mapComplexUnique();

### multiMapComplex

void multiMapComplex();

### multiSetComplex

void multiSetComplex();

### multiSetSimple

void multiSetSimple();

### multipleResults

void multipleResults(
const std::string & sql = "SELECT * FROM Person WHERE Age = ?; " "SELECT Age FROM Person WHERE FirstName = 'Bart'; " "SELECT * FROM Person WHERE Age = ? OR Age = ? ORDER BY Age;"
);

### nullBulk

void nullBulk(
const std::string & blobPlaceholder = "?"s
);

### nullable

void nullable();

### nullableImpl

template < typename T > void nullableImpl(
const std::string & emptyName
);

### nulls

void nulls();

### prepare

void prepare();

### ranges

void ranges();

### reconnect

void reconnect();

### recordSet

void recordSet();

### rowIterator

void rowIterator();

### selectIntoSingle

void selectIntoSingle();

### selectIntoSingleFail

void selectIntoSingleFail();

### selectIntoSingleStep

void selectIntoSingleStep();

### session

void session(
const std::string & connector,
const std::string & connectString,
int timeout
);

### session

Poco::Data::Session & session(
bool enc = false
);

### sessionPool

void sessionPool(
const std::string & connector,
const std::string & connectString,
int minSessions,
int maxSessions,
int idleTime,
int timeout
);

### sessionTransaction

void sessionTransaction(
const std::string & connector,
const std::string & connect
);

### sessionTransactionNoAutoCommit

void sessionTransactionNoAutoCommit(
const std::string & connector,
const std::string & connect
);

### setComplex

void setComplex();

### setComplexUnique

void setComplexUnique();

### setSimple

void setSimple();

### setTransactionIsolation

void setTransactionIsolation(
Poco::Data::Session & session,
Poco::UInt32 ti
);

### sharedPtrComplexTypeVector

void sharedPtrComplexTypeVector();

### simpleAccess

void simpleAccess();

### simpleAccessDeque

void simpleAccessDeque();

### simpleAccessList

void simpleAccessList();

### simpleAccessVector

void simpleAccessVector();

### singleSelect

void singleSelect();

### sqlChannel

void sqlChannel(
const std::string & connector,
const std::string & connect
);

### sqlLogger

void sqlLogger(
const std::string & connector,
const std::string & connect
);

### stdOptional

void stdOptional();

### stdTupleWithOptional

void stdTupleWithOptional();

### stdVectorBool

void stdVectorBool();

### time

void time();

### transaction

void transaction(
const std::string & connector,
const std::string & connect,
bool readUncommitted = true
);

### transactionIsolation

void transactionIsolation();

### transactor

void transactor();

### tupleVector

void tupleVector();

### tuples

void tuples();

### unicode

void unicode(
const std::string & dbConnString
);

### uuids

void uuids();

### zeroRows

void zeroRows();