com.aliyun.dms_enterprise20181101.models

类 ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList

java.lang.Object

com.aliyun.tea.TeaModel

com.aliyun.dms_enterprise20181101.models.ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList

封闭类:

ListSQLReviewOriginSQLResponseBody

public static class ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList
extends com.aliyun.tea.TeaModel

字段概要

字段

限定符和类型	字段和说明
String	checkedTime The time when the SQL statement was reviewed.
String	checkStatus The review status of the SQL statement.
Long	fileId The file ID.
String	fileName The name of the file.
String	reviewSummary The statistics on the optimization suggestions for SQL statements.
String	SQLContent The SQL statement in the file.
String	sqlHash The MD5 hash value that is obtained after the SQL statement is calculated by using a hash algorithm.
Long	SQLId The ID of the SQL statement.
String	SQLName The name of the SQL statement.
String	SQLReviewQueryKey The key that is used to query the information about optimization suggestions.
String	statusDesc The description of the review status.

构造器概要

构造器

构造器和说明
ListSQLReviewOriginSQLResponseBodyOriginSQLList()

方法概要

限定符和类型	方法和说明
static ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList	build(Map<String,?> map)
String	getCheckedTime()
String	getCheckStatus()
Long	getFileId()
String	getFileName()
String	getReviewSummary()
String	getSQLContent()
String	getSqlHash()
Long	getSQLId()
String	getSQLName()
String	getSQLReviewQueryKey()
String	getStatusDesc()
ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList	setCheckedTime(String checkedTime)
ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList	setCheckStatus(String checkStatus)
ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList	setFileId(Long fileId)
ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList	setFileName(String fileName)
ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList	setReviewSummary(String reviewSummary)
ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList	setSQLContent(String SQLContent)
ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList	setSqlHash(String sqlHash)
ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList	setSQLId(Long SQLId)
ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList	setSQLName(String SQLName)
ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList	setSQLReviewQueryKey(String SQLReviewQueryKey)
ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList	setStatusDesc(String statusDesc)

从类继承的方法 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

字段详细资料

checkStatus

@NameInMap(value="CheckStatus")
public String checkStatus

The review status of the SQL statement. Valid values:

• new: The SQL statement was waiting to be reviewed.
• unknown: The SQL statement cannot be parsed.
• check_not_pass: The SQL statement failed to pass the review.
• check_pass: The SQL statement passed the review.
• force_pass: The SQL statement passed the manual review.
• force_not_pass: The SQL statement failed to pass the manual review.

example:

check_pass

checkedTime

@NameInMap(value="CheckedTime")
public String checkedTime

The time when the SQL statement was reviewed.

example:

2021-06-09 21:07:00

fileId

@NameInMap(value="FileId")
public Long fileId

The file ID.

example:

123321

fileName

@NameInMap(value="FileName")
public String fileName

The name of the file.

example:

test.sql

reviewSummary

@NameInMap(value="ReviewSummary")
public String reviewSummary

The statistics on the optimization suggestions for SQL statements. The value is a JSON string. Valid values:

• MUST_IMPROVE: The SQL statements must be optimized.
• POTENTIAL_ISSUE: The SQL statements contain potential issues.
• SUGGEST_IMPROVE: We recommend that you optimize the SQL statements.
• USEDMSTOOLKIT: We recommend that you change schemas without locking tables.
• USEDMSDML_UNLOCK: We recommend that you change data without locking tables.
• TABLEINDEXSUGGEST: We recommend that you optimize indexes for the SQL statements.

example:

{"POTENTIAL_ISSUE":1,"SUGGEST_IMPROVE":1}

SQLContent

@NameInMap(value="SQLContent")
public String SQLContent

The SQL statement in the file.

example:

select id from table_name

SQLId

@NameInMap(value="SQLId")
public Long SQLId

The ID of the SQL statement.

example:

1111

SQLName

@NameInMap(value="SQLName")
public String SQLName

The name of the SQL statement.

example:

getByPk

SQLReviewQueryKey

@NameInMap(value="SQLReviewQueryKey")
public String SQLReviewQueryKey

The key that is used to query the information about optimization suggestions. You can call the GetSQLReviewOptimizeDetail operation to query the details based on this key.

example:

a57e54ec5433475ea3082d882fdb89c5

sqlHash

@NameInMap(value="SqlHash")
public String sqlHash

The MD5 hash value that is obtained after the SQL statement is calculated by using a hash algorithm.

example:

95adb6e77a0884d9e50232cb8c5c969d

statusDesc

@NameInMap(value="StatusDesc")
public String statusDesc

The description of the review status.

example:

passed the test

构造器详细资料

ListSQLReviewOriginSQLResponseBodyOriginSQLList

public ListSQLReviewOriginSQLResponseBodyOriginSQLList()

方法详细资料

build

public static ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList build(Map<String,?> map)
                                                                                                throws Exception

抛出:

Exception

setCheckStatus

public ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList setCheckStatus(String checkStatus)

getCheckStatus

public String getCheckStatus()

setCheckedTime

public ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList setCheckedTime(String checkedTime)

getCheckedTime

public String getCheckedTime()

setFileId

public ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList setFileId(Long fileId)

getFileId

public Long getFileId()

setFileName

public ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList setFileName(String fileName)

getFileName

public String getFileName()

setReviewSummary

public ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList setReviewSummary(String reviewSummary)

getReviewSummary

public String getReviewSummary()

setSQLContent

public ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList setSQLContent(String SQLContent)

getSQLContent

public String getSQLContent()

setSQLId

public ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList setSQLId(Long SQLId)

getSQLId

public Long getSQLId()

setSQLName

public ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList setSQLName(String SQLName)

getSQLName

public String getSQLName()

setSQLReviewQueryKey

public ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList setSQLReviewQueryKey(String SQLReviewQueryKey)

getSQLReviewQueryKey

public String getSQLReviewQueryKey()

setSqlHash

public ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList setSqlHash(String sqlHash)

getSqlHash

public String getSqlHash()

setStatusDesc

public ListSQLReviewOriginSQLResponseBody.ListSQLReviewOriginSQLResponseBodyOriginSQLList setStatusDesc(String statusDesc)

getStatusDesc

public String getStatusDesc()