private void convertDatabaseToFile(Connection connection) {
try {
final String GROUP_QUERY = "SELECT name, prefix, suffix, permission, priority FROM " + DatabaseConfig.TABLE_GROUPS;
final String PLAYER_QUERY = "SELECT name, uuid, prefix, suffix, priority FROM " + DatabaseConfig.TABLE_PLAYERS;
final File groupsFile = new File(plugin.getDataFolder(), "groups_CONVERTED.yml");
final File playersFile = new File(plugin.getDataFolder(), "players_CONVERTED.yml");
final YamlConfiguration groups = Utils.getConfig(groupsFile);
final YamlConfiguration players = Utils.getConfig(playersFile);
ResultSet results = connection.prepareStatement(GROUP_QUERY).executeQuery();
while (results.next()) {
groups.set("Groups." + results.getString("name") + ".Permission", results.getString("permission"));
groups.set("Groups." + results.getString("name") + ".Prefix", results.getString("prefix"));
groups.set("Groups." + results.getString("name") + ".Suffix", results.getString("suffix"));
groups.set("Groups." + results.getString("name") + ".SortPriority", results.getInt("priority"));
}
results = connection.prepareStatement(PLAYER_QUERY).executeQuery();
while (results.next()) {
players.set("Players." + results.getString("uuid") + ".Name", results.getString("name"));
players.set("Players." + results.getString("uuid") + ".Prefix", results.getString("prefix"));
players.set("Players." + results.getString("uuid") + ".Suffix", results.getString("suffix"));
players.set("Players." + results.getString("uuid") + ".SortPriority", results.getInt("priority"));
}
results.close();
groups.save(groupsFile);
players.save(playersFile);
} catch (SQLException | IOException e) {
e.printStackTrace();
}
}