private void relocateNation(Connection conn, int nationId, String nation, String happening)
     throws SQLException {
   Matcher match = Utils.REGION_PATTERN.matcher(happening);
   String prevRegion = null;
   String newRegion = null;
   if (match.find()) {
     String title = happening.substring(match.start() + 2, match.end() - 2);
     prevRegion = Utils.sanitizeName(title);
   }
   if (match.find()) {
     String title = happening.substring(match.start() + 2, match.end() - 2);
     newRegion = Utils.sanitizeName(title);
   }
   Logger.info("Relocating " + nation + " from " + prevRegion + " to " + newRegion);
   if (prevRegion != null && newRegion != null) {
     // Double check they are still at their prev region before setting their new region!
     int newRegionId = getOrCreateRegion(conn, nation, newRegion);
     PreparedStatement update =
         conn.prepareStatement(
             "UPDATE assembly.nation SET region = ?, wa_member = 2 WHERE id = ? AND region = ?");
     update.setInt(1, newRegionId);
     update.setInt(2, nationId);
     update.setInt(3, getOrCreateRegion(conn, nation, prevRegion));
     update.executeUpdate();
     DbUtils.closeQuietly(update);
   }
 }
 public static void updateRegionHappenings(
     Connection conn,
     DatabaseAccess access,
     int nationId,
     int happeningId,
     String happening,
     HappeningType type)
     throws SQLException, ExecutionException {
   String region1Happening = type.transformToRegion1Happening(happening);
   String region2Happening = type.transformToRegion2Happening(happening);
   List<Integer> regionIds = new ArrayList<Integer>(2);
   Matcher regions = Utils.REGION_PATTERN.matcher(happening);
   while (regions.find()) {
     regionIds.add(
         access
             .getRegionIdCache()
             .get(happening.substring(regions.start() + 2, regions.end() - 2)));
   }
   if (regionIds.size() == 0 && nationId > -1) {
     PreparedStatement select =
         conn.prepareStatement("SELECT region FROM assembly.nation WHERE id = ?");
     select.setInt(1, nationId);
     ResultSet result = select.executeQuery();
     if (result.next()) {
       regionIds.add(result.getInt(1));
     }
     DbUtils.closeQuietly(result);
     DbUtils.closeQuietly(select);
   }
   PreparedStatement insert =
       conn.prepareStatement(
           "INSERT INTO assembly.regional_happenings (global_id, region, happening) VALUES (?, ?, ?)");
   if (region1Happening != null && regionIds.size() > 0) {
     insert.setInt(1, happeningId);
     insert.setInt(2, regionIds.get(0));
     insert.setString(3, region1Happening);
     insert.executeUpdate();
   }
   if (region2Happening != null && regionIds.size() > 1) {
     insert.setInt(1, happeningId);
     insert.setInt(2, regionIds.get(1));
     insert.setString(3, region2Happening);
     insert.executeUpdate();
   }
   DbUtils.closeQuietly(insert);
 }
 public static void abolishRegionFlag(Connection conn, DatabaseAccess access, String happening)
     throws SQLException, ExecutionException {
   Matcher regions = Utils.REGION_PATTERN.matcher(happening);
   if (regions.find()) {
     int region =
         access
             .getRegionIdCache()
             .get(happening.substring(regions.start() + 2, regions.end() - 2));
     if (region > -1) {
       PreparedStatement updateFlag =
           conn.prepareStatement("UPDATE assembly.region SET flag = ? WHERE id = ?");
       updateFlag.setString(1, "");
       updateFlag.setInt(2, region);
       updateFlag.executeUpdate();
       DbUtils.closeQuietly(updateFlag);
     }
   }
 }
  public void runImpl() {
    if (monitor != null) monitor.happeningHeartbeat();
    HappeningData data;
    synchronized (api) {
      // Throttle the happening queries based on how many new happenings occurred last run
      if (lastRun + Duration.standardSeconds(10).getMillis() > System.currentTimeMillis()) {
        final int activity = this.highActivity.get();
        if (newEvents >= 50 || activity > 0) {
          Logger.info("Very high happenings activity, running at 2s intervals");
          this.highActivity.set(newEvents >= 50 ? 10 : activity - 1);
        } else {
          Logger.debug(
              "Skipping happening run, little activity, last run was "
                  + (System.currentTimeMillis() - lastRun)
                  + " ms ago");
          return;
        }
      }
      lastRun = System.currentTimeMillis() + Duration.standardSeconds(1).getMillis();
      newEvents = 0;
      Logger.info("Executing global happenings run. Max Event ID: " + maxEventId);
      try {
        data = api.getHappeningInfo(null, -1, maxEventId);
      } catch (RateLimitReachedException e) {
        Logger.warn("Happenings monitoring rate limited!");
        return;
      }
      final int oldEventId = maxEventId;
      for (EventHappening happening : data.happenings) {
        if (maxEventId < happening.eventId) {
          maxEventId = happening.eventId;
        }
        if (oldEventId < happening.eventId) {
          newEvents++;
        }
      }
    }
    Connection conn = null;
    PreparedStatement happeningInsert = null;
    try {
      conn = pool.getConnection();

      PreparedStatement state =
          conn.prepareStatement("UPDATE assembly.settings SET last_event_id = ? WHERE id = 1");
      state.setInt(1, maxEventId);
      state.executeUpdate();
      DbUtils.closeQuietly(state);

      happeningInsert =
          conn.prepareStatement(
              "INSERT INTO assembly.global_happenings (nation, happening, timestamp, type) VALUES (?, ?, ?, ?)",
              Statement.RETURN_GENERATED_KEYS);
      for (EventHappening happening : data.happenings) {
        final String text = happening.text;
        final long timestamp = happening.timestamp * 1000;
        Matcher match = Utils.NATION_PATTERN.matcher(text);
        int nationId = -1;
        String nation = "";
        if (match.find()) {
          String title = text.substring(match.start() + 2, match.end() - 2);
          nation = Utils.sanitizeName(title);
          nationId = access.getNationIdCache().get(nation);
          if (nationId == -1) {
            PreparedStatement insert =
                conn.prepareStatement(
                    "INSERT INTO assembly.nation (name, title, full_name, region, first_seen, wa_member) VALUES (?, ?, ?, ?, ?, 2)",
                    Statement.RETURN_GENERATED_KEYS);
            insert.setString(1, nation);
            insert.setString(2, title);
            insert.setString(3, WordUtils.capitalizeFully(nation.replaceAll("_", " ")));
            insert.setInt(4, -1);
            insert.setLong(5, happening.timestamp);
            insert.executeUpdate();
            ResultSet keys = insert.getGeneratedKeys();
            keys.next();
            nationId = keys.getInt(1);
            access.getNationIdCache().put(nation, nationId);

            DbUtils.closeQuietly(keys);
            DbUtils.closeQuietly(insert);
          }
        }

        final int happeningType = HappeningType.match(text);
        final HappeningType type = HappeningType.getType(happeningType);

        if (happeningType == HappeningType.getType("ENDORSEMENT").getId()) {
          if (match.find()) {
            String title = text.substring(match.start() + 2, match.end() - 2);
            String otherNation = Utils.sanitizeName(title);
            addEndorsement(conn, access.getNationIdCache().get(otherNation), nationId);

            // Add *was endorsed by* to db
            happeningInsert.setInt(1, access.getNationIdCache().get(otherNation));
            happeningInsert.setString(
                2, "@@" + otherNation + "@@ was endorsed by @@" + nation + "@@.");
            happeningInsert.setLong(3, timestamp);
            happeningInsert.setInt(4, happeningType);
            happeningInsert.executeUpdate();
          }
        } else if (happeningType == HappeningType.getType("WITHDREW_ENDORSEMENT").getId()) {
          if (match.find()) {
            String title = text.substring(match.start() + 2, match.end() - 2);
            String otherNation = Utils.sanitizeName(title);
            removeEndorsement(conn, access.getNationIdCache().get(otherNation), nationId);
          }
        } else if (happeningType == HappeningType.getType("LOST_ENDORSEMENT").getId()) {
          if (match.find()) {
            String title = text.substring(match.start() + 2, match.end() - 2);
            String otherNation = Utils.sanitizeName(title);
            removeEndorsement(conn, nationId, access.getNationIdCache().get(otherNation));
          }
        } else if (happeningType == HappeningType.getType("RESIGNED_FROM_WORLD_ASSEMBLY").getId()) {
          resignFromWorldAssembly(conn, nationId, false);
        } else if (happeningType == HappeningType.getType("ADMITTED_TO_WORLD_ASSEMBLY").getId()) {
          joinWorldAssembly(conn, nationId);
        } else if (happeningType == HappeningType.getType("EJECTED_FOR_RULE_VIOLATIONS").getId()) {
          resignFromWorldAssembly(conn, nationId, true);
        } else if (happeningType == HappeningType.getType("ABOLISHED_REGIONAL_FLAG").getId()) {
          abolishRegionFlag(conn, access, text);
        } else if (happeningType == HappeningType.getType("RELOCATED").getId()) {
          relocateNation(conn, nationId, nation, text);
        } else if (updateCache.getIfPresent(nationId) == null
            && happeningType == HappeningType.getType("NEW_LEGISLATION").getId()) {
          setRegionUpdateTime(conn, nationId, timestamp);
          updateCache.put(nationId, true);
        } else if (nationId > -1
            && (happeningType == HappeningType.getType("REFOUNDED").getId()
                || happeningType == HappeningType.getType("FOUNDED").getId())) {
          if (happeningType == HappeningType.getType("REFOUNDED").getId()) {
            // Ensure nation is dead
            access.markNationDead(nationId, conn);

            // Only erase flag if it was user uploaded
            PreparedStatement flag =
                conn.prepareStatement("SELECT flag FROM assembly.nation WHERE id = ?");
            flag.setInt(1, nationId);
            ResultSet set = flag.executeQuery();
            boolean eraseFlag = set.next() && set.getString(1).contains("/uploads/");
            DbUtils.closeQuietly(set);
            DbUtils.closeQuietly(flag);

            PreparedStatement alive =
                conn.prepareStatement(
                    "UPDATE assembly.nation SET alive = 1, wa_member = 2"
                        + (eraseFlag ? ", flag = ?" : "")
                        + " WHERE id = ?");
            if (eraseFlag) {
              alive.setString(1, "http://nationstates.net/images/flags/Default.png");
              alive.setInt(2, nationId);
            } else {
              alive.setInt(1, nationId);
            }
            alive.executeUpdate();
            DbUtils.closeQuietly(alive);
          }

          // Update region
          Matcher regions = Utils.REGION_PATTERN.matcher(text);
          if (regions.find()) {
            final int regionId =
                access
                    .getRegionIdCache()
                    .get(text.substring(regions.start() + 2, regions.end() - 2));
            if (regionId > -1) {
              PreparedStatement update =
                  conn.prepareStatement(
                      "UPDATE assembly.nation SET region = ?, wa_member = 2, puppet = ? WHERE id = ?");
              update.setInt(1, regionId);
              update.setInt(2, puppetCache.getIfPresent(nation) != null ? 1 : 0);
              update.setInt(3, nationId);
              update.executeUpdate();
              DbUtils.closeQuietly(update);

              if (puppetCache.getIfPresent(nation) != null) {
                String defaultSettings =
                    "{\"settings\":{\"show_gameplay_news\":false,\"show_roleplay_news\":false,\"show_regional_news\":false,\"show_irc\":false,\"show_world_census\":false,\"show_regional_population\":false,},\"last_update\":"
                        + System.currentTimeMillis()
                        + "}";
                PreparedStatement insert =
                    conn.prepareStatement(
                        "INSERT INTO assembly.ns_settings (id, settings, last_settings_update) VALUES (?, ?, ?)");
                insert.setInt(1, nationId);
                insert.setString(2, defaultSettings);
                insert.setLong(3, System.currentTimeMillis());
                insert.executeUpdate();
                DbUtils.closeQuietly(insert);
                puppetCache.invalidate(nation);
              }
            }
          }
        } else if (nationId > -1
            && happeningType == HappeningType.getType("CEASED_TO_EXIST").getId()) {
          access.markNationDead(nationId, conn);
        }
        happeningInsert.setInt(1, nationId);
        happeningInsert.setString(2, parseHappening(text));
        happeningInsert.setLong(3, timestamp);
        happeningInsert.setInt(4, happeningType);
        happeningInsert.executeUpdate();
        ResultSet keys = happeningInsert.getGeneratedKeys();
        keys.next();
        int happeningId = keys.getInt(1);
        if (type != null) {
          updateRegionHappenings(conn, access, nationId, happeningId, text, type);
        }
        DbUtils.closeQuietly(keys);
      }
    } catch (SQLException e) {
      Logger.error("Unable to update happenings", e);
    } catch (ExecutionException e) {
      Logger.error("Unable to update happenings", e);
    } finally {
      DbUtils.closeQuietly(happeningInsert);
      DbUtils.closeQuietly(conn);
    }
  }