mysql = require('mysql');
dbname = 'fortnitebot';
dbusername = 'fortniteroot';
dbpassword = 'fortniteroot';
dbhost = 'db4free.net';

// Mysql server setup

db = mysql.createPool({
    connectionLimit: 30,
    host: dbhost,
    password: dbpassword,
    user: dbusername,
    database: dbname,
})

class User {

    constructor(userId, username, lang) {
        this.userId = userId,
        this.username = username;
        this.lang = lang;
    }

    // Checks user existance by id
    checkExistanceById() {
        var query = 'SELECT * FROM `users` WHERE `uid` = ?;';
        this.db.query(query, [this.userId], function(err, fields, rows) {
            if(err) throw err;
            if(fields.length != 0) {
                return true;
            } else {
                return false;
            }
        })
    }
    // Registers a new user
    registerUser() {
        var query = 'INSERT INTO `users` (`uid`, `username`, `lang`) VALUES (`?`, `?`, `?`)';
        this.db.query(query, [this.userId, this.username, this.lang], function(err, fields, rows){
            if(err) throw err;
        })
    }
}


module.exports = User;