package com.zt.life.modules.mainPart.sys.controller;


import com.zt.common.servlet.Result;
import com.zt.life.modules.mainPart.sys.model.SysMysql;
import com.zt.life.modules.mainPart.sys.service.SysMysqlService;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;



/**
 * sys_change_log
 *
 * @author zt generator 
 * @since 1.0.0 2024-10-09
 */
@RestController
@RequestMapping("/sys/mysql/")
public class SysMysqlController {
    @Autowired
    private SysMysqlService sysMysqlService;

    @GetMapping("check")
    @ApiOperation("查询")
    public Result<SysMysql> check(String sql){
        SysMysql data = sysMysqlService.check(sql);

        return Result.ok(data);
    }

    @GetMapping("execute")
    @ApiOperation("修改")
    public Result execute(String sql){
        sysMysqlService.execute(sql);

        return Result.ok();
    }

    @GetMapping("logDownload")
    @ApiOperation("日志下载")
    public Result logDownload(HttpServletRequest request, HttpServletResponse response){
        sysMysqlService.logDownload(request,response);

        return Result.ok();
    }
}