view implementations/midi-db/examples/importing-midifiles.lisp @ 330:2fbff655ba47 tip

Removed cpitch-adj and cents SQL columns

(cl:in-package #:amuse-midi-db)

(connect-to-database :database-name "amuse"
		     :username "jamief") ; needs to be adequate permissions

;(create-midi-db-tables *amuse-database*) ; if not already created

;(drop-midi-db-tables *amuse-database*)

;(register-new-implementation *package*) ; if not already registered


;;;=====================================================================
;;; Import collections of drum loops (from Marcus)
;;;=====================================================================

;;; Dangerous Drums
(let ((collection-identifier
       (register-new-collection "Dangerous Drums"
				"Collection of drum loops. Each 'composition' is a collection of loops on separate tracks."
				*amuse-database*)))

  (import-midifiles
   "/home/jamie/music/midifiles/marcus-midifiles/DangerousDrums/"
   collection-identifier
   *amuse-database*))


;;; LA Riot v1
(let ((collection-identifier
       (register-new-collection "LA Riot V1"
				"Collection of drum loops. Each 'composition' is a collection of loops on separate tracks."
				*amuse-database*)))

  (import-midifiles
   "/home/jamie/music/midifiles/marcus-midifiles/LARiotv1/"
   collection-identifier
   *amuse-database*))

;;; Midi breakbeats v8
(let ((collection-identifier
       (register-new-collection "MIDI Breakbeats V8"
				"Collection of drum loops. Each 'composition' is a collection of loops on separate tracks."
				*amuse-database*)))

  (import-midifiles
   "/home/jamie/music/midifiles/marcus-midifiles/MIDIBreakbeatsv8/"
   collection-identifier
   *amuse-database*))


;;;=====================================================================
;;; Import Clapping Music (from Marcus)
;;;=====================================================================

(let ((collection-identifier
       (register-new-collection "Minimalism"
				"Minimalist midifile."
				*amuse-database*)))

  (import-midifiles
   "/home/jamie/music/midifiles/modernism/reich/"
   collection-identifier
   *amuse-database*))


(disconnect-from-database)