Trait yii\db\ConstraintFinderTrait
ConstraintFinderTrait provides methods for getting a table constraint information.
公共方法
方法 | 描述 | 被定义在 |
---|---|---|
getSchemaChecks() | Returns check constraints for all tables in the database. | yii\db\ConstraintFinderTrait |
getSchemaDefaultValues() | Returns default value constraints for all tables in the database. | yii\db\ConstraintFinderTrait |
getSchemaForeignKeys() | Returns foreign keys for all tables in the database. | yii\db\ConstraintFinderTrait |
getSchemaIndexes() | Returns indexes for all tables in the database. | yii\db\ConstraintFinderTrait |
getSchemaPrimaryKeys() | Returns primary keys for all tables in the database. | yii\db\ConstraintFinderTrait |
getSchemaUniques() | Returns unique constraints for all tables in the database. | yii\db\ConstraintFinderTrait |
getTableChecks() | Obtains the check constraints information for the named table. | yii\db\ConstraintFinderTrait |
getTableDefaultValues() | Obtains the default value constraints information for the named table. | yii\db\ConstraintFinderTrait |
getTableForeignKeys() | Obtains the foreign keys information for the named table. | yii\db\ConstraintFinderTrait |
getTableIndexes() | Obtains the indexes information for the named table. | yii\db\ConstraintFinderTrait |
getTablePrimaryKey() | Obtains the primary key for the named table. | yii\db\ConstraintFinderTrait |
getTableUniques() | Obtains the unique constraints information for the named table. | yii\db\ConstraintFinderTrait |
受保护的方法
方法 | 描述 | 被定义在 |
---|---|---|
getSchemaMetadata() | Returns the metadata of the given type for all tables in the given schema. | yii\db\ConstraintFinderTrait |
getTableMetadata() | Returns the metadata of the given type for the given table. | yii\db\ConstraintFinderTrait |
loadTableChecks() | Loads all check constraints for the given table. | yii\db\ConstraintFinderTrait |
loadTableDefaultValues() | Loads all default value constraints for the given table. | yii\db\ConstraintFinderTrait |
loadTableForeignKeys() | Loads all foreign keys for the given table. | yii\db\ConstraintFinderTrait |
loadTableIndexes() | Loads all indexes for the given table. | yii\db\ConstraintFinderTrait |
loadTablePrimaryKey() | Loads a primary key for the given table. | yii\db\ConstraintFinderTrait |
loadTableUniques() | Loads all unique constraints for the given table. | yii\db\ConstraintFinderTrait |
方法详情
Returns check constraints for all tables in the database.
public \yii\db\CheckConstraint[][] getSchemaChecks($schema = '', $refresh = false) | ||
$schema | string | The schema of the tables. Defaults to empty string, meaning the current or default schema name. |
$refresh | boolean | Whether 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. |
---|
Returns default value constraints for all tables in the database.
public yii\db\DefaultValueConstraint[] getSchemaDefaultValues($schema = '', $refresh = false) | ||
$schema | string | The schema of the tables. Defaults to empty string, meaning the current or default schema name. |
$refresh | boolean | Whether to fetch the latest available table schemas. If this is false, cached data may be returned if available. |
return | yii\db\DefaultValueConstraint[] | Default value constraints for all tables in the database. Each array element is an array of yii\db\DefaultValueConstraint or its child classes. |
---|
Returns foreign keys for all tables in the database.
public \yii\db\ForeignKeyConstraint[][] getSchemaForeignKeys($schema = '', $refresh = false) | ||
$schema | string | The schema of the tables. Defaults to empty string, meaning the current or default schema name. |
$refresh | boolean | Whether 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. |
---|
Returns indexes for all tables in the database.
public \yii\db\IndexConstraint[][] getSchemaIndexes($schema = '', $refresh = false) | ||
$schema | string | The schema of the tables. Defaults to empty string, meaning the current or default schema name. |
$refresh | boolean | Whether 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. |
---|
Returns the metadata of the given type for all tables in the given schema.
protected abstract array getSchemaMetadata($schema, $type, $refresh) | ||
$schema | string | The schema of the metadata. Defaults to empty string, meaning the current or default schema name. |
$type | string | Metadata type. |
$refresh | boolean | Whether to fetch the latest available table metadata. If this is |
return | array | Array of metadata. |
---|
Returns primary keys for all tables in the database.
public yii\db\Constraint[] getSchemaPrimaryKeys($schema = '', $refresh = false) | ||
$schema | string | The schema of the tables. Defaults to empty string, meaning the current or default schema name. |
$refresh | boolean | Whether to fetch the latest available table schemas. If this is |
return | yii\db\Constraint[] | Primary keys for all tables in the database. Each array element is an instance of yii\db\Constraint or its child class. |
---|
Returns unique constraints for all tables in the database.
public \yii\db\Constraint[][] getSchemaUniques($schema = '', $refresh = false) | ||
$schema | string | The schema of the tables. Defaults to empty string, meaning the current or default schema name. |
$refresh | boolean | Whether 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. |
---|
Obtains the check constraints information for the named table.
public yii\db\CheckConstraint[] getTableChecks($name, $refresh = false) | ||
$name | string | Table name. The table name may contain schema name if any. Do not quote the table name. |
$refresh | boolean | Whether to reload the information even if it is found in the cache. |
return | yii\db\CheckConstraint[] | Table check constraints. |
---|
Obtains the default value constraints information for the named table.
public yii\db\DefaultValueConstraint[] getTableDefaultValues($name, $refresh = false) | ||
$name | string | Table name. The table name may contain schema name if any. Do not quote the table name. |
$refresh | boolean | Whether to reload the information even if it is found in the cache. |
return | yii\db\DefaultValueConstraint[] | Table default value constraints. |
---|
Obtains the foreign keys information for the named table.
public yii\db\ForeignKeyConstraint[] getTableForeignKeys($name, $refresh = false) | ||
$name | string | Table name. The table name may contain schema name if any. Do not quote the table name. |
$refresh | boolean | Whether to reload the information even if it is found in the cache. |
return | yii\db\ForeignKeyConstraint[] | Table foreign keys. |
---|
Obtains the indexes information for the named table.
public yii\db\IndexConstraint[] getTableIndexes($name, $refresh = false) | ||
$name | string | Table name. The table name may contain schema name if any. Do not quote the table name. |
$refresh | boolean | Whether to reload the information even if it is found in the cache. |
return | yii\db\IndexConstraint[] | Table indexes. |
---|
Returns the metadata of the given type for the given table.
protected abstract mixed getTableMetadata($name, $type, $refresh) | ||
$name | string | Table name. The table name may contain schema name if any. Do not quote the table name. |
$type | string | Metadata type. |
$refresh | boolean | Whether to reload the table metadata even if it is found in the cache. |
return | mixed | Metadata. |
---|
Obtains the primary key for the named table.
public yii\db\Constraint|null getTablePrimaryKey($name, $refresh = false) | ||
$name | string | Table name. The table name may contain schema name if any. Do not quote the table name. |
$refresh | boolean | Whether to reload the information even if it is found in the cache. |
return | yii\db\Constraint|null | Table primary key, |
---|
Obtains the unique constraints information for the named table.
public yii\db\Constraint[] getTableUniques($name, $refresh = false) | ||
$name | string | Table name. The table name may contain schema name if any. Do not quote the table name. |
$refresh | boolean | Whether to reload the information even if it is found in the cache. |
return | yii\db\Constraint[] | Table unique constraints. |
---|
Loads all check constraints for the given table.
protected abstract yii\db\CheckConstraint[] loadTableChecks($tableName) | ||
$tableName | string | Table name. |
return | yii\db\CheckConstraint[] | Check constraints for the given table. |
---|
Loads all default value constraints for the given table.
protected abstract yii\db\DefaultValueConstraint[] loadTableDefaultValues($tableName) | ||
$tableName | string | Table name. |
return | yii\db\DefaultValueConstraint[] | Default value constraints for the given table. |
---|
Loads all foreign keys for the given table.
protected abstract yii\db\ForeignKeyConstraint[] loadTableForeignKeys($tableName) | ||
$tableName | string | Table name. |
return | yii\db\ForeignKeyConstraint[] | Foreign keys for the given table. |
---|
Loads all indexes for the given table.
protected abstract yii\db\IndexConstraint[] loadTableIndexes($tableName) | ||
$tableName | string | Table name. |
return | yii\db\IndexConstraint[] | Indexes for the given table. |
---|
Loads a primary key for the given table.
protected abstract yii\db\Constraint|null loadTablePrimaryKey($tableName) | ||
$tableName | string | Table name. |
return | yii\db\Constraint|null | Primary key for the given table, |
---|
Loads all unique constraints for the given table.
protected abstract yii\db\Constraint[] loadTableUniques($tableName) | ||
$tableName | string | Table name. |
return | yii\db\Constraint[] | Unique constraints for the given table. |
---|