summaryrefslogtreewikicommitdiff
path: root/src/main/java/net/tylermurphy/hideAndSeek/database/LegacyTable.java
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/java/net/tylermurphy/hideAndSeek/database/LegacyTable.java')
-rw-r--r--src/main/java/net/tylermurphy/hideAndSeek/database/LegacyTable.java101
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;
- }
- }
-
-}