File Information
Library: Data/SQLite
Package: SQLite
Header: Poco/Data/SQLite/SessionImpl.h
Description
Implements SessionImpl interface.
Inheritance
Direct Base Classes: Poco::Data::AbstractSessionImpl < SessionImpl >
All Base Classes: Poco::Data::AbstractSessionImpl < SessionImpl >
Member Summary
Member Functions: autoCommit, begin, canTransact, close, commit, connectorName, createStatementImpl, getConnectionTimeout, getTransactionIsolation, getTransactionType, hasTransactionIsolation, isAutoCommit, isConnected, isTransaction, isTransactionIsolation, open, reset, rollback, setConnectionTimeout, setTransactionIsolation, setTransactionType
Constructors
SessionImpl
SessionImpl(
const std::string & fileName,
std::size_t loginTimeout = LOGIN_TIMEOUT_DEFAULT
);
Creates the SessionImpl. Opens a connection to the database.
Destructor
~SessionImpl
~SessionImpl();
Destroys the SessionImpl.
Member Functions
autoCommit
void autoCommit(
const std::string & param73,
bool val
);
Sets autocommit property for the session.
begin
void begin();
Starts a transaction.
canTransact
bool canTransact() const;
Returns true if session has transaction capabilities.
close
void close();
Closes the session.
commit
void commit();
Commits and ends a transaction.
connectorName
const std::string & connectorName() const;
Returns the name of the connector.
createStatementImpl
Poco::SharedPtr < Poco::Data::StatementImpl > createStatementImpl();
Returns an SQLite StatementImpl.
getConnectionTimeout
std::size_t getConnectionTimeout() const;
Returns the session connection timeout value. Timeout value is in seconds.
getTransactionIsolation
Poco::UInt32 getTransactionIsolation() const;
Returns the transaction isolation level.
getTransactionType
TransactionType getTransactionType() const;
Returns begin transaction type.
hasTransactionIsolation
bool hasTransactionIsolation(
Poco::UInt32 ti
) const;
Returns true iff the transaction isolation level corresponding to the supplied bitmask is supported.
isAutoCommit
bool isAutoCommit(
const std::string & name = ""
) const;
Returns autocommit property value.
isConnected
bool isConnected() const;
Returns true if connected, false otherwise.
isTransaction
bool isTransaction() const;
Returns true iff a transaction is a transaction is in progress, false otherwise.
isTransactionIsolation
bool isTransactionIsolation(
Poco::UInt32 ti
) const;
Returns true iff the transaction isolation level corresponds to the supplied bitmask.
open
void open(
const std::string & connect = ""
);
Opens a connection to the Database.
An in-memory system database (sys), with a single table (dual) containing single field (dummy) is attached to the database. The in-memory system database is used to force change count to be reset to zero on every new query (or batch of queries) execution. Without this functionality, select statements executions that do not return any rows return the count of changes effected by the most recent insert, update or delete. In-memory system database can be queried and updated but can not be dropped. It may be used for other purposes in the future.
reset
void reset();
Do nothing
rollback
void rollback();
Aborts a transaction.
setConnectionTimeout
void setConnectionTimeout(
std::size_t timeout
);
Sets the session connection timeout value. Timeout value is in seconds.
setTransactionIsolation
void setTransactionIsolation(
Poco::UInt32 ti
);
Sets the transaction isolation level.
setTransactionType
void setTransactionType(
TransactionType transactionType
);
Sets begin transaction type for the session.
getConnectionTimeout
Poco::Any getConnectionTimeout(
const std::string & prop
) const;
getTransactionType
Poco::Any getTransactionType(
const std::string & prop
) const;
setConnectionTimeout
void setConnectionTimeout(
const std::string & prop,
const Poco::Any & value
);
setTransactionType
void setTransactionType(
const std::string & prop,
const Poco::Any & value
);