var mysql = require('mysql');
var twitch = require('twitch-api-v5');

var pool  = mysql.createPool({
  host     : 'localhost',
  user     : 'rfxcom',
  password : 'rfxcom',
  database : 'rfxcom'
});

var twitchUserId = '5q4om4r2livi19sz422larprugmwip';
var sql = "SELECT token FROM twitch__clients WHERE user = '" + twitchUserId + "'";
var twitchAccessToken = '';

// GET TOKEN FROM MYSQL
pool.getConnection(function(err, connection) {
  if(err) { console.log(err); return; }
  connection.query(sql, [], function(err, rows) {
    connection.release();
    if(err) { console.log(err); return; }
    for (var i in rows) {
      twitchAccessToken = rows[i].token;
      twitchInit(function(){
        exitScript();
      });
    }
  });
});

// INIT TWITCH
function twitchInit(callback) {
  twitch.clientID = twitchUserId;
  twitch.auth.checkToken({ auth: 'OAuth ' + twitchAccessToken}, (err, res) => {
    //console.log(res.token);
    var valid = res.token.valid;
    var scopes = res.token.authorization.scopes;
    if(valid) {
      //console.log(scopes);
      //GET CHANNEL INFO, LIKE AN ID
      //twitch.channels.channel({ auth: 'OAuth ' + twitchAccessToken}, (err, res) => {console.log(res);});
      checkFollowers();
    } else {
      console.log('Wrong Access Token');
    }
    if(callback !== undefined) callback();
  });
}

function checkFollowers(callback) {
  //NO ACCESS TOKEN REQUIRED
  twitch.channels.followers({channelID: 155462223}, (err, res) => {
    console.log(res.follows);
  });
}

//EXIT
function exitScript() {
  pool.end();
}