From 328d0cd912dfa5dbda53a09ecdfeaeb93504b560 Mon Sep 17 00:00:00 2001 From: Daniel Hader Date: Wed, 3 Jun 2026 22:32:09 -0500 Subject: submission logic and fetching submissions --- src/database/sql/fetch_display_submissions.sql | 10 ++++++++++ src/database/sql/fetch_submissions_by_problem_id.sql | 1 + src/database/sql/fetch_user.sql | 1 + 3 files changed, 12 insertions(+) create mode 100644 src/database/sql/fetch_display_submissions.sql create mode 100644 src/database/sql/fetch_submissions_by_problem_id.sql create mode 100644 src/database/sql/fetch_user.sql (limited to 'src/database/sql') diff --git a/src/database/sql/fetch_display_submissions.sql b/src/database/sql/fetch_display_submissions.sql new file mode 100644 index 0000000..5e836b3 --- /dev/null +++ b/src/database/sql/fetch_display_submissions.sql @@ -0,0 +1,10 @@ +SELECT +submission.id AS id, +user.username AS username, +submission.language AS language, +submission.details AS details, +submission.code AS code +FROM submission JOIN user +ON user.id = submission.user_id +WHERE submission.problem_id = ?1 +ORDER BY length(submission.code); diff --git a/src/database/sql/fetch_submissions_by_problem_id.sql b/src/database/sql/fetch_submissions_by_problem_id.sql new file mode 100644 index 0000000..3b5a4ae --- /dev/null +++ b/src/database/sql/fetch_submissions_by_problem_id.sql @@ -0,0 +1 @@ +SELECT * FROM submission WHERE submission.problem_id = ?1; diff --git a/src/database/sql/fetch_user.sql b/src/database/sql/fetch_user.sql new file mode 100644 index 0000000..caadee9 --- /dev/null +++ b/src/database/sql/fetch_user.sql @@ -0,0 +1 @@ +SELECT * FROM user WHERE user.id = ?1; -- cgit v1.2.3