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
32
33
34
35
36
37
38
39
40
41
42
|
(in-package :simple-date)
;; Postgresql days are measured from 01-01-2000, whereas simple-date
;; uses 01-03-2000.
(defconstant +postgres-day-offset+ -60)
(defconstant +usecs-in-one-day+ (* 1000 1000 3600 24))
(flet ((interpret-timestamp (usecs)
(multiple-value-bind (days usecs) (floor usecs +usecs-in-one-day+)
(make-instance 'timestamp :days (+ days +postgres-day-offset+)
:ms (floor usecs 1000)))))
(cl-postgres:set-sql-datetime-readers
:date (lambda (days)
(make-instance 'date :days (+ days +postgres-day-offset+)))
:timestamp #'interpret-timestamp
:timestamp-with-timezone #'interpret-timestamp
:interval (lambda (months days usecs)
(make-instance 'interval :months months
:ms (floor (+ (* days +usecs-in-one-day+) usecs) 1000)))))
(defmethod cl-postgres:to-sql-string ((arg date))
(multiple-value-bind (year month day) (decode-date arg)
(values (format nil "~4,'0d-~2,'0d-~2,'0d" year month day) "date")))
(defmethod cl-postgres:to-sql-string ((arg timestamp))
(multiple-value-bind (year month day hour min sec ms) (decode-timestamp arg)
(values
(format nil "~4,'0d-~2,'0d-~2,'0d ~2,'0d:~2,'0d:~2,'0d~@[.~3,'0d~]"
year month day hour min sec (if (zerop ms) nil ms))
"timestamp")))
(defmethod cl-postgres:to-sql-string ((arg interval))
(multiple-value-bind (year month day hour min sec ms) (decode-interval arg)
(if (= year month day hour min sec ms 0)
(values "0 milliseconds" "interval")
(flet ((not-zero (x) (if (zerop x) nil x)))
(values
(format nil "~@[~d years ~]~@[~d months ~]~@[~d days ~]~@[~d hours ~]~@[~d minutes ~]~@[~d seconds ~]~@[~d milliseconds~]"
(not-zero year) (not-zero month) (not-zero day)
(not-zero hour) (not-zero min) (not-zero sec) (not-zero ms))
"interval")))))
|
