summaryrefslogtreecommitdiff
path: root/lisp/sql/resume-pkg.lisp
blob: 8a7b0fa58cd65ee62f53b57c9b51df36c30ff93e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
;;; -*- Mode: Lisp; Syntax: ANSI-Common-Lisp; Base: 10 -*-
(declaim (optimize (speed 0) (safety 3) (debug 3)))

(in-package :resume)

(defclass resume-pkg (record-pkg)
  ()
  (:documentation ""))

(defmethod get-all-resumes-for-user ((resume-pkg resume-pkg) (user user))
    (let ((resume (make-instance 'resume :user_id (id user))))
      (get-records resume-pkg resume "name asc")))

(defmethod get-resume ((resume-pkg resume-pkg) (resume resume))
  (get-record resume-pkg resume))

(defmethod insert-resume ((resume-pkg resume-pkg) (resume resume))
  (setf (*table resume) (format nil
                                "resume.insert_resume(~a, '~a')"
                                (user_id resume)
                                (name resume)))
  (caar (call-pg-function resume-pkg resume)))

(defmethod update-resume ((resume-pkg resume-pkg) (resume resume))
  (update-record resume-pkg resume))

(defmethod delete-resume ((resume-pkg resume-pkg) (resume resume))
  (setf (*table resume) (format nil
                                "resume.delete_resume(~a)"
                                (id resume)))
  (caar (call-pg-function resume-pkg resume)))