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 --- libs/datajob.js | 27 +++++++++++++++++++++++++++ 1 file changed, 27 insertions(+) create mode 100644 libs/datajob.js (limited to 'libs/datajob.js') diff --git a/libs/datajob.js b/libs/datajob.js new file mode 100644 index 0000000..3453bcd --- /dev/null +++ b/libs/datajob.js @@ -0,0 +1,27 @@ +function queryAw(connection, id, key, value) { + connection.query("INSERT INTO amygdala_profile(timestamp, userID, key, value) VALUES ($1, $2, $3, $4);", [Date.now(), id, key, value]); +} + +module.exports = { + async saveUserData(connection, userId) { + let userData = client.users.cache.get(userId); + if (userData === undefined) { + userData = await client.users.fetch(userId); + } + + await connection.query("BEGIN;"); + + try { + if (userData.globalName !== null) await queryAw(connection, userId, "discord_globalName", userData.globalName); + if (userData.avatar !== null) await queryAw(connection, userId, "discord_avatar", userData.avatar); + await queryAw(connection, userId, "discord_username", userData.username); + await queryAw(connection, userId, "discord_discriminator", userData.discriminator); + } catch (e) { + await connection.query("ROLLBACK;"); + throw e; + } + + await connection.query("COMMIT;"); + } +} + -- cgit 1.4.1