From 51aa4409c58625687445f3d176e3f6bfa5281153 Mon Sep 17 00:00:00 2001
From: ckonstanski <kostcarl@isu.edu>
Date: Tue, 21 Jul 2026 17:54:15 -0600
Subject: added languages

---
 sql/functions/resume.insert_language.sql | 45 ++++++++++++++++++++++++++++++++
 1 file changed, 45 insertions(+)
 create mode 100644 sql/functions/resume.insert_language.sql

(limited to 'sql/functions')

diff --git a/sql/functions/resume.insert_language.sql b/sql/functions/resume.insert_language.sql
new file mode 100644
index 0000000..92ce6b9
--- /dev/null
+++ b/sql/functions/resume.insert_language.sql
@@ -0,0 +1,45 @@
+drop function resume.insert_language (
+    p_user_id int,
+    p_name character varying,
+    p_understanding_listening character varying,
+    p_understanding_reading character varying,
+    p_speaking_interaction character varying,
+    p_speaking_production character varying,
+    p_writing character varying
+);
+
+create or replace function resume.insert_language (
+    p_user_id int,
+    p_name character varying,
+    p_understanding_listening character varying,
+    p_understanding_reading character varying,
+    p_speaking_interaction character varying,
+    p_speaking_production character varying,
+    p_writing character varying
+)
+returns bigint
+as $$
+declare
+  l_id bigint;
+begin
+    insert into resume.language (
+        user_id,
+        name,
+        understanding_listening,
+        understanding_reading,
+        speaking_interaction,
+        speaking_production,
+        writing
+    ) values (
+        p_user_id,
+        p_name,
+        p_understanding_listening,
+        p_understanding_reading,
+        p_speaking_interaction,
+        p_speaking_production,
+        p_writing
+    ) returning id into l_id;
+
+    return l_id;
+end;
+$$ language plpgsql;
-- 
cgit v1.3