added education

1 files changed, 49 insertions, 0 deletions

diff --git a/sql/functions/resume.insert_education.sql b/sql/functions/resume.insert_education.sql
new file mode 100644
index 0000000..59ba98b
--- /dev/null
+++ b/sql/functions/resume.insert_education.sql
@@ -0,0 +1,49 @@
+drop function resume.insert_education (
+    p_user_id int,
+    p_school character varying,
+    p_start_date character varying,
+    p_end_date character varying,
+    p_major character varying,
+    p_minor character varying,
+    p_degree character varying,
+    p_progress character varying
+);
+
+create or replace function resume.insert_education (
+    p_user_id int,
+    p_school character varying,
+    p_start_date character varying,
+    p_end_date character varying,
+    p_major character varying,
+    p_minor character varying,
+    p_degree character varying,
+    p_progress character varying
+)
+returns bigint
+as $$
+declare
+  l_id bigint;
+begin
+    insert into resume.education (
+        user_id,
+        school,
+        start_date,
+        end_date,
+        major,
+        minor,
+        degree,
+        progress
+    ) values (
+        p_user_id,
+        p_school,
+        p_start_date,
+        p_end_date,
+        p_major,
+        p_minor,
+        p_degree,
+        p_progress
+    ) returning id into l_id;
+
+    return l_id;
+end;
+$$ language plpgsql;