implement basic file retrieval

1 files changed, 31 insertions, 0 deletions

diff --git a/src/main/java/com/pinapelz/Database.java b/src/main/java/com/pinapelz/Database.java
index 41d5257..7116328 100644
--- a/src/main/java/com/pinapelz/Database.java
+++ b/src/main/java/com/pinapelz/Database.java
@@ -57,4 +57,35 @@ public class Database {
         ps.executeUpdate();
 
     }
+
+    public String[] getFileById(int fileId) {
+        String sql = """
+        SELECT
+            disc_channel_id,
+            disc_message_id,
+            file_name
+        FROM files
+        WHERE file_id = ?
+    """;
+
+        try (PreparedStatement ps = conn.prepareStatement(sql)) {
+            ps.setInt(1, fileId);
+
+            try (ResultSet rs = ps.executeQuery()) {
+                if (!rs.next()) {
+                    throw new RuntimeException("File not found for id=" + fileId);
+                }
+
+                String channelId = rs.getString("disc_channel_id");
+                String messageId = rs.getString("disc_message_id");
+                String fileName  = rs.getString("file_name");
+
+                return new String[]{ channelId, messageId, fileName };
+            }
+
+        } catch (SQLException e) {
+            throw new RuntimeException("Failed to fetch file metadata", e);
+        }
+    }
+
 }