mysql

A wrapper package to make the mysql package more Dummy proof.

Install

npm i @scrptwr/mysql

Functions

• mysql.connect(options)
• mysql.query(query, [values])
• mysql.disconnect()

mysql.connect(options)

• options <Oject>
  • host: <String>
  • user: <String>
  • password: <String>
  • database: <String>

const mysql = require('./index');

(async () => {
  try {
    await mysql.connect({
      host: '******',
      user: '******',
      password: '******',
      database: '******'
    });
  } catch (error) {
    console.log(error);
  }
})();

mysql.query(query, [values])

• query <String>
• [values] <Array>

const mysql = require('./index');

(async () => {
  try {
    await const results = await mysql.query('SELECT * FROM `abschlag` WHERE `AbschlagID` = ?', [80]);

    console.log(results);
  } catch (error) {
    console.log(error);
  }
})();

mysql.disconnect()

const mysql = require('./index');

(async () => {
  try {
    await mysql.disconnect();
  } catch (error) {
    console.log(error);
  }
})();