📇 Database

// 📦 Zeltux Database Class – Usage Guide
const AddonData = {
    Name: 'AddonName',
    Description: "AddonDescription",
    Developer: "DeveloperName",
    Discord: 'DiscordInvite'
};

const Database = require('./Database');
const database = new Database(AddonData.Name + '.sqlite'); // Create new database for your addon :)

// 📁 createTable
await database.createTable("users", {
    id: "INTEGER PRIMARY KEY",
    username: "TEXT",
    age: "INTEGER"
});

// ➕ insert
await database.insert("users", {
    id: 1,
    username: "Zeltux",
    age: 20
});
// 🔍 findOne
const user = await database.findOne("users", {
    id: 1
});
// 📄 get
const users = await database.get("users", {
    age: 20
});
// ✏️ update
await database.update("users",{ username: "NewName" },{ id: 1 });
// ❌ delete
await database.delete("users", { id: 1 });
// 📚 findAll
const allUsers = await database.findAll("users");
// ⚡ createIndex
await database.createIndex("users", ["username"]);
// 🚀 createIndexForAllColumns
await database.createIndexForAllColumns("users");
// 📡 pingAverage
const ping = await database.pingAverage(10);
console.log(ping + "ms");
// 🧹 deleteAll
await database.deleteAll("users");
// 🏗️ tables
await database.tables({
    users: {
        id: "INTEGER PRIMARY KEY",
        username: "TEXT"
    },
    logs: {
        id: "INTEGER PRIMARY KEY",
        message: "TEXT"
    }
});
// 📋 getAllTables
const tables = await database.getAllTables();
// 🔄 upsert
await database.upsert("users", { id: 1, username: "ZeltuxUpdated" });
// 🔒 close
database.close();