public class MySQL
{
  public static String ip = "localhost";
  public static String port = "3306";
  public static String database = "NovaCube";
  public static String username = "root";
  public static String password = "8Um9e2mFTEAffXKm";
  public static String Friends = "player_friends";
  public static MySQLConnector db = new MySQLConnector(ip, port, database, username, password);

  public static void deleteFriend(UUID sender, UUID target)
  {
    if (!getFriend(sender, target)) {
      return;
    }
    db.deleteRowAnd(Friends, "UUIDSender", sender.toString(), "UUIDTarget", target.toString());
    db.deleteRowAnd(Friends, "UUIDSender", target.toString(), "UUIDTarget", sender.toString());
  }

  public static void addFriend(UUID sender, UUID target)
  {
    if (getFriend(sender, target)) {
      return;
    }
    db.insertData(Friends, "`UUIDSender`, `UUIDTarget`", "'" + sender + "','" + target + "'");
    db.insertData(Friends, "`UUIDSender`, `UUIDTarget`", "'" + target + "','" + sender + "'");
  }

  public static boolean getFriend(UUID sender, UUID target)
  {
    boolean isFriend = false;
    ResultSet rs = db.getAllDataFromRowAnd(Friends, "UUIDSender", sender.toString(), "UUIDTarget", target.toString()).getResultSet();
    try
    {
      while (rs.next()) {
        isFriend = true;
      }
    }
    catch (SQLException e)
    {
      e.printStackTrace();
    }
    return isFriend;
  }

  public static ArrayList<UUID> listFriends(UUID sender)
  {
    ArrayList<UUID> id = new ArrayList();
    ResultSet rs = db.getAllDataFromRow(Friends, "UUIDSender", sender.toString()).getResultSet();
    try
    {
      while (rs.next()) {
        id.add(UUID.fromString(rs.getString("UUIDTarget")));
      }
    }
    catch (SQLException e)
    {
      e.printStackTrace();
    }
    return id;
  }
}