From fbe9b9eb7a462b42f235d100811b377659101b3c Mon Sep 17 00:00:00 2001
From: Pinapelz <yukais@pinapelz.com>
Date: Sun, 28 Dec 2025 19:44:52 -0800
Subject: implement basic file retrieval

---
 src/main/java/com/pinapelz/Database.java | 31 +++++++++++++++++++++++++++++++
 1 file changed, 31 insertions(+)

(limited to 'src/main/java/com/pinapelz/Database.java')

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);
+        }
+    }
+
 }
-- 
cgit v1.2.3