com.aliyun.dms_enterprise20181101.models

类 ListSQLExecAuditLogRequest

java.lang.Object

com.aliyun.tea.TeaModel

com.aliyun.dms_enterprise20181101.models.ListSQLExecAuditLogRequest

public class ListSQLExecAuditLogRequest
extends com.aliyun.tea.TeaModel

字段概要

字段

限定符和类型	字段和说明
String	endTime The end of the time range to query.
String	execState The execution status of the SQL statement.
String	opUserName The nickname of the user who wrote the SQL statement.
Integer	pageNumber The number of the page to return.
Integer	pageSize The number of entries to return on each page.
String	searchName The name of the database or instance based on which you want to query SQL statements.
String	sqlType The type of the SQL statement.
String	startTime The beginning of the time range to query.
Long	tid The ID of the tenant.

构造器概要

构造器

构造器和说明
ListSQLExecAuditLogRequest()

方法概要

限定符和类型	方法和说明
static ListSQLExecAuditLogRequest	build(Map<String,?> map)
String	getEndTime()
String	getExecState()
String	getOpUserName()
Integer	getPageNumber()
Integer	getPageSize()
String	getSearchName()
String	getSqlType()
String	getStartTime()
Long	getTid()
ListSQLExecAuditLogRequest	setEndTime(String endTime)
ListSQLExecAuditLogRequest	setExecState(String execState)
ListSQLExecAuditLogRequest	setOpUserName(String opUserName)
ListSQLExecAuditLogRequest	setPageNumber(Integer pageNumber)
ListSQLExecAuditLogRequest	setPageSize(Integer pageSize)
ListSQLExecAuditLogRequest	setSearchName(String searchName)
ListSQLExecAuditLogRequest	setSqlType(String sqlType)
ListSQLExecAuditLogRequest	setStartTime(String startTime)
ListSQLExecAuditLogRequest	setTid(Long tid)

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

字段详细资料

endTime

@NameInMap(value="EndTime")
public String endTime

The end of the time range to query.

The end time supports fuzzy match. Specify the time in the YYYY-MM-DD hh:mm:ss format. We recommend that you use the StartTime and EndTime parameters to specify a time range that does not exceed one day. The returned entries can be displayed by page to improve query efficiency.

This parameter is required.

example:

2021-11-08 11:00:00

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

opUserName

@NameInMap(value="OpUserName")
public String opUserName

The nickname of the user who wrote the SQL statement.

example:

test_OpUserName

pageNumber

@NameInMap(value="PageNumber")
public Integer pageNumber

The number of the page to return.

example:

1

pageSize

@NameInMap(value="PageSize")
public Integer pageSize

The number of entries to return on each page. The value cannot exceed 100.

example:

20

searchName

@NameInMap(value="SearchName")
public String searchName

The name of the database or instance based on which you want to query SQL statements.

If the SQL statements to be queried are at the instance level, you can set this parameter to an instance name. If the SQL statements to be queried are at the database level, you can set this parameter to a database name.

example:

test_SearchName

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

startTime

@NameInMap(value="StartTime")
public String startTime

The beginning of the time range to query.

The start time supports fuzzy match. Specify the time in the YYYY-MM-DD hh:mm:ss format.

This parameter is required.

example:

2021-11-08 11:04:00

tid

@NameInMap(value="Tid")
public Long tid

The ID of the tenant. You can call the GetUserActiveTenant operation to obtain the tenant ID.

example:

3***

构造器详细资料

ListSQLExecAuditLogRequest

public ListSQLExecAuditLogRequest()

方法详细资料

build

public static ListSQLExecAuditLogRequest build(Map<String,?> map)
                                        throws Exception

抛出:

Exception

setEndTime

public ListSQLExecAuditLogRequest setEndTime(String endTime)

getEndTime

public String getEndTime()

setExecState

public ListSQLExecAuditLogRequest setExecState(String execState)

getExecState

public String getExecState()

setOpUserName

public ListSQLExecAuditLogRequest setOpUserName(String opUserName)

getOpUserName

public String getOpUserName()

setPageNumber

public ListSQLExecAuditLogRequest setPageNumber(Integer pageNumber)

getPageNumber

public Integer getPageNumber()

setPageSize

public ListSQLExecAuditLogRequest setPageSize(Integer pageSize)

getPageSize

public Integer getPageSize()

setSearchName

public ListSQLExecAuditLogRequest setSearchName(String searchName)

getSearchName

public String getSearchName()

setSqlType

public ListSQLExecAuditLogRequest setSqlType(String sqlType)

getSqlType

public String getSqlType()

setStartTime

public ListSQLExecAuditLogRequest setStartTime(String startTime)

getStartTime

public String getStartTime()

setTid

public ListSQLExecAuditLogRequest setTid(Long tid)

getTid

public Long getTid()