MDB2
[ class tree: MDB2 ] [ index: MDB2 ] [ all elements ]
Packages:
MDB2


Classes:
MDB2_Driver_Datatype_sqlite
MDB2_Driver_Manager_sqlite
MDB2_Driver_Native_sqlite
MDB2_Driver_Reverse_sqlite
MDB2_Driver_sqlite
MDB2_Driver_sqlite
   MDB2_BufferedResult_sqlite
   MDB2_Result_sqlite
   MDB2_Statement_sqlite
Files:
sqlite.php
sqlite.php
sqlite.php
sqlite.php
sqlite.php

Class: MDB2_Driver_Manager_sqlite

Source Location: /MDB2_Driver_sqlite-0.1.0/MDB2/Driver/Manager/sqlite.php

Class Overview

MDB2_Driver_Manager_Common
   |
   --MDB2_Driver_Manager_sqlite

MDB2 SQLite driver for the management modules


Author(s):

Methods

Inherited Variables

Inherited Methods

Class Details

[line 57]
MDB2 SQLite driver for the management modules


[ Top ]

Method Detail

createDatabase   [line 68]

mixed createDatabase( string $name)

create a new database
  • Return: MDB2_OK on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $name   —  name of the database that should be created

[ Top ]

createIndex   [line 230]

mixed createIndex( string $table, string $name, array $definition)

get the stucture of a field into an array
  • Return: MDB2_OK on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $table   —  name of the table on which the index is to be created
string   $name   —  name of the index to be created
array   $definition   — 

associative array that defines properties of the index to be created. Currently, only one property named FIELDS is supported. This property is also an associative with the names of the index fields as array indexes. Each entry of this array is set to another type of associative array that specifies properties of the index that are specific to each field.

Currently, only the sorting property is supported. It should be used to define the sorting direction of the index. It may be set to either ascending or descending.

Not all DBMS support index sorting direction configuration. The DBMS drivers of those that do not support it ignore this property. Use the function support() to determine whether the DBMS driver can manage indexes. Example array( 'fields' => array( 'user_name' => array( 'sorting' => 'ascending' ), 'last_login' => array() ) )

[ Top ]

createSequence   [line 302]

mixed createSequence( string $seq_name, [string $start = 1])

create sequence
  • Return: MDB2_OK on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $seq_name   —  name of the sequence to be created
string   $start   —  start value of the sequence; default is 1

[ Top ]

dropDatabase   [line 96]

mixed dropDatabase( string $name)

drop an existing database
  • Return: MDB2_OK on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $name   —  name of the database that should be dropped

[ Top ]

dropIndex   [line 257]

mixed dropIndex( string $table, string $name)

drop existing index
  • Return: MDB2_OK on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $table   —  name of table that should be used in method
string   $name   —  name of the index to be dropped

[ Top ]

dropSequence   [line 341]

mixed dropSequence( string $seq_name)

drop existing sequence
  • Return: MDB2_OK on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $seq_name   —  name of the sequence to be dropped

[ Top ]

listDatabases   [line 121]

mixed listDatabases( )

list all databases
  • Return: data array on success, a MDB2 error on failure
  • Access: public

[ Top ]

listSequences   [line 357]

mixed listSequences( )

list all sequences in the current database
  • Return: data array on success, a MDB2 error on failure
  • Access: public

[ Top ]

listTableFields   [line 178]

mixed listTableFields( string $table)

list all fields in a tables in the current database
  • Return: data array on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $table   —  name of table that should be used in method

[ Top ]

listTableIndexes   [line 273]

mixed listTableIndexes( string $table)

list all indexes in a table
  • Return: data array on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $table   —  name of table that should be used in method

[ Top ]

listTables   [line 152]

mixed listTables( )

list all tables in the current database
  • Return: data array on success, a MDB2 error on failure
  • Access: public

[ Top ]

listUsers   [line 137]

mixed listUsers( )

list all users
  • Return: data array on success, a MDB2 error on failure
  • Access: public

[ Top ]
Documentation generated on Mon, 11 Mar 2019 14:19:41 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.