var mysql = require('mysql2/promise');

export class Mysql {
  pool: any;

  constructor(conf: {user: string, password: string, host: string, database: string}) {
    const mysqlConf = {
      ...conf,
      namedPlaceholders: true,
      waitForConnections: true,
      connectionLimit: 10,
      queueLimit: 0
    };
    this.pool = mysql.createPool(mysqlConf);
  }

  async query(script: string, parameters?: any) {
    return await this.pool.execute(script, parameters);
  }

  async executeCommand(script: string, parameters?: any) {
    await this.pool.query(script, parameters);
  }
}