Poco::Data::SQLite

class SessionImpl

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, hasTransactionIsolation, isAutoCommit, isConnected, isTransaction, isTransactionIsolation, open, reset, rollback, setConnectionTimeout, setTransactionIsolation

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 & param152,
    bool val
);

Sets autocommit property for the session.

begin

void begin();

Starts a transaction.

canTransact inline

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 inline

const std::string & connectorName() const;

Returns the name of the connector.

createStatementImpl

Poco::SharedPtr < Poco::Data::StatementImpl > createStatementImpl();

Returns an SQLite StatementImpl.

getConnectionTimeout inline

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.

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 inline

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.

getConnectionTimeout protected

Poco::Any getConnectionTimeout(
    const std::string & prop
) const;

setConnectionTimeout protected

void setConnectionTimeout(
    const std::string & prop,
    const Poco::Any & value
);

Securely control IoT edge devices from anywhere   Connect a Device