view base/database/datasets-setup.lisp @ 235:ea45a3d0730c

Add some generic functions for querying the database in amuse-database-admin.

Ignore-this: d2516f9e731f2e7a079d8a094c70e927

How much general functionality should there be here?
The basic idea is a generalisation of mtp-admin, but there is a lot still to do.

darcs-hash:20100223150341-16a00-46cb41323450b18e21a4fff2cdaf7d38e9c572dc.gz

committer: Jamie Forth <[e-mail]>

(cl:in-package #:amuse-database-admin)

(defun create-datasets-table (&optional (database *amuse-database*))
  (%create-datasets-table database)
  (%create-datasets-join-table database))

(defun drop-datasets-table (&optional (database *amuse-database*))
  (%drop-datasets-table database)
  (%drop-datasets-join-table database))

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;; Helper functions

(defun %create-datasets-table (database)
  #.(clsql:locally-enable-sql-reader-syntax)
  (clsql:create-table "amuse_datasets"
		      '(([|dataset-id|] clsql:smallint :unsigned
			 :not-null :auto-increment :primary-key)
			([|description|] (clsql:varchar 255)
			 :not-null))
		      :database database
		      :transactions t)
  #.(clsql:locally-disable-sql-reader-syntax))

(defun %create-datasets-join-table (database)
  #.(clsql:locally-enable-sql-reader-syntax)
  (clsql:create-table "amuse_datasets_join"
		      '(([|dataset-id|] clsql:smallint :unsigned
			 :not-null)
			([|implementation-id|] clsql:smallint
			 :unsigned :not-null)
			([|composition-id|] clsql:smallint :not-null))
		      :constraints '("KEY (dataset_id)")
		      :database database
		      :transactions t)
  #.(clsql:locally-disable-sql-reader-syntax))

(defun %drop-datasets-table (database)
  (clsql:drop-table "amuse_datasets"
		    :database database
		    :if-does-not-exist :ignore))

(defun %drop-datasets-join-table (database)
  (clsql:drop-table "amuse_datasets_join"
		    :database database
		    :if-does-not-exist :ignore))