com.aliyun.dms_enterprise20181101.models

类 ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog

java.lang.Object

com.aliyun.tea.TeaModel

com.aliyun.dms_enterprise20181101.models.ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog

封闭类:

ListSQLExecAuditLogResponseBody

public static class ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog
extends com.aliyun.tea.TeaModel

字段概要

字段

限定符和类型	字段和说明
Long	affectRows The number of rows affected by the SQL statement.
Long	dbId The ID of the database.
Long	elapsedTime The amount of time consumed by the execution of the SQL statement.
String	execState The execution status of the SQL statement.
Long	instanceId The ID of the instance.
String	instanceName The name of the database.
Boolean	logic Indicates whether the database is a logical database.
String	opTime The time when the operation specified by the SQL statement was performed on the instance or database.
String	remark The comment on the SQL statement.
String	schemaName The name of the database.
String	SQL The SQL statement that was written.
String	SQLType The type of the SQL statement.
Long	userId The ID of the user who wrote the SQL statement.
String	userName The nickname of the user who wrote the SQL statement.

构造器概要

构造器

构造器和说明
ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog()

方法概要

限定符和类型	方法和说明
static ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	build(Map<String,?> map)
Long	getAffectRows()
Long	getDbId()
Long	getElapsedTime()
String	getExecState()
Long	getInstanceId()
String	getInstanceName()
Boolean	getLogic()
String	getOpTime()
String	getRemark()
String	getSchemaName()
String	getSQL()
String	getSQLType()
Long	getUserId()
String	getUserName()
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setAffectRows(Long affectRows)
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setDbId(Long dbId)
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setElapsedTime(Long elapsedTime)
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setExecState(String execState)
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setInstanceId(Long instanceId)
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setInstanceName(String instanceName)
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setLogic(Boolean logic)
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setOpTime(String opTime)
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setRemark(String remark)
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setSchemaName(String schemaName)
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setSQL(String SQL)
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setSQLType(String SQLType)
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setUserId(Long userId)
ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog	setUserName(String userName)

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

字段详细资料

affectRows

@NameInMap(value="AffectRows")
public Long affectRows

The number of rows affected by the SQL statement. For example, if you execute an SQL statement to query data, the number of retrieved rows is returned.

example:

2

dbId

@NameInMap(value="DbId")
public Long dbId

The ID of the database.

example:

2157****

elapsedTime

@NameInMap(value="ElapsedTime")
public Long elapsedTime

The amount of time consumed by the execution of the SQL statement. Unit: milliseconds.

example:

18

execState

@NameInMap(value="ExecState")
public String execState

The execution status of the SQL statement. Valid values:

• FAIL: The SQL statement fails to be executed.
• NOEXE: The SQL statement has not been executed.
• RUNNING: The SQL statement is being executed.
• CANCEL: The execution of the SQL statement is canceled.
• SUCCESS: The SQL statement is executed.

example:

SUCCESS

instanceId

@NameInMap(value="InstanceId")
public Long instanceId

The ID of the instance.

example:

185***

instanceName

@NameInMap(value="InstanceName")
public String instanceName

The name of the database.

If the SQL statement takes effect on an instance, the name of the instance is returned.

example:

polar123@pc-bp1h9tgq4st9g****.mysql.polardb.rds.aliyuncs.com:3306[polar_qw_test]

logic

@NameInMap(value="Logic")
public Boolean logic

Indicates whether the database is a logical database. Valid values:

• true: The database is a logical database.
• false: The database is a physical database.

example:

false

opTime

@NameInMap(value="OpTime")
public String opTime

The time when the operation specified by the SQL statement was performed on the instance or database.

example:

2021-11-08 11:04:27

remark

@NameInMap(value="Remark")
public String remark

The comment on the SQL statement.

example:

success

SQL

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

The SQL statement that was written.

example:

SELECT * FROM polar123.p_qw ORDER BY id DESC

SQLType

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

The type of the SQL statement. Valid values:

• SELECT: the SQL statement that is used to query data.
• INSERT: the SQL statement that is used to insert data.
• DELETE: the SQL statement that is used to delete data.
• CREATE_TABLE: the SQL statement that is used to create tables.

To view more types of SQL statements, log on to the DMS console and click Security and Specifications. In the left-side navigation pane, click Operation Audit. Then, you can view all supported types of SQL statements from the SQL type drop-down list.

example:

SELECT

schemaName

@NameInMap(value="SchemaName")
public String schemaName

The name of the database.

example:

polar123

userId

@NameInMap(value="UserId")
public Long userId

The ID of the user who wrote the SQL statement.

example:

12****

userName

@NameInMap(value="UserName")
public String userName

The nickname of the user who wrote the SQL statement.

example:

test_UserName

构造器详细资料

ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog

public ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog()

方法详细资料

build

public static ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog build(Map<String,?> map)
                                                                                                               throws Exception

抛出:

Exception

setAffectRows

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setAffectRows(Long affectRows)

getAffectRows

public Long getAffectRows()

setDbId

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setDbId(Long dbId)

getDbId

public Long getDbId()

setElapsedTime

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setElapsedTime(Long elapsedTime)

getElapsedTime

public Long getElapsedTime()

setExecState

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setExecState(String execState)

getExecState

public String getExecState()

setInstanceId

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setInstanceId(Long instanceId)

getInstanceId

public Long getInstanceId()

setInstanceName

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setInstanceName(String instanceName)

getInstanceName

public String getInstanceName()

setLogic

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setLogic(Boolean logic)

getLogic

public Boolean getLogic()

setOpTime

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setOpTime(String opTime)

getOpTime

public String getOpTime()

setRemark

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setRemark(String remark)

getRemark

public String getRemark()

setSQL

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setSQL(String SQL)

getSQL

public String getSQL()

setSQLType

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setSQLType(String SQLType)

getSQLType

public String getSQLType()

setSchemaName

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setSchemaName(String schemaName)

getSchemaName

public String getSchemaName()

setUserId

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setUserId(Long userId)

getUserId

public Long getUserId()

setUserName

public ListSQLExecAuditLogResponseBody.ListSQLExecAuditLogResponseBodySQLExecAuditLogListSQLExecAuditLog setUserName(String userName)

getUserName

public String getUserName()