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

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):

Variables

Methods


Inherited Variables

Inherited Methods


Class Details

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


[ 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 ]


Documentation generated on Tue, 23 Oct 2012 18:30:48 +0000 by phpDocumentor 1.4.3. PEAR Logo Copyright © PHP Group 2004.