;;;;
;;;; Name: sql-create
;;;; Purpose: Create SQL database for UMLisp
-;;;; Programmer: Kevin M. Rosenberg
+;;;; Author: Kevin M. Rosenberg
;;;; Date Started: Apr 2000
;;;;
-;;;; $Id: sql-create.lisp,v 1.19 2003/05/06 07:17:35 kevin Exp $
+;;;; $Id: sql-create.lisp,v 1.20 2003/05/06 07:44:07 kevin Exp $
;;;;
;;;; This file, part of UMLisp, is
;;;; Copyright (c) 2000-2002 by Kevin M. Rosenberg, M.D.
(format nil "~a (~a)" sqltype (cmax c))
sqltype))))))
(format nil "CREATE TABLE ~a (~{~a~^,~})" (table file)
- (mapcar col-func (ucols-for-umls-file file)))))
+ (mapcar col-func (ucols-for-ufile file)))))
(defun create-custom-table-cmd (tablename sql-cmd)
"Return SQL command to create a custom table"
(find-if (lambda (x) (and (string-equal filename (car x))
(string-equal col (cadr x)))) +custom-cols+))
-
(defun custom-colnames-for-filename (filename)
(mapcar #'cadr (find-custom-cols-for-filename filename)))
(defun translate-umls-file (file extension)
"Translate a umls file into a format suitable for sql copy cmd"
- (translate-files (fil file) extension (list file)))
+ (translate-files file extension (list file)))
(defun make-noneng-index-file (extension)
"Make non-english index file"
- (translate-files "MRXW.NONENG" extension (noneng-lang-index-files)))
+ (translate-files (find-ufile "MRXW.NONENG")
+ extension (noneng-lang-index-files)))
-(defun translate-files (output-basename extension input-files)
+(defun translate-files (out-ufile extension input-ufiles)
"Translate a umls file into a format suitable for sql copy cmd"
- (let ((output-path (umls-pathname output-basename extension)))
+ (let ((output-path (umls-pathname (fil out-ufile) extension)))
(if (probe-file output-path)
(format t "File ~A already exists: skipping~%" output-path)
(with-open-file (ostream output-path :direction :output)
- (dolist (input-file input-files)
- (with-umls-file (line (fil input-file))
- (umls-translate input-file line ostream)
+ (dolist (input-ufile input-ufiles)
+ (with-umls-file (line (fil input-ufile))
+ (umls-translate out-ufile line ostream)
(princ #\newline ostream)))))))
(defun pg-copy-cmd (file extension)