From 3572b97661a3f7c6c29e958b63c20d9f2ef936ac Mon Sep 17 00:00:00 2001 From: Amygdala Peanut-Almond Date: Wed, 22 Apr 2026 22:49:01 +0200 Subject: initialise repository Signed-off-by: Amygdala Peanut-Almond --- commands/sql.js | 65 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 65 insertions(+) create mode 100644 commands/sql.js (limited to 'commands/sql.js') diff --git a/commands/sql.js b/commands/sql.js new file mode 100644 index 0000000..78aeb02 --- /dev/null +++ b/commands/sql.js @@ -0,0 +1,65 @@ +/* + * Copyright (C) 2024 Emilia Luminé + * This file is a part of the Shamestech bot. + * + * The Shamestech bot is free software: you can redistribute it and/or modify it + * under the terms of the European Union Public License as published by + * by the European Union, only the version 1.2 of the License. + * + * The Shamestech bot is distributed in the hope that it will be useful + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * European Union Public License for more details. + * + * You should have received a copy of the European Union Public License, If not + * see +*/ + +const util = require('node:util'); + +function _plushie(object) { + let loopie = Object.keys(object); + let out = ""; + + for (let i = 0; i < loopie.length; i++) { + out = `${out}${loopie[i]}: ${object[loopie[i]]}; ` + } + out = `${out}` + + return out; +} + +function plushie(arrie) { + let out = ''; + + for (let i = 0; i < arrie.length; i++) { + out = `${out}\n${_plushie(arrie[i])}`; + } + + return out; +} + +module.exports = { + name: 'sql', + hidden: true, + async execute(message, args) { + const prompt = args.join(' '); + let out = ''; + + if (message.author.id !== "1425229394703683614") { + return; + } + + try { + const query = await database.query(prompt); + out = `${plushie(query)}`; + } catch (e) { + out = `${e}`; + } + + return await message.reply({ + content: `${out}` + }); + } +} + -- cgit 1.4.1