PHP 클래스 Gdn_MySQLStructure, vanilla

상속: extends Gdn_DatabaseStructure
파일 보기 프로젝트 열기: vanilla/vanilla

공개 메소드들

메소드 설명
__construct ( null $Database = null )
drop ( ) Drops $this->Table() from the database.
dropColumn ( string $Name ) : boolean Drops $Name column from $this->Table().
engine ( $Engine, boolean $CheckAvailability = true )
getRowCountEstimate ( string $tableName ) : integer | null Get the estimated number of rows in a table.
hasEngine ( $Engine ) : boolean
indexSqlDb ( ) : array
renameColumn ( string $OldName, string $NewName, string $TableName = '' ) : boolean Renames a column in $this->Table().
renameTable ( string $OldName, string $NewName, boolean $UsePrefix = false ) : boolean Renames a table in the database.
view ( string $Name, $SQL ) Specifies the name of the view to create or modify.

보호된 메소드들

메소드 설명
_create ( ) Creates the table defined with $this->Table() and $this->Column().
_defineColumn ( stdClass $column, string $newColumnName = null )
_indexSql ( $Columns, boolean $KeyType = false ) : array
_indexSqlDb ( ) : array
_modify ( boolean $Explicit = false ) Modifies $this->Table() with the columns specified with $this->Column().
_quoteValue ( $Value ) : string
_supportsFulltext ( ) : boolean
getCharsetFromCollation ( string $collation ) : string Get the character set for a collation.
getTableInfo ( string $tableName ) : array? Get the high-level table information for a given table.

메소드 상세

__construct() 공개 메소드

public __construct ( null $Database = null )
$Database null

_create() 보호된 메소드

Creates the table defined with $this->Table() and $this->Column().
protected _create ( )

_defineColumn() 보호된 메소드

protected _defineColumn ( stdClass $column, string $newColumnName = null )
$column stdClass
$newColumnName string For rename action only.

_indexSql() 보호된 메소드

protected _indexSql ( $Columns, boolean $KeyType = false ) : array
$Columns
$KeyType boolean
리턴 array

_indexSqlDb() 보호된 메소드

protected _indexSqlDb ( ) : array
리턴 array

_modify() 보호된 메소드

Modifies $this->Table() with the columns specified with $this->Column().
protected _modify ( boolean $Explicit = false )
$Explicit boolean If TRUE, this method will remove any columns from the table that were not defined with $this->Column().

_quoteValue() 보호된 정적인 메소드

protected static _quoteValue ( $Value ) : string
$Value
리턴 string

_supportsFulltext() 보호된 메소드

protected _supportsFulltext ( ) : boolean
리턴 boolean

drop() 공개 메소드

Drops $this->Table() from the database.
public drop ( )

dropColumn() 공개 메소드

Drops $Name column from $this->Table().
public dropColumn ( string $Name ) : boolean
$Name string The name of the column to drop from $this->Table().
리턴 boolean

engine() 공개 메소드

public engine ( $Engine, boolean $CheckAvailability = true )
$Engine
$CheckAvailability boolean

getCharsetFromCollation() 보호된 메소드

Get the character set for a collation.
protected getCharsetFromCollation ( string $collation ) : string
$collation string The name of the collation.
리턴 string Returns the name of the character set or an empty string if the collation was not found.

getRowCountEstimate() 공개 메소드

Get the estimated number of rows in a table.
public getRowCountEstimate ( string $tableName ) : integer | null
$tableName string The name of the table to look up, without its prefix.
리턴 integer | null Returns the estimated number of rows or **null** if the information doesn't exist.

getTableInfo() 보호된 메소드

Get the high-level table information for a given table.
protected getTableInfo ( string $tableName ) : array?
$tableName string The name of the table to get the information for.
리턴 array?

hasEngine() 공개 메소드

public hasEngine ( $Engine ) : boolean
$Engine
리턴 boolean

indexSqlDb() 공개 메소드

public indexSqlDb ( ) : array
리턴 array

renameColumn() 공개 메소드

Renames a column in $this->Table().
public renameColumn ( string $OldName, string $NewName, string $TableName = '' ) : boolean
$OldName string The name of the column to be renamed.
$NewName string The new name for the column being renamed.
$TableName string
리턴 boolean

renameTable() 공개 메소드

Renames a table in the database.
public renameTable ( string $OldName, string $NewName, boolean $UsePrefix = false ) : boolean
$OldName string The name of the table to be renamed.
$NewName string The new name for the table being renamed.
$UsePrefix boolean A boolean value indicating if $this->_DatabasePrefix should be prefixed before $OldName and $NewName.
리턴 boolean

view() 공개 메소드

Specifies the name of the view to create or modify.
public view ( string $Name, $SQL )
$Name string The name of the view.