package com.ltkj.web.controller.api;

import com.alibaba.druid.pool.DruidDataSource;
import com.ltkj.common.annotation.Anonymous;
import com.ltkj.common.core.domain.AjaxResult;
import com.ltkj.common.utils.spring.SpringUtils;
import com.ltkj.web.config.wordUtil.ITableService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import java.sql.SQLException;
import java.util.Properties;

@Slf4j
@RestController
@RequestMapping("/api")
@Api(tags = "AAAAAAAAAAAAA  数据库操作接口")
public class TableController {

    @Autowired
    ITableService tableService;

    @GetMapping(value = "/tableToWord", produces = "application/json;charset=utf-8", name = "导出数据库表信息生成Word")
    //@ApiOperation(value = "导出数据库表信息生成Word", httpMethod = "GET", response = AjaxResult.class, notes = "导出数据库表信息生成Word")
    public AjaxResult tableToWord() {
        try {
            return AjaxResult.success("导出数据库表信息生成Word成功", tableService.getTableInfo());
        } catch (Exception e) {
            return AjaxResult.error(e.getMessage());
        }
    }

    @GetMapping("/updateDruidProperty")
    @ApiOperation(value ="切换数据库")
    @Anonymous
    public AjaxResult updateProperty(@RequestParam @ApiParam(value = "数据库ip")String ip,
                                     @RequestParam @ApiParam(value = "数据库端口")String prot,
                                     @RequestParam @ApiParam(value = "数据库名")String name,
                                     @RequestParam @ApiParam(value = "数据库用户名")String userName,
                                     @RequestParam @ApiParam(value = "数据库密码")String passWored){
        DruidDataSource dataSource = SpringUtils.getBean("masterDataSource");
        try {
            Properties properties = new Properties();
            // 这里是测试写法，具体的value可以通过请求参数传递过来
            properties.setProperty("druid.url","jdbc:mysql://"+ip+":"+prot+"/"+name+"?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8");
            properties.setProperty("druid.username",userName);
            properties.setProperty("druid.password",passWored);
            dataSource.restart(properties);
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return AjaxResult.success();
    }

}