CreateDataImportOrderRequest.CreateDataImportOrderRequestParam (dms

java.lang.Object
- com.aliyun.tea.TeaModel
- - com.aliyun.dms_enterprise20181101.models.CreateDataImportOrderRequest.CreateDataImportOrderRequestParam

封闭类:: CreateDataImportOrderRequest

public static class CreateDataImportOrderRequest.CreateDataImportOrderRequestParam
extends com.aliyun.tea.TeaModel

字段概要

字段
限定符和类型	字段和说明
`String`	`attachmentName` The key of the attachment that contains the SQL statements used to import data.
`String`	`classify` The reason for the data import.
`Boolean`	`csvFirstRowIsColumnDef` The type of the CSV file.
`List<CreateDataImportOrderRequest.CreateDataImportOrderRequestParamDbItemList>`	`dbItemList` The database to which you want to import data.
`String`	`execMode`
`String`	`fileEncoding` The encoding algorithm to be used by the destination database.
`String`	`fileType` The format of the file for the data import.
`Boolean`	`ignoreError` Specifies whether to skip an error that occurs.
`String`	`importMode` The import mode.
`String`	`insertType` The mode in which the data in the CSV format is to be written to the destination table.
`String`	`rollbackAttachmentName` The key of the attachment that contains the SQL statements used to roll back the data import.
`String`	`rollbackSQL` The SQL statements used to roll back the data import.
`String`	`rollbackSqlType` The format of the SQL statements used to roll back the data import.
`String`	`tableName` The destination table to which you want to import the data in the CSV format.

构造器概要

构造器
构造器和说明

CreateDataImportOrderRequestParam()

构造器
构造器和说明
`CreateDataImportOrderRequestParam()`

方法概要

所有方法静态方法实例方法具体方法
限定符和类型	方法和说明
`static CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`build(Map<String,?> map)`
`String`	`getAttachmentName()`
`String`	`getClassify()`
`Boolean`	`getCsvFirstRowIsColumnDef()`
`List<CreateDataImportOrderRequest.CreateDataImportOrderRequestParamDbItemList>`	`getDbItemList()`
`String`	`getExecMode()`
`String`	`getFileEncoding()`
`String`	`getFileType()`
`Boolean`	`getIgnoreError()`
`String`	`getImportMode()`
`String`	`getInsertType()`
`String`	`getRollbackAttachmentName()`
`String`	`getRollbackSQL()`
`String`	`getRollbackSqlType()`
`String`	`getTableName()`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setAttachmentName(String attachmentName)`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setClassify(String classify)`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setCsvFirstRowIsColumnDef(Boolean csvFirstRowIsColumnDef)`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setDbItemList(List<CreateDataImportOrderRequest.CreateDataImportOrderRequestParamDbItemList> dbItemList)`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setExecMode(String execMode)`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setFileEncoding(String fileEncoding)`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setFileType(String fileType)`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setIgnoreError(Boolean ignoreError)`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setImportMode(String importMode)`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setInsertType(String insertType)`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setRollbackAttachmentName(String rollbackAttachmentName)`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setRollbackSQL(String rollbackSQL)`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setRollbackSqlType(String rollbackSqlType)`
`CreateDataImportOrderRequest.CreateDataImportOrderRequestParam`	`setTableName(String tableName)`

从类继承的方法 com.aliyun.tea.TeaModel
build, buildMap, confirmType, confirmType, parseObject, toMap, toMap, toModel, validate, validateParams

从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- 字段详细资料
  - attachmentName
```
@NameInMap(value="AttachmentName")
public String attachmentName
```
    The key of the attachment that contains the SQL statements used to import data. You can call the GetUserUploadFileJob operation to the attachment key from the value of the AttachmentKey parameter.
    
    This parameter is required.
    example:
    order_text
  - classify
```
@NameInMap(value="Classify")
public String classify
```
    The reason for the data import.
    example:
    test
  - csvFirstRowIsColumnDef
```
@NameInMap(value="CsvFirstRowIsColumnDef")
public Boolean csvFirstRowIsColumnDef
```
    The type of the CSV file. Valid values:
    - true: The first row in the CSV file contains field names.
    - false: The first row in the CSV file contains data.
    This parameter is required if you set the FileType parameter to CSV.
    
    example:
    true
  - dbItemList
```
@NameInMap(value="DbItemList")
public List<CreateDataImportOrderRequest.CreateDataImportOrderRequestParamDbItemList> dbItemList
```
    The database to which you want to import data. You can specify only one database.
    
    This parameter is required.
  - execMode
```
@NameInMap(value="ExecMode")
public String execMode
```
  - fileEncoding
```
@NameInMap(value="FileEncoding")
public String fileEncoding
```
    The encoding algorithm to be used by the destination database. Valid values:
    - AUTO: automatic identification
    - UTF-8: UTF-8 encoding
    - GBK: GBK encoding
    - ISO-8859-1: ISO-8859-1 encoding
    example:
    AUTO
  - fileType
```
@NameInMap(value="FileType")
public String fileType
```
    The format of the file for the data import. Valid values:
    - SQL: an SQL file
    - CSV: a CSV file
    This parameter is required.
    example:
    CSV
  - ignoreError
```
@NameInMap(value="IgnoreError")
public Boolean ignoreError
```
    Specifies whether to skip an error that occurs. Valid values:
    - true: skips the error and continues to execute SQL statements.
    - false: stops executing SQL statements.
    example:
    false
  - importMode
```
@NameInMap(value="ImportMode")
public String importMode
```
    The import mode. Valid values:
    - FAST_MODE: In the Execute step, the uploaded file is read and SQL statements are executed to import data to the specified destination database. Compared with the security mode, this mode can be used to import data in a less secure but more efficient manner.
    - SAFE_MODE: In the Precheck step, the uploaded file is parsed, and SQL statements or CSV file data is cached. In the Execute step, the cached SQL statements are read and executed to import data, or the cached CSV file data is read and imported to the specified destination database. This mode can be used to import data in a more secure but less efficient manner.
    example:
    FAST_MODE
  - insertType
```
@NameInMap(value="InsertType")
public String insertType
```
    The mode in which the data in the CSV format is to be written to the destination table. Valid values:
    - INSERT: The database checks the primary key when data is written. If a duplicate primary key value exists, an error message is returned.
    - INSERT_IGNORE: If the imported data contains data records that are the same as those in the destination table, the new data records are ignored.
    - REPLACE_INTO: If the imported data contains a row that has the same value for the primary key or unique index as one row in the destination table, the database deletes the existing row and inserts the new row into the destination table.
    This parameter is required if you set the FileType parameter to CSV.
    
    example:
    INSERT
  - rollbackAttachmentName
```
@NameInMap(value="RollbackAttachmentName")
public String rollbackAttachmentName
```
    The key of the attachment that contains the SQL statements used to roll back the data import. You can call the GetUserUploadFileJob operation to obtain the attachment key from the value of the AttachmentKey parameter.
    
    This parameter is required if you set the RollbackSqlType parameter to ATTACHMENT.
    
    example:
    rollback.sql
  - rollbackSQL
```
@NameInMap(value="RollbackSQL")
public String rollbackSQL
```
    The SQL statements used to roll back the data import.
    
    This parameter is required if you set the RollbackSqlType parameter to TEXT.
    
    example:
    empty
  - rollbackSqlType
```
@NameInMap(value="RollbackSqlType")
public String rollbackSqlType
```
    The format of the SQL statements used to roll back the data import. Valid values:
    - TEXT: text
    - ATTACHMENT: attachment
    example:
    TEXT
  - tableName
```
@NameInMap(value="TableName")
public String tableName
```
    The destination table to which you want to import the data in the CSV format.
    
    This parameter is required if you set the FileType parameter to CSV.
    
    example:
    Table_text
- 构造器详细资料
  - CreateDataImportOrderRequestParam
```
public CreateDataImportOrderRequestParam()
```
- 方法详细资料
  - build
```
public static CreateDataImportOrderRequest.CreateDataImportOrderRequestParam build(Map<String,?> map)
                                                                            throws Exception
```
    抛出:
    
    Exception
  - setAttachmentName
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setAttachmentName(String attachmentName)
```
  - getAttachmentName
```
public String getAttachmentName()
```
  - setClassify
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setClassify(String classify)
```
  - getClassify
```
public String getClassify()
```
  - setCsvFirstRowIsColumnDef
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setCsvFirstRowIsColumnDef(Boolean csvFirstRowIsColumnDef)
```
  - getCsvFirstRowIsColumnDef
```
public Boolean getCsvFirstRowIsColumnDef()
```
  - setDbItemList
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setDbItemList(List<CreateDataImportOrderRequest.CreateDataImportOrderRequestParamDbItemList> dbItemList)
```
  - getDbItemList
```
public List<CreateDataImportOrderRequest.CreateDataImportOrderRequestParamDbItemList> getDbItemList()
```
  - setExecMode
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setExecMode(String execMode)
```
  - getExecMode
```
public String getExecMode()
```
  - setFileEncoding
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setFileEncoding(String fileEncoding)
```
  - getFileEncoding
```
public String getFileEncoding()
```
  - setFileType
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setFileType(String fileType)
```
  - getFileType
```
public String getFileType()
```
  - setIgnoreError
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setIgnoreError(Boolean ignoreError)
```
  - getIgnoreError
```
public Boolean getIgnoreError()
```
  - setImportMode
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setImportMode(String importMode)
```
  - getImportMode
```
public String getImportMode()
```
  - setInsertType
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setInsertType(String insertType)
```
  - getInsertType
```
public String getInsertType()
```
  - setRollbackAttachmentName
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setRollbackAttachmentName(String rollbackAttachmentName)
```
  - getRollbackAttachmentName
```
public String getRollbackAttachmentName()
```
  - setRollbackSQL
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setRollbackSQL(String rollbackSQL)
```
  - getRollbackSQL
```
public String getRollbackSQL()
```
  - setRollbackSqlType
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setRollbackSqlType(String rollbackSqlType)
```
  - getRollbackSqlType
```
public String getRollbackSqlType()
```
  - setTableName
```
public CreateDataImportOrderRequest.CreateDataImportOrderRequestParam setTableName(String tableName)
```
  - getTableName
```
public String getTableName()
```

类 CreateDataImportOrderRequest.CreateDataImportOrderRequestParam

字段概要

构造器概要

方法概要

从类继承的方法 com.aliyun.tea.TeaModel

从类继承的方法 java.lang.Object

字段详细资料

attachmentName

classify

csvFirstRowIsColumnDef

dbItemList

execMode

fileEncoding

fileType

ignoreError

importMode

insertType

rollbackAttachmentName

rollbackSQL

rollbackSqlType

tableName

构造器详细资料

CreateDataImportOrderRequestParam

方法详细资料

build

setAttachmentName

getAttachmentName

setClassify

getClassify

setCsvFirstRowIsColumnDef

getCsvFirstRowIsColumnDef

setDbItemList

getDbItemList

setExecMode

getExecMode

setFileEncoding

getFileEncoding

setFileType

getFileType

setIgnoreError

getIgnoreError

setImportMode

getImportMode

setInsertType

getInsertType

setRollbackAttachmentName

getRollbackAttachmentName

setRollbackSQL

getRollbackSQL

setRollbackSqlType

getRollbackSqlType

setTableName

getTableName