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


import com.zt.common.annotation.LogOperation;
import com.zt.common.annotation.QueryParam;
import com.zt.common.constant.Constant;
import com.zt.common.db.query.QueryFilter;
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.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import springfox.documentation.annotations.ApiIgnore;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.nio.charset.StandardCharsets;
import java.util.LinkedList;
import java.util.List;


/**
 * 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();
    }
}