ConstraintFinderTrait provides methods for getting a table constraint information.
Property DetailsCheck constraints for all tables in the database. Each array element is an array of yii\db\CheckConstraint or its child classes. This property is read-only.
Default value constraints for all tables in the database. Each array element is an array of yii\db\DefaultValueConstraint or its child classes. This property is read-only.
Foreign keys for all tables in the database. Each array element is an array of yii\db\ForeignKeyConstraint or its child classes. This property is read-only.
Indexes for all tables in the database. Each array element is an array of yii\db\IndexConstraint or its child classes. This property is read-only.
Primary keys for all tables in the database. Each array element is an instance of yii\db\Constraint or its child class. This property is read-only.
Unique constraints for all tables in the database. Each array element is an array of yii\db\IndexConstraint or its child classes. This property is read-only.
Method DetailsReturns check constraints for all tables in the database.
public \yii\db\CheckConstraint[][] getSchemaChecks ( $schema = '', $refresh = false ) $schema stringThe schema of the tables. Defaults to empty string, meaning the current or default schema name.
$refresh booleanWhether to fetch the latest available table schemas. If this is false, cached data may be returned if available.
return \yii\db\CheckConstraint[][]Check constraints for all tables in the database. Each array element is an array of yii\db\CheckConstraint or its child classes.
public function getSchemaChecks($schema = '', $refresh = false)
{
return $this->getSchemaMetadata($schema, 'checks', $refresh);
}
Returns default value constraints for all tables in the database.
public function getSchemaDefaultValues($schema = '', $refresh = false)
{
return $this->getSchemaMetadata($schema, 'defaultValues', $refresh);
}
Returns foreign keys for all tables in the database.
public \yii\db\ForeignKeyConstraint[][] getSchemaForeignKeys ( $schema = '', $refresh = false ) $schema stringThe schema of the tables. Defaults to empty string, meaning the current or default schema name.
$refresh booleanWhether to fetch the latest available table schemas. If this is false, cached data may be returned if available.
return \yii\db\ForeignKeyConstraint[][]Foreign keys for all tables in the database. Each array element is an array of yii\db\ForeignKeyConstraint or its child classes.
public function getSchemaForeignKeys($schema = '', $refresh = false)
{
return $this->getSchemaMetadata($schema, 'foreignKeys', $refresh);
}
Returns indexes for all tables in the database.
public \yii\db\IndexConstraint[][] getSchemaIndexes ( $schema = '', $refresh = false ) $schema stringThe schema of the tables. Defaults to empty string, meaning the current or default schema name.
$refresh booleanWhether to fetch the latest available table schemas. If this is false, cached data may be returned if available.
return \yii\db\IndexConstraint[][]Indexes for all tables in the database. Each array element is an array of yii\db\IndexConstraint or its child classes.
public function getSchemaIndexes($schema = '', $refresh = false)
{
return $this->getSchemaMetadata($schema, 'indexes', $refresh);
}
Returns primary keys for all tables in the database.
public yii\db\Constraint[] getSchemaPrimaryKeys ( $schema = '', $refresh = false ) $schema stringThe schema of the tables. Defaults to empty string, meaning the current or default schema name.
$refresh booleanWhether to fetch the latest available table schemas. If this is false
, cached data may be returned if available.
Primary keys for all tables in the database. Each array element is an instance of yii\db\Constraint or its child class.
public function getSchemaPrimaryKeys($schema = '', $refresh = false)
{
return $this->getSchemaMetadata($schema, 'primaryKey', $refresh);
}
Returns unique constraints for all tables in the database.
public \yii\db\Constraint[][] getSchemaUniques ( $schema = '', $refresh = false ) $schema stringThe schema of the tables. Defaults to empty string, meaning the current or default schema name.
$refresh booleanWhether to fetch the latest available table schemas. If this is false, cached data may be returned if available.
return \yii\db\Constraint[][]Unique constraints for all tables in the database. Each array element is an array of yii\db\Constraint or its child classes.
public function getSchemaUniques($schema = '', $refresh = false)
{
return $this->getSchemaMetadata($schema, 'uniques', $refresh);
}
Obtains the check constraints information for the named table.
public function getTableChecks($name, $refresh = false)
{
return $this->getTableMetadata($name, 'checks', $refresh);
}
Obtains the default value constraints information for the named table.
public function getTableDefaultValues($name, $refresh = false)
{
return $this->getTableMetadata($name, 'defaultValues', $refresh);
}
Obtains the foreign keys information for the named table.
public function getTableForeignKeys($name, $refresh = false)
{
return $this->getTableMetadata($name, 'foreignKeys', $refresh);
}
Obtains the indexes information for the named table.
public function getTableIndexes($name, $refresh = false)
{
return $this->getTableMetadata($name, 'indexes', $refresh);
}
Obtains the primary key for the named table.
public function getTablePrimaryKey($name, $refresh = false)
{
return $this->getTableMetadata($name, 'primaryKey', $refresh);
}
Obtains the unique constraints information for the named table.
public function getTableUniques($name, $refresh = false)
{
return $this->getTableMetadata($name, 'uniques', $refresh);
}
Loads all check constraints for the given table.
abstract protected function loadTableChecks($tableName);
Loads all default value constraints for the given table.
abstract protected function loadTableDefaultValues($tableName);
Loads all foreign keys for the given table.
abstract protected function loadTableForeignKeys($tableName);
Loads all indexes for the given table.
abstract protected function loadTableIndexes($tableName);
Loads a primary key for the given table.
abstract protected function loadTablePrimaryKey($tableName);
Loads all unique constraints for the given table.
abstract protected function loadTableUniques($tableName);
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4