@discremy/mysql

MySQL integration package for Discremy, powered by mysql2.

Installation

npm i @discremy/mysql

Use with Discremy

1) Auto-load with config

module.exports = {
  modules: {
    mysql: {
      enabled: true,
      host: '127.0.0.1',
      port: 3306,
      user: 'root',
      password: '',
      database: 'my_discremy_db'
    }
  }
};

With this config, Discremy auto-loads @discremy/mysql on startup.

2) Manual plugin registration

const Discremy = require('discremy');
const mysqlModule = require('@discremy/mysql');

const bot = new Discremy();
bot.use(mysqlModule, {
  host: '127.0.0.1',
  user: 'root',
  database: 'my_discremy_db'
});

await bot.connectMySQL();
const [rows] = await bot.querySQL('SELECT NOW() AS now');

Standalone usage (without Discremy)

const { createStandaloneClient } = require('@discremy/mysql');

const db = createStandaloneClient({
  host: '127.0.0.1',
  user: 'root',
  database: 'my_discremy_db'
});

await db.connect();
const [rows] = await db.query('SELECT 1 AS ok');
await db.close();

API

• register(client, options?)
• createMySQLAdapter(client, options?)
• createStandaloneClient(options?)
• Adapter methods: connect, reconnect, query, execute, close