From 51fac3f3b6f73b649ba8109b37d8ff311b905cd4 Mon Sep 17 00:00:00 2001 From: Daniel Hader Date: Tue, 2 Jun 2026 20:37:40 -0500 Subject: problem statement on submission page and submission logic tweaks --- src/database/sql/fetch_problem.sql | 1 + src/database/sql/initialize.sql | 5 +++-- src/database/sql/insert_submission.sql | 1 + 3 files changed, 5 insertions(+), 2 deletions(-) create mode 100644 src/database/sql/fetch_problem.sql create mode 100644 src/database/sql/insert_submission.sql (limited to 'src/database/sql') diff --git a/src/database/sql/fetch_problem.sql b/src/database/sql/fetch_problem.sql new file mode 100644 index 0000000..f319c2f --- /dev/null +++ b/src/database/sql/fetch_problem.sql @@ -0,0 +1 @@ +SELECT * FROM problem WHERE problem.id == ?1; diff --git a/src/database/sql/initialize.sql b/src/database/sql/initialize.sql index 72b7468..8c0f2ef 100644 --- a/src/database/sql/initialize.sql +++ b/src/database/sql/initialize.sql @@ -16,9 +16,10 @@ CREATE TABLE IF NOT EXISTS submission ( id INTEGER PRIMARY KEY, user_id INTEGER NOT NULL, problem_id INTEGER NOT NULL, - code TEXT NOT NULL, language TEXT NOT NULL, - validated INTEGER NOT NULL + details TEXT NOT NULL, + code TEXT NOT NULL + ); INSERT INTO problem (title, description) VALUES ( diff --git a/src/database/sql/insert_submission.sql b/src/database/sql/insert_submission.sql new file mode 100644 index 0000000..96df322 --- /dev/null +++ b/src/database/sql/insert_submission.sql @@ -0,0 +1 @@ +INSERT INTO submission (user_id, problem_id, language, details, code) VALUES (?1, ?2, ?3, ?4, ?5) RETURNING id; -- cgit v1.2.3