Docs For Class MDB2_TableBrowser

__construct (Constructor) [line 53]

MDB2_TableBrowser_TableValidator __construct(

&$mdbref, string
$tableName, [boolean
$caseSensitive = false])

Constructor

Access: public

Parameters:

MDB2_Driver_Common	`&$mdbref`	—	Refrence to an MDB2 connection
string	`$tableName`	—	The table name
boolean	`$caseSensitive`	—	flag to make the library case sensitive

[ Top ]

formatIdentifier [line 68]

string formatIdentifier(
string
$name)

formats the columnName to be in a format used internally. Column names are by default stored in a cases insensitive manner.

Return: The formated name
Access: public

Parameters:

string $name — The identifier

[ Top ]

getColumns [line 119]

array getColumns(
)

Returns all the columns of the table, in the order that they are defined in the table

Return: the column names
Access: public

[ Top ]

getInsertSQL [line 128]

string getInsertSQL(
)

Gets a properly formated Insert sql statment for the table.

Access: public

[ Top ]

isValidColumn [line 139]

boolean isValidColumn(
string
$columnName)

Checks to see if a column exists in the table definition

Access: public

Parameters:

string $columnName — The column name

[ Top ]

isValidData [line 174]

boolean isValidData(
string
$colName, string
$columnValue)

Checks to see if a given column value is valid given the table definition

Access: public

Parameters:

string	`$colName`	—	The column name
string	`$columnValue`	—	The column value

[ Top ]

isValidOperator [line 186]

boolean isValidOperator(
string
$op)

Checks to see if an operator is valid

Access: public

Parameters:

string $op — The operator eg: '=', '>='

[ Top ]

isValidRow [line 157]

unknown isValidRow(
array
$rowData)

Checks to see if a row is valid given the table definition

Access: public

Parameters:

array $rowData — The row data

[ Top ]

loadTableDefinition [line 78]

array loadTableDefinition(
)

Loads a table definition and stores it in the class variable self::$tableRegistry

Return: structure containing the table definition
Throws: MDB2_TableBrowser_DBException if the table is invalid or inaccessable
Access: protected

[ Top ]

quote [line 209]

string quote(
string
$data)

Escapes/Quotes a column value (uses mdb2's quote)

Access: public

Parameters:

string $data — The column value

[ Top ]

quoteIdentifier [line 198]

string quoteIdentifier(
string
$columnName)

Escapes/Quotes a column name (uses mdb2's quoteIdentifier)

Access: public

Parameters:

string $columnName — The column name

[ Top ]

Class: MDB2_TableBrowser_TableValidator

Class Overview

Author(s):

Version:

Copyright:

Variables

Methods

Inherited Variables

Inherited Methods

Class Details

Class Variables

$caseSensitiveIdentifiers = false

$mdb2Object = null

$tableName = null

$tableRegistry = array()

Method Detail

__construct (Constructor) [line 53]

Parameters:

formatIdentifier [line 68]

Parameters:

getColumns [line 119]

getInsertSQL [line 128]

isValidColumn [line 139]

Parameters:

isValidData [line 174]

Parameters:

isValidOperator [line 186]

Parameters:

isValidRow [line 157]

Parameters:

loadTableDefinition [line 78]

quote [line 209]

Parameters:

quoteIdentifier [line 198]

Parameters: