const discord = require("discord.js");
const database = require("../database.json");
const mysql = require("mysql");

module.exports.run = async (bot, message, args) => {

    var con = mysql.createConnection({

        host: database.host,
        user: database.user,
        password: database.password,
        database: database.database

    });

    con.connect(err => {

        if (err) throw err;

    });

    var user = message.guild.member(message.mentions.users.first());
    var bijnaam = args.join(" ").slice(22);

    if (user && !bijnaam) {

        con.query(`SELECT bijnaam FROM data WHERE idUser = '${user.id}'`, (err , rows) => {

            if(err) throw err;

            if(rows.length >= 1) {

                message.channel.send(rows[0].bijnaam);

            }else {

                message.channel.send("Geen gegevens gevonden");

            }

        })



    } else if (user && bijnaam == "remove") {

        con.query(`DELETE FROM data WHERE idUser = '${user.id}'`, (err, rows) => {

            if (err) throw err;

            if (rows.length >= 1) {

                message.channel.send("Weggehaald van bijnaam " + message.guild.members.get(user.id).user.username);

            } else {

                message.channel.send("Geen gegevens gevonden");

            }


        })


    } else if (user && bijnaam) {

        con.query(`SELECT * FROM data WHERE IdUser = '${user.id}'`, (err, rows) => {

            if (err) throw err;

            if (rows.length < 1) {

                con.query(`INSERT INTO data (idUser,bijnaam) VALUES ("${user.id}","${bijnaam}")`);

            } else {

                con.query(`UPDATE data SET bijnaam = '${bijnaam}' WHERE idUser = '${user.id}'`);

            }

        });

    } else {

        con.query(`SELECT * FROM data`, (err, rows) => {

            if (err) throw err;

            if (rows.length > 0) {

                for (var i = 0; i < rows.length; i++) {

                    var id = rows[i].idUser;
                    message.channel.send(message.guild.members.get(id).user.username + ": bijnaam, " + rows[i].bijnaam);

                }

            } else {

                message.channel.send("Geen gegevens gevonden");

            }

        })

    }




}

module.exports.help = {
    name: "data"
}