Debian Codegraph @

docs/dyn/datamigration_v1.projects.locations.conversionWorkspaces.mappingRules.html

raw
1 <html><body>
2 <style>
3
4 body, h1, h2, h3, div, span, p, pre, a {
5 margin: 0;
6 padding: 0;
7 border: 0;
8 font-weight: inherit;
9 font-style: inherit;
10 font-size: 100%;
11 font-family: inherit;
12 vertical-align: baseline;
13 }
14
15 body {
16 font-size: 13px;
17 padding: 1em;
18 }
19
20 h1 {
21 font-size: 26px;
22 margin-bottom: 1em;
23 }
24
25 h2 {
26 font-size: 24px;
27 margin-bottom: 1em;
28 }
29
30 h3 {
31 font-size: 20px;
32 margin-bottom: 1em;
33 margin-top: 1em;
34 }
35
36 pre, code {
37 line-height: 1.5;
38 font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Lucida Console', monospace;
39 }
40
41 pre {
42 margin-top: 0.5em;
43 }
44
45 h1, h2, h3, p {
46 font-family: Arial, sans serif;
47 }
48
49 h1, h2, h3 {
50 border-bottom: solid #CCC 1px;
51 }
52
53 .toc_element {
54 margin-top: 0.5em;
55 }
56
57 .firstline {
58 margin-left: 2 em;
59 }
60
61 .method {
62 margin-top: 1em;
63 border: solid 1px #CCC;
64 padding: 1em;
65 background: #EEE;
66 }
67
68 .details {
69 font-weight: bold;
70 font-size: 14px;
71 }
72
73 </style>
74
75 <h1><a href="datamigration_v1.html">Database Migration API</a> . <a href="datamigration_v1.projects.html">projects</a> . <a href="datamigration_v1.projects.locations.html">locations</a> . <a href="datamigration_v1.projects.locations.conversionWorkspaces.html">conversionWorkspaces</a> . <a href="datamigration_v1.projects.locations.conversionWorkspaces.mappingRules.html">mappingRules</a></h1>
76 <h2>Instance Methods</h2>
77 <p class="toc_element">
78 <code><a href="#close">close()</a></code></p>
79 <p class="firstline">Close httplib2 connections.</p>
80 <p class="toc_element">
81 <code><a href="#create">create(parent, body=None, mappingRuleId=None, requestId=None, x__xgafv=None)</a></code></p>
82 <p class="firstline">Creates a new mapping rule for a given conversion workspace.</p>
83 <p class="toc_element">
84 <code><a href="#delete">delete(name, requestId=None, x__xgafv=None)</a></code></p>
85 <p class="firstline">Deletes a single mapping rule.</p>
86 <p class="toc_element">
87 <code><a href="#get">get(name, x__xgafv=None)</a></code></p>
88 <p class="firstline">Gets the details of a mapping rule.</p>
89 <p class="toc_element">
90 <code><a href="#import_">import_(parent, body=None, x__xgafv=None)</a></code></p>
91 <p class="firstline">Imports the mapping rules for a given conversion workspace. Supports various formats of external rules files.</p>
92 <p class="toc_element">
93 <code><a href="#list">list(parent, pageSize=None, pageToken=None, x__xgafv=None)</a></code></p>
94 <p class="firstline">Lists the mapping rules for a specific conversion workspace.</p>
95 <p class="toc_element">
96 <code><a href="#list_next">list_next()</a></code></p>
97 <p class="firstline">Retrieves the next page of results.</p>
98 <h3>Method Details</h3>
99 <div class="method">
100 <code class="details" id="close">close()</code>
101 <pre>Close httplib2 connections.</pre>
102 </div>
103
104 <div class="method">
105 <code class="details" id="create">create(parent, body=None, mappingRuleId=None, requestId=None, x__xgafv=None)</code>
106 <pre>Creates a new mapping rule for a given conversion workspace.
107
108 Args:
109 parent: string, Required. The parent which owns this collection of mapping rules. (required)
110 body: object, The request body.
111 The object takes the form of:
112
113 { # 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.
114 &quot;conditionalColumnSetValue&quot;: { # Options to configure rule type ConditionalColumnSetValue. The rule is used to transform the data which is being replicated/migrated. The rule filter field can refer to one or more entities. The rule scope can be one of: Column. # 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.
115 &quot;customFeatures&quot;: { # Optional. Custom engine specific features.
116 &quot;a_key&quot;: &quot;&quot;, # Properties of the object.
117 },
118 &quot;sourceNumericFilter&quot;: { # Filter for fixed point number data types such as NUMERIC/NUMBER # Optional. Optional filter on source column precision and scale. Used for fixed point numbers such as NUMERIC/NUMBER data types.
119 &quot;numericFilterOption&quot;: &quot;A String&quot;, # Required. Enum to set the option defining the datatypes numeric filter has to be applied to
120 &quot;sourceMaxPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision smaller than or equal to this number.
121 &quot;sourceMaxScaleFilter&quot;: 42, # Optional. The filter will match columns with scale smaller than or equal to this number.
122 &quot;sourceMinPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision greater than or equal to this number.
123 &quot;sourceMinScaleFilter&quot;: 42, # Optional. The filter will match columns with scale greater than or equal to this number.
124 },
125 &quot;sourceTextFilter&quot;: { # Filter for text-based data types like varchar. # Optional. Optional filter on source column length. Used for text based data types like varchar.
126 &quot;sourceMaxLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length smaller than or equal to this number.
127 &quot;sourceMinLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length greater than or equal to this number.
128 },
129 &quot;valueTransformation&quot;: { # Description of data transformation during migration as part of the ConditionalColumnSetValue. # Required. Description of data transformation during migration.
130 &quot;applyHash&quot;: { # Apply a hash function on the value. # Optional. Applies a hash function on the data
131 &quot;uuidFromBytes&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Generate UUID from the data&#x27;s byte array
132 },
133 },
134 &quot;assignMaxValue&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Set to max_value - if integer or numeric, will use int.maxvalue, etc
135 },
136 &quot;assignMinValue&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Set to min_value - if integer or numeric, will use int.minvalue, etc
137 },
138 &quot;assignNull&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Set to null
139 },
140 &quot;assignSpecificValue&quot;: { # Set to a specific value (value is converted to fit the target data type) # Optional. Set to a specific value (value is converted to fit the target data type)
141 &quot;value&quot;: &quot;A String&quot;, # Required. Specific value to be assigned
142 },
143 &quot;doubleComparison&quot;: { # Filter based on relation between source value and compare value of type double in ConditionalColumnSetValue # Optional. Filter on relation between source value and compare value of type double.
144 &quot;value&quot;: 3.14, # Required. Double compare value to be used
145 &quot;valueComparison&quot;: &quot;A String&quot;, # Required. Relation between source value and compare value
146 },
147 &quot;intComparison&quot;: { # Filter based on relation between source value and compare value of type integer in ConditionalColumnSetValue # Optional. Filter on relation between source value and compare value of type integer.
148 &quot;value&quot;: &quot;A String&quot;, # Required. Integer compare value to be used
149 &quot;valueComparison&quot;: &quot;A String&quot;, # Required. Relation between source value and compare value
150 },
151 &quot;isNull&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Value is null
152 },
153 &quot;roundScale&quot;: { # This allows the data to change scale, for example if the source is 2 digits after the decimal point, specify round to scale value = 2. If for example the value needs to be converted to an integer, use round to scale value = 0. # Optional. Allows the data to change scale
154 &quot;scale&quot;: 42, # Required. Scale value to be used
155 },
156 &quot;valueList&quot;: { # A list of values to filter by in ConditionalColumnSetValue # Optional. Value is found in the specified list.
157 &quot;ignoreCase&quot;: True or False, # Required. Whether to ignore case when filtering by values. Defaults to false
158 &quot;valuePresentList&quot;: &quot;A String&quot;, # Required. Indicates whether the filter matches rows with values that are present in the list or those with values not present in it.
159 &quot;values&quot;: [ # Required. The list to be used to filter by
160 &quot;A String&quot;,
161 ],
162 },
163 },
164 },
165 &quot;convertRowidColumn&quot;: { # Options to configure rule type ConvertROWIDToColumn. The rule is used to add column rowid to destination tables based on an Oracle rowid function/property. The rule filter field can refer to one or more entities. The rule scope can be one of: Table. This rule requires additional filter to be specified beyond the basic rule filter field, which is whether or not to work on tables which already have a primary key defined. # Optional. Rule to specify how multiple tables should be converted with an additional rowid column.
166 &quot;onlyIfNoPrimaryKey&quot;: True or False, # Required. Only work on tables without primary key defined
167 },
168 &quot;displayName&quot;: &quot;A String&quot;, # Optional. A human readable name
169 &quot;entityMove&quot;: { # Options to configure rule type EntityMove. The rule is used to move an entity to a new schema. The rule filter field can refer to one or more entities. The rule scope can be one of: Table, Column, Constraint, Index, View, Function, Stored Procedure, Materialized View, Sequence, UDT # Optional. Rule to specify how multiple entities should be relocated into a different schema.
170 &quot;newSchema&quot;: &quot;A String&quot;, # Required. The new schema
171 },
172 &quot;filter&quot;: { # A filter defining the entities that a mapping rule should be applied to. When more than one field is specified, the rule is applied only to entities which match all the fields. # Required. The rule filter
173 &quot;entities&quot;: [ # Optional. The rule should be applied to specific entities defined by their fully qualified names.
174 &quot;A String&quot;,
175 ],
176 &quot;entityNameContains&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose non-qualified name contains the given string.
177 &quot;entityNamePrefix&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose non-qualified name starts with the given prefix.
178 &quot;entityNameSuffix&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose non-qualified name ends with the given suffix.
179 &quot;parentEntity&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose parent entity (fully qualified name) matches the given value. For example, if the rule applies to a table entity, the expected value should be a schema (schema). If the rule applies to a column or index entity, the expected value can be either a schema (schema) or a table (schema.table)
180 },
181 &quot;filterTableColumns&quot;: { # Options to configure rule type FilterTableColumns. The rule is used to filter the list of columns to include or exclude from a table. The rule filter field can refer to one entity. The rule scope can be: Table Only one of the two lists can be specified for the rule. # Optional. Rule to specify the list of columns to include or exclude from a table.
182 &quot;excludeColumns&quot;: [ # Optional. List of columns to be excluded for a particular table.
183 &quot;A String&quot;,
184 ],
185 &quot;includeColumns&quot;: [ # Optional. List of columns to be included for a particular table.
186 &quot;A String&quot;,
187 ],
188 },
189 &quot;multiColumnDataTypeChange&quot;: { # Options to configure rule type MultiColumnDatatypeChange. The rule is used to change the data type and associated properties of multiple columns at once. The rule filter field can refer to one or more entities. The rule scope can be one of:Column. This rule requires additional filters to be specified beyond the basic rule filter field, which is the source data type, but the rule supports additional filtering capabilities such as the minimum and maximum field length. All additional filters which are specified are required to be met in order for the rule to be applied (logical AND between the fields). # Optional. Rule to specify how multiple columns should be converted to a different data type.
190 &quot;customFeatures&quot;: { # Optional. Custom engine specific features.
191 &quot;a_key&quot;: &quot;&quot;, # Properties of the object.
192 },
193 &quot;newDataType&quot;: &quot;A String&quot;, # Required. New data type.
194 &quot;overrideFractionalSecondsPrecision&quot;: 42, # Optional. Column fractional seconds precision - used only for timestamp based datatypes - if not specified and relevant uses the source column fractional seconds precision.
195 &quot;overrideLength&quot;: &quot;A String&quot;, # Optional. Column length - e.g. varchar (50) - if not specified and relevant uses the source column length.
196 &quot;overridePrecision&quot;: 42, # Optional. Column precision - when relevant - if not specified and relevant uses the source column precision.
197 &quot;overrideScale&quot;: 42, # Optional. Column scale - when relevant - if not specified and relevant uses the source column scale.
198 &quot;sourceDataTypeFilter&quot;: &quot;A String&quot;, # Required. Filter on source data type.
199 &quot;sourceNumericFilter&quot;: { # Filter for fixed point number data types such as NUMERIC/NUMBER # Optional. Filter for fixed point number data types such as NUMERIC/NUMBER.
200 &quot;numericFilterOption&quot;: &quot;A String&quot;, # Required. Enum to set the option defining the datatypes numeric filter has to be applied to
201 &quot;sourceMaxPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision smaller than or equal to this number.
202 &quot;sourceMaxScaleFilter&quot;: 42, # Optional. The filter will match columns with scale smaller than or equal to this number.
203 &quot;sourceMinPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision greater than or equal to this number.
204 &quot;sourceMinScaleFilter&quot;: 42, # Optional. The filter will match columns with scale greater than or equal to this number.
205 },
206 &quot;sourceTextFilter&quot;: { # Filter for text-based data types like varchar. # Optional. Filter for text-based data types like varchar.
207 &quot;sourceMaxLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length smaller than or equal to this number.
208 &quot;sourceMinLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length greater than or equal to this number.
209 },
210 },
211 &quot;multiEntityRename&quot;: { # Options to configure rule type MultiEntityRename. The rule is used to rename multiple entities. The rule filter field can refer to one or more entities. The rule scope can be one of: Database, Schema, Table, Column, Constraint, Index, View, Function, Stored Procedure, Materialized View, Sequence, UDT # Optional. Rule to specify how multiple entities should be renamed.
212 &quot;newNamePattern&quot;: &quot;A String&quot;, # Optional. The pattern used to generate the new entity&#x27;s name. This pattern must include the characters &#x27;{name}&#x27;, which will be replaced with the name of the original entity. For example, the pattern &#x27;t_{name}&#x27; for an entity name jobs would be converted to &#x27;t_jobs&#x27;. If unspecified, the default value for this field is &#x27;{name}&#x27;
213 &quot;sourceNameTransformation&quot;: &quot;A String&quot;, # Optional. Additional transformation that can be done on the source entity name before it is being used by the new_name_pattern, for example lower case. If no transformation is desired, use NO_TRANSFORMATION
214 },
215 &quot;name&quot;: &quot;A String&quot;, # Full name of the mapping rule resource, in the form of: projects/{project}/locations/{location}/conversionWorkspaces/{set}/mappingRule/{rule}.
216 &quot;revisionCreateTime&quot;: &quot;A String&quot;, # Output only. The timestamp that the revision was created.
217 &quot;revisionId&quot;: &quot;A String&quot;, # 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.
218 &quot;ruleOrder&quot;: &quot;A String&quot;, # 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.
219 &quot;ruleScope&quot;: &quot;A String&quot;, # Required. The rule scope
220 &quot;setTablePrimaryKey&quot;: { # Options to configure rule type SetTablePrimaryKey. The rule is used to specify the columns and name to configure/alter the primary key of a table. The rule filter field can refer to one entity. The rule scope can be one of: Table. # Optional. Rule to specify the primary key for a table
221 &quot;primaryKey&quot;: &quot;A String&quot;, # Optional. Name for the primary key
222 &quot;primaryKeyColumns&quot;: [ # Required. List of column names for the primary key
223 &quot;A String&quot;,
224 ],
225 },
226 &quot;singleColumnChange&quot;: { # Options to configure rule type SingleColumnChange. The rule is used to change the properties of a column. The rule filter field can refer to one entity. The rule scope can be one of: Column. When using this rule, if a field is not specified than the destination column&#x27;s configuration will be the same as the one in the source column.. # Optional. Rule to specify how a single column is converted.
227 &quot;array&quot;: True or False, # Optional. Is the column of array type.
228 &quot;arrayLength&quot;: 42, # Optional. The length of the array, only relevant if the column type is an array.
229 &quot;autoGenerated&quot;: True or False, # Optional. Is the column auto-generated/identity.
230 &quot;charset&quot;: &quot;A String&quot;, # Optional. Charset override - instead of table level charset.
231 &quot;collation&quot;: &quot;A String&quot;, # Optional. Collation override - instead of table level collation.
232 &quot;comment&quot;: &quot;A String&quot;, # Optional. Comment associated with the column.
233 &quot;customFeatures&quot;: { # Optional. Custom engine specific features.
234 &quot;a_key&quot;: &quot;&quot;, # Properties of the object.
235 },
236 &quot;dataType&quot;: &quot;A String&quot;, # Optional. Column data type name.
237 &quot;fractionalSecondsPrecision&quot;: 42, # Optional. Column fractional seconds precision - e.g. 2 as in timestamp (2) - when relevant.
238 &quot;length&quot;: &quot;A String&quot;, # Optional. Column length - e.g. 50 as in varchar (50) - when relevant.
239 &quot;nullable&quot;: True or False, # Optional. Is the column nullable.
240 &quot;precision&quot;: 42, # Optional. Column precision - e.g. 8 as in double (8,2) - when relevant.
241 &quot;scale&quot;: 42, # Optional. Column scale - e.g. 2 as in double (8,2) - when relevant.
242 &quot;setValues&quot;: [ # Optional. Specifies the list of values allowed in the column.
243 &quot;A String&quot;,
244 ],
245 &quot;udt&quot;: True or False, # Optional. Is the column a UDT (User-defined Type).
246 },
247 &quot;singleEntityRename&quot;: { # Options to configure rule type SingleEntityRename. The rule is used to rename an entity. The rule filter field can refer to only one entity. The rule scope can be one of: Database, Schema, Table, Column, Constraint, Index, View, Function, Stored Procedure, Materialized View, Sequence, UDT, Synonym # Optional. Rule to specify how a single entity should be renamed.
248 &quot;newName&quot;: &quot;A String&quot;, # Required. The new name of the destination entity
249 },
250 &quot;singlePackageChange&quot;: { # Options to configure rule type SinglePackageChange. The rule is used to alter the sql code for a package entities. The rule filter field can refer to one entity. The rule scope can be: Package # Optional. Rule to specify how a single package is converted.
251 &quot;packageBody&quot;: &quot;A String&quot;, # Optional. Sql code for package body
252 &quot;packageDescription&quot;: &quot;A String&quot;, # Optional. Sql code for package description
253 },
254 &quot;sourceSqlChange&quot;: { # Options to configure rule type SourceSqlChange. The rule is used to alter the sql code for database entities. The rule filter field can refer to one entity. The rule scope can be: StoredProcedure, Function, Trigger, View # Optional. Rule to change the sql code for an entity, for example, function, procedure.
255 &quot;sqlCode&quot;: &quot;A String&quot;, # Required. Sql code for source (stored procedure, function, trigger or view)
256 },
257 &quot;state&quot;: &quot;A String&quot;, # Optional. The mapping rule state
258 }
259
260 mappingRuleId: string, Required. The ID of the rule to create.
261 requestId: string, Optional. A unique ID used to identify the request. If the server receives two requests with the same ID, then the second request is ignored. It is recommended to always set this value to a UUID. The ID must contain only letters (a-z, A-Z), numbers (0-9), underscores (_), and hyphens (-). The maximum length is 40 characters.
262 x__xgafv: string, V1 error format.
263 Allowed values
264 1 - v1 error format
265 2 - v2 error format
266
267 Returns:
268 An object of the form:
269
270 { # 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.
271 &quot;conditionalColumnSetValue&quot;: { # Options to configure rule type ConditionalColumnSetValue. The rule is used to transform the data which is being replicated/migrated. The rule filter field can refer to one or more entities. The rule scope can be one of: Column. # 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.
272 &quot;customFeatures&quot;: { # Optional. Custom engine specific features.
273 &quot;a_key&quot;: &quot;&quot;, # Properties of the object.
274 },
275 &quot;sourceNumericFilter&quot;: { # Filter for fixed point number data types such as NUMERIC/NUMBER # Optional. Optional filter on source column precision and scale. Used for fixed point numbers such as NUMERIC/NUMBER data types.
276 &quot;numericFilterOption&quot;: &quot;A String&quot;, # Required. Enum to set the option defining the datatypes numeric filter has to be applied to
277 &quot;sourceMaxPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision smaller than or equal to this number.
278 &quot;sourceMaxScaleFilter&quot;: 42, # Optional. The filter will match columns with scale smaller than or equal to this number.
279 &quot;sourceMinPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision greater than or equal to this number.
280 &quot;sourceMinScaleFilter&quot;: 42, # Optional. The filter will match columns with scale greater than or equal to this number.
281 },
282 &quot;sourceTextFilter&quot;: { # Filter for text-based data types like varchar. # Optional. Optional filter on source column length. Used for text based data types like varchar.
283 &quot;sourceMaxLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length smaller than or equal to this number.
284 &quot;sourceMinLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length greater than or equal to this number.
285 },
286 &quot;valueTransformation&quot;: { # Description of data transformation during migration as part of the ConditionalColumnSetValue. # Required. Description of data transformation during migration.
287 &quot;applyHash&quot;: { # Apply a hash function on the value. # Optional. Applies a hash function on the data
288 &quot;uuidFromBytes&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Generate UUID from the data&#x27;s byte array
289 },
290 },
291 &quot;assignMaxValue&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Set to max_value - if integer or numeric, will use int.maxvalue, etc
292 },
293 &quot;assignMinValue&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Set to min_value - if integer or numeric, will use int.minvalue, etc
294 },
295 &quot;assignNull&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Set to null
296 },
297 &quot;assignSpecificValue&quot;: { # Set to a specific value (value is converted to fit the target data type) # Optional. Set to a specific value (value is converted to fit the target data type)
298 &quot;value&quot;: &quot;A String&quot;, # Required. Specific value to be assigned
299 },
300 &quot;doubleComparison&quot;: { # Filter based on relation between source value and compare value of type double in ConditionalColumnSetValue # Optional. Filter on relation between source value and compare value of type double.
301 &quot;value&quot;: 3.14, # Required. Double compare value to be used
302 &quot;valueComparison&quot;: &quot;A String&quot;, # Required. Relation between source value and compare value
303 },
304 &quot;intComparison&quot;: { # Filter based on relation between source value and compare value of type integer in ConditionalColumnSetValue # Optional. Filter on relation between source value and compare value of type integer.
305 &quot;value&quot;: &quot;A String&quot;, # Required. Integer compare value to be used
306 &quot;valueComparison&quot;: &quot;A String&quot;, # Required. Relation between source value and compare value
307 },
308 &quot;isNull&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Value is null
309 },
310 &quot;roundScale&quot;: { # This allows the data to change scale, for example if the source is 2 digits after the decimal point, specify round to scale value = 2. If for example the value needs to be converted to an integer, use round to scale value = 0. # Optional. Allows the data to change scale
311 &quot;scale&quot;: 42, # Required. Scale value to be used
312 },
313 &quot;valueList&quot;: { # A list of values to filter by in ConditionalColumnSetValue # Optional. Value is found in the specified list.
314 &quot;ignoreCase&quot;: True or False, # Required. Whether to ignore case when filtering by values. Defaults to false
315 &quot;valuePresentList&quot;: &quot;A String&quot;, # Required. Indicates whether the filter matches rows with values that are present in the list or those with values not present in it.
316 &quot;values&quot;: [ # Required. The list to be used to filter by
317 &quot;A String&quot;,
318 ],
319 },
320 },
321 },
322 &quot;convertRowidColumn&quot;: { # Options to configure rule type ConvertROWIDToColumn. The rule is used to add column rowid to destination tables based on an Oracle rowid function/property. The rule filter field can refer to one or more entities. The rule scope can be one of: Table. This rule requires additional filter to be specified beyond the basic rule filter field, which is whether or not to work on tables which already have a primary key defined. # Optional. Rule to specify how multiple tables should be converted with an additional rowid column.
323 &quot;onlyIfNoPrimaryKey&quot;: True or False, # Required. Only work on tables without primary key defined
324 },
325 &quot;displayName&quot;: &quot;A String&quot;, # Optional. A human readable name
326 &quot;entityMove&quot;: { # Options to configure rule type EntityMove. The rule is used to move an entity to a new schema. The rule filter field can refer to one or more entities. The rule scope can be one of: Table, Column, Constraint, Index, View, Function, Stored Procedure, Materialized View, Sequence, UDT # Optional. Rule to specify how multiple entities should be relocated into a different schema.
327 &quot;newSchema&quot;: &quot;A String&quot;, # Required. The new schema
328 },
329 &quot;filter&quot;: { # A filter defining the entities that a mapping rule should be applied to. When more than one field is specified, the rule is applied only to entities which match all the fields. # Required. The rule filter
330 &quot;entities&quot;: [ # Optional. The rule should be applied to specific entities defined by their fully qualified names.
331 &quot;A String&quot;,
332 ],
333 &quot;entityNameContains&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose non-qualified name contains the given string.
334 &quot;entityNamePrefix&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose non-qualified name starts with the given prefix.
335 &quot;entityNameSuffix&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose non-qualified name ends with the given suffix.
336 &quot;parentEntity&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose parent entity (fully qualified name) matches the given value. For example, if the rule applies to a table entity, the expected value should be a schema (schema). If the rule applies to a column or index entity, the expected value can be either a schema (schema) or a table (schema.table)
337 },
338 &quot;filterTableColumns&quot;: { # Options to configure rule type FilterTableColumns. The rule is used to filter the list of columns to include or exclude from a table. The rule filter field can refer to one entity. The rule scope can be: Table Only one of the two lists can be specified for the rule. # Optional. Rule to specify the list of columns to include or exclude from a table.
339 &quot;excludeColumns&quot;: [ # Optional. List of columns to be excluded for a particular table.
340 &quot;A String&quot;,
341 ],
342 &quot;includeColumns&quot;: [ # Optional. List of columns to be included for a particular table.
343 &quot;A String&quot;,
344 ],
345 },
346 &quot;multiColumnDataTypeChange&quot;: { # Options to configure rule type MultiColumnDatatypeChange. The rule is used to change the data type and associated properties of multiple columns at once. The rule filter field can refer to one or more entities. The rule scope can be one of:Column. This rule requires additional filters to be specified beyond the basic rule filter field, which is the source data type, but the rule supports additional filtering capabilities such as the minimum and maximum field length. All additional filters which are specified are required to be met in order for the rule to be applied (logical AND between the fields). # Optional. Rule to specify how multiple columns should be converted to a different data type.
347 &quot;customFeatures&quot;: { # Optional. Custom engine specific features.
348 &quot;a_key&quot;: &quot;&quot;, # Properties of the object.
349 },
350 &quot;newDataType&quot;: &quot;A String&quot;, # Required. New data type.
351 &quot;overrideFractionalSecondsPrecision&quot;: 42, # Optional. Column fractional seconds precision - used only for timestamp based datatypes - if not specified and relevant uses the source column fractional seconds precision.
352 &quot;overrideLength&quot;: &quot;A String&quot;, # Optional. Column length - e.g. varchar (50) - if not specified and relevant uses the source column length.
353 &quot;overridePrecision&quot;: 42, # Optional. Column precision - when relevant - if not specified and relevant uses the source column precision.
354 &quot;overrideScale&quot;: 42, # Optional. Column scale - when relevant - if not specified and relevant uses the source column scale.
355 &quot;sourceDataTypeFilter&quot;: &quot;A String&quot;, # Required. Filter on source data type.
356 &quot;sourceNumericFilter&quot;: { # Filter for fixed point number data types such as NUMERIC/NUMBER # Optional. Filter for fixed point number data types such as NUMERIC/NUMBER.
357 &quot;numericFilterOption&quot;: &quot;A String&quot;, # Required. Enum to set the option defining the datatypes numeric filter has to be applied to
358 &quot;sourceMaxPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision smaller than or equal to this number.
359 &quot;sourceMaxScaleFilter&quot;: 42, # Optional. The filter will match columns with scale smaller than or equal to this number.
360 &quot;sourceMinPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision greater than or equal to this number.
361 &quot;sourceMinScaleFilter&quot;: 42, # Optional. The filter will match columns with scale greater than or equal to this number.
362 },
363 &quot;sourceTextFilter&quot;: { # Filter for text-based data types like varchar. # Optional. Filter for text-based data types like varchar.
364 &quot;sourceMaxLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length smaller than or equal to this number.
365 &quot;sourceMinLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length greater than or equal to this number.
366 },
367 },
368 &quot;multiEntityRename&quot;: { # Options to configure rule type MultiEntityRename. The rule is used to rename multiple entities. The rule filter field can refer to one or more entities. The rule scope can be one of: Database, Schema, Table, Column, Constraint, Index, View, Function, Stored Procedure, Materialized View, Sequence, UDT # Optional. Rule to specify how multiple entities should be renamed.
369 &quot;newNamePattern&quot;: &quot;A String&quot;, # Optional. The pattern used to generate the new entity&#x27;s name. This pattern must include the characters &#x27;{name}&#x27;, which will be replaced with the name of the original entity. For example, the pattern &#x27;t_{name}&#x27; for an entity name jobs would be converted to &#x27;t_jobs&#x27;. If unspecified, the default value for this field is &#x27;{name}&#x27;
370 &quot;sourceNameTransformation&quot;: &quot;A String&quot;, # Optional. Additional transformation that can be done on the source entity name before it is being used by the new_name_pattern, for example lower case. If no transformation is desired, use NO_TRANSFORMATION
371 },
372 &quot;name&quot;: &quot;A String&quot;, # Full name of the mapping rule resource, in the form of: projects/{project}/locations/{location}/conversionWorkspaces/{set}/mappingRule/{rule}.
373 &quot;revisionCreateTime&quot;: &quot;A String&quot;, # Output only. The timestamp that the revision was created.
374 &quot;revisionId&quot;: &quot;A String&quot;, # 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.
375 &quot;ruleOrder&quot;: &quot;A String&quot;, # 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.
376 &quot;ruleScope&quot;: &quot;A String&quot;, # Required. The rule scope
377 &quot;setTablePrimaryKey&quot;: { # Options to configure rule type SetTablePrimaryKey. The rule is used to specify the columns and name to configure/alter the primary key of a table. The rule filter field can refer to one entity. The rule scope can be one of: Table. # Optional. Rule to specify the primary key for a table
378 &quot;primaryKey&quot;: &quot;A String&quot;, # Optional. Name for the primary key
379 &quot;primaryKeyColumns&quot;: [ # Required. List of column names for the primary key
380 &quot;A String&quot;,
381 ],
382 },
383 &quot;singleColumnChange&quot;: { # Options to configure rule type SingleColumnChange. The rule is used to change the properties of a column. The rule filter field can refer to one entity. The rule scope can be one of: Column. When using this rule, if a field is not specified than the destination column&#x27;s configuration will be the same as the one in the source column.. # Optional. Rule to specify how a single column is converted.
384 &quot;array&quot;: True or False, # Optional. Is the column of array type.
385 &quot;arrayLength&quot;: 42, # Optional. The length of the array, only relevant if the column type is an array.
386 &quot;autoGenerated&quot;: True or False, # Optional. Is the column auto-generated/identity.
387 &quot;charset&quot;: &quot;A String&quot;, # Optional. Charset override - instead of table level charset.
388 &quot;collation&quot;: &quot;A String&quot;, # Optional. Collation override - instead of table level collation.
389 &quot;comment&quot;: &quot;A String&quot;, # Optional. Comment associated with the column.
390 &quot;customFeatures&quot;: { # Optional. Custom engine specific features.
391 &quot;a_key&quot;: &quot;&quot;, # Properties of the object.
392 },
393 &quot;dataType&quot;: &quot;A String&quot;, # Optional. Column data type name.
394 &quot;fractionalSecondsPrecision&quot;: 42, # Optional. Column fractional seconds precision - e.g. 2 as in timestamp (2) - when relevant.
395 &quot;length&quot;: &quot;A String&quot;, # Optional. Column length - e.g. 50 as in varchar (50) - when relevant.
396 &quot;nullable&quot;: True or False, # Optional. Is the column nullable.
397 &quot;precision&quot;: 42, # Optional. Column precision - e.g. 8 as in double (8,2) - when relevant.
398 &quot;scale&quot;: 42, # Optional. Column scale - e.g. 2 as in double (8,2) - when relevant.
399 &quot;setValues&quot;: [ # Optional. Specifies the list of values allowed in the column.
400 &quot;A String&quot;,
401 ],
402 &quot;udt&quot;: True or False, # Optional. Is the column a UDT (User-defined Type).
403 },
404 &quot;singleEntityRename&quot;: { # Options to configure rule type SingleEntityRename. The rule is used to rename an entity. The rule filter field can refer to only one entity. The rule scope can be one of: Database, Schema, Table, Column, Constraint, Index, View, Function, Stored Procedure, Materialized View, Sequence, UDT, Synonym # Optional. Rule to specify how a single entity should be renamed.
405 &quot;newName&quot;: &quot;A String&quot;, # Required. The new name of the destination entity
406 },
407 &quot;singlePackageChange&quot;: { # Options to configure rule type SinglePackageChange. The rule is used to alter the sql code for a package entities. The rule filter field can refer to one entity. The rule scope can be: Package # Optional. Rule to specify how a single package is converted.
408 &quot;packageBody&quot;: &quot;A String&quot;, # Optional. Sql code for package body
409 &quot;packageDescription&quot;: &quot;A String&quot;, # Optional. Sql code for package description
410 },
411 &quot;sourceSqlChange&quot;: { # Options to configure rule type SourceSqlChange. The rule is used to alter the sql code for database entities. The rule filter field can refer to one entity. The rule scope can be: StoredProcedure, Function, Trigger, View # Optional. Rule to change the sql code for an entity, for example, function, procedure.
412 &quot;sqlCode&quot;: &quot;A String&quot;, # Required. Sql code for source (stored procedure, function, trigger or view)
413 },
414 &quot;state&quot;: &quot;A String&quot;, # Optional. The mapping rule state
415 }</pre>
416 </div>
417
418 <div class="method">
419 <code class="details" id="delete">delete(name, requestId=None, x__xgafv=None)</code>
420 <pre>Deletes a single mapping rule.
421
422 Args:
423 name: string, Required. Name of the mapping rule resource to delete. (required)
424 requestId: string, Optional. A unique ID used to identify the request. If the server receives two requests with the same ID, then the second request is ignored. It is recommended to always set this value to a UUID. The ID must contain only letters (a-z, A-Z), numbers (0-9), underscores (_), and hyphens (-). The maximum length is 40 characters.
425 x__xgafv: string, V1 error format.
426 Allowed values
427 1 - v1 error format
428 2 - v2 error format
429
430 Returns:
431 An object of the form:
432
433 { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); }
434 }</pre>
435 </div>
436
437 <div class="method">
438 <code class="details" id="get">get(name, x__xgafv=None)</code>
439 <pre>Gets the details of a mapping rule.
440
441 Args:
442 name: string, Required. Name of the mapping rule resource to get. Example: conversionWorkspaces/123/mappingRules/rule123 In order to retrieve a previous revision of the mapping rule, also provide the revision ID. Example: conversionWorkspace/123/mappingRules/rule123@c7cfa2a8c7cfa2a8c7cfa2a8c7cfa2a8 (required)
443 x__xgafv: string, V1 error format.
444 Allowed values
445 1 - v1 error format
446 2 - v2 error format
447
448 Returns:
449 An object of the form:
450
451 { # 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.
452 &quot;conditionalColumnSetValue&quot;: { # Options to configure rule type ConditionalColumnSetValue. The rule is used to transform the data which is being replicated/migrated. The rule filter field can refer to one or more entities. The rule scope can be one of: Column. # 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.
453 &quot;customFeatures&quot;: { # Optional. Custom engine specific features.
454 &quot;a_key&quot;: &quot;&quot;, # Properties of the object.
455 },
456 &quot;sourceNumericFilter&quot;: { # Filter for fixed point number data types such as NUMERIC/NUMBER # Optional. Optional filter on source column precision and scale. Used for fixed point numbers such as NUMERIC/NUMBER data types.
457 &quot;numericFilterOption&quot;: &quot;A String&quot;, # Required. Enum to set the option defining the datatypes numeric filter has to be applied to
458 &quot;sourceMaxPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision smaller than or equal to this number.
459 &quot;sourceMaxScaleFilter&quot;: 42, # Optional. The filter will match columns with scale smaller than or equal to this number.
460 &quot;sourceMinPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision greater than or equal to this number.
461 &quot;sourceMinScaleFilter&quot;: 42, # Optional. The filter will match columns with scale greater than or equal to this number.
462 },
463 &quot;sourceTextFilter&quot;: { # Filter for text-based data types like varchar. # Optional. Optional filter on source column length. Used for text based data types like varchar.
464 &quot;sourceMaxLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length smaller than or equal to this number.
465 &quot;sourceMinLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length greater than or equal to this number.
466 },
467 &quot;valueTransformation&quot;: { # Description of data transformation during migration as part of the ConditionalColumnSetValue. # Required. Description of data transformation during migration.
468 &quot;applyHash&quot;: { # Apply a hash function on the value. # Optional. Applies a hash function on the data
469 &quot;uuidFromBytes&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Generate UUID from the data&#x27;s byte array
470 },
471 },
472 &quot;assignMaxValue&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Set to max_value - if integer or numeric, will use int.maxvalue, etc
473 },
474 &quot;assignMinValue&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Set to min_value - if integer or numeric, will use int.minvalue, etc
475 },
476 &quot;assignNull&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Set to null
477 },
478 &quot;assignSpecificValue&quot;: { # Set to a specific value (value is converted to fit the target data type) # Optional. Set to a specific value (value is converted to fit the target data type)
479 &quot;value&quot;: &quot;A String&quot;, # Required. Specific value to be assigned
480 },
481 &quot;doubleComparison&quot;: { # Filter based on relation between source value and compare value of type double in ConditionalColumnSetValue # Optional. Filter on relation between source value and compare value of type double.
482 &quot;value&quot;: 3.14, # Required. Double compare value to be used
483 &quot;valueComparison&quot;: &quot;A String&quot;, # Required. Relation between source value and compare value
484 },
485 &quot;intComparison&quot;: { # Filter based on relation between source value and compare value of type integer in ConditionalColumnSetValue # Optional. Filter on relation between source value and compare value of type integer.
486 &quot;value&quot;: &quot;A String&quot;, # Required. Integer compare value to be used
487 &quot;valueComparison&quot;: &quot;A String&quot;, # Required. Relation between source value and compare value
488 },
489 &quot;isNull&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Value is null
490 },
491 &quot;roundScale&quot;: { # This allows the data to change scale, for example if the source is 2 digits after the decimal point, specify round to scale value = 2. If for example the value needs to be converted to an integer, use round to scale value = 0. # Optional. Allows the data to change scale
492 &quot;scale&quot;: 42, # Required. Scale value to be used
493 },
494 &quot;valueList&quot;: { # A list of values to filter by in ConditionalColumnSetValue # Optional. Value is found in the specified list.
495 &quot;ignoreCase&quot;: True or False, # Required. Whether to ignore case when filtering by values. Defaults to false
496 &quot;valuePresentList&quot;: &quot;A String&quot;, # Required. Indicates whether the filter matches rows with values that are present in the list or those with values not present in it.
497 &quot;values&quot;: [ # Required. The list to be used to filter by
498 &quot;A String&quot;,
499 ],
500 },
501 },
502 },
503 &quot;convertRowidColumn&quot;: { # Options to configure rule type ConvertROWIDToColumn. The rule is used to add column rowid to destination tables based on an Oracle rowid function/property. The rule filter field can refer to one or more entities. The rule scope can be one of: Table. This rule requires additional filter to be specified beyond the basic rule filter field, which is whether or not to work on tables which already have a primary key defined. # Optional. Rule to specify how multiple tables should be converted with an additional rowid column.
504 &quot;onlyIfNoPrimaryKey&quot;: True or False, # Required. Only work on tables without primary key defined
505 },
506 &quot;displayName&quot;: &quot;A String&quot;, # Optional. A human readable name
507 &quot;entityMove&quot;: { # Options to configure rule type EntityMove. The rule is used to move an entity to a new schema. The rule filter field can refer to one or more entities. The rule scope can be one of: Table, Column, Constraint, Index, View, Function, Stored Procedure, Materialized View, Sequence, UDT # Optional. Rule to specify how multiple entities should be relocated into a different schema.
508 &quot;newSchema&quot;: &quot;A String&quot;, # Required. The new schema
509 },
510 &quot;filter&quot;: { # A filter defining the entities that a mapping rule should be applied to. When more than one field is specified, the rule is applied only to entities which match all the fields. # Required. The rule filter
511 &quot;entities&quot;: [ # Optional. The rule should be applied to specific entities defined by their fully qualified names.
512 &quot;A String&quot;,
513 ],
514 &quot;entityNameContains&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose non-qualified name contains the given string.
515 &quot;entityNamePrefix&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose non-qualified name starts with the given prefix.
516 &quot;entityNameSuffix&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose non-qualified name ends with the given suffix.
517 &quot;parentEntity&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose parent entity (fully qualified name) matches the given value. For example, if the rule applies to a table entity, the expected value should be a schema (schema). If the rule applies to a column or index entity, the expected value can be either a schema (schema) or a table (schema.table)
518 },
519 &quot;filterTableColumns&quot;: { # Options to configure rule type FilterTableColumns. The rule is used to filter the list of columns to include or exclude from a table. The rule filter field can refer to one entity. The rule scope can be: Table Only one of the two lists can be specified for the rule. # Optional. Rule to specify the list of columns to include or exclude from a table.
520 &quot;excludeColumns&quot;: [ # Optional. List of columns to be excluded for a particular table.
521 &quot;A String&quot;,
522 ],
523 &quot;includeColumns&quot;: [ # Optional. List of columns to be included for a particular table.
524 &quot;A String&quot;,
525 ],
526 },
527 &quot;multiColumnDataTypeChange&quot;: { # Options to configure rule type MultiColumnDatatypeChange. The rule is used to change the data type and associated properties of multiple columns at once. The rule filter field can refer to one or more entities. The rule scope can be one of:Column. This rule requires additional filters to be specified beyond the basic rule filter field, which is the source data type, but the rule supports additional filtering capabilities such as the minimum and maximum field length. All additional filters which are specified are required to be met in order for the rule to be applied (logical AND between the fields). # Optional. Rule to specify how multiple columns should be converted to a different data type.
528 &quot;customFeatures&quot;: { # Optional. Custom engine specific features.
529 &quot;a_key&quot;: &quot;&quot;, # Properties of the object.
530 },
531 &quot;newDataType&quot;: &quot;A String&quot;, # Required. New data type.
532 &quot;overrideFractionalSecondsPrecision&quot;: 42, # Optional. Column fractional seconds precision - used only for timestamp based datatypes - if not specified and relevant uses the source column fractional seconds precision.
533 &quot;overrideLength&quot;: &quot;A String&quot;, # Optional. Column length - e.g. varchar (50) - if not specified and relevant uses the source column length.
534 &quot;overridePrecision&quot;: 42, # Optional. Column precision - when relevant - if not specified and relevant uses the source column precision.
535 &quot;overrideScale&quot;: 42, # Optional. Column scale - when relevant - if not specified and relevant uses the source column scale.
536 &quot;sourceDataTypeFilter&quot;: &quot;A String&quot;, # Required. Filter on source data type.
537 &quot;sourceNumericFilter&quot;: { # Filter for fixed point number data types such as NUMERIC/NUMBER # Optional. Filter for fixed point number data types such as NUMERIC/NUMBER.
538 &quot;numericFilterOption&quot;: &quot;A String&quot;, # Required. Enum to set the option defining the datatypes numeric filter has to be applied to
539 &quot;sourceMaxPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision smaller than or equal to this number.
540 &quot;sourceMaxScaleFilter&quot;: 42, # Optional. The filter will match columns with scale smaller than or equal to this number.
541 &quot;sourceMinPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision greater than or equal to this number.
542 &quot;sourceMinScaleFilter&quot;: 42, # Optional. The filter will match columns with scale greater than or equal to this number.
543 },
544 &quot;sourceTextFilter&quot;: { # Filter for text-based data types like varchar. # Optional. Filter for text-based data types like varchar.
545 &quot;sourceMaxLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length smaller than or equal to this number.
546 &quot;sourceMinLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length greater than or equal to this number.
547 },
548 },
549 &quot;multiEntityRename&quot;: { # Options to configure rule type MultiEntityRename. The rule is used to rename multiple entities. The rule filter field can refer to one or more entities. The rule scope can be one of: Database, Schema, Table, Column, Constraint, Index, View, Function, Stored Procedure, Materialized View, Sequence, UDT # Optional. Rule to specify how multiple entities should be renamed.
550 &quot;newNamePattern&quot;: &quot;A String&quot;, # Optional. The pattern used to generate the new entity&#x27;s name. This pattern must include the characters &#x27;{name}&#x27;, which will be replaced with the name of the original entity. For example, the pattern &#x27;t_{name}&#x27; for an entity name jobs would be converted to &#x27;t_jobs&#x27;. If unspecified, the default value for this field is &#x27;{name}&#x27;
551 &quot;sourceNameTransformation&quot;: &quot;A String&quot;, # Optional. Additional transformation that can be done on the source entity name before it is being used by the new_name_pattern, for example lower case. If no transformation is desired, use NO_TRANSFORMATION
552 },
553 &quot;name&quot;: &quot;A String&quot;, # Full name of the mapping rule resource, in the form of: projects/{project}/locations/{location}/conversionWorkspaces/{set}/mappingRule/{rule}.
554 &quot;revisionCreateTime&quot;: &quot;A String&quot;, # Output only. The timestamp that the revision was created.
555 &quot;revisionId&quot;: &quot;A String&quot;, # 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.
556 &quot;ruleOrder&quot;: &quot;A String&quot;, # 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.
557 &quot;ruleScope&quot;: &quot;A String&quot;, # Required. The rule scope
558 &quot;setTablePrimaryKey&quot;: { # Options to configure rule type SetTablePrimaryKey. The rule is used to specify the columns and name to configure/alter the primary key of a table. The rule filter field can refer to one entity. The rule scope can be one of: Table. # Optional. Rule to specify the primary key for a table
559 &quot;primaryKey&quot;: &quot;A String&quot;, # Optional. Name for the primary key
560 &quot;primaryKeyColumns&quot;: [ # Required. List of column names for the primary key
561 &quot;A String&quot;,
562 ],
563 },
564 &quot;singleColumnChange&quot;: { # Options to configure rule type SingleColumnChange. The rule is used to change the properties of a column. The rule filter field can refer to one entity. The rule scope can be one of: Column. When using this rule, if a field is not specified than the destination column&#x27;s configuration will be the same as the one in the source column.. # Optional. Rule to specify how a single column is converted.
565 &quot;array&quot;: True or False, # Optional. Is the column of array type.
566 &quot;arrayLength&quot;: 42, # Optional. The length of the array, only relevant if the column type is an array.
567 &quot;autoGenerated&quot;: True or False, # Optional. Is the column auto-generated/identity.
568 &quot;charset&quot;: &quot;A String&quot;, # Optional. Charset override - instead of table level charset.
569 &quot;collation&quot;: &quot;A String&quot;, # Optional. Collation override - instead of table level collation.
570 &quot;comment&quot;: &quot;A String&quot;, # Optional. Comment associated with the column.
571 &quot;customFeatures&quot;: { # Optional. Custom engine specific features.
572 &quot;a_key&quot;: &quot;&quot;, # Properties of the object.
573 },
574 &quot;dataType&quot;: &quot;A String&quot;, # Optional. Column data type name.
575 &quot;fractionalSecondsPrecision&quot;: 42, # Optional. Column fractional seconds precision - e.g. 2 as in timestamp (2) - when relevant.
576 &quot;length&quot;: &quot;A String&quot;, # Optional. Column length - e.g. 50 as in varchar (50) - when relevant.
577 &quot;nullable&quot;: True or False, # Optional. Is the column nullable.
578 &quot;precision&quot;: 42, # Optional. Column precision - e.g. 8 as in double (8,2) - when relevant.
579 &quot;scale&quot;: 42, # Optional. Column scale - e.g. 2 as in double (8,2) - when relevant.
580 &quot;setValues&quot;: [ # Optional. Specifies the list of values allowed in the column.
581 &quot;A String&quot;,
582 ],
583 &quot;udt&quot;: True or False, # Optional. Is the column a UDT (User-defined Type).
584 },
585 &quot;singleEntityRename&quot;: { # Options to configure rule type SingleEntityRename. The rule is used to rename an entity. The rule filter field can refer to only one entity. The rule scope can be one of: Database, Schema, Table, Column, Constraint, Index, View, Function, Stored Procedure, Materialized View, Sequence, UDT, Synonym # Optional. Rule to specify how a single entity should be renamed.
586 &quot;newName&quot;: &quot;A String&quot;, # Required. The new name of the destination entity
587 },
588 &quot;singlePackageChange&quot;: { # Options to configure rule type SinglePackageChange. The rule is used to alter the sql code for a package entities. The rule filter field can refer to one entity. The rule scope can be: Package # Optional. Rule to specify how a single package is converted.
589 &quot;packageBody&quot;: &quot;A String&quot;, # Optional. Sql code for package body
590 &quot;packageDescription&quot;: &quot;A String&quot;, # Optional. Sql code for package description
591 },
592 &quot;sourceSqlChange&quot;: { # Options to configure rule type SourceSqlChange. The rule is used to alter the sql code for database entities. The rule filter field can refer to one entity. The rule scope can be: StoredProcedure, Function, Trigger, View # Optional. Rule to change the sql code for an entity, for example, function, procedure.
593 &quot;sqlCode&quot;: &quot;A String&quot;, # Required. Sql code for source (stored procedure, function, trigger or view)
594 },
595 &quot;state&quot;: &quot;A String&quot;, # Optional. The mapping rule state
596 }</pre>
597 </div>
598
599 <div class="method">
600 <code class="details" id="import_">import_(parent, body=None, x__xgafv=None)</code>
601 <pre>Imports the mapping rules for a given conversion workspace. Supports various formats of external rules files.
602
603 Args:
604 parent: string, Required. Name of the conversion workspace resource to import the rules to in the form of: projects/{project}/locations/{location}/conversionWorkspaces/{conversion_workspace}. (required)
605 body: object, The request body.
606 The object takes the form of:
607
608 { # Request message for &#x27;ImportMappingRules&#x27; request.
609 &quot;autoCommit&quot;: True or False, # Required. Should the conversion workspace be committed automatically after the import operation.
610 &quot;rulesFiles&quot;: [ # Required. One or more rules files.
611 { # Details of a single rules file.
612 &quot;rulesContent&quot;: &quot;A String&quot;, # Required. The text content of the rules that needs to be converted.
613 &quot;rulesSourceFilename&quot;: &quot;A String&quot;, # Required. The filename of the rules that needs to be converted. The filename is used mainly so that future logs of the import rules job contain it, and can therefore be searched by it.
614 },
615 ],
616 &quot;rulesFormat&quot;: &quot;A String&quot;, # Required. The format of the rules content file.
617 }
618
619 x__xgafv: string, V1 error format.
620 Allowed values
621 1 - v1 error format
622 2 - v2 error format
623
624 Returns:
625 An object of the form:
626
627 { # This resource represents a long-running operation that is the result of a network API call.
628 &quot;done&quot;: True or False, # If the value is `false`, it means the operation is still in progress. If `true`, the operation is completed, and either `error` or `response` is available.
629 &quot;error&quot;: { # The `Status` type defines a logical error model that is suitable for different programming environments, including REST APIs and RPC APIs. It is used by [gRPC](https://github.com/grpc). Each `Status` message contains three pieces of data: error code, error message, and error details. You can find out more about this error model and how to work with it in the [API Design Guide](https://cloud.google.com/apis/design/errors). # The error result of the operation in case of failure or cancellation.
630 &quot;code&quot;: 42, # The status code, which should be an enum value of google.rpc.Code.
631 &quot;details&quot;: [ # A list of messages that carry the error details. There is a common set of message types for APIs to use.
632 {
633 &quot;a_key&quot;: &quot;&quot;, # Properties of the object. Contains field @type with type URL.
634 },
635 ],
636 &quot;message&quot;: &quot;A String&quot;, # A developer-facing error message, which should be in English. Any user-facing error message should be localized and sent in the google.rpc.Status.details field, or localized by the client.
637 },
638 &quot;metadata&quot;: { # Service-specific metadata associated with the operation. It typically contains progress information and common metadata such as create time. Some services might not provide such metadata. Any method that returns a long-running operation should document the metadata type, if any.
639 &quot;a_key&quot;: &quot;&quot;, # Properties of the object. Contains field @type with type URL.
640 },
641 &quot;name&quot;: &quot;A String&quot;, # The server-assigned name, which is only unique within the same service that originally returns it. If you use the default HTTP mapping, the `name` should be a resource name ending with `operations/{unique_id}`.
642 &quot;response&quot;: { # The normal, successful response of the operation. If the original method returns no data on success, such as `Delete`, the response is `google.protobuf.Empty`. If the original method is standard `Get`/`Create`/`Update`, the response should be the resource. For other methods, the response should have the type `XxxResponse`, where `Xxx` is the original method name. For example, if the original method name is `TakeSnapshot()`, the inferred response type is `TakeSnapshotResponse`.
643 &quot;a_key&quot;: &quot;&quot;, # Properties of the object. Contains field @type with type URL.
644 },
645 }</pre>
646 </div>
647
648 <div class="method">
649 <code class="details" id="list">list(parent, pageSize=None, pageToken=None, x__xgafv=None)</code>
650 <pre>Lists the mapping rules for a specific conversion workspace.
651
652 Args:
653 parent: string, Required. Name of the conversion workspace resource whose mapping rules are listed in the form of: projects/{project}/locations/{location}/conversionWorkspaces/{conversion_workspace}. (required)
654 pageSize: integer, Optional. The maximum number of rules to return. The service may return fewer than this value.
655 pageToken: string, Optional. The nextPageToken value received in the previous call to mappingRules.list, used in the subsequent request to retrieve the next page of results. On first call this should be left blank. When paginating, all other parameters provided to mappingRules.list must match the call that provided the page token.
656 x__xgafv: string, V1 error format.
657 Allowed values
658 1 - v1 error format
659 2 - v2 error format
660
661 Returns:
662 An object of the form:
663
664 { # Response message for &#x27;ListMappingRulesRequest&#x27; request.
665 &quot;mappingRules&quot;: [ # The list of conversion workspace mapping rules.
666 { # 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.
667 &quot;conditionalColumnSetValue&quot;: { # Options to configure rule type ConditionalColumnSetValue. The rule is used to transform the data which is being replicated/migrated. The rule filter field can refer to one or more entities. The rule scope can be one of: Column. # 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.
668 &quot;customFeatures&quot;: { # Optional. Custom engine specific features.
669 &quot;a_key&quot;: &quot;&quot;, # Properties of the object.
670 },
671 &quot;sourceNumericFilter&quot;: { # Filter for fixed point number data types such as NUMERIC/NUMBER # Optional. Optional filter on source column precision and scale. Used for fixed point numbers such as NUMERIC/NUMBER data types.
672 &quot;numericFilterOption&quot;: &quot;A String&quot;, # Required. Enum to set the option defining the datatypes numeric filter has to be applied to
673 &quot;sourceMaxPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision smaller than or equal to this number.
674 &quot;sourceMaxScaleFilter&quot;: 42, # Optional. The filter will match columns with scale smaller than or equal to this number.
675 &quot;sourceMinPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision greater than or equal to this number.
676 &quot;sourceMinScaleFilter&quot;: 42, # Optional. The filter will match columns with scale greater than or equal to this number.
677 },
678 &quot;sourceTextFilter&quot;: { # Filter for text-based data types like varchar. # Optional. Optional filter on source column length. Used for text based data types like varchar.
679 &quot;sourceMaxLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length smaller than or equal to this number.
680 &quot;sourceMinLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length greater than or equal to this number.
681 },
682 &quot;valueTransformation&quot;: { # Description of data transformation during migration as part of the ConditionalColumnSetValue. # Required. Description of data transformation during migration.
683 &quot;applyHash&quot;: { # Apply a hash function on the value. # Optional. Applies a hash function on the data
684 &quot;uuidFromBytes&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Generate UUID from the data&#x27;s byte array
685 },
686 },
687 &quot;assignMaxValue&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Set to max_value - if integer or numeric, will use int.maxvalue, etc
688 },
689 &quot;assignMinValue&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Set to min_value - if integer or numeric, will use int.minvalue, etc
690 },
691 &quot;assignNull&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Set to null
692 },
693 &quot;assignSpecificValue&quot;: { # Set to a specific value (value is converted to fit the target data type) # Optional. Set to a specific value (value is converted to fit the target data type)
694 &quot;value&quot;: &quot;A String&quot;, # Required. Specific value to be assigned
695 },
696 &quot;doubleComparison&quot;: { # Filter based on relation between source value and compare value of type double in ConditionalColumnSetValue # Optional. Filter on relation between source value and compare value of type double.
697 &quot;value&quot;: 3.14, # Required. Double compare value to be used
698 &quot;valueComparison&quot;: &quot;A String&quot;, # Required. Relation between source value and compare value
699 },
700 &quot;intComparison&quot;: { # Filter based on relation between source value and compare value of type integer in ConditionalColumnSetValue # Optional. Filter on relation between source value and compare value of type integer.
701 &quot;value&quot;: &quot;A String&quot;, # Required. Integer compare value to be used
702 &quot;valueComparison&quot;: &quot;A String&quot;, # Required. Relation between source value and compare value
703 },
704 &quot;isNull&quot;: { # A generic empty message that you can re-use to avoid defining duplicated empty messages in your APIs. A typical example is to use it as the request or the response type of an API method. For instance: service Foo { rpc Bar(google.protobuf.Empty) returns (google.protobuf.Empty); } # Optional. Value is null
705 },
706 &quot;roundScale&quot;: { # This allows the data to change scale, for example if the source is 2 digits after the decimal point, specify round to scale value = 2. If for example the value needs to be converted to an integer, use round to scale value = 0. # Optional. Allows the data to change scale
707 &quot;scale&quot;: 42, # Required. Scale value to be used
708 },
709 &quot;valueList&quot;: { # A list of values to filter by in ConditionalColumnSetValue # Optional. Value is found in the specified list.
710 &quot;ignoreCase&quot;: True or False, # Required. Whether to ignore case when filtering by values. Defaults to false
711 &quot;valuePresentList&quot;: &quot;A String&quot;, # Required. Indicates whether the filter matches rows with values that are present in the list or those with values not present in it.
712 &quot;values&quot;: [ # Required. The list to be used to filter by
713 &quot;A String&quot;,
714 ],
715 },
716 },
717 },
718 &quot;convertRowidColumn&quot;: { # Options to configure rule type ConvertROWIDToColumn. The rule is used to add column rowid to destination tables based on an Oracle rowid function/property. The rule filter field can refer to one or more entities. The rule scope can be one of: Table. This rule requires additional filter to be specified beyond the basic rule filter field, which is whether or not to work on tables which already have a primary key defined. # Optional. Rule to specify how multiple tables should be converted with an additional rowid column.
719 &quot;onlyIfNoPrimaryKey&quot;: True or False, # Required. Only work on tables without primary key defined
720 },
721 &quot;displayName&quot;: &quot;A String&quot;, # Optional. A human readable name
722 &quot;entityMove&quot;: { # Options to configure rule type EntityMove. The rule is used to move an entity to a new schema. The rule filter field can refer to one or more entities. The rule scope can be one of: Table, Column, Constraint, Index, View, Function, Stored Procedure, Materialized View, Sequence, UDT # Optional. Rule to specify how multiple entities should be relocated into a different schema.
723 &quot;newSchema&quot;: &quot;A String&quot;, # Required. The new schema
724 },
725 &quot;filter&quot;: { # A filter defining the entities that a mapping rule should be applied to. When more than one field is specified, the rule is applied only to entities which match all the fields. # Required. The rule filter
726 &quot;entities&quot;: [ # Optional. The rule should be applied to specific entities defined by their fully qualified names.
727 &quot;A String&quot;,
728 ],
729 &quot;entityNameContains&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose non-qualified name contains the given string.
730 &quot;entityNamePrefix&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose non-qualified name starts with the given prefix.
731 &quot;entityNameSuffix&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose non-qualified name ends with the given suffix.
732 &quot;parentEntity&quot;: &quot;A String&quot;, # Optional. The rule should be applied to entities whose parent entity (fully qualified name) matches the given value. For example, if the rule applies to a table entity, the expected value should be a schema (schema). If the rule applies to a column or index entity, the expected value can be either a schema (schema) or a table (schema.table)
733 },
734 &quot;filterTableColumns&quot;: { # Options to configure rule type FilterTableColumns. The rule is used to filter the list of columns to include or exclude from a table. The rule filter field can refer to one entity. The rule scope can be: Table Only one of the two lists can be specified for the rule. # Optional. Rule to specify the list of columns to include or exclude from a table.
735 &quot;excludeColumns&quot;: [ # Optional. List of columns to be excluded for a particular table.
736 &quot;A String&quot;,
737 ],
738 &quot;includeColumns&quot;: [ # Optional. List of columns to be included for a particular table.
739 &quot;A String&quot;,
740 ],
741 },
742 &quot;multiColumnDataTypeChange&quot;: { # Options to configure rule type MultiColumnDatatypeChange. The rule is used to change the data type and associated properties of multiple columns at once. The rule filter field can refer to one or more entities. The rule scope can be one of:Column. This rule requires additional filters to be specified beyond the basic rule filter field, which is the source data type, but the rule supports additional filtering capabilities such as the minimum and maximum field length. All additional filters which are specified are required to be met in order for the rule to be applied (logical AND between the fields). # Optional. Rule to specify how multiple columns should be converted to a different data type.
743 &quot;customFeatures&quot;: { # Optional. Custom engine specific features.
744 &quot;a_key&quot;: &quot;&quot;, # Properties of the object.
745 },
746 &quot;newDataType&quot;: &quot;A String&quot;, # Required. New data type.
747 &quot;overrideFractionalSecondsPrecision&quot;: 42, # Optional. Column fractional seconds precision - used only for timestamp based datatypes - if not specified and relevant uses the source column fractional seconds precision.
748 &quot;overrideLength&quot;: &quot;A String&quot;, # Optional. Column length - e.g. varchar (50) - if not specified and relevant uses the source column length.
749 &quot;overridePrecision&quot;: 42, # Optional. Column precision - when relevant - if not specified and relevant uses the source column precision.
750 &quot;overrideScale&quot;: 42, # Optional. Column scale - when relevant - if not specified and relevant uses the source column scale.
751 &quot;sourceDataTypeFilter&quot;: &quot;A String&quot;, # Required. Filter on source data type.
752 &quot;sourceNumericFilter&quot;: { # Filter for fixed point number data types such as NUMERIC/NUMBER # Optional. Filter for fixed point number data types such as NUMERIC/NUMBER.
753 &quot;numericFilterOption&quot;: &quot;A String&quot;, # Required. Enum to set the option defining the datatypes numeric filter has to be applied to
754 &quot;sourceMaxPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision smaller than or equal to this number.
755 &quot;sourceMaxScaleFilter&quot;: 42, # Optional. The filter will match columns with scale smaller than or equal to this number.
756 &quot;sourceMinPrecisionFilter&quot;: 42, # Optional. The filter will match columns with precision greater than or equal to this number.
757 &quot;sourceMinScaleFilter&quot;: 42, # Optional. The filter will match columns with scale greater than or equal to this number.
758 },
759 &quot;sourceTextFilter&quot;: { # Filter for text-based data types like varchar. # Optional. Filter for text-based data types like varchar.
760 &quot;sourceMaxLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length smaller than or equal to this number.
761 &quot;sourceMinLengthFilter&quot;: &quot;A String&quot;, # Optional. The filter will match columns with length greater than or equal to this number.
762 },
763 },
764 &quot;multiEntityRename&quot;: { # Options to configure rule type MultiEntityRename. The rule is used to rename multiple entities. The rule filter field can refer to one or more entities. The rule scope can be one of: Database, Schema, Table, Column, Constraint, Index, View, Function, Stored Procedure, Materialized View, Sequence, UDT # Optional. Rule to specify how multiple entities should be renamed.
765 &quot;newNamePattern&quot;: &quot;A String&quot;, # Optional. The pattern used to generate the new entity&#x27;s name. This pattern must include the characters &#x27;{name}&#x27;, which will be replaced with the name of the original entity. For example, the pattern &#x27;t_{name}&#x27; for an entity name jobs would be converted to &#x27;t_jobs&#x27;. If unspecified, the default value for this field is &#x27;{name}&#x27;
766 &quot;sourceNameTransformation&quot;: &quot;A String&quot;, # Optional. Additional transformation that can be done on the source entity name before it is being used by the new_name_pattern, for example lower case. If no transformation is desired, use NO_TRANSFORMATION
767 },
768 &quot;name&quot;: &quot;A String&quot;, # Full name of the mapping rule resource, in the form of: projects/{project}/locations/{location}/conversionWorkspaces/{set}/mappingRule/{rule}.
769 &quot;revisionCreateTime&quot;: &quot;A String&quot;, # Output only. The timestamp that the revision was created.
770 &quot;revisionId&quot;: &quot;A String&quot;, # 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.
771 &quot;ruleOrder&quot;: &quot;A String&quot;, # 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.
772 &quot;ruleScope&quot;: &quot;A String&quot;, # Required. The rule scope
773 &quot;setTablePrimaryKey&quot;: { # Options to configure rule type SetTablePrimaryKey. The rule is used to specify the columns and name to configure/alter the primary key of a table. The rule filter field can refer to one entity. The rule scope can be one of: Table. # Optional. Rule to specify the primary key for a table
774 &quot;primaryKey&quot;: &quot;A String&quot;, # Optional. Name for the primary key
775 &quot;primaryKeyColumns&quot;: [ # Required. List of column names for the primary key
776 &quot;A String&quot;,
777 ],
778 },
779 &quot;singleColumnChange&quot;: { # Options to configure rule type SingleColumnChange. The rule is used to change the properties of a column. The rule filter field can refer to one entity. The rule scope can be one of: Column. When using this rule, if a field is not specified than the destination column&#x27;s configuration will be the same as the one in the source column.. # Optional. Rule to specify how a single column is converted.
780 &quot;array&quot;: True or False, # Optional. Is the column of array type.
781 &quot;arrayLength&quot;: 42, # Optional. The length of the array, only relevant if the column type is an array.
782 &quot;autoGenerated&quot;: True or False, # Optional. Is the column auto-generated/identity.
783 &quot;charset&quot;: &quot;A String&quot;, # Optional. Charset override - instead of table level charset.
784 &quot;collation&quot;: &quot;A String&quot;, # Optional. Collation override - instead of table level collation.
785 &quot;comment&quot;: &quot;A String&quot;, # Optional. Comment associated with the column.
786 &quot;customFeatures&quot;: { # Optional. Custom engine specific features.
787 &quot;a_key&quot;: &quot;&quot;, # Properties of the object.
788 },
789 &quot;dataType&quot;: &quot;A String&quot;, # Optional. Column data type name.
790 &quot;fractionalSecondsPrecision&quot;: 42, # Optional. Column fractional seconds precision - e.g. 2 as in timestamp (2) - when relevant.
791 &quot;length&quot;: &quot;A String&quot;, # Optional. Column length - e.g. 50 as in varchar (50) - when relevant.
792 &quot;nullable&quot;: True or False, # Optional. Is the column nullable.
793 &quot;precision&quot;: 42, # Optional. Column precision - e.g. 8 as in double (8,2) - when relevant.
794 &quot;scale&quot;: 42, # Optional. Column scale - e.g. 2 as in double (8,2) - when relevant.
795 &quot;setValues&quot;: [ # Optional. Specifies the list of values allowed in the column.
796 &quot;A String&quot;,
797 ],
798 &quot;udt&quot;: True or False, # Optional. Is the column a UDT (User-defined Type).
799 },
800 &quot;singleEntityRename&quot;: { # Options to configure rule type SingleEntityRename. The rule is used to rename an entity. The rule filter field can refer to only one entity. The rule scope can be one of: Database, Schema, Table, Column, Constraint, Index, View, Function, Stored Procedure, Materialized View, Sequence, UDT, Synonym # Optional. Rule to specify how a single entity should be renamed.
801 &quot;newName&quot;: &quot;A String&quot;, # Required. The new name of the destination entity
802 },
803 &quot;singlePackageChange&quot;: { # Options to configure rule type SinglePackageChange. The rule is used to alter the sql code for a package entities. The rule filter field can refer to one entity. The rule scope can be: Package # Optional. Rule to specify how a single package is converted.
804 &quot;packageBody&quot;: &quot;A String&quot;, # Optional. Sql code for package body
805 &quot;packageDescription&quot;: &quot;A String&quot;, # Optional. Sql code for package description
806 },
807 &quot;sourceSqlChange&quot;: { # Options to configure rule type SourceSqlChange. The rule is used to alter the sql code for database entities. The rule filter field can refer to one entity. The rule scope can be: StoredProcedure, Function, Trigger, View # Optional. Rule to change the sql code for an entity, for example, function, procedure.
808 &quot;sqlCode&quot;: &quot;A String&quot;, # Required. Sql code for source (stored procedure, function, trigger or view)
809 },
810 &quot;state&quot;: &quot;A String&quot;, # Optional. The mapping rule state
811 },
812 ],
813 &quot;nextPageToken&quot;: &quot;A String&quot;, # A token which can be sent as `page_token` to retrieve the next page. If this field is omitted, there are no subsequent pages.
814 }</pre>
815 </div>
816
817 <div class="method">
818 <code class="details" id="list_next">list_next()</code>
819 <pre>Retrieves the next page of results.
820
821 Args:
822 previous_request: The request for the previous page. (required)
823 previous_response: The response from the request for the previous page. (required)
824
825 Returns:
826 A request object that you can call &#x27;execute()&#x27; on to request the next
827 page. Returns None if there are no more items in the collection.
828 </pre>
829 </div>
830
831 </body></html>