var mysql = require('mysql');
var connection = mysql.createConnection(
    {
      host     : 'hackteams.c6p7kpyzcymg.us-east-1.rds.amazonaws.com',
      user     : 'test',
      password : 'password',
      database : 'hackteams'
    }
);

// username, friend's username:
var user = 'tiger';
var friend = 'bbob';

function getUserId(callback) {
	connection.query("SELECT id FROM users WHERE username = '" + user + "'", function(err, rows, field) {
		if (err) callback(err, -1, null);
		callback(null, -1, rows[0].id);
	});
}
function getFriendId(in_id, callback) {
	connection.query("SELECT id FROM users WHERE username = '" + friend + "'", function(err, rows, field) {
		if (err) callback(err, in_id, null);
		callback(null, in_id, rows[0].id);
	});
}
function setFriend(user_id, friend_id) {
	var f = {
		user_id : user_id,
		friend_id : friend_id
	};
	connection.query("INSERT INTO user_has_friend SET ?", f, function(err, res) {
		if (err) throw err;
		console.log("success");
		connection.end();
	});
}
function processId(err, type, result) {
	console.log(result);
	if (type == -1) {
		getFriendId(result, processId);
	} else {
		setFriend(type, result);
	}
}

getUserId(processId);