CI_DB_sqlite_utility Class Reference

Inheritance diagram for CI_DB_sqlite_utility:

[legend]

Collaboration diagram for CI_DB_sqlite_utility:

[legend]

List of all members.

Public Member Functions
	_list_databases ()
	List databases.
	_optimize_table ($table)
	Optimize table query.
	_repair_table ($table)
	Repair table query.
	_backup ($params=array())
	SQLite Export.
	_create_database ()
	The functions below have been deprecated as of 1.6, and are only here for backwards compatibility.
	_drop_database ($name)
	Drop database.

---

Detailed Description

Definition at line 25 of file sqlite_utility.php.

---

Member Function Documentation

CI_DB_sqlite_utility::_backup

(

$

params = array()

)

SQLite Export.

private

Parameters:

array

Preferences

Returns:

mixed

Definition at line 88 of file sqlite_utility.php.

        {
                // Currently unsupported
                return $this->db->display_error('db_unsuported_feature');
        }

CI_DB_sqlite_utility::_create_database

(

)

The functions below have been deprecated as of 1.6, and are only here for backwards compatibility.

They now reside in dbforge(). The use of dbutils for database manipulation is STRONGLY discouraged in favour if using dbforge. Create database public

Parameters:

string

the database name

Returns:

bool

Definition at line 109 of file sqlite_utility.php.

        {
                // In SQLite, a database is created when you connect to the database.
                // We'll return TRUE so that an error isn't generated
                return TRUE;
        }

CI_DB_sqlite_utility::_drop_database

(

$

name

)

Drop database.

private

Parameters:

string

the database name

Returns:

bool

Definition at line 125 of file sqlite_utility.php.

        {
                if ( ! @file_exists($this->db->database) OR ! @unlink($this->db->database))
                {
                        if ($this->db->db_debug)
                        {
                                return $this->db->display_error('db_unable_to_drop');
                        }
                        return FALSE;
                }
                return TRUE;
        }

CI_DB_sqlite_utility::_list_databases

(

)

List databases.

I don't believe you can do a database listing with SQLite since each database is its own file. I suppose we could try reading a directory looking for SQLite files, but that doesn't seem like a terribly good idea

private

Returns:

bool

Definition at line 38 of file sqlite_utility.php.

        {
                if ($this->db_debug)
                {
                        return $this->display_error('db_unsuported_feature');
                }
                return array();
        }

CI_DB_sqlite_utility::_optimize_table

(

$

table

)

Optimize table query.

Is optimization even supported in SQLite?

private

Parameters:

string

the table name

Returns:

object

Definition at line 58 of file sqlite_utility.php.

        {
                return FALSE;
        }

CI_DB_sqlite_utility::_repair_table

(

$

table

)

Repair table query.

Are table repairs even supported in SQLite?

private

Parameters:

string

the table name

Returns:

object

Definition at line 74 of file sqlite_utility.php.

        {
                return FALSE;
        }

---

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

• sqlite_utility.php