• Index
• Search by APIs
• Search by Words
• Project Search

• Java
• Python
• JavaScript
• TypeScript
• C++
• Scala
• Blog

• Designer-Server-master
  • src
    • app.ts
    • entity
      • manager
        • Service.ts
        • DatabaseConnection.ts
        • LoaderLog.ts
        • TrafficConfig.ts
        • Stage.ts
        • MetaParam.ts
        • Application.ts
        • MetaColumn.ts
        • Meta.ts
    • grpc
      • applications.ts
      • InfuserGrpcAppClient.ts
      • InfuserGrpcAuthorClient.ts
    • index.ts
    • helpers
      • MysqlHelper.ts
    • lib
      • file-manager
        • strategies
          • FsStrategy.ts
          • S3Strategy.ts
        • FileManageStrategy.ts
        • FileManager.ts
    • util
      • SwaggerBuilder.ts
      • dbms_data_types
        • cubrid.json
        • mysql.json
      • Pagination.ts
      • BullManager.ts
      • RedisManager.ts
      • swagger_template
        • path_template.json
        • api_response.json
      • ErrorCodes.ts
    • config
      • ormConfig.ts
      • propertyConfig.ts
      • aws-config-sample.json
    • controllers
      • api
        • ApiStageController.ts
        • ApiMetaParamController.ts
        • ApiServiceController.ts
        • ApiFileController.ts
        • ApiMetaController.ts
        • ApiApplicationController.ts
        • AuthController.ts
    • middlewares
      • authentication.ts
    • @types
      • index.d.ts
    • interfaces
      • MetaInfo.ts
      • dataloader
        • DataLoaderTableColumnsParams.ts
      • requestParams
        • FileParams.ts
        • ServiceParams.ts
        • ApplicationParams.ts
        • MetaParamParams.ts
        • DbmsParams.ts
      • MysqlTableStatus.ts
      • ConvetedType.ts
      • MysqlDescribeResult.ts
      • SelectOptions.ts
    • ApplicationError.ts
    • routes
      • routes.ts
      • swagger.json
  • Makefile
  • tsoa.json
  • property-sample.json
  • .gitmodules
  • LICENSE
  • test
    • 0_metaLoader.test.ts
    • 1_authApi.test.ts
    • filesForTest
    • 5_stageApi.test.ts
    • 4_serviceApi.test.ts
    • 3_metaApi.test.ts
    • 2_applicationApi.test.ts
  • api-test.http
  • README.md
  • package.json
  • .Dockerignore
  • Dockerfile
  • tsconfig.json
  • .gitignore
  • ormconfig-sample.json

import { ConnectionOptions, createConnections, getManager, getConnection } from "typeorm";
import { Meta } from "../entity/manager/Meta";
import { MetaColumn } from "../entity/manager/MetaColumn";
const mysqlTypes = require("../util/dbms_data_types/mysql.json");

export class MysqlHelper {
  static showTables = async(connectOption: ConnectionOptions) => {
    return new Promise(async(resolve, reject) => {
      const name = connectOption.name;
      let tables = []
      try {
        await createConnections([connectOption])
        const manager = await getManager(name)
        const results = await manager.query("SHOW tables;");
        
        
        results.forEach(row => {
          tables.push(row[`Tables_in_${connectOption.database}`]);
        });
      } catch(err) {
        await getConnection(name).close();
        reject(err);
        return;
      } finally {
        await getConnection(name).close();
      }
      resolve(tables);
    });
  };

  static showTableStatus = async(connectOption: ConnectionOptions):Promise<MysqlTableStatus[]> => {
    return new Promise(async(resolve, reject) => {
      const name = connectOption.name;
      let tableStatuses:MysqlTableStatus[] = []
      try {
        await createConnections([connectOption])
        const manager = await getManager(name)
        tableStatuses = await manager.query("SHOW TABLE STATUS;");
      } catch(err) {
        await getConnection(name).close();
        reject(err);
        return;
      } finally {
        await getConnection(name).close();
      }
      resolve(tableStatuses);
    });
  };

  static getColumns = async(connectOption: ConnectionOptions, table: string):Promise<MetaColumn[]> => {
    return new Promise(async(resolve, reject) => {
      const name = connectOption.name;
      let mysqlDescribeResults:MysqlDescribeResult[] = []
      let columns: MetaColumn[] = []
      try {
        await createConnections([connectOption])
        const manager = await getManager(name)
        mysqlDescribeResults = await manager.query(`DESCRIBE \`${table}\`;`);
        mysqlDescribeResults.forEach( result => {
          const metaCol = new MetaColumn();
          metaCol.originalColumnName = result.Field;
          metaCol.columnName = result.Field;
          const convertedType = MysqlHelper.convertType(result.Type);
          metaCol.type = convertedType.type;
          if(convertedType.size) metaCol.size = convertedType.size;
          columns.push(metaCol);
        })
      } catch(err) {
        await getConnection(name).close();
        reject(err);
        return;
      } finally {
        await getConnection(name).close();
      }
      resolve(columns);
    })
  }

  static convertType(originType: string){
    const lowercaseType:string = originType.toLowerCase()
    const tokens = lowercaseType.split("(");
    let type = mysqlTypes[tokens[0]]
    let size
  
    if(tokens[1]) {
      size = tokens[1].split(")")[0];
    }
    
    if(!type) type = "varchar"
  
    return {
      type: type,
      size: size
    }
  }
}