|
j@236
|
1 (cl:in-package #:amuse-midi-db)
|
|
j@236
|
2
|
|
j@240
|
3 ;;;=====================================================================
|
|
j@240
|
4 ;;; Specialized constructors
|
|
j@240
|
5 ;;;=====================================================================
|
|
j@240
|
6
|
|
j@240
|
7 (defmethod make-composition-identifier ((package (eql *package*))
|
|
j@240
|
8 composition-id)
|
|
j@240
|
9 (make-midi-db-composition-identifier composition-id))
|
|
j@240
|
10
|
|
j@240
|
11
|
|
j@240
|
12
|
|
j@240
|
13 ;;;=====================================================================
|
|
j@240
|
14 ;;; Specialized database-admin methods
|
|
j@240
|
15 ;;;=====================================================================
|
|
j@240
|
16
|
|
j@236
|
17 (defmethod list-collections ((package (eql *package*)) &key
|
|
j@236
|
18 compositions (stream *standard-output*))
|
|
j@236
|
19 "FIXME: better formatting."
|
|
j@236
|
20 (let ((collection-rows (%get-all-collection-headers)))
|
|
j@241
|
21 (flet ((print-separator (&optional (columns 70))
|
|
j@241
|
22 (format stream "~%~A~%"
|
|
j@236
|
23 (make-sequence 'string columns :initial-element #\-))))
|
|
j@236
|
24 (loop for collection-row in collection-rows
|
|
j@236
|
25 do (destructuring-bind (collection-id collection-name description)
|
|
j@236
|
26 collection-row
|
|
j@236
|
27 (format stream "~%Collection-id: ~A~% Name: ~A~% Description: ~A~%"
|
|
j@236
|
28 collection-id collection-name description)
|
|
j@236
|
29 (when compositions
|
|
j@236
|
30 (list-compositions package
|
|
j@236
|
31 :collection-identifier
|
|
j@236
|
32 (make-midi-db-collection-identifier
|
|
j@236
|
33 collection-id))))
|
|
j@236
|
34 do (print-separator)))))
|
|
j@236
|
35
|
|
j@236
|
36 (defmethod list-compositions ((package (eql *package*)) &key
|
|
j@236
|
37 collection-identifier
|
|
j@236
|
38 (stream *standard-output*))
|
|
j@236
|
39 (let ((composition-headers
|
|
j@236
|
40 (if collection-identifier
|
|
j@236
|
41 (%get-all-collection-composition-headers
|
|
j@236
|
42 collection-identifier)
|
|
j@236
|
43 (%get-all-composition-headers))))
|
|
j@236
|
44 (loop for composition-header in composition-headers
|
|
j@241
|
45 do (destructuring-bind (collection-id composition-id filename
|
|
j@241
|
46 timebase start duration owner version creation-timestamp
|
|
j@241
|
47 deletion-timestamp) composition-header
|
|
j@241
|
48 (format stream "~%Collection-id: ~A Composition-id: ~A filename: ~A timebase: ~A start: ~A duration: ~A owner: ~A version: ~A created: ~A deleted: ~A~%"
|
|
j@241
|
49 collection-id composition-id filename timebase
|
|
j@241
|
50 start duration owner version creation-timestamp
|
|
j@241
|
51 deletion-timestamp)))))
|
