Class Poco::Data::Test::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, nullable, 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, stdVectorBool, time, transaction, transactionIsolation, transactor, tupleVector, tuples, unicode, uuids, zeroRows

Enumerations

Constructors

SQLExecutor

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

Destructor

Member Functions

affectedRows

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

asynchronous

void asynchronous(
int rowCount = 500
);

blob

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

blobContainer

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

connection

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

doBulkPerformance

void doBulkPerformance(
Poco::UInt32 size
);

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"
);

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;"
);

nullable

void nullable();

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