diff options
Diffstat (limited to 'src/main/java/dev/tylerm/khs/database/LegacyTable.java')
-rw-r--r-- | src/main/java/dev/tylerm/khs/database/LegacyTable.java | 101 |
1 files changed, 0 insertions, 101 deletions
diff --git a/src/main/java/dev/tylerm/khs/database/LegacyTable.java b/src/main/java/dev/tylerm/khs/database/LegacyTable.java deleted file mode 100644 index 7bf079c..0000000 --- a/src/main/java/dev/tylerm/khs/database/LegacyTable.java +++ /dev/null @@ -1,101 +0,0 @@ -/* - * This file is part of Kenshins Hide and Seek - * - * Copyright (c) 2022 Tyler Murphy. - * - * Kenshins Hide and Seek free software: you can redistribute it and/or modify - * it under the terms of the GNU General Public License as published by - * he Free Software Foundation version 3. - * - * Kenshins Hide and Seek is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - * GNU General Public License for more details. - * - * You should have received a copy of the GNU General Public License - * along with this program. If not, see <http://www.gnu.org/licenses/>. - * - */ - -package dev.tylerm.khs.database; - -import dev.tylerm.khs.database.util.LegacyPlayerInfo; - -import java.sql.Connection; -import java.sql.ResultSet; -import java.sql.SQLException; -import java.sql.Statement; -import java.util.ArrayList; -import java.util.List; - -public class LegacyTable { - - private final Database database; - private final boolean exists; - - protected LegacyTable(Database database) { - - String sql = "SELECT * FROM player_info LIMIT 1;"; - - boolean check; - try(Connection connection = database.connect(); Statement statement = connection.createStatement()) { - ResultSet resultSet = statement.executeQuery(sql); - check = resultSet.next(); - } catch (SQLException e) { - check = false; - } - - this.exists = check; - this.database = database; - } - - public boolean exists(){ - return exists; - } - - public boolean copyData(){ - String sql = "SELECT * FROM player_info;"; - List<LegacyPlayerInfo> legacyPlayerInfoList = new ArrayList<>(); - try(Connection connection = database.connect(); Statement statement = connection.createStatement()) { - ResultSet resultSet = statement.executeQuery(sql); - while(resultSet.next()){ - legacyPlayerInfoList.add(new LegacyPlayerInfo( - resultSet.getBytes("uuid"), - resultSet.getInt("hider_wins"), - resultSet.getInt("seeker_wins"), - resultSet.getInt("games_played") - )); - } - resultSet.close(); - } catch (SQLException e) { - e.printStackTrace(); - return false; - } - for(LegacyPlayerInfo legacyInfo : legacyPlayerInfoList){ - database.getGameData().updateInfo( - legacyInfo.getUniqueId(), - legacyInfo.getHiderWins(), - legacyInfo.getSeekerWins(), - legacyInfo.getGamesPlayer() - legacyInfo.getSeekerWins(), - legacyInfo.getSeekerWins(), - 0, - 0, - 0, - 0 - ); - } - return true; - } - - public boolean drop(){ - String sql = "DROP table player_info"; - try(Connection connection = database.connect(); Statement statement = connection.createStatement()) { - statement.execute(sql); - return true; - } catch (SQLException e) { - e.printStackTrace(); - return false; - } - } - -} |