aoi.js-mysql

• Easy to use package for the implementation of MySQL (MariaDB) in aoi.js with minimal changes.

Setup

To get started with aoi.js-mysql, we have to do a couple things.

• Install the package.

npm install github:st333in/aoi.mysql

• Update your index.js file.

const { AoiClient, LoadCommands } = require("aoi.js");
const { Database } = require("aoi.mysql");

const client = new AoiClient({
  token: "DISCORD BOT TOKEN",
  prefix: "DISCORD BOT PREFIX",
  intents: ["Guilds", "GuildMessages", "GuildMembers", "MessageContent"],
  events: ["onInteractionCreate", "onMessage"],
  disableAoiDB: true // This is important, ensure it's set to true. You can't use both at once.
});

const database = new Database(client, {
  host: "", //192.168.256.253 (DON'T PUT PORT HERE)
  user: "", //root 
  password: "", //mypassword123
  database: "", //s5_test
  port: 3306, //If your port is 3306, you can remove this
  connectionLimit: 20,
  tables: ["main"],
  autoUpdate: true
});

//OR

const database = new Database(client, {
  url: "",  //jdbc:mysql://s5_test:[email protected]:3306/s5_test
  connectionLimit: 20,
  tables: ["main"],
  autoUpdate: true
});

client.variables({
    variable: "value"
});

// rest of your index.js..

Transfer aoi.db database

You can indeed transfer your database!

const { AoiClient, LoadCommands } = require("aoi.js");
const { Database } = require("aoi.mongo");

const client = new AoiClient({
  token: "DISCORD BOT TOKEN",
  prefix: "DISCORD BOT PREFIX",
  intents: ["Guilds", "GuildMessages", "GuildMembers", "MessageContent"],
  events: ["onInteractionCreate", "onMessage"],
  disableAoiDB: true // This is important, ensure it's set to true. You can't use both at once.
});

const database = new Database(client, {
  host: "", //192.168.256.253 (DON'T PUT PORT HERE)
  user: "", //root 
  password: "", //mypassword123
  database: "", //s5_test
  port: 3306, //If your port is 3306, you can remove this
  connectionLimit: 20,
  tables: ["main"],
    convertOldData: {
      enabled: true,
      dir: "./database"
    },
  autoUpdate: true
});

//OR

const database = new Database(client, {
  url: "",  //jdbc:mysql://s5_test:[email protected]:3306/s5_test
  connectionLimit: 20,
  tables: ["main"],
    convertOldData: {
      enabled: true,
      dir: "./database"
    },
  autoUpdate: true
});

client.variables({
    variable: "value"
});

// rest of your index.js..

Uninstalling

aoi.mysql modifies certain functions of aoi.js, however, when you uninstall this package, make sure you reinstall aoi.js so that everything works perfectly. Follow the example below:

npm r aoi.mysql

npm i aoi.js