TZSQLiteDriver Class Reference

Implements SQLite Database Driver. More...

Inheritance diagram for TZSQLiteDriver:

TZAbstractDriver TInterfacedObject IZDriver

List of all members.

Public Member Functions

Boolean AcceptsURL (const string Url)
 Returns true if the driver thinks that it can open a connection to the given URL.
IZConnection Connect (const string Url, TStrings Info)
 Attempts to make a database connection to the given URL.
Integer GetClientVersion (const string Url)
 Returns the version of the plain driver library that will be used to open a connection to the given URL.
Integer GetMajorVersion ()
 Gets the driver's major version number.
Integer GetMinorVersion ()
 Gets the driver's minor version number.
TStrings GetPropertyInfo (const string Url, TStrings Info)
 Gets information about the possible properties for this driver.
IZStatementAnalyser GetStatementAnalyser ()
 Creates a statement analyser object.
Integer GetSubVersion ()
 Gets the driver's sub version (revision) number.
TStringDynArray GetSupportedProtocols ()
 Get a name of the supported subprotocol.
IZTokenizer GetTokenizer ()
 Gets a SQL syntax tokenizer.
 TZSQLiteDriver ()
 Constructs this object with default properties.

Protected Member Functions

IZSQLitePlainDriver GetPlainDriver (const string Url)
 Gets plain driver for selected protocol.

Protected Attributes

IZStatementAnalyser Analyser
IZTokenizer Tokenizer

Private Attributes

IZSQLitePlainDriver FSQLite28PlainDriver
IZSQLitePlainDriver FSQLite3PlainDriver


Detailed Description

Implements SQLite Database Driver.

Definition at line 71 of file ZDbcSqLite.pas.


Constructor & Destructor Documentation

TZSQLiteDriver::TZSQLiteDriver (  ) 

Constructs this object with default properties.

Definition at line 238 of file ZDbcSqLite.pas.


Member Function Documentation

Boolean TZAbstractDriver::AcceptsURL ( const string  Url  )  [inherited]

Returns true if the driver thinks that it can open a connection to the given URL.

Typically drivers will return true if they understand the subprotocol specified in the URL and false if they don't.

Parameters:
url the URL of the database
Returns:
true if this driver can connect to the given URL

Reimplemented from IZDriver.

Definition at line 572 of file ZDbcConnection.pas.

IZConnection TZSQLiteDriver::Connect ( const string  Url,
TStrings  Info 
)

Attempts to make a database connection to the given URL.

The driver should return "null" if it realizes it is the wrong kind of driver to connect to the given URL. This will be common, as when the JDBC driver manager is asked to connect to a given URL it passes the URL to each loaded driver in turn.

The driver should raise a SQLException if it is the right driver to connect to the given URL, but has trouble connecting to the database.

The java.util.Properties argument can be used to passed arbitrary string tag/value pairs as connection arguments. Normally at least "user" and "password" properties should be included in the Properties.

Parameters:
url the URL of the database to which to connect
info a list of arbitrary string tag/value pairs as connection arguments. Normally at least a "user" and "password" property should be included.
Returns:
a Connection object that represents a connection to the URL

Reimplemented from TZAbstractDriver.

Definition at line 270 of file ZDbcSqLite.pas.

Integer TZAbstractDriver::GetClientVersion ( const string  Url  )  [inherited]

Returns the version of the plain driver library that will be used to open a connection to the given URL.

Parameters:
url the URL of the database
Returns:
the version number of the plain driver library for the give URL

Reimplemented from IZDriver.

Reimplemented in TZMySQLDriver.

Definition at line 689 of file ZDbcConnection.pas.

Integer TZSQLiteDriver::GetMajorVersion (  ) 

Gets the driver's major version number.

Initially this should be 1.

Returns:
this driver's major version number

Reimplemented from TZAbstractDriver.

Definition at line 303 of file ZDbcSqLite.pas.

Integer TZSQLiteDriver::GetMinorVersion (  ) 

Gets the driver's minor version number.

Initially this should be 0.

Returns:
this driver's minor version number

Reimplemented from TZAbstractDriver.

Definition at line 315 of file ZDbcSqLite.pas.

IZSQLitePlainDriver TZSQLiteDriver::GetPlainDriver ( const string  Url  )  [protected]

Gets plain driver for selected protocol.

Parameters:
Url a database connection URL.
Returns:
a selected protocol.

Definition at line 371 of file ZDbcSqLite.pas.

References P.

TStrings TZAbstractDriver::GetPropertyInfo ( const string  Url,
TStrings  Info 
) [inherited]

Gets information about the possible properties for this driver.

The getPropertyInfo method is intended to allow a generic GUI tool to discover what properties it should prompt a human for in order to get enough information to connect to a database. Note that depending on the values the human has supplied so far, additional values may become necessary, so it may be necessary to iterate though several calls to getPropertyInfo.

Parameters:
url the URL of the database to which to connect
info a proposed list of tag/value pairs that will be sent on connect open
Returns:
an array of DriverPropertyInfo objects describing possible properties. This array may be an empty array if no properties are required.

Reimplemented from IZDriver.

Definition at line 610 of file ZDbcConnection.pas.

IZStatementAnalyser TZSQLiteDriver::GetStatementAnalyser (  ) 

Creates a statement analyser object.

Returns:
a statement analyser object.

Reimplemented from TZAbstractDriver.

Definition at line 341 of file ZDbcSqLite.pas.

Integer TZAbstractDriver::GetSubVersion (  )  [inherited]

Gets the driver's sub version (revision) number.

Initially this should be 0.

Returns:
this driver's sub version number

Reimplemented from IZDriver.

Definition at line 648 of file ZDbcConnection.pas.

TStringDynArray TZSQLiteDriver::GetSupportedProtocols (  ) 

Get a name of the supported subprotocol.

For example: mysql, oracle8 or postgresql72

Reimplemented from TZAbstractDriver.

Definition at line 355 of file ZDbcSqLite.pas.

References CheckSQLiteError().

IZTokenizer TZSQLiteDriver::GetTokenizer (  ) 

Gets a SQL syntax tokenizer.

Returns:
a SQL syntax tokenizer object.

Reimplemented from TZAbstractDriver.

Definition at line 327 of file ZDbcSqLite.pas.


Member Data Documentation

See also:
FAnalyser For reading

FAnalyser For writing

Definition at line 95 of file ZDbcConnection.pas.

Definition at line 76 of file ZDbcSqLite.pas.

Definition at line 78 of file ZDbcSqLite.pas.

IZTokenizer TZAbstractDriver::Tokenizer [protected, inherited]

See also:
FTokenizer For reading

FTokenizer For writing

Definition at line 92 of file ZDbcConnection.pas.


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

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