AnewtDatabaseConnectionSQLite class

SQLite database connection.

Page Contents

  1. Class Overview
  2. Public Methods
  3. Protected Methods
  4. Inheritance

Class Overview

SQLite database connection.

Specify sqlite as the connection type when setting up the connection using AnewtDatabase::setup_connection().

The settings accepted by this backend are:

If no filename is specified, an in-memory database is opened.

See also

Public Methods

__construct($settings)

Create a new connection instance (internal use only).

Do not call this method directly; it is for internal use only. See the AnewtDatabase documentation on how to setup and obtain AnewtDatabaseConnection instances.

Parameters

$settings

Associative array with connection settings.

is_connected()

Check whether the connection is currently open.

Return value

True if the connection is open, false otherwise.

last_insert_id($options=null)

Get the last insert id for this connection.

The $options parameter is database backend specific. For most backends this value is not needed. At least PostgreSQL needs a sequence name. See the backend documentation for more information.

Parameters

$options

Backend-specific value.

real_execute_sql($sql)

Execute SQL and create an AnewtDatabaseResultSet for a query.

This method is for internal use only and is backend-specific.

Parameters

$sql

The SQL query to execute.

escape_string($value)

Escape a string for use in SQL queries.

Parameters

$value

The value to escape

Return value

The escaped value

Protected Methods

real_connect() [protected]

Establish a database connection.

real_disconnect() [protected]

Disconnect the database connection.

Inheritance

Base Classes

Inherited members

Anewt. Almost No Effort Web Toolkit.

© 2006–2009. This page was generated at 2009-08-02T22:54:42+02:00.