Gitee
\
test

\CI_DB_sqlite_utility

SQLite Utility Class

Summary

Methods
Properties
Constants
__construct()
list_databases()
database_exists()
optimize_table()
optimize_database()
repair_table()
csv_from_result()
xml_from_result()
backup()
create_database()
drop_database()
add_key()
add_field()
create_table()
drop_table()
rename_table()
add_column()
drop_column()
modify_column()
_reset()
_list_databases()
_optimize_table()
_repair_table()
_backup()
$db
$data_cache
$fields
$keys
$primary_keys
$db_char_set
No constants found
No protected methods found
No protected properties found
N/A
No private methods found
No private properties found
N/A

Properties

$db

$db :

Type

$data_cache

$data_cache :

Type

$fields

$fields :

Type

$keys

$keys :

Type

$primary_keys

$primary_keys :

Type

$db_char_set

$db_char_set :

Type

Methods

__construct()

__construct()

Constructor

Grabs the CI super object instance so we can access it.

list_databases()

list_databases() : boolean

List databases

Returns

boolean

database_exists()

database_exists(  $database_name) : boolean

Determine if a particular database exists

Parameters

$database_name

Returns

boolean

optimize_table()

optimize_table(  $table_name) : boolean

Optimize Table

Parameters

$table_name

Returns

boolean

optimize_database()

optimize_database() : array

Optimize Database

Returns

array

repair_table()

repair_table(  $table_name) : boolean

Repair Table

Parameters

$table_name

Returns

boolean

csv_from_result()

csv_from_result(  $query,   $delim = ",",   $newline = "\n",   $enclosure = '"') : string

Generate CSV from a query result object

Parameters

$query
$delim
$newline
$enclosure

Returns

string

xml_from_result()

xml_from_result(  $query,   $params = array()) : string

Generate XML data from a query result object

Parameters

$query
$params

Returns

string

backup()

backup(  $params = array()) : void

Database Backup

Parameters

$params

create_database()

create_database(  $db_name) : boolean

Create database

Parameters

$db_name

Returns

boolean

drop_database()

drop_database(  $db_name) : boolean

Drop database

Parameters

$db_name

Returns

boolean

add_key()

add_key(  $key = '',   $primary = FALSE) : void

Add Key

Parameters

$key
$primary

add_field()

add_field(  $field = '') : void

Add Field

Parameters

$field

create_table()

create_table(  $table = '',   $if_not_exists = FALSE) : boolean

Create Table

Parameters

$table
$if_not_exists

Returns

boolean

drop_table()

drop_table(  $table_name) : boolean

Drop Table

Parameters

$table_name

Returns

boolean

rename_table()

rename_table(  $table_name,   $new_table_name) : boolean

Rename Table

Parameters

$table_name
$new_table_name

Returns

boolean

add_column()

add_column(  $table = '',   $field = array(),   $after_field = '') : boolean

Column Add

Parameters

$table
$field
$after_field

Returns

boolean

drop_column()

drop_column(  $table = '',   $column_name = '') : boolean

Column Drop

Parameters

$table
$column_name

Returns

boolean

modify_column()

modify_column(  $table = '',   $field = array()) : boolean

Column Modify

Parameters

$table
$field

Returns

boolean

_reset()

_reset() : void

Reset

Resets table creation vars

_list_databases()

_list_databases() : boolean

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

Returns

boolean

_optimize_table()

_optimize_table(  $table) : object

Optimize table query

Is optimization even supported in SQLite?

Parameters

$table

Returns

object

_repair_table()

_repair_table(  $table) : object

Repair table query

Are table repairs even supported in SQLite?

Parameters

$table

Returns

object

_backup()

_backup(  $params = array()) : mixed

SQLite Export

Parameters

$params

Returns

mixed