Class: MDB2_Driver_Reverse_mysqli

Source Location: /MDB2-2.0.0beta4/MDB2/Driver/Reverse/mysqli.php

Class Overview

MDB2_Driver_Reverse_Common
   |
   --MDB2_Driver_Reverse_mysqli

MDB2 MySQL driver for the schema reverse engineering module

Author(s):

Lukas Smith <smith at backendmedia.com>

Variables

Methods

Child classes:

MDB2_Driver_Reverse_mysql: MDB2 MySQL driver for the schema reverse engineering module

Inherited Variables

Class: MDB2_Driver_Reverse_Common

MDB2_Driver_Reverse_Common::$db_index

Inherited Methods

Class: MDB2_Driver_Reverse_Common

MDB2_Driver_Reverse_Common::__construct(): Constructor
MDB2_Driver_Reverse_Common::MDB2_Driver_Reverse_Common()
MDB2_Driver_Reverse_Common::getSequenceDefinition(): get the stucture of a sequence into an array
MDB2_Driver_Reverse_Common::getTableFieldDefinition(): get the stucture of a field into an array
MDB2_Driver_Reverse_Common::getTableIndexDefinition(): get the stucture of an index into an array
MDB2_Driver_Reverse_Common::tableInfo(): Returns information about a table or a result set

Class Details

[line 57]
MDB2 MySQL driver for the schema reverse engineering module

Author: Lukas Smith <smith@backendmedia.com>

[ Top ]

Class Variables

$flags = array(
        MYSQLI_NOT_NULL_FLAG        => 'not_null',
        MYSQLI_PRI_KEY_FLAG         => 'primary_key',
        MYSQLI_UNIQUE_KEY_FLAG      => 'unique_key',
        MYSQLI_MULTIPLE_KEY_FLAG    => 'multiple_key',
        MYSQLI_BLOB_FLAG            => 'blob',
        MYSQLI_UNSIGNED_FLAG        => 'unsigned',
        MYSQLI_ZEROFILL_FLAG        => 'zerofill',
        MYSQLI_AUTO_INCREMENT_FLAG  => 'auto_increment',
        MYSQLI_TIMESTAMP_FLAG       => 'timestamp',
        MYSQLI_SET_FLAG             => 'set',
        // MYSQLI_NUM_FLAG             => 'numeric',  // unnecessary
        // MYSQLI_PART_KEY_FLAG        => 'multiple_key',  // duplicatvie
        MYSQLI_GROUP_FLAG           => 'group_by'
    )

[line 65]

Array for converting MYSQLI_*_FLAG constants to text values

Since: Property available since Release 1.6.5
Access: public

Type:

array

[ Top ]

$types = array(
        MYSQLI_TYPE_DECIMAL     => 'decimal',
        MYSQLI_TYPE_TINY        => 'tinyint',
        MYSQLI_TYPE_SHORT       => 'int',
        MYSQLI_TYPE_LONG        => 'int',
        MYSQLI_TYPE_FLOAT       => 'float',
        MYSQLI_TYPE_DOUBLE      => 'double',
        // MYSQLI_TYPE_NULL        => 'DEFAULT NULL',  // let flags handle it
        MYSQLI_TYPE_TIMESTAMP   => 'timestamp',
        MYSQLI_TYPE_LONGLONG    => 'bigint',
        MYSQLI_TYPE_INT24       => 'mediumint',
        MYSQLI_TYPE_DATE        => 'date',
        MYSQLI_TYPE_TIME        => 'time',
        MYSQLI_TYPE_DATETIME    => 'datetime',
        MYSQLI_TYPE_YEAR        => 'year',
        MYSQLI_TYPE_NEWDATE     => 'date',
        MYSQLI_TYPE_ENUM        => 'enum',
        MYSQLI_TYPE_SET         => 'set',
        MYSQLI_TYPE_TINY_BLOB   => 'tinyblob',
        MYSQLI_TYPE_MEDIUM_BLOB => 'mediumblob',
        MYSQLI_TYPE_LONG_BLOB   => 'longblob',
        MYSQLI_TYPE_BLOB        => 'blob',
        MYSQLI_TYPE_VAR_STRING  => 'varchar',
        MYSQLI_TYPE_STRING      => 'char',
        MYSQLI_TYPE_GEOMETRY    => 'geometry',
    )

[line 87]

Array for converting MYSQLI_TYPE_* constants to text values

Since: Property available since Release 1.6.5
Access: public

Type:

array

[ Top ]

Method Detail

getTableFieldDefinition [line 124]

mixed getTableFieldDefinition(
string
$table, string
$field_name)

get the stucture of a field into an array

Return: data array on success, a MDB2 error on failure
Access: public

Overrides MDB2_Driver_Reverse_Common::getTableFieldDefinition() (get the stucture of a field into an array)

Parameters:

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

[ Top ]

getTableIndexDefinition [line 222]

mixed getTableIndexDefinition(
string
$table, string
$index_name)

get the stucture of an index into an array

Return: data array on success, a MDB2 error on failure
Access: public

Overrides MDB2_Driver_Reverse_Common::getTableIndexDefinition() (get the stucture of an index into an array)

Parameters:

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

[ Top ]

tableInfo [line 283]

array tableInfo(
object|string
$result, [int
$mode = null])

Returns information about a table or a result set

Return: an associative array with the information requested. A MDB2_Error object on failure.
See: MDB2_common::setOption()

Overridden in child classes as:

MDB2_Driver_Reverse_mysql::tableInfo(): Returns information about a table or a result set

Overrides MDB2_Driver_Reverse_Common::tableInfo() (Returns information about a table or a result set)

Parameters:

object\|string	`$result`	—	MDB2_result object from a query or a string containing the name of a table. While this also accepts a query result resource identifier, this behavior is deprecated.
int	`$mode`	—	a valid tableInfo mode

[ Top ]