var request = require('request');
var mysql = require('mysql');
var uid = "";

var con = mysql.createConnection({
    host: "localhost",
    user: "peter",
    password: "xxx,
    database: "mobiletest"
});

con.connect(function(err) {
        con.query("SELECT * FROM login_data where surname = ''", function (err, result, fields) {
            result.forEach(function(row) {
                request({url: 'https://fortnite-public-api.theapinetwork.com/prod09/users/id?username='+row.name, json: true}, function(err, res, data) {
                    if (err) throw err;
                    if (data.errorMessage == "unknown_epic_user"){
                        con.query("update login_data set surname = 'FAILED' where name = \?\;",[row.name], function (err, result, fields) {
                        });
                        return;
                    }
                    con.query("update login_data set surname = 'VALIDATED' where name = \?\;",[row.name], function (err, result, fields) {
                        if (err) throw err;
                    });
                });
            });
        });
});