CI_DB_sqlite_utility Class Reference

Inheritance diagram for CI_DB_sqlite_utility:

Public Member Functions
	_list_databases ()
	_optimize_table ($table)
	_repair_table ($table)
	_backup ($params=array())
Public Member Functions inherited from CI_DB_utility
	__construct ()
	list_databases ()
	database_exists ($database_name)
	optimize_table ($table_name)
	optimize_database ()
	repair_table ($table_name)
	csv_from_result ($query, $delim=",", $newline="\n", $enclosure= '"')
	xml_from_result ($query, $params=array())
	backup ($params=array())
Public Member Functions inherited from CI_DB_forge
	__construct ()
	create_database ($db_name)
	drop_database ($db_name)
	add_key ($key= '', $primary=FALSE)
	add_field ($field= '')
	create_table ($table= '', $if_not_exists=FALSE)
	drop_table ($table_name)
	rename_table ($table_name, $new_table_name)
	add_column ($table= '', $field=array(), $after_field= '')
	drop_column ($table= '', $column_name= '')
	modify_column ($table= '', $field=array())
	_reset ()

Additional Inherited Members
Data Fields inherited from CI_DB_utility
	$db
	$data_cache = array()

Member Function Documentation

_backup

(

$params = array())

SQLite Export

private

Parameters

array

Preferences

Returns

mixed

_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

_optimize_table

(

$table)

Optimize table query

Is optimization even supported in SQLite?

private

Parameters

string

the table name

Returns

object

_repair_table

(

$table)

Repair table query

Are table repairs even supported in SQLite?

private

Parameters

string

the table name

Returns

object

---

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

• system/database/drivers/sqlite/sqlite_utility.php