TZSQLiteConnection Class Reference

Implements SQLite Database Connection. More...

Inheritance diagram for TZSQLiteConnection:

TZAbstractConnection IZSQLiteConnection TInterfacedObject IZConnection

List of all members.

Public Member Functions

 ClearWarnings ()
 Clears all warnings reported for this Connection object.
 Close ()
 Releases a Connection's database and JDBC resources immediately instead of waiting for them to be automatically released.
 Commit ()
 Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.
 CommitPrepared (const string transactionid)
IZNotification CreateNotification (const string Event)
 Creates an object to send/recieve notifications from SQL server.
IZPreparedStatement CreatePreparedStatement (const string SQL, TStrings Info)
 Creates a PreparedStatement object for sending parameterized SQL statements to the database.
IZStatement CreateRegularStatement (TStrings Info)
 Creates a Statement object for sending SQL statements to the database.
IZSequence CreateSequence (const string Sequence, Integer BlockSize)
 Creates a sequence generator object.
IZStatement CreateStatement ()
 Creates a Statement object for sending SQL statements to the database.
IZStatement CreateStatementWithParams (TStrings Info)
 Creates a Statement object for sending SQL statements to the database.
String EscapeString (String Value)
 Escape a string so it's acceptable for the Connection's server.
Boolean GetAutoCommit ()
 Gets the current auto-commit state.
string GetCatalog ()
 Gets a selected catalog name.
Integer GetClientVersion ()
 Gets the client's full version number.
Psqlite GetConnectionHandle ()
 Gets a reference to SQLite connection handle.
IZDriver GetDriver ()
 Gets the parent ZDBC driver.
Integer GetHostVersion ()
 Gets the host's full version number.
IZDatabaseMetadata GetMetadata ()
 Gets the metadata regarding this connection's database.
TStrings GetParameters ()
 Gets a connection parameters.
IZSQLitePlainDriver GetPlainDriver ()
 Gets a SQLite plain driver interface.
TZTransactIsolationLevel GetTransactionIsolation ()
 Gets this Connection's current transaction isolation level.
EZSQLWarning GetWarnings ()
 Returns the first warning reported by calls on this Connection.
Boolean IsClosed ()
 Tests to see if a Connection is closed.
Boolean IsReadOnly ()
 Tests to see if the connection is in read-only mode.
Integer Key (const string Key)
 Set encryption key for a database.
string NativeSQL (const string SQL)
 Converts the given SQL statement into the system's native SQL grammar.
 Open ()
 Opens a connection to database server with specified parameters.
Integer PingServer ()
 Ping Current Connection's server, if client was disconnected, the connection is resumed.
IZCallableStatement PrepareCall (const string SQL)
 Creates a CallableStatement object for calling database stored procedures.
IZCallableStatement PrepareCallWithParams (const string SQL, TStrings Info)
 Creates a CallableStatement object for calling database stored procedures.
IZPreparedStatement PrepareStatement (const string SQL)
 Creates a PreparedStatement object for sending parameterized SQL statements to the database.
IZPreparedStatement PrepareStatementWithParams (const string SQL, TStrings Info)
 Creates a PreparedStatement object for sending parameterized SQL statements to the database.
 PrepareTransaction (const string transactionid)
Integer ReKey (const string Key)
 Reencrypt a database with a new key.
 Rollback ()
 Drops all changes made since the previous commit/rollback and releases any database locks currently held by this Connection.
 RollbackPrepared (const string transactionid)
 SetAutoCommit (Boolean AutoCommit)
 Sets this connection's auto-commit mode.
 SetCatalog (const string Catalog)
 Sets a new selected catalog name.
 SetReadOnly (Boolean ReadOnly)
 Puts this connection in read-only mode as a hint to enable database optimizations.
 SetTransactionIsolation (TZTransactIsolationLevel Level)
 Sets a new transact isolation level.
 TZSQLiteConnection (IZDriver Driver, const string Url, IZSQLitePlainDriver PlainDriver, const string HostName, Integer Port, const string Database, const string User, const string Password, TStrings Info)
 Constructs this object and assignes the main properties.
 ~TZSQLiteConnection ()
 Destroys this object and cleanups the memory.

Protected Member Functions

IZCallableStatement CreateCallableStatement (const string SQL, TStrings Info)
 Creates a callable statement object.
 RaiseUnsupportedException ()
 Raises unsupported operation exception.
 StartTransactionSupport ()
 Starts a transaction support.

Protected Attributes

Boolean AutoCommit
Boolean Closed
string Database
IZDriver Driver
string HostName
TStrings Info
string Password
Integer Port
Boolean ReadOnly
TZTransactIsolationLevel TransactIsolationLevel
string User

Private Attributes

string FCatalog
Psqlite FHandle
IZSQLitePlainDriver FPlainDriver


Detailed Description

Implements SQLite Database Connection.

Definition at line 131 of file ZDbcSqLite.pas.


Constructor & Destructor Documentation

TZSQLiteConnection::TZSQLiteConnection ( IZDriver  Driver,
const string  Url,
IZSQLitePlainDriver  PlainDriver,
const string  HostName,
Integer  Port,
const string  Database,
const string  User,
const string  Password,
TStrings  Info 
)

Constructs this object and assignes the main properties.

Parameters:
Driver the parent ZDBC driver.
PlainDriver a SQLite plain driver.
HostName a name of the host.
Port a port number (0 for default port).
Database a name pof the database.
User a user name.
Password a user password.
Info a string list with extra connection parameters.

Definition at line 406 of file ZDbcSqLite.pas.

TZSQLiteConnection::~TZSQLiteConnection (  ) 

Destroys this object and cleanups the memory.

Definition at line 434 of file ZDbcSqLite.pas.


Member Function Documentation

TZAbstractConnection::ClearWarnings (  )  [inherited]

Clears all warnings reported for this Connection object.

After a call to this method, the method getWarnings returns null until a new warning is reported for this Connection.

Reimplemented from IZConnection.

Reimplemented in TZAdoConnection, and TZDBLibConnection.

Definition at line 1386 of file ZDbcConnection.pas.

TZSQLiteConnection::Close (  ) 

Releases a Connection's database and JDBC resources immediately instead of waiting for them to be automatically released.

Note: A Connection is automatically closed when it is garbage collected. Certain fatal errors also result in a closed Connection.

Reimplemented from TZAbstractConnection.

Definition at line 706 of file ZDbcSqLite.pas.

TZSQLiteConnection::Commit (  ) 

Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.

This method should be used only when auto-commit mode has been disabled.

See also:
setAutoCommit

Reimplemented from TZAbstractConnection.

Definition at line 640 of file ZDbcSqLite.pas.

TZAbstractConnection::CommitPrepared ( const string  transactionid  )  [inherited]

Reimplemented from IZConnection.

Reimplemented in TZPostgreSQLConnection.

Definition at line 1111 of file ZDbcConnection.pas.

IZCallableStatement TZAbstractConnection::CreateCallableStatement ( const string  SQL,
TStrings  Info 
) [protected, inherited]

Creates a callable statement object.

Parameters:
SQL a SQL query string.
Info a statement parameters.
Returns:
a created statement.

Reimplemented in TZAdoConnection, TZASAConnection, TZDBLibConnection, and TZInterbase6Connection.

Definition at line 992 of file ZDbcConnection.pas.

IZNotification TZAbstractConnection::CreateNotification ( const string  Event  )  [inherited]

Creates an object to send/recieve notifications from SQL server.

Parameters:
Event an event name.
Returns:
a created notification object.

Reimplemented from IZConnection.

Definition at line 1008 of file ZDbcConnection.pas.

IZPreparedStatement TZSQLiteConnection::CreatePreparedStatement ( const string  SQL,
TStrings  Info 
)

Creates a PreparedStatement object for sending parameterized SQL statements to the database.

A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.

Note: This method is optimized for handling parametric SQL statements that benefit from precompilation. If the driver supports precompilation, the method prepareStatement will send the statement to the database for precompilation. Some drivers may not support precompilation. In this case, the statement may not be sent to the database until the PreparedStatement is executed. This has no direct effect on users; however, it does affect which method throws certain SQLExceptions.

Result sets created using the returned PreparedStatement will have forward-only type and read-only concurrency, by default.

Parameters:
sql a SQL statement that may contain one or more '?' IN parameter placeholders
Info a statement parameters.
Returns:
a new PreparedStatement object containing the pre-compiled statement

Reimplemented from TZAbstractConnection.

Definition at line 595 of file ZDbcSqLite.pas.

IZStatement TZSQLiteConnection::CreateRegularStatement ( TStrings  Info  ) 

Creates a Statement object for sending SQL statements to the database.

SQL statements without parameters are normally executed using Statement objects. If the same SQL statement is executed many times, it is more efficient to use a PreparedStatement object.

Result sets created using the returned Statement object will by default have forward-only type and read-only concurrency.

Parameters:
Info a statement parameters.
Returns:
a new Statement object

Reimplemented from TZAbstractConnection.

Definition at line 557 of file ZDbcSqLite.pas.

IZSequence TZAbstractConnection::CreateSequence ( const string  Sequence,
Integer  BlockSize 
) [inherited]

Creates a sequence generator object.

Parameters:
Sequence a name of the sequence generator.
BlockSize a number of unique keys requested in one trip to SQL server.
Returns:
a created sequence object.

Reimplemented from IZConnection.

Reimplemented in TZInterbase6Connection, TZOracleConnection, and TZPostgreSQLConnection.

Definition at line 1024 of file ZDbcConnection.pas.

IZStatement TZAbstractConnection::CreateStatement (  )  [inherited]

Creates a Statement object for sending SQL statements to the database.

SQL statements without parameters are normally executed using Statement objects. If the same SQL statement is executed many times, it is more efficient to use a PreparedStatement object.

Result sets created using the returned Statement object will by default have forward-only type and read-only concurrency.

Returns:
a new Statement object

Reimplemented from IZConnection.

Definition at line 797 of file ZDbcConnection.pas.

IZStatement TZAbstractConnection::CreateStatementWithParams ( TStrings  Info  )  [inherited]

Creates a Statement object for sending SQL statements to the database.

SQL statements without parameters are normally executed using Statement objects. If the same SQL statement is executed many times, it is more efficient to use a PreparedStatement object.

Result sets created using the returned Statement object will by default have forward-only type and read-only concurrency.

Parameters:
Info a statement parameters.
Returns:
a new Statement object

Reimplemented from IZConnection.

Definition at line 820 of file ZDbcConnection.pas.

String TZAbstractConnection::EscapeString ( String  Value  )  [inherited]

Escape a string so it's acceptable for the Connection's server.

Parameters:
value string that should be escaped
Returns:
Escaped string

Reimplemented from IZConnection.

Reimplemented in TZMySQLConnection.

Definition at line 1163 of file ZDbcConnection.pas.

Boolean TZAbstractConnection::GetAutoCommit (  )  [inherited]

Gets the current auto-commit state.

Returns:
the current state of auto-commit mode
See also:
setAutoCommit

Reimplemented from IZConnection.

Definition at line 1088 of file ZDbcConnection.pas.

string TZSQLiteConnection::GetCatalog (  ) 

Gets a selected catalog name.

Returns:
a selected catalog name.

Reimplemented from TZAbstractConnection.

Definition at line 730 of file ZDbcSqLite.pas.

Integer TZAbstractConnection::GetClientVersion (  )  [inherited]

Gets the client's full version number.

Initially this should be 0. The format of the version resturned must be XYYYZZZ where X = Major version YYY = Minor version ZZZ = Sub version

Returns:
this clients's full version number

Reimplemented from IZConnection.

Reimplemented in TZMySQLConnection.

Definition at line 1252 of file ZDbcConnection.pas.

Psqlite TZSQLiteConnection::GetConnectionHandle (  ) 

Gets a reference to SQLite connection handle.

Returns:
a reference to SQLite connection handle.

Reimplemented from IZSQLiteConnection.

Definition at line 788 of file ZDbcSqLite.pas.

IZDriver TZAbstractConnection::GetDriver (  )  [inherited]

Gets the parent ZDBC driver.

Returns:
the parent ZDBC driver interface.

Reimplemented from IZConnection.

Definition at line 1206 of file ZDbcConnection.pas.

Integer TZAbstractConnection::GetHostVersion (  )  [inherited]

Gets the host's full version number.

Initially this should be 0. The format of the version returned must be XYYYZZZ where X = Major version YYY = Minor version ZZZ = Sub version

Returns:
this server's full version number

Reimplemented from IZConnection.

Reimplemented in TZMySQLConnection, and TZPostgreSQLConnection.

Definition at line 1268 of file ZDbcConnection.pas.

IZDatabaseMetadata TZAbstractConnection::GetMetadata (  )  [inherited]

Gets the metadata regarding this connection's database.

A Connection's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, and so on. This information is made available through a DatabaseMetaData object.

Returns:
a DatabaseMetaData object for this Connection

Reimplemented from IZConnection.

Definition at line 1224 of file ZDbcConnection.pas.

TStrings TZAbstractConnection::GetParameters (  )  [inherited]

Gets a connection parameters.

Returns:
a list with connection parameters.

Reimplemented from IZConnection.

Definition at line 1236 of file ZDbcConnection.pas.

IZSQLitePlainDriver TZSQLiteConnection::GetPlainDriver (  ) 

Gets a SQLite plain driver interface.

Returns:
a SQLite plain driver interface.

Reimplemented from IZSQLiteConnection.

Definition at line 800 of file ZDbcSqLite.pas.

TZTransactIsolationLevel TZAbstractConnection::GetTransactionIsolation (  )  [inherited]

Gets this Connection's current transaction isolation level.

Returns:
the current TRANSACTION_* mode value

Reimplemented from IZConnection.

Definition at line 1359 of file ZDbcConnection.pas.

EZSQLWarning TZAbstractConnection::GetWarnings (  )  [inherited]

Returns the first warning reported by calls on this Connection.

Note: Subsequent warnings will be chained to this SQLWarning.

Returns:
the first SQLWarning or null

Reimplemented from IZConnection.

Reimplemented in TZAdoConnection, and TZDBLibConnection.

Definition at line 1373 of file ZDbcConnection.pas.

Boolean TZAbstractConnection::IsClosed (  )  [inherited]

Tests to see if a Connection is closed.

Returns:
true if the connection is closed; false if it's still open

Reimplemented from IZConnection.

Definition at line 1194 of file ZDbcConnection.pas.

Boolean TZAbstractConnection::IsReadOnly (  )  [inherited]

Tests to see if the connection is in read-only mode.

Returns:
true if connection is read-only and false otherwise

Reimplemented from IZConnection.

Definition at line 1300 of file ZDbcConnection.pas.

Integer TZSQLiteConnection::Key ( const string  Key  ) 

Set encryption key for a database.

Parameters:
Key the key used to encrypt your database.
Returns:
error code from SQLite Key function.

Definition at line 447 of file ZDbcSqLite.pas.

string TZAbstractConnection::NativeSQL ( const string  SQL  )  [inherited]

Converts the given SQL statement into the system's native SQL grammar.

A driver may convert the JDBC sql grammar into its system's native SQL grammar prior to sending it; this method returns the native form of the statement that the driver would have sent.

Parameters:
sql a SQL statement that may contain one or more '?' parameter placeholders
Returns:
the native form of this statement

Reimplemented from IZConnection.

Reimplemented in TZAdoConnection, and TZDBLibConnection.

Definition at line 1045 of file ZDbcConnection.pas.

TZSQLiteConnection::Open (  ) 

Opens a connection to database server with specified parameters.

Reimplemented from TZAbstractConnection.

Definition at line 490 of file ZDbcSqLite.pas.

Integer TZAbstractConnection::PingServer (  )  [inherited]

Ping Current Connection's server, if client was disconnected, the connection is resumed.

Returns:
0 if succesfull or error code if any error occurs

Reimplemented from IZConnection.

Reimplemented in TZInterbase6Connection, TZMySQLConnection, and TZPostgreSQLConnection.

Definition at line 1149 of file ZDbcConnection.pas.

IZCallableStatement TZAbstractConnection::PrepareCall ( const string  SQL  )  [inherited]

Creates a CallableStatement object for calling database stored procedures.

The CallableStatement object provides methods for setting up its IN and OUT parameters, and methods for executing the call to a stored procedure.

Note: This method is optimized for handling stored procedure call statements. Some drivers may send the call statement to the database when the method prepareCall is done; others may wait until the CallableStatement object is executed. This has no direct effect on users; however, it does affect which method throws certain SQLExceptions.

Result sets created using the returned CallableStatement will have forward-only type and read-only concurrency, by default.

Parameters:
sql a SQL statement that may contain one or more '?' parameter placeholders. Typically this statement is a JDBC function call escape string.
Returns:
a new CallableStatement object containing the pre-compiled SQL statement

Reimplemented from IZConnection.

Definition at line 953 of file ZDbcConnection.pas.

IZCallableStatement TZAbstractConnection::PrepareCallWithParams ( const string  SQL,
TStrings  Info 
) [inherited]

Creates a CallableStatement object for calling database stored procedures.

The CallableStatement object provides methods for setting up its IN and OUT parameters, and methods for executing the call to a stored procedure.

Parameters:
SQL a SQL statement that may contain one or more '?' parameter placeholders. Typically this statement is a JDBC function call escape string.
Info a statement parameters.
Returns:
a new CallableStatement object containing the pre-compiled SQL statement

Reimplemented from IZConnection.

Definition at line 976 of file ZDbcConnection.pas.

IZPreparedStatement TZAbstractConnection::PrepareStatement ( const string  SQL  )  [inherited]

Creates a PreparedStatement object for sending parameterized SQL statements to the database.

A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.

Note: This method is optimized for handling parametric SQL statements that benefit from precompilation. If the driver supports precompilation, the method prepareStatement will send the statement to the database for precompilation. Some drivers may not support precompilation. In this case, the statement may not be sent to the database until the PreparedStatement is executed. This has no direct effect on users; however, it does affect which method throws certain SQLExceptions.

Result sets created using the returned PreparedStatement will have forward-only type and read-only concurrency, by default.

Parameters:
sql a SQL statement that may contain one or more '?' IN parameter placeholders
Returns:
a new PreparedStatement object containing the pre-compiled statement

Reimplemented from IZConnection.

Definition at line 872 of file ZDbcConnection.pas.

IZPreparedStatement TZAbstractConnection::PrepareStatementWithParams ( const string  SQL,
TStrings  Info 
) [inherited]

Creates a PreparedStatement object for sending parameterized SQL statements to the database.

Parameters:
SQL a SQL statement that may contain one or more '?' IN parameter placeholders
Info a statement parameters.
Returns:
a new PreparedStatement object containing the pre-compiled statement

Reimplemented from IZConnection.

Definition at line 891 of file ZDbcConnection.pas.

TZAbstractConnection::PrepareTransaction ( const string  transactionid  )  [inherited]

Reimplemented from IZConnection.

Reimplemented in TZPostgreSQLConnection.

Definition at line 901 of file ZDbcConnection.pas.

References P.

TZAbstractConnection::RaiseUnsupportedException (  )  [protected, inherited]

Raises unsupported operation exception.

Definition at line 776 of file ZDbcConnection.pas.

Integer TZSQLiteConnection::ReKey ( const string  Key  ) 

Reencrypt a database with a new key.

The old/current key needs to be set before calling this function.

Parameters:
Key the new key used to encrypt your database.
Returns:
error code from SQLite ReKey function.

Definition at line 470 of file ZDbcSqLite.pas.

TZSQLiteConnection::Rollback (  ) 

Drops all changes made since the previous commit/rollback and releases any database locks currently held by this Connection.

This method should be used only when auto- commit has been disabled.

See also:
setAutoCommit

Reimplemented from TZAbstractConnection.

Definition at line 672 of file ZDbcSqLite.pas.

TZAbstractConnection::RollbackPrepared ( const string  transactionid  )  [inherited]

Reimplemented from IZConnection.

Reimplemented in TZPostgreSQLConnection.

Definition at line 1135 of file ZDbcConnection.pas.

TZAbstractConnection::SetAutoCommit ( Boolean  AutoCommit  )  [inherited]

Sets this connection's auto-commit mode.

If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions. Otherwise, its SQL statements are grouped into transactions that are terminated by a call to either the method commit or the method rollback. By default, new connections are in auto-commit mode.

The commit occurs when the statement completes or the next execute occurs, whichever comes first. In the case of statements returning a ResultSet, the statement completes when the last row of the ResultSet has been retrieved or the ResultSet has been closed. In advanced cases, a single statement may return multiple results as well as output parameter values. In these cases the commit occurs when all results and output parameter values have been retrieved.

Parameters:
autoCommit true enables auto-commit; false disables auto-commit.

Reimplemented from IZConnection.

Reimplemented in TZAdoConnection, TZDBLibConnection, and TZMySQLConnection.

Definition at line 1074 of file ZDbcConnection.pas.

TZSQLiteConnection::SetCatalog ( const string  Catalog  ) 

Sets a new selected catalog name.

Parameters:
Catalog a selected catalog name.

Reimplemented from TZAbstractConnection.

Definition at line 742 of file ZDbcSqLite.pas.

TZAbstractConnection::SetReadOnly ( Boolean  ReadOnly  )  [inherited]

Puts this connection in read-only mode as a hint to enable database optimizations.

Note: This method cannot be called while in the middle of a transaction.

Parameters:
readOnly true enables read-only mode; false disables read-only mode.

Reimplemented from IZConnection.

Reimplemented in TZAdoConnection, and TZDBLibConnection.

Definition at line 1287 of file ZDbcConnection.pas.

TZSQLiteConnection::SetTransactionIsolation ( TZTransactIsolationLevel  Level  ) 

Sets a new transact isolation level.

Parameters:
Level a new transact isolation level.

Reimplemented from TZAbstractConnection.

Definition at line 755 of file ZDbcSqLite.pas.

TZSQLiteConnection::StartTransactionSupport (  )  [protected]

Starts a transaction support.

Definition at line 610 of file ZDbcSqLite.pas.


Member Data Documentation

Boolean TZAbstractConnection::AutoCommit [protected, inherited]

See also:
FAutoCommit For reading

FAutoCommit For writing

Definition at line 221 of file ZDbcConnection.pas.

Boolean TZAbstractConnection::Closed [protected, inherited]

See also:
FClosed For reading

FClosed For writing

Definition at line 231 of file ZDbcConnection.pas.

string TZAbstractConnection::Database [protected, inherited]

See also:
FDatabase For reading

FDatabase For writing

Definition at line 209 of file ZDbcConnection.pas.

IZDriver TZAbstractConnection::Driver [protected, inherited]

See also:
FDriver For reading

FDriver For writing

Definition at line 197 of file ZDbcConnection.pas.

string TZSQLiteConnection::FCatalog [private]

Definition at line 136 of file ZDbcSqLite.pas.

Definition at line 140 of file ZDbcSqLite.pas.

Definition at line 138 of file ZDbcSqLite.pas.

string TZAbstractConnection::HostName [protected, inherited]

See also:
FHostName For reading

FHostName For writing

Definition at line 203 of file ZDbcConnection.pas.

TStrings TZAbstractConnection::Info [protected, inherited]

See also:
FInfo For reading

Definition at line 218 of file ZDbcConnection.pas.

string TZAbstractConnection::Password [protected, inherited]

See also:
FPassword For reading

FPassword For writing

Definition at line 215 of file ZDbcConnection.pas.

Integer TZAbstractConnection::Port [protected, inherited]

See also:
FPort For reading

FPort For writing

Definition at line 206 of file ZDbcConnection.pas.

Boolean TZAbstractConnection::ReadOnly [protected, inherited]

See also:
FReadOnly For reading

FReadOnly For writing

Definition at line 224 of file ZDbcConnection.pas.

See also:
FTransactIsolationLevel For reading

FTransactIsolationLevel For writing

Definition at line 228 of file ZDbcConnection.pas.

string TZAbstractConnection::User [protected, inherited]

See also:
FUser For reading

FUser For writing

Definition at line 212 of file ZDbcConnection.pas.


The documentation for this class was generated from the following file:

Generated on Wed Dec 30 08:42:56 2009 for zeoslib by  doxygen 1.5.7.1