Google Cloud Dms V1 Client - Class MappingRule (1.4.2)

Version 1.4.2

• 2.0.2 (latest)
• 2.0.1
• 1.5.5
• 1.4.2
• 1.3.0
• 1.2.1
• 1.1.0
• 1.0.5

Reference documentation and code samples for the Google Cloud Dms V1 Client class MappingRule.

Definition of a transformation that is to be applied to a group of entities in the source schema. Several such transformations can be applied to an entity sequentially to define the corresponding entity in the target schema.

Generated from protobuf message google.cloud.clouddms.v1.MappingRule

Namespace

Google \ Cloud \ CloudDms \ V1

Methods

__construct

Constructor.

Parameters
Name	Description
data	array Optional. Data for populating the Message object.
↳ name	string Full name of the mapping rule resource, in the form of: projects/{project}/locations/{location}/conversionWorkspaces/{set}/mappingRule/{rule}.
↳ display_name	string Optional. A human readable name
↳ state	int Optional. The mapping rule state
↳ rule_scope	int Required. The rule scope
↳ filter	Google\Cloud\CloudDms\V1\MappingRuleFilter Required. The rule filter
↳ rule_order	int|string Required. The order in which the rule is applied. Lower order rules are applied before higher value rules so they may end up being overridden.
↳ revision_id	string Output only. The revision ID of the mapping rule. A new revision is committed whenever the mapping rule is changed in any way. The format is an 8-character hexadecimal string.
↳ revision_create_time	Google\Protobuf\Timestamp Output only. The timestamp that the revision was created.
↳ single_entity_rename	Google\Cloud\CloudDms\V1\SingleEntityRename Optional. Rule to specify how a single entity should be renamed.
↳ multi_entity_rename	Google\Cloud\CloudDms\V1\MultiEntityRename Optional. Rule to specify how multiple entities should be renamed.
↳ entity_move	Google\Cloud\CloudDms\V1\EntityMove Optional. Rule to specify how multiple entities should be relocated into a different schema.
↳ single_column_change	Google\Cloud\CloudDms\V1\SingleColumnChange Optional. Rule to specify how a single column is converted.
↳ multi_column_data_type_change	Google\Cloud\CloudDms\V1\MultiColumnDatatypeChange Optional. Rule to specify how multiple columns should be converted to a different data type.
↳ conditional_column_set_value	Google\Cloud\CloudDms\V1\ConditionalColumnSetValue Optional. Rule to specify how the data contained in a column should be transformed (such as trimmed, rounded, etc) provided that the data meets certain criteria.
↳ convert_rowid_column	Google\Cloud\CloudDms\V1\ConvertRowIdToColumn Optional. Rule to specify how multiple tables should be converted with an additional rowid column.
↳ set_table_primary_key	Google\Cloud\CloudDms\V1\SetTablePrimaryKey Optional. Rule to specify the primary key for a table
↳ single_package_change	Google\Cloud\CloudDms\V1\SinglePackageChange Optional. Rule to specify how a single package is converted.
↳ source_sql_change	Google\Cloud\CloudDms\V1\SourceSqlChange Optional. Rule to change the sql code for an entity, for example, function, procedure.
↳ filter_table_columns	Google\Cloud\CloudDms\V1\FilterTableColumns Optional. Rule to specify the list of columns to include or exclude from a table.

getName

Full name of the mapping rule resource, in the form of: projects/{project}/locations/{location}/conversionWorkspaces/{set}/mappingRule/{rule}.

Returns
Type	Description
string

setName

Full name of the mapping rule resource, in the form of: projects/{project}/locations/{location}/conversionWorkspaces/{set}/mappingRule/{rule}.

Parameter
Name	Description
var	string

Returns
Type	Description
$this

getDisplayName

Optional. A human readable name

Returns
Type	Description
string

setDisplayName

Optional. A human readable name

Parameter
Name	Description
var	string

Returns
Type	Description
$this

getState

Optional. The mapping rule state

Returns
Type	Description
int

setState

Optional. The mapping rule state

Parameter
Name	Description
var	int

Returns
Type	Description
$this

getRuleScope

Required. The rule scope

Returns
Type	Description
int

setRuleScope

Required. The rule scope

Parameter
Name	Description
var	int

Returns
Type	Description
$this

getFilter

Required. The rule filter

Returns
Type	Description
Google\Cloud\CloudDms\V1\MappingRuleFilter|null

hasFilter

clearFilter

setFilter

Required. The rule filter

Parameter
Name	Description
var	Google\Cloud\CloudDms\V1\MappingRuleFilter

Returns
Type	Description
$this

getRuleOrder

Required. The order in which the rule is applied. Lower order rules are applied before higher value rules so they may end up being overridden.

Returns
Type	Description
int|string

setRuleOrder

Required. The order in which the rule is applied. Lower order rules are applied before higher value rules so they may end up being overridden.

Parameter
Name	Description
var	int|string

Returns
Type	Description
$this

getRevisionId

Output only. The revision ID of the mapping rule.

A new revision is committed whenever the mapping rule is changed in any way. The format is an 8-character hexadecimal string.

Returns
Type	Description
string

setRevisionId

Output only. The revision ID of the mapping rule.

A new revision is committed whenever the mapping rule is changed in any way. The format is an 8-character hexadecimal string.

Parameter
Name	Description
var	string

Returns
Type	Description
$this

getRevisionCreateTime

Output only. The timestamp that the revision was created.

Returns
Type	Description
Google\Protobuf\Timestamp|null

hasRevisionCreateTime

clearRevisionCreateTime

setRevisionCreateTime

Output only. The timestamp that the revision was created.

Parameter
Name	Description
var	Google\Protobuf\Timestamp

Returns
Type	Description
$this

getSingleEntityRename

Optional. Rule to specify how a single entity should be renamed.

Returns
Type	Description
Google\Cloud\CloudDms\V1\SingleEntityRename|null

hasSingleEntityRename

setSingleEntityRename

Optional. Rule to specify how a single entity should be renamed.

Parameter
Name	Description
var	Google\Cloud\CloudDms\V1\SingleEntityRename

Returns
Type	Description
$this

getMultiEntityRename

Optional. Rule to specify how multiple entities should be renamed.

Returns
Type	Description
Google\Cloud\CloudDms\V1\MultiEntityRename|null

hasMultiEntityRename

setMultiEntityRename

Optional. Rule to specify how multiple entities should be renamed.

Parameter
Name	Description
var	Google\Cloud\CloudDms\V1\MultiEntityRename

Returns
Type	Description
$this

getEntityMove

Optional. Rule to specify how multiple entities should be relocated into a different schema.

Returns
Type	Description
Google\Cloud\CloudDms\V1\EntityMove|null

hasEntityMove

setEntityMove

Optional. Rule to specify how multiple entities should be relocated into a different schema.

Parameter
Name	Description
var	Google\Cloud\CloudDms\V1\EntityMove

Returns
Type	Description
$this

getSingleColumnChange

Optional. Rule to specify how a single column is converted.

Returns
Type	Description
Google\Cloud\CloudDms\V1\SingleColumnChange|null

hasSingleColumnChange

setSingleColumnChange

Optional. Rule to specify how a single column is converted.

Parameter
Name	Description
var	Google\Cloud\CloudDms\V1\SingleColumnChange

Returns
Type	Description
$this

getMultiColumnDataTypeChange

Optional. Rule to specify how multiple columns should be converted to a different data type.

Returns
Type	Description
Google\Cloud\CloudDms\V1\MultiColumnDatatypeChange|null

hasMultiColumnDataTypeChange

setMultiColumnDataTypeChange

Optional. Rule to specify how multiple columns should be converted to a different data type.

Parameter
Name	Description
var	Google\Cloud\CloudDms\V1\MultiColumnDatatypeChange

Returns
Type	Description
$this

getConditionalColumnSetValue

Optional. Rule to specify how the data contained in a column should be transformed (such as trimmed, rounded, etc) provided that the data meets certain criteria.

Returns
Type	Description
Google\Cloud\CloudDms\V1\ConditionalColumnSetValue|null

hasConditionalColumnSetValue

setConditionalColumnSetValue

Optional. Rule to specify how the data contained in a column should be transformed (such as trimmed, rounded, etc) provided that the data meets certain criteria.

Parameter
Name	Description
var	Google\Cloud\CloudDms\V1\ConditionalColumnSetValue

Returns
Type	Description
$this

getConvertRowidColumn

Optional. Rule to specify how multiple tables should be converted with an additional rowid column.

Returns
Type	Description
Google\Cloud\CloudDms\V1\ConvertRowIdToColumn|null

hasConvertRowidColumn

setConvertRowidColumn

Optional. Rule to specify how multiple tables should be converted with an additional rowid column.

Parameter
Name	Description
var	Google\Cloud\CloudDms\V1\ConvertRowIdToColumn

Returns
Type	Description
$this

getSetTablePrimaryKey

Optional. Rule to specify the primary key for a table

Returns
Type	Description
Google\Cloud\CloudDms\V1\SetTablePrimaryKey|null

hasSetTablePrimaryKey

setSetTablePrimaryKey

Optional. Rule to specify the primary key for a table

Parameter
Name	Description
var	Google\Cloud\CloudDms\V1\SetTablePrimaryKey

Returns
Type	Description
$this

getSinglePackageChange

Optional. Rule to specify how a single package is converted.

Returns
Type	Description
Google\Cloud\CloudDms\V1\SinglePackageChange|null

hasSinglePackageChange

setSinglePackageChange

Optional. Rule to specify how a single package is converted.

Parameter
Name	Description
var	Google\Cloud\CloudDms\V1\SinglePackageChange

Returns
Type	Description
$this

getSourceSqlChange

Optional. Rule to change the sql code for an entity, for example, function, procedure.

Returns
Type	Description
Google\Cloud\CloudDms\V1\SourceSqlChange|null

hasSourceSqlChange

setSourceSqlChange

Optional. Rule to change the sql code for an entity, for example, function, procedure.

Parameter
Name	Description
var	Google\Cloud\CloudDms\V1\SourceSqlChange

Returns
Type	Description
$this

getFilterTableColumns

Optional. Rule to specify the list of columns to include or exclude from a table.

Returns
Type	Description
Google\Cloud\CloudDms\V1\FilterTableColumns|null

hasFilterTableColumns

setFilterTableColumns

Optional. Rule to specify the list of columns to include or exclude from a table.

Parameter
Name	Description
var	Google\Cloud\CloudDms\V1\FilterTableColumns

Returns
Type	Description
$this

getDetails

Returns
Type	Description
string