@scrptwr/mysql v1.0.0

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);
  }
})();