@empjourney/mysql

This library is a mysql2 wrapper with intuitive developer friendly methods

Usage

import mysqlUtil  from '@empjourney/mysql-util';

Once imported, get the singleton instance

 const dbInstance = await MySqlUtil.getInstance({
      host: process.env.MYSQL_HOST,
      user: process.env.MYSQL_USER,
      password: process.env.MYSQL_PASSWORD,
      database: process.env.MYSQL_DATABASE //optional
    });
})

This gives you instance of MySqlUtil which has following methods:

| Method (all async) | Description | | :---------------------------------------------------- | :------------------------------------------ | | query (dbName:string) | runs query against DbPool | | createAndUseDatabase (dbName:string) | Creates database and switches to it | | useDatabase (dbName:string) | switches to it | | dropDatabase (dbName:string) | Drops the database | | createTable(tableName: string,columns: TableColumn) | Creates table with specified column details | | generateInsertStatements(tableName: string) | Generated Insert Queries for all rows | | describeTable(tableName: string) | Returns all columns with description |