Help with discord.js and SQL intregation

[HypeArts]

I have a discord.js bot and I need some huge help here by someone really experienced: https://cdn.discordapp.com/attachments/561619607115399178/561620807584055296/unknown.png (so this is my database)

I assume that I need to create the tables in order to really get started

My objective is, is that when someone is banned using my bot they are stored in this database with 3 entries: ["USERNAME"] ["CLIEND_ID"] ["REASON"]

https://gyazo.com/14ed3e0123fe854c7edc805923e2b093 (is the ban success code)

How can I make it so whenever someone is banned with my bot, they are stored in a database?

 

[HypeArts]

UPDATES: https://gyazo.com/522908b0cebddc1fc09a29e148920b2a

Created tables, now I need to implement this into JS

 

[LillianA]

Use https://github.com/eslachance/enmap with one of the extentions for it she has made, I use it and it runs perfectly with TypeScript (of course will work with javascript aswell) and once they are banned just input them into the db.

Not going to spoonfeed you but if you have any sort of knowledge of how to actually program with TypeScript or JavaScript you can figure it out with the documentation she wrote up on it aswell

 

[CerealKillahh]

https://www.npmjs.com/package/mysql

var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'me',
password : 'secret',
database : 'my_db'
});

connection.connect();

connection.query('
INSERT INTO `banned_users` (`client_id`, `reason`, `username`) VALUES ('$IDVAR', '$REASONVAR', '$USERNAMEVAR')
', post, function (error, results, fields) {
if (error) throw error;
});


connection.end();

 

[birthdates]

https://www.npmjs.com/package/mysql

var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'me',
password : 'secret',
database : 'my_db'
});

connection.connect();

connection.query('
INSERT INTO `banned_users` (`client_id`, `reason`, `username`) VALUES ('$IDVAR', '$REASONVAR', '$USERNAMEVAR')
', post, function (error, results, fields) {
if (error) throw error;
});


connection.end();

Also, remember with mysql.js every time you end a connection you must set the "connection" variable function.

 

[Function]

If you need help with enmap you can always contact me hype, it's your old business partner.

~ Onfrow