import moment from 'moment';
import fs from 'fs';
import { promises as fsPromises } from 'fs';
import { globalCache } from '../../util/GlobalCache.js';
import config from '../../config/index.js';
import _ from 'lodash';
import axios from 'axios';
import commonModel from '../../model/commonModel.js';

/**
 * 分数线网页首页
 * @generator
 * @yields {Object} 返回渲染后的HTML页面内容
 * @description 读取并返回public目录下的mpsDefault.html文件内容作为响应体
 */
export async function Kylx365DBAdmin(ctx) {
    console.log("Kylx365DBAdmin");
    const data = await fsPromises.readFile("./public/mg/kylx365_db_admin.html");
    ctx.body = data.toString();
};

export async function GetKylx365Tables(ctx) {
    let result = await commonModel.RunSql(null,"SELECT table_name,table_comment FROM information_schema.tables WHERE table_schema = 'kylx365_db';");
    console.log("表格数："+result.length);
    ctx.body = {"errcode": 10000, result: result};
};
    
export async function GetKylx365TableColumnByTable(ctx) {
    let param = {
        TableName: ctx.query.table || "",
    };
    let result = await commonModel.RunSql(null,"SHOW COLUMNS FROM `"+param.TableName+"`;");
    console.log("字段数："+result.length);
    ctx.body = {"errcode": 10000, result: result};
};
        
export async function RunKylx365DBSql(ctx) {
    let param = {
        SQL: ctx.query.sql || "",
    };
    let result = await commonModel.RunSql(null,param.SQL);
    console.log("记录数："+result.length);
    ctx.body = {"errcode": 10000, result: result};
};