summaryrefslogtreecommitdiff
path: root/lisp/sql/resume-pkg.lisp
blob: cc79173999627be9f8f875034b4bcc37711477c1 (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
;;; -*- 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))