Docs For Class SQLiteConnection

Description

Habari database specific connection class

Located in /system/schema/sqlite/connection.php (line 8)

DatabaseConnection
   |
   --SQLiteConnection

Method Summary

boolean connect (connection_string $connect_string, db_user $db_user, db_pass $db_pass)

string dbdelta (queries $queries, [(optional) $execute = true], [(optional) $silent = true], [ $doinserts = false])

string replace_concat (array $matches)

string sql_t (sql $sql)

boolean upgrade (integer $old_version, [ $upgrade_path = ''])

Variables

Inherited Variables

Inherited from DatabaseConnection

DatabaseConnection::$pdo
DatabaseConnection::$prefix

Methods

connect (line 56)

Connect to SQLite Overrides the DatabaseConnection to return false if the SQLite file doesn't exist.

return: True if connection succeeded, false if not.
access: public

boolean connect (connection_string $connect_string, db_user $db_user, db_pass $db_pass)

connection_string $connect_string: string a PDO connection string
db_user $db_user: string the database user name
db_pass $db_pass: string the database user password

Redefinition of:

DatabaseConnection::connect(): Connect to a database server

dbdelta (line 72)

automatic diffing function - used for determining required database upgrades based on Owen Winkler's microwiki upgrade function

return: translated SQL string ** FIXME: SQLite diffing is horribly terribly broken. There is varying support for alter table and mucking with columns

string dbdelta (queries $queries, [(optional) $execute = true], [(optional) $silent = true], [ $doinserts = false])

queries $queries: array of create table and insert statements which constitute a fresh install
(optional) $execute: execute should the queries be executed against the database or just simulated. default = true
(optional) $silent: silent silent running with no messages printed? default = true
$doinserts

Redefinition of:

DatabaseConnection::dbdelta(): Automatic diffing function, used for determining required database upgrades.

replace_concat (line 41)

Replaces the MySQL CONCAT function with SQLite-compatible statements

return: The replacement for the MySQL SQL
see: SQLiteConnection::sql_t()
todo: needs work, kind of sucky conversion

string replace_concat (array $matches)

array $matches: Matches from the regex in sql_t()

sql_t (line 19)

database specific SQL translation function, loosely modelled on the

internationalization _t() function Call with a database independent SQL string and it will be translated to a SQLite specific SQL string

return: translated SQL string

string sql_t (sql $sql)

sql $sql: database independent SQL

Redefinition of:

DatabaseConnection::sql_t(): Translates the query for the current database engine

upgrade (line 151)

Run all of the upgrades since the last database revision.

return: True on success
access: public

boolean upgrade (integer $old_version, [ $upgrade_path = ''])

integer $old_version: The current version of the database that is being upgraded
$upgrade_path

Redefinition of:

DatabaseConnection::upgrade(): Updates the content of the database between versions.

Inherited Methods

Inherited From DatabaseConnection

DatabaseConnection::begin_transaction()
DatabaseConnection::clear_errors()
DatabaseConnection::commit()
DatabaseConnection::connect()
DatabaseConnection::ConnectionFactory()
DatabaseConnection::dbdelta()
DatabaseConnection::delete()
DatabaseConnection::disconnect()
DatabaseConnection::exec()
DatabaseConnection::execute_procedure()
DatabaseConnection::exists()
DatabaseConnection::filter_tables()
DatabaseConnection::get_column()
DatabaseConnection::get_driver_name()
DatabaseConnection::get_errors()
DatabaseConnection::get_keyvalue()
DatabaseConnection::get_last_error()
DatabaseConnection::get_profiles()
DatabaseConnection::get_results()
DatabaseConnection::get_row()
DatabaseConnection::get_value()
DatabaseConnection::has_errors()
DatabaseConnection::insert()
DatabaseConnection::in_transaction()
DatabaseConnection::is_connected()
DatabaseConnection::last_insert_id()
DatabaseConnection::list_tables()
DatabaseConnection::load_tables()
DatabaseConnection::query()
DatabaseConnection::query_file()
DatabaseConnection::register_table()
DatabaseConnection::rollback()
DatabaseConnection::row_count()
DatabaseConnection::set_fetch_class()
DatabaseConnection::set_fetch_mode()
DatabaseConnection::sql_t()
DatabaseConnection::table()
DatabaseConnection::update()
DatabaseConnection::upgrade()