1 ;;;; -*- Mode: Lisp; Syntax: ANSI-Common-Lisp; Base: 10; Package: umlisp -*-
2 ;;;; *************************************************************************
3 ;;;; FILE IDENTIFICATION
5 ;;;; Name: connect.lisp
6 ;;;; Purpose: Low-level SQL routines data for UMLisp
7 ;;;; Programmer: Kevin M. Rosenberg
8 ;;;; Date Started: Apr 2000
10 ;;;; $Id: connect.lisp,v 1.1 2002/12/01 21:07:28 kevin Exp $
12 ;;;; This file, part of Hyperobject-SQL, is
13 ;;;; Copyright (c) 2000-2002 by Kevin M. Rosenberg, M.D.
14 ;;;; *************************************************************************
16 (in-package :hyperobject)
17 (declaim (optimize (speed 3) (safety 1) (compilation-speed 0) (debug 3)))
20 (defvar *ho-sql-db* "ho")
23 (defun ho-sql-db! (dbname)
24 (sql-disconnect-pooled)
25 (setq *ho-sql-db* dbname))
27 (defvar *ho-sql-user* "secret")
30 (defun ho-sql-user! (u)
31 (sql-disconnect-pooled)
32 (setq *ho-sql-user* u))
34 (defvar *ho-sql-passwd* "secret")
35 (defun ho-sql-passwd ()
37 (defun ho-sql-passwd! (p)
38 (sql-disconnect-pooled)
39 (setq *ho-sql-passwd* p))
41 (defvar *ho-sql-host* "localhost")
44 (defun ho-sql-host! (h)
45 (sql-disconnect-pooled)
46 (setq *ho-sql-host* h))
48 (defvar *ho-sql-type* :mysql)
51 (defun ho-sql-type! (h)
52 (sql-disconnect-pooled)
53 (setq *ho-sql-type* h))
56 "Connect to HO database, automatically used pooled connections"
57 (clsql:connect `(,(ho-sql-host) ,(ho-sql-db) ,(ho-sql-user) ,(ho-sql-passwd))
58 :database-type *ho-sql-type* :pool t))
60 (defun sql-disconnect (conn)
61 "Disconnect from HO database, but put connection back into pool"
62 (clsql:disconnect :database conn))
64 (defun sql-disconnect-pooled ()
65 (clsql:disconnect-pooled))
67 (defmacro with-sql-connection ((conn) &body body)
68 `(let ((,conn (sql-connect)))
71 (when ,conn (clsql:disconnect :database ,conn)))))
73 (defun sql (stmt conn)
74 (if (string-equal "SELECT" (subseq stmt 0 6))
76 (sql-execute stmt conn)))
78 (defun sql-query (cmd conn &key (types :auto))
79 (clsql:query cmd :database conn :types types))
81 (defun sql-execute (cmd conn)
82 (clsql:execute-command cmd :database conn))
85 (check-type stmt string)
86 (with-sql-connection (conn)
89 ;;; Pool of open connections
91 (defmacro with-mutex-sql ((conn) &body body)
92 `(let ((,conn (sql-connect)))
95 (when ,conn (sql-disconnect ,conn)))))
97 (defun mutex-sql-execute (cmd)
98 (with-mutex-sql (conn)
99 (sql-execute cmd conn)))
101 (defun mutex-sql-query (cmd &key (types :auto))
102 (with-mutex-sql (conn)
103 (sql-query cmd conn :types types)))