;;;; Author: Kevin M. Rosenberg
;;;; Date Started: Apr 2000
;;;;
-;;;; $Id: create-sql.lisp,v 1.2 2003/05/07 22:53:36 kevin Exp $
+;;;; $Id: create-sql.lisp,v 1.3 2003/05/08 04:36:12 kevin Exp $
;;;;
;;;; This file, part of UMLisp, is
;;;; Copyright (c) 2000-2002 by Kevin M. Rosenberg, M.D.
(defun create-umls-db-by-insert ()
"SQL Databases: initializes entire database via SQL insert commands"
- (ensure-init-umls)
- (init-hash-table)
+ (ensure-ucols+ufiles)
+ (ensure-preparse)
(with-sql-connection (conn)
(sql-drop-tables conn)
(sql-create-tables conn)
(copy-cmd #'mysql-copy-cmd))
"SQL Databases: initializes entire database via SQL copy commands.
This is much faster that using create-umls-db-insert."
- (ensure-init-umls)
- (init-hash-table)
+ (ensure-ucols+ufiles)
+ (ensure-preparse)
(translate-all-files extension)
(with-sql-connection (conn)
(sql-drop-tables conn)
(nreverse avoidable) (nreverse unavoidable))))
(defun display-waste ()
- (ensure-init-umls)
+ (ensure-ucols+ufiles)
(multiple-value-bind (tw ta tu al ul) (umls-fixed-size-waste)
(format t "Total waste: ~d~%" tw)
(format t "Total avoidable: ~d~%" ta)
(defun max-umls-field ()
"Return length of longest field"
(declare (optimize (speed 3) (space 0)))
- (ensure-init-umls)
+ (ensure-ucols+ufiles)
(let ((max 0))
(declare (fixnum max))
(dolist (ucol *umls-cols*)
(defun max-umls-row ()
"Return length of longest row"
(declare (optimize (speed 3) (space 0)))
- (ensure-init-umls)
+ (ensure-ucols+ufiles)
(let ((rowsizes '()))
(dolist (file *umls-files*)
(let ((row 0))