Installation

To install the module, and the keyv dependency :

npm install --save [email protected]
npm install --save keyv @keyv/sqlite

Presentation

Foxi DB has been designed for database management, it uses the Keyv dependency for sqlite. Thanks to Lukechilds for its creation.

Utilisation

All functions :

await Foxi.set('Hi', 'Hello'); //Set "Hi" to "Hello"

await Foxi.get('Hi'); //"Hello"

await Foxi.delete('Hi'); //Delete "Hello"

A short example with money :

• Read a user's money

//Module
const Foxi = require("foxi-db")

//The link to your .sql file (designed before)
const DATAMONEY = new Foxi("sqlite://path/to/../../data/money.sql")

//Reading the money variable of USER
let MONEY = await DATAMONEY.get(USER)

//If USER has no money
if (MONEY === null) MONEY = 0;
if (MONEY === undefined) MONEY = 0;

//Message
message.channel.send(`${USER} has ${MONEY}`)

• Add money to a user

//Module
const Foxi = require("foxi-db")

//The link to your .sql file (designed before)
const DATAMONEY = new Foxi("sqlite://path/to/../../data/money.sql")

//Reading the money variable of USER
let MONEY = await DATAMONEY.get(USER)

//If USER has no money
if (MONEY === null) MONEY = 0;
if (MONEY === undefined) MONEY = 0;

//Add 100 to USER money
await DATAMONEY.set(USER, MONEY + 100);

//Message
message.channel.send(`${USER} just won 100 coins`)

• Remove money to a user

//Module
const Foxi = require("foxi-db")

//The link to your .sql file (designed before)
const DATAMONEY = new Foxi("sqlite://path/to/../../data/money.sql")

//Reading the money variable of USER
let MONEY = await DATAMONEY.get(USER)

//If USER has no money
if (MONEY === null) MONEY = 0;
if (MONEY === undefined) MONEY = 0;

//Remove 100 to USER money
await DATAMONEY.set(USER, MONEY - 100);

//Message
message.channel.send(`${USER} just lost 100 coins`)

Set a prefix for example :

//Module
const Foxi = require("foxi-db")

//The link to your .sql file (designed before)
const DATAPREFIX = new Foxi("sqlite://path/to/../../data/prefix.sql")

//Get args
let messageArray = message.content.split(' ');
let args = messageArray.slice(1);

//If no prefix is given
if (!args[0]) return message.channel.send("Please enter a new prefix !")

//Reading the prefix variable of GUILD
let PREFIX = await DATAPREFIX.get(GUILD)

//If the GUILD doesn't have a prefix
if (PREFIX === null) PREFIX = "!"
if (PREFIX === undefined) PREFIX = "!"

//Set new prefix "PREFIX"
await DATAPREFIX.set(GUILD, args.join(" "));

//Message
message.channel.send(`${USER} the new prefix on ${GUILD} is ${PREFIX}`)