Merge pull request '1.7.5' (#10) from dev into main

Reviewed-on: https://g.tylerm.dev/tylermurphy534/KenshinsHideAndSeek/pulls/10

1 files changed, 101 insertions, 0 deletions

diff --git a/src/main/java/dev/tylerm/khs/database/LegacyTable.java b/src/main/java/dev/tylerm/khs/database/LegacyTable.java
new file mode 100644
index 0000000..7bf079c
--- /dev/null
+++ b/src/main/java/dev/tylerm/khs/database/LegacyTable.java
@@ -0,0 +1,101 @@
+/*
+ * 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;
+        }
+    }
+
+}