diff options
author | tylermurphy534 <tylerm@tylerm.dev> | 2023-07-30 22:13:49 +0000 |
---|---|---|
committer | tylermurphy534 <tylerm@tylerm.dev> | 2023-07-30 22:13:49 +0000 |
commit | a2ea5a635e1b841f58c05ca07e4b547a38fe3433 (patch) | |
tree | 5217465c967796680cc03b11359490f638d6b78c /src/main/java/net/tylermurphy/hideAndSeek/database/LegacyTable.java | |
parent | Update 'README.md' (diff) | |
parent | 1.7.5 rc4 (diff) | |
download | kenshinshideandseek-a2ea5a635e1b841f58c05ca07e4b547a38fe3433.tar.gz kenshinshideandseek-a2ea5a635e1b841f58c05ca07e4b547a38fe3433.tar.bz2 kenshinshideandseek-a2ea5a635e1b841f58c05ca07e4b547a38fe3433.zip |
Merge pull request '1.7.5' (#10) from dev into main
Reviewed-on: https://g.tylerm.dev/tylermurphy534/KenshinsHideAndSeek/pulls/10
Diffstat (limited to 'src/main/java/net/tylermurphy/hideAndSeek/database/LegacyTable.java')
-rw-r--r-- | src/main/java/net/tylermurphy/hideAndSeek/database/LegacyTable.java | 101 |
1 files changed, 0 insertions, 101 deletions
diff --git a/src/main/java/net/tylermurphy/hideAndSeek/database/LegacyTable.java b/src/main/java/net/tylermurphy/hideAndSeek/database/LegacyTable.java deleted file mode 100644 index e134c22..0000000 --- a/src/main/java/net/tylermurphy/hideAndSeek/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 net.tylermurphy.hideAndSeek.database; - -import net.tylermurphy.hideAndSeek.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; - } - } - -} |