;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
SQLI/SQLD (c) 2004/2005/2006 Hans Oesterholt-Dijkema, License: LGPL.
For more information, see:
http://www.elemental-programming.org/Bigloo%20SQLI.html
You can also look in the manual section of the Help Desk for "SQLI - SQL Interface module".
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
CONTENTS
--------
* INCLUDED DRIVERS
* TODO
* INSTALLATION LINUX
* SPECIAL CONSIDERATIONS FOR WINDOWS
* MY LINUX INSTALLATION LOG
* WITH PLANET
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
INCLUDED DRIVERS
----------------
Drivers for the following databases are included:
- Oracle >=8 (via libsqlora8).
- DB2 (via db2cli).
- mysql (via mysqlclient).
- sqlite (sqlite 3).
- postgresql (via libpq).
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
TODO
----
* Add support for database CURSORS.
* Maybe add support for more types.
* Add support for large objects.
* Add more drivers; e.g. for:
* Sybase
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
INSTALLATION LINUX
------------------
with setup-plt the sqlid package is installed. drivers are being compiled.
libraries and include files for the drivers need to be in standard places,
e.g. /usr/lib or /usr/local/lib.
DB2 NOTES:
----------
The db2-test.scm test program requires two environment variables:
USER=<the user account to use when connecting to DB2>
PASSWD=<the password to use with the given user account>
DB2 ON UNIX
-----------
Please Note that when using the DB2 Driver on UNIX, You'll need
to set the environment variable DB2INSTANCE. Otherwise you'll certainly get
the message:
c_db2_open: Cannot allocate environment handle using SQLAllocHandle
E.g. I've installed DB2 on Linux using an instance "db2". I've set my
DB2INSTANCE to db2:
export DB2INSTANCE=db2
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
SPECIAL CONSIDERATIONS FOR WINDOWS
----------------------------------
The Windows version of sqlid is distributed with pre-compiled drivers.
With these drivers, also client libraries are distributed against which
the pre-compiled drivers have been linked. The following client libraries
are provided:
- Oracle >=8 : sqlora8.dll (but not oci.dll, which must be installed with Oracle).
- DB2 : - (needed: db2cli.dll, db2api.dll which must be installed with DB2).
- mysql : libmysql.dll (from mysql 5.0.18).
- sqlite : sqlite3.dll (sqlite 3.0.8)
- postgresql : libpq.dll (postgresql 8.0)
Note: For the commercial databases, no client libraries are provided.
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
MY LINUX INSTALLATION LOG
-------------------------
I've got the following installation on my Linux BOX:
- sqlite3 installed in $HOME/local --> $HOME/local/include; $HOME/local/lib are needed
- postgesql installed in $HOME/local --> $HOME/local/include; $HOME/local/lib are needed
- mysql installed in $HOME/local --> $HOME/local/include/mysql; $HOME/local/lib/mysql are needed
- DB2 installed in /opt/IBM/db2/V8.1 --> /opt/IBM/db2/V8.1/lib; /opt/IBM/db2/V8.1/include are needed
- ORACLE *not installed*
Additionally I'm having libpthread installed in the standard places, i.e. /usr/lib/libpthread*
What I'm doing to get sqlid setup right:
ln -sf /usr/lib/*pthread* $HOME/local/lib
ln -sf /usr/include/*pthread* $HOME/local/include
mkdir -p $HOME/local/mysql/lib
mkdir -p $HOME/local/mysql/include
ln -sf /usr/lib/*pthread* $HOME/local/mysql/lib
ln -sf /usr/include/*pthread* $HOME/local/mysql/include
ln -sf $HOME/local/lib/mysql/* $HOME/local/mysql/lib
ln -sf $HOME/local/include/mysql/* $HOME/local/mysql/include
mkdir -p $HOME/local/db2/lib
mkdir -p $HOME/local/db2/include
ln -sf /usr/lib/*pthread* $HOME/local/db2/lib
ln -sf /usr/include/*pthread* $HOME/local/db2/include
ln -sf /opt/IBM/db2/V8.1/lib/* $HOME/local/db2/lib
ln -sf /opt/IBM/db2/V8.1/include/* $HOME/local/db2/include
export MYSQL_EXTENSION_LIB_PATH=$HOME/local/mysql
export DB2_EXTENSION_LIB_PATH=$HOME/local/db2
export PLT_EXTENSION_LIB_PATHS=$HOME/local
export LD_LIBRARY_PATH=$HOME/local/lib:$HOME/local/mysql/lib:/opt/IBM/db2/V8.1/lib
setup-plt sqlid-1.00.plt
or
planet --install oesterholt sqlid.plt 1 0
********************************************************************************************
[hans@asuras sqlid]$ setup-plt sqlid-1.00.plt
setup-plt: Setup version is 300
setup-plt: PLT home directory is /home/hans/local
setup-plt: Collection paths are
setup-plt: /home/hans/.plt-scheme/300/collects
setup-plt: /home/hans/local/collects
setup-plt: Unpacking sqlid from sqlid-1.00.plt
setup-plt: making directory sqlid in /home/hans/local/./collects/
setup-plt: unpacking c-sqld-mysql.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking c-sqld-oracle.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqld-psql-internal.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqlid-libpath.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqlid.h in /home/hans/local/./collects/sqlid/
setup-plt: unpacking c-sqld-db2.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking c-sqld-psql.c in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqld-sqlite.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqld-sqlite-internal.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking doc.txt in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqld-oracle.scm in /home/hans/local/./collects/sqlid/
setup-plt: making directory html in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqlid.css in /home/hans/local/./collects/sqlid/html/
setup-plt: unpacking index.html in /home/hans/local/./collects/sqlid/html/
setup-plt: unpacking sqld-psql.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking info.ss in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqli.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking c-sqld-mysql.c in /home/hans/local/./collects/sqlid/
setup-plt: unpacking c-sqld-sqlite.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqld-db2-internal.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqld-mysql.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking c-sqld-db2.c in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqld-db2.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking c-threads.h in /home/hans/local/./collects/sqlid/
setup-plt: unpacking c-sqld-oracle.c in /home/hans/local/./collects/sqlid/
setup-plt: unpacking c-threads.c in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqld-mysql-internal.scm in /home/hans/local/./collects/sqlid/
setup-plt: making directory samples in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqlite-test.scm in /home/hans/local/./collects/sqlid/samples/
setup-plt: unpacking mysql-test.scm in /home/hans/local/./collects/sqlid/samples/
setup-plt: unpacking oracle-test.scm in /home/hans/local/./collects/sqlid/samples/
setup-plt: unpacking psql-test.scm in /home/hans/local/./collects/sqlid/samples/
setup-plt: unpacking db2-test.scm in /home/hans/local/./collects/sqlid/samples/
setup-plt: unpacking pre-installer.ss in /home/hans/local/./collects/sqlid/
setup-plt: unpacking c-sqld-sqlite.c in /home/hans/local/./collects/sqlid/
setup-plt: unpacking sqld-oracle-internal.scm in /home/hans/local/./collects/sqlid/
setup-plt: unpacking c-sqld-psql.scm in /home/hans/local/./collects/sqlid/
setup-plt: Pre-Installing sqlid
plthome = /home/hans/local
package-dir = /home/hans/local/collects/sqlid
SQLITE3 DRIVER
SQLITE3_EXTENSION_LIB_PATH has not been set, will *not* be used for PLT_EXTENSION_LIB_PATHS
Resetting PLT_EXTENSION_LIB_PATHS=/home/hans/local
PLT_EXTENSION_LIB_PATHS=/home/hans/local
SEARCH PATH=(/home/hans/local /usr /usr/local /usr/local/gnu /sw /arch/gnu/packages/readline-4.2), sys-path=/home/hans/local
make: making compiled/native/i386-linux/c-sqld-sqlite.o because compiled/native/i386-linux/c-sqld-sqlite.o does not exist
compile-extension: (/usr/bin/gcc -c -O2 -fPIC -I/home/hans/local/include -I/home/hans/local/include c-sqld-sqlite.c -o compiled/native/i386-linux/c-sqld-sqlite.o)
make: making compiled/native/i386-linux/c-sqld-sqlite.so because compiled/native/i386-linux/c-sqld-sqlite.so does not exist
link-extension: (/usr/bin/ld -shared -L/home/hans/local/lib compiled/native/i386-linux/c-sqld-sqlite.o -lsqlite3 -lpthread /home/hans/local/lib/mzdyn.o -o compiled/native/i386-linux/c-sqld-sqlite.so)
make: made compiled/native/i386-linux/c-sqld-sqlite.o
make: made compiled/native/i386-linux/c-sqld-sqlite.so
POSTGRESQL DRIVER
PSQL_EXTENSION_LIB_PATH has not been set, will *not* be used for PLT_EXTENSION_LIB_PATHS
Resetting PLT_EXTENSION_LIB_PATHS=/home/hans/local
PLT_EXTENSION_LIB_PATHS=/home/hans/local
SEARCH PATH=(/home/hans/local /usr /usr/local /usr/local/gnu /sw /arch/gnu/packages/readline-4.2), sys-path=/home/hans/local
make: making compiled/native/i386-linux/c-sqld-psql.o because compiled/native/i386-linux/c-sqld-psql.o does not exist
compile-extension: (/usr/bin/gcc -c -O2 -fPIC -I/home/hans/local/include -I/home/hans/local/include c-sqld-psql.c -o compiled/native/i386-linux/c-sqld-psql.o)
make: making compiled/native/i386-linux/c-sqld-psql.so because compiled/native/i386-linux/c-sqld-psql.so does not exist
link-extension: (/usr/bin/ld -shared -L/home/hans/local/lib compiled/native/i386-linux/c-sqld-psql.o -lpq -lpthread /home/hans/local/lib/mzdyn.o -o compiled/native/i386-linux/c-sqld-psql.so)
make: made compiled/native/i386-linux/c-sqld-psql.o
make: made compiled/native/i386-linux/c-sqld-psql.so
MYSQL DRIVER
Setting PLT_EXTENSION_LIB_PATHS=/home/hans/local/mysql
PLT_EXTENSION_LIB_PATHS=/home/hans/local/mysql
SEARCH PATH=(/home/hans/local/mysql /usr /usr/local /usr/local/gnu /sw /arch/gnu/packages/readline-4.2), sys-path=/home/hans/local/mysql
make: making compiled/native/i386-linux/c-sqld-mysql.o because compiled/native/i386-linux/c-sqld-mysql.o does not exist
compile-extension: (/usr/bin/gcc -c -O2 -fPIC -I/home/hans/local/mysql/include -I/home/hans/local/include c-sqld-mysql.c -o compiled/native/i386-linux/c-sqld-mysql.o)
make: making compiled/native/i386-linux/c-sqld-mysql.so because compiled/native/i386-linux/c-sqld-mysql.so does not exist
link-extension: (/usr/bin/ld -shared -L/home/hans/local/mysql/lib compiled/native/i386-linux/c-sqld-mysql.o -lmysqlclient -lpthread /home/hans/local/lib/mzdyn.o -o compiled/native/i386-linux/c-sqld-mysql.so)
make: made compiled/native/i386-linux/c-sqld-mysql.o
make: made compiled/native/i386-linux/c-sqld-mysql.so
ORACLE DRIVER
ORACLE_EXTENSION_LIB_PATH has not been set, will *not* be used for PLT_EXTENSION_LIB_PATHS
Resetting PLT_EXTENSION_LIB_PATHS=/home/hans/local
PLT_EXTENSION_LIB_PATHS=/home/hans/local
SEARCH PATH=(/home/hans/local /usr /usr/local /usr/local/gnu /sw /arch/gnu/packages/readline-4.2), sys-path=#f
ORACLE DRIVER NOT INSTALLED
Setting environment variable ORACLE_EXTENSION_LIB_PATH might help.
It will be used as PLT_EXTENSION_LIB_PATHS variable
DB2 DRIVER
Setting PLT_EXTENSION_LIB_PATHS=/home/hans/local/db2
PLT_EXTENSION_LIB_PATHS=/home/hans/local/db2
SEARCH PATH=(/home/hans/local/db2 /usr /usr/local /usr/local/gnu /sw /arch/gnu/packages/readline-4.2), sys-path=/home/hans/local/db2
make: making compiled/native/i386-linux/c-sqld-db2.o because compiled/native/i386-linux/c-sqld-db2.o does not exist
compile-extension: (/usr/bin/gcc -c -O2 -fPIC -I/home/hans/local/db2/include -I/home/hans/local/include c-sqld-db2.c -o compiled/native/i386-linux/c-sqld-db2.o)
make: making compiled/native/i386-linux/c-sqld-db2.so because compiled/native/i386-linux/c-sqld-db2.so does not exist
link-extension: (/usr/bin/ld -shared -L/home/hans/local/db2/lib compiled/native/i386-linux/c-sqld-db2.o -ldb2 -lpthread /home/hans/local/lib/mzdyn.o -o compiled/native/i386-linux/c-sqld-db2.so)
make: made compiled/native/i386-linux/c-sqld-db2.o
make: made compiled/native/i386-linux/c-sqld-db2.so
setup-plt: Compiling .zos used by sqlid
setup-plt: in /home/hans/local/collects/sqlid/
setup-plt: Done setting up
[hans@asuras sqlid]$
[hans@asuras sqlid]$ export DB2INSTANCE=db2
[hans@asuras sqlid]$ rlwrap mzscheme
Welcome to MzScheme version 300, Copyright (c) 2004-2005 PLT Scheme Inc.
> (require (lib "sqld-db2.scm" "sqlid"))
> (require (lib "sqli.scm" "sqlid"))
> (define d (sqld-db2-new "alias=test user=db2 passwd=test"))
> (define s (sqli-connect d))
> (define r (sqli-query s "select * from test"))
> (sqli-error-message s)
""
> (sqli-fetchall s)
(("row'1" "1" "1" "2006-01-04 22:00:38.000000") ("row'2" "2" "1" "2006-01-04 22:00:38.000000") ("row'3" "3" "1" "2006-01-04 22:00:38.000000") ("row'4" "4" "1" "2006-01-04 22:00:38.000000") ("row'5" "5" "1" "2006-01-04 22:00:38.000000") ("row'6" "6" "1" "2006-01-04 22:00:38.000000") ("row'7" "7" "1" "2006-01-04 22:00:38.000000") ("row'8" "8" "1" "2006-01-04 22:00:38.000000") ("row'9" "9" "1" "2006-01-04 22:00:38.000000") ("row'10" "10" "1" "2006-01-04 22:00:38.000000") ("false" "0" "0" "") ("row'1" "1" "1" "2006-01-04 22:00:44.000000") ("row'2" "2" "1" "2006-01-04 22:00:45.000000") ("row'3" "3" "1" "2006-01-04 22:00:45.000000") ("row'4" "4" "1" "2006-01-04 22:00:45.000000") ("row'5" "5" "1" "2006-01-04 22:00:45.000000") ("row'6" "6" "1" "2006-01-04 22:00:45.000000") ("row'7" "7" "1" "2006-01-04 22:00:45.000000") ("row'8" "8" "1" "2006-01-04 22:00:45.000000") ("row'9" "9" "1" "2006-01-04 22:00:45.000000") ("row'10" "10" "1" "2006-01-04 22:00:45.000000") ("false" "0" "0" "") ("row'1" "1" "1" "2006-01-04 22:01:40.000000") ("row'2" "2" "1" "2006-01-04 22:01:40.000000") ("row'3" "3" "1" "2006-01-04 22:01:40.000000") ("row'4" "4" "1" "2006-01-04 22:01:40.000000") ("row'5" "5" "1" "2006-01-04 22:01:40.000000") ("row'6" "6" "1" "2006-01-04 22:01:40.000000") ("row'7" "7" "1" "2006-01-04 22:01:40.000000") ("row'8" "8" "1" "2006-01-04 22:01:40.000000") ("row'9" "9" "1" "2006-01-04 22:01:40.000000") ("row'10" "10" "1" "2006-01-04 22:01:40.000000") ("false" "0" "0" "") ("row'1" "1" "1" "2006-01-04 22:01:43.000000") ("row'2" "2" "1" "2006-01-04 22:01:43.000000") ("row'3" "3" "1" "2006-01-04 22:01:43.000000") ("row'4" "4" "1" "2006-01-04 22:01:43.000000") ("row'5" "5" "1" "2006-01-04 22:01:43.000000") ("row'6" "6" "1" "2006-01-04 22:01:43.000000") ("row'7" "7" "1" "2006-01-04 22:01:43.000000") ("row'8" "8" "1" "2006-01-04 22:01:43.000000") ("row'9" "9" "1" "2006-01-04 22:01:43.000000") ("row'10" "10" "1" "2006-01-04 22:01:43.000000") ("false" "0" "0" "") ("row'1" "1" "1" "2006-01-04 22:01:47.000000") ("row'2" "2" "1" "2006-01-04 22:01:47.000000") ("row'3" "3" "1" "2006-01-04 22:01:47.000000") ("row'4" "4" "1" "2006-01-04 22:01:47.000000") ("row'5" "5" "1" "2006-01-04 22:01:47.000000") ("row'6" "6" "1" "2006-01-04 22:01:47.000000") ("row'7" "7" "1" "2006-01-04 22:01:47.000000") ("row'8" "8" "1" "2006-01-04 22:01:47.000000") ("row'9" "9" "1" "2006-01-04 22:01:47.000000") ("row'10" "10" "1" "2006-01-04 22:01:47.000000") ("false" "0" "0" ""))
> (sqli-disconnect s)
> (exit)
[hans@asuras sqlid]$
Welcome to MzScheme version 300, Copyright (c) 2004-2005 PLT Scheme Inc.
> (require (lib "sqld-mysql.scm" "sqlid"))
> (require (lib "sqli.scm" "sqlid"))
> (define d (sqld-mysql-new "db=test user=test passwd=test"))
> (define s (sqli-connect d))
> (sqli-error-message s)
""
> (define r (sqli-query s "select * from test"))
> (sqli-error-message s)
""
> (sqli-fetchall s)
(("row'1" "1" "1" "2006-01-04 21:52:51") ("row'2" "2" "1" "2006-01-04 21:52:51") ("row'3" "3" "1" "2006-01-04 21:52:51") ("row'4" "4" "1" "2006-01-04 21:52:51") ("row'5" "5" "1" "2006-01-04 21:52:51") ("row'6" "6" "1" "2006-01-04 21:52:51") ("row'7" "7" "1" "2006-01-04 21:52:51") ("row'8" "8" "1" "2006-01-04 21:52:51") ("row'9" "9" "1" "2006-01-04 21:52:51") ("row'10" "10" "1" "2006-01-04 21:52:51") ("false" "0" "0" "2006-01-04 21:52:51") ("row'1" "1" "1" "2006-01-04 21:52:54") ("row'2" "2" "1" "2006-01-04 21:52:54") ("row'3" "3" "1" "2006-01-04 21:52:54") ("row'4" "4" "1" "2006-01-04 21:52:54") ("row'5" "5" "1" "2006-01-04 21:52:54") ("row'6" "6" "1" "2006-01-04 21:52:54") ("row'7" "7" "1" "2006-01-04 21:52:54") ("row'8" "8" "1" "2006-01-04 21:52:54") ("row'9" "9" "1" "2006-01-04 21:52:54") ("row'10" "10" "1" "2006-01-04 21:52:54") ("false" "0" "0" "2006-01-04 21:52:54") ("row'1" "1" "1" "2006-01-04 21:52:57") ("row'2" "2" "1" "2006-01-04 21:52:57") ("row'3" "3" "1" "2006-01-04 21:52:57") ("row'4" "4" "1" "2006-01-04 21:52:57") ("row'5" "5" "1" "2006-01-04 21:52:57") ("row'6" "6" "1" "2006-01-04 21:52:57") ("row'7" "7" "1" "2006-01-04 21:52:57") ("row'8" "8" "1" "2006-01-04 21:52:57") ("row'9" "9" "1" "2006-01-04 21:52:57") ("row'10" "10" "1" "2006-01-04 21:52:57") ("false" "0" "0" "2006-01-04 21:52:57"))
> (sqli-disconnect s)
> (exit)
[hans@asuras sqlid]$
********************************************************************************************
WITH PLANET
********************************************************************************************
ln -sf /usr/lib/*pthread* $HOME/local/lib
ln -sf /usr/include/*pthread* $HOME/local/include
mkdir -p $HOME/local/mysql/lib
mkdir -p $HOME/local/mysql/include
ln -sf /usr/lib/*pthread* $HOME/local/mysql/lib
ln -sf /usr/include/*pthread* $HOME/local/mysql/include
ln -sf $HOME/local/lib/mysql/* $HOME/local/mysql/lib
ln -sf $HOME/local/include/mysql/* $HOME/local/mysql/include
mkdir -p $HOME/local/db2/lib
mkdir -p $HOME/local/db2/include
ln -sf /usr/lib/*pthread* $HOME/local/db2/lib
ln -sf /usr/include/*pthread* $HOME/local/db2/include
ln -sf /opt/IBM/db2/V8.1/lib/* $HOME/local/db2/lib
ln -sf /opt/IBM/db2/V8.1/include/* $HOME/local/db2/include
export MYSQL_EXTENSION_LIB_PATH=$HOME/local/mysql
export DB2_EXTENSION_LIB_PATH=$HOME/local/db2
export PLT_EXTENSION_LIB_PATHS=$HOME/local
export LD_LIBRARY_PATH=$HOME/local/lib:$HOME/local/mysql/lib:/opt/IBM/db2/V8.1/lib
planet --file sqlid.plt oesterholt 1 0
cat $HOME/.pltscheme/planet/300/300/INSTALL-LOG
(...)
============= Installing sqlid.plt on Wed, 4 Jan 2006 23:41:49 =============
setup-plt: Setup version is 300
setup-plt: PLT home directory is /home/hans/local
setup-plt: Collection paths are
setup-plt: /home/hans/.plt-scheme/300/collects
setup-plt: /home/hans/local/collects
setup-plt: Unpacking archive from /home/hans/src/sqlid/sqlid.plt
setup-plt: unpacking c-sqld-mysql.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking c-sqld-oracle.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking sqld-psql-internal.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./setup-plt: unpacking sqlid-libpath.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking sqlid.h in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking c-sqld-db2.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking c-sqld-psql.c in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking sqld-sqlite.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking sqld-sqlite-internal.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking doc.txt in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking sqld-oracle.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: making directory html in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking sqlid.css in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./html/
setup-plt: unpacking index.html in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./html/
setup-plt: unpacking sqld-psql.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking info.ss in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking sqli.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking c-sqld-mysql.c in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking c-sqld-sqlite.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking sqld-db2-internal.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking sqld-mysql.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking c-sqld-db2.c in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking sqld-db2.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking c-threads.h in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking c-sqld-oracle.c in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking c-threads.c in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking sqld-mysql-internal.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: making directory samples in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking sqlite-test.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./samples/
setup-plt: unpacking mysql-test.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./samples/setup-plt: unpacking oracle-test.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./samples/
setup-plt: unpacking psql-test.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./samples/
setup-plt: unpacking db2-test.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./samples/
setup-plt: unpacking pre-installer.ss in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking c-sqld-sqlite.c in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking sqld-oracle-internal.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: unpacking c-sqld-psql.scm in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/./
setup-plt: Pre-Installing sqlid
plthome = /home/hans/local
package-dir = /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0
SQLITE3 DRIVER
SQLITE3_EXTENSION_LIB_PATH has not been set, will *not* be used for PLT_EXTENSION_LIB_PATHS
Resetting PLT_EXTENSION_LIB_PATHS=/home/hans/local
PLT_EXTENSION_LIB_PATHS=/home/hans/local
SEARCH PATH=(/home/hans/local /usr /usr/local /usr/local/gnu /sw /arch/gnu/packages/readline-4.2), sys-path=/home/hans/local
make: making compiled/native/i386-linux/c-sqld-sqlite.o because compiled/native/i386-linux/c-sqld-sqlite.o does not exist
compile-extension: (/usr/bin/gcc -c -O2 -fPIC -I/home/hans/local/include -I/home/hans/local/include c-sqld-sqlite.c -o compiled/native/i386-linux/c-sqld-sqlite.o)
make: making compiled/native/i386-linux/c-sqld-sqlite.so because compiled/native/i386-linux/c-sqld-sqlite.so does not exist
link-extension: (/usr/bin/ld -shared -L/home/hans/local/lib compiled/native/i386-linux/c-sqld-sqlite.o -lsqlite3 -lpthread /home/hans/local/lib/mzdyn.o -o compiled/native/i386-linux/c-sqld-sqlite.so)
make: made compiled/native/i386-linux/c-sqld-sqlite.o
make: made compiled/native/i386-linux/c-sqld-sqlite.so
POSTGRESQL DRIVER
PSQL_EXTENSION_LIB_PATH has not been set, will *not* be used for PLT_EXTENSION_LIB_PATHS
Resetting PLT_EXTENSION_LIB_PATHS=/home/hans/local
PLT_EXTENSION_LIB_PATHS=/home/hans/local
SEARCH PATH=(/home/hans/local /usr /usr/local /usr/local/gnu /sw /arch/gnu/packages/readline-4.2), sys-path=/home/hans/local
make: making compiled/native/i386-linux/c-sqld-psql.o because compiled/native/i386-linux/c-sqld-psql.o does not exist
compile-extension: (/usr/bin/gcc -c -O2 -fPIC -I/home/hans/local/include -I/home/hans/local/include c-sqld-psql.c -o compiled/native/i386-linux/c-sqld-psql.o)
make: making compiled/native/i386-linux/c-sqld-psql.so because compiled/native/i386-linux/c-sqld-psql.so does not exist
link-extension: (/usr/bin/ld -shared -L/home/hans/local/lib compiled/native/i386-linux/c-sqld-psql.o -lpq -lpthread /home/hans/local/lib/mzdyn.o -o compiled/native/i386-linux/c-sqld-psql.so)
make: made compiled/native/i386-linux/c-sqld-psql.o
make: made compiled/native/i386-linux/c-sqld-psql.so
MYSQL DRIVER
Setting PLT_EXTENSION_LIB_PATHS=/home/hans/local/mysql
PLT_EXTENSION_LIB_PATHS=/home/hans/local/mysql
SEARCH PATH=(/home/hans/local/mysql /usr /usr/local /usr/local/gnu /sw /arch/gnu/packages/readline-4.2), sys-path=/home/hans/local/mysql
make: making compiled/native/i386-linux/c-sqld-mysql.o because compiled/native/i386-linux/c-sqld-mysql.o does not exist
compile-extension: (/usr/bin/gcc -c -O2 -fPIC -I/home/hans/local/mysql/include -I/home/hans/local/include c-sqld-mysql.c -o compiled/native/i386-linux/c-sqld-mysql.o)
make: making compiled/native/i386-linux/c-sqld-mysql.so because compiled/native/i386-linux/c-sqld-mysql.so does not exist
link-extension: (/usr/bin/ld -shared -L/home/hans/local/mysql/lib compiled/native/i386-linux/c-sqld-mysql.o -lmysqlclient -lpthread /home/hans/local/lib/mzdyn.o -o compiled/native/i386-linux/c-sqld-mysql.so)
make: made compiled/native/i386-linux/c-sqld-mysql.o
make: made compiled/native/i386-linux/c-sqld-mysql.so
ORACLE DRIVER
ORACLE_EXTENSION_LIB_PATH has not been set, will *not* be used for PLT_EXTENSION_LIB_PATHS
Resetting PLT_EXTENSION_LIB_PATHS=/home/hans/local
PLT_EXTENSION_LIB_PATHS=/home/hans/local
SEARCH PATH=(/home/hans/local /usr /usr/local /usr/local/gnu /sw /arch/gnu/packages/readline-4.2), sys-path=#f
ORACLE DRIVER NOT INSTALLED
Setting environment variable ORACLE_EXTENSION_LIB_PATH might help.
It will be used as PLT_EXTENSION_LIB_PATHS variable
DB2 DRIVER
Setting PLT_EXTENSION_LIB_PATHS=/home/hans/local/db2
PLT_EXTENSION_LIB_PATHS=/home/hans/local/db2
SEARCH PATH=(/home/hans/local/db2 /usr /usr/local /usr/local/gnu /sw /arch/gnu/packages/readline-4.2), sys-path=/home/hans/local/db2
make: making compiled/native/i386-linux/c-sqld-db2.o because compiled/native/i386-linux/c-sqld-db2.o does not exist
compile-extension: (/usr/bin/gcc -c -O2 -fPIC -I/home/hans/local/db2/include -I/home/hans/local/include c-sqld-db2.c -o compiled/native/i386-linux/c-sqld-db2.o)
make: making compiled/native/i386-linux/c-sqld-db2.so because compiled/native/i386-linux/c-sqld-db2.so does not exist
link-extension: (/usr/bin/ld -shared -L/home/hans/local/db2/lib compiled/native/i386-linux/c-sqld-db2.o -ldb2 -lpthread /home/hans/local/lib/mzdyn.o -o compiled/native/i386-linux/c-sqld-db2.so)
make: made compiled/native/i386-linux/c-sqld-db2.o
make: made compiled/native/i386-linux/c-sqld-db2.so
setup-plt: Compiling .zos used by sqlid
setup-plt: in /home/hans/.plt-scheme/planet/300/300/cache/oesterholt/sqlid.plt/1/0/
setup-plt: Updating /home/hans/.plt-scheme/planet/300/300/cache.ss
setup-plt: Done setting up
[hans@asuras sqlid]$
[hans@asuras sqlid]$ mzscheme
Welcome to MzScheme version 300, Copyright (c) 2004-2005 PLT Scheme Inc.
> (require (planet "sqld-sqlite.scm" ("oesterholt" "sqlid.plt" 1 0)))
> (require (planet "sqli.scm" ("oesterholt" "sqlid.plt" 1 0)))
> (define d (sqld-sqlite-new "test.db"))
> (define s (sqli-connect d))
> (define r (sqli-query s "create table test (a varchar, b integer)"))
> (sqli-error-message s)
""
> (define r (sqli-query s "insert into test values ('abc',123)"))
> (define r (sqli-query s "insert into test values ('abcd',233)"))
> (sqli-begin s)
#f
> (sqli-query s "insert into test values ('eee',111)")
#f
> (sqli-query s "insert into test values ('efe',232)")
#f
> (sqli-commit s)
#f
> (define r (sqli-query s "select * from test"))
> (sqli-fetchall s)
(("abc" "123") ("abcd" "233") ("eee" "111") ("efe" "232"))
> (sqli-disconnect s)
> (exit)
[hans@asuras sqlid]$
********************************************************************************************
---
$Id: doc.txt,v 1.4 2006/01/05 00:19:24 HansOesterholt Exp $
![[logo]](/logo.png){kind=logo}