;;;; -*- Mode: LISP; Syntax: ANSI-Common-Lisp; Base: 10 -*-
;;;; *************************************************************************
;;;; FILE IDENTIFICATION
;;;;
;;;; Name:          mysql-loader.sql
;;;; Purpose:       MySQL library loader using UFFI
;;;; Programmers:   Kevin M. Rosenberg
;;;; Date Started:  Feb 2002
;;;;
;;;; $Id: mysql-loader.lisp,v 1.2 2002/10/17 17:01:18 kevin Exp $
;;;;
;;;; This file, part of CLSQL, is Copyright (c) 2002 by Kevin M. Rosenberg
;;;;
;;;; CLSQL users are granted the rights to distribute and use this software
;;;; as governed by the terms of the Lisp Lesser GNU Public License
;;;; (http://opensource.franz.com/preamble.html), also known as the LLGPL.
;;;; *************************************************************************

(declaim (optimize (debug 3) (speed 3) (safety 1) (compilation-speed 0)))
(in-package :mysql)

;;;; Modified by Kevin Rosenberg 
;;;;  - probe potential directories to find library
;;;;  - Changed from CMUCL functions to UFFI to
;;;;      -- prevent library from being loaded multiple times
;;;;      -- support Allegro CL and Lispworks

(defvar *clsql-mysql-library-filename* 
  (uffi:find-foreign-library
   "clsql-mysql"
   `(,(make-pathname :directory (pathname-directory *load-truename*))
     "/opt/lisp/clsql/db-mysql/"
     "/home/kevin/debian/src/clsql/db-mysql/")
   :drive-letters '("C" "D" "E" "F" "G")))
  
(defvar *mysql-library-filename*
    (cond
     ((probe-file "/opt/mysql/lib/mysql/libmysqlclient.so")
      "/opt/mysql/lib/mysql/libmysqlclient.so")
     ((probe-file "/usr/local/lib/libmysqlclient.so")
      "/usr/local/lib/libmysqlclient.so")
     ((probe-file "/usr/lib/libmysqlclient.so")
      "/usr/lib/libmysqlclient.so")
     #+(or win32 mswindows) 
     ((probe-file "c:/mysql/lib/opt/libmysql.dll")
      "c:/mysql/lib/opt/libmysql.dll")
     (t
      (warn "Can't find MySQL client library to load.")))
  "Location where the MySQL client library is to be found.")

(defvar *mysql-library-candidate-names*
    '("libmysqlclient" "libmysql"))

(defvar *mysql-library-candidate-directories*
    '("/opt/mysql/lib/mysql/" "/usr/local/lib/" "/usr/lib/" "/mysql/lib/opt/"))

(defvar *mysql-library-candidate-drive-letters* '("C" "D" "E"))

(defvar *mysql-supporting-libraries* '("c")
  "Used only by CMU. List of library flags needed to be passed to ld to
load the MySQL client library succesfully.  If this differs at your site,
set to the right path before compiling or loading the system.")

(defvar *mysql-library-loaded* nil
  "T if foreign library was able to be loaded successfully")

(defmethod clsql-base-sys:database-type-library-loaded ((database-type (eql :mysql)))
  *mysql-library-loaded*)
				      
(defmethod clsql-base-sys:database-type-load-foreign ((database-type (eql :mysql)))
  (let ((mysql-path
	 (uffi:find-foreign-library *mysql-library-candidate-names*
				    *mysql-library-candidate-directories*
				    :drive-letters
				    *mysql-library-candidate-drive-letters*)))
    ;; zlib required to load mysql on CMUCL Solaris
    (uffi:load-foreign-library 
     (uffi:find-foreign-library '("libz" "zlib")
				'("/usr/lib/" "/usr/local/" "/lib/")))
    (if	(and
	 (uffi:load-foreign-library mysql-path
				    :module "mysql" 
				    :supporting-libraries 
				    *mysql-supporting-libraries*)
	 (uffi:load-foreign-library *clsql-mysql-library-filename* 
				    :module "clsql-mysql" 
				    :supporting-libraries 
				    (append *mysql-supporting-libraries*)))
	(setq *mysql-library-loaded* t)
      (warn "Unable to load MySQL client library ~A or CLSQL-MySQL library ~A"
	    mysql-path *clsql-mysql-library-filename*))))


(clsql-base-sys:database-type-load-foreign :mysql)