package com.citygis.web.controller;


import com.citygis.common.annotation.Log;
import com.citygis.common.core.controller.BaseController;
import com.citygis.common.core.page.TableDataInfo;
import com.citygis.common.enums.BusinessType;
import com.citygis.web.domain.TabSqlExecute;
import com.citygis.web.service.ITabSqlExecuteService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;

/**
 * <p>
 * 前端控制器
 * </p>
 *
 * @author citygis
 * @since 2025-01-08
 */
@Api(tags = "sql安全审计")
@RestController
@RequestMapping("/web/tab-sql-execute")
public class TabSqlExecuteController extends BaseController {

    @Resource
    ITabSqlExecuteService tabSqlExecuteService;

    @Log(title = "安全审计管理", businessType = BusinessType.SELECT)
    @ApiOperation("sql审计列表")
    @GetMapping("/getTabSqlExecuteList")
    public TableDataInfo getTabSqlExecuteList(TabSqlExecute tabSqlExecute) {
        startPage();
        return getDataTable(tabSqlExecuteService.getSqlResult(tabSqlExecute));
    }

//    @Log(title = "安全审计管理", businessType = BusinessType.DELETE)
//    @ApiOperation("删除sql审计")
//    @DeleteMapping("/deleteSql/{id}")
//    public AjaxResult deleteSql(@PathVariable String id) {
//       return tabSqlExecuteService.deleteSql(id);
//    }
}