Class: MDB2_Driver_Reverse_mysqli

Source Location: /MDB2_Driver_mysqli-1.5.0b4/MDB2/Driver/Reverse/mysqli.php

Class Overview

MDB2_Driver_Reverse_Common
   |
   --MDB2_Driver_Reverse_mysqli

MDB2 MySQLi driver for the schema reverse engineering module

Author(s):

Lukas Smith <smith at pooteeweet.org>
Lorenzo Alberton <l.alberton at quipo.it>

Variables

Methods

Inherited Variables

Inherited Methods

Class Details

[line 58]
MDB2 MySQLi driver for the schema reverse engineering module

Author: Lukas Smith <smith@pooteeweet.org>
Author: Lorenzo Alberton <l.alberton@quipo.it>

[ 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

Access: public

Type:

array

[ Top ]

$types = array(
        MYSQLI_TYPE_DECIMAL     => 'decimal',
        246                     => '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 86]

Array for converting MYSQLI_TYPE_* constants to text values

Access: public

Type:

array

[ Top ]

Method Detail

getTableConstraintDefinition [line 315]

mixed getTableConstraintDefinition(
string
$table_name, string
$constraint_name)

Get the structure of a constraint into an array

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

Parameters:

string	`$table_name`	—	name of table that should be used in method
string	`$constraint_name`	—	name of constraint that should be used in method

[ Top ]

getTableFieldDefinition [line 124]

mixed getTableFieldDefinition(
string
$table_name, string
$field_name)

Get the structure of a field into an array

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

Parameters:

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

[ Top ]

getTableIndexDefinition [line 240]

mixed getTableIndexDefinition(
string
$table_name, string
$index_name)

Get the structure of an index into an array

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

Parameters:

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

[ Top ]

getTriggerDefinition [line 489]

mixed getTriggerDefinition(
string
$trigger)

Get the structure of a trigger into an array

EXPERIMENTAL

WARNING: this function is experimental and may change the returned value at any time until labelled as non-experimental

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

Parameters:

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

[ Top ]

tableInfo [line 537]

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_Driver_Common::setOption()

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 ]