This is the mssql Reference Manual, version 0.0.3, generated automatically by Declt version 4.0 beta 2 "William Riker" on Sun Sep 15 04:15:12 2024 GMT+0.
The main system appears first, followed by any subsystem dependency.
mssql
A Common Lisp library for interacting with MS SQL Server databases.
Andrey Moskvitin <archimag@gmail.com>
GPLv2
0.0.3
cffi
(system).
iterate
(system).
garbage-pools
(system).
parse-number
(system).
src
(module).
Modules are listed depth-first from the system components tree.
mssql/src
mssql
(system).
packages.lisp
(file).
mssql.lisp
(file).
connection.lisp
(file).
query.lisp
(file).
execute.lisp
(file).
remote.lisp
(file).
Files are sorted by type and then listed depth-first from the systems components trees.
mssql/mssql.asd
mssql/src/packages.lisp
mssql/src/mssql.lisp
mssql/src/connection.lisp
mssql/src/query.lisp
mssql/src/execute.lisp
mssql/src/remote.lisp
mssql/src/mssql.lisp
packages.lisp
(file).
src
(module).
print-object
(method).
%dberrhandle
(function).
%dbmsghandle
(function).
*error-message-list*
(special variable).
+fail+
(constant).
+int_cancel+
(constant).
cffi-string
(function).
define-sybdb-function
(macro).
mssql-error
(condition).
mssql/src/connection.lisp
mssql.lisp
(file).
src
(module).
*database*
(special variable).
connect
(function).
connect-toplevel
(function).
connected-p
(function).
database-connection
(class).
disconnect
(function).
disconnect-toplevel
(function).
object-register
(method).
with-connection
(macro).
%%dbcancel
(function).
%%dbcmd
(function).
%%dblogin
(function).
%%dbsetlname
(function).
%%dbsqlexec
(function).
%%tdsdbopen
(function).
%dbcancel
(function).
%dbclose
(function).
%dbcmd
(function).
%dblogin
(function).
%dbloginfree
(function).
%dbsetlname
(function).
%dbsqlexec
(function).
%tdsdbopen
(function).
mssql/src/query.lisp
connection.lisp
(file).
src
(module).
query
(function).
%dbcolname
(function).
%dbcoltype
(function).
%dbconvert
(function).
%dbdata
(function).
%dbdatlen
(function).
%dbnextrow
(function).
%dbnumcols
(function).
%dbresults
(function).
*query-formats*
(special variable).
+no-more-results+
(constant).
+no-more-rows+
(constant).
+numeric-buf-sz+
(constant).
all-rows
(function).
define-row-reader
(macro).
field-name-s
(function).
get-results
(function).
one-row
(function).
read-alist-row
(function).
read-list-row
(function).
read-plist-row
(function).
read-single-value
(function).
sysdb-data-to-lisp
(function).
unsigned-to-signed
(function).
mssql/src/execute.lisp
connection.lisp
(file).
src
(module).
commit-transaction
(function).
execute
(function).
rollback-transaction
(function).
with-transaction
(macro).
transaction-connection
(reader method).
transaction-handle
(class).
transaction-open-p
(reader method).
(setf transaction-open-p)
(writer method).
mssql/src/remote.lisp
query.lisp
(file).
src
(module).
call-remote-procedure
(function).
%dbrpcinit
(function).
%dbrpcparam
(function).
%dbrpcsend
(function).
lisp-to-sysdb
(function).
Packages are listed by definition order.
mssql
cffi
.
common-lisp
.
iterate
.
*database*
(special variable).
call-remote-procedure
(function).
commit-transaction
(function).
connect
(function).
connect-toplevel
(function).
connected-p
(function).
database-connection
(class).
disconnect
(function).
disconnect-toplevel
(function).
execute
(function).
query
(function).
rollback-transaction
(function).
with-connection
(macro).
with-transaction
(macro).
%%dbcancel
(function).
%%dbcmd
(function).
%%dblogin
(function).
%%dbsetlname
(function).
%%dbsqlexec
(function).
%%tdsdbopen
(function).
%dbcancel
(function).
%dbclose
(function).
%dbcmd
(function).
%dbcolname
(function).
%dbcoltype
(function).
%dbconvert
(function).
%dbdata
(function).
%dbdatlen
(function).
%dberrhandle
(function).
%dblogin
(function).
%dbloginfree
(function).
%dbmsghandle
(function).
%dbnextrow
(function).
%dbnumcols
(function).
%dbresults
(function).
%dbrpcinit
(function).
%dbrpcparam
(function).
%dbrpcsend
(function).
%dbsetlname
(function).
%dbsqlexec
(function).
%tdsdbopen
(function).
*error-message-list*
(special variable).
*query-formats*
(special variable).
+fail+
(constant).
+int_cancel+
(constant).
+no-more-results+
(constant).
+no-more-rows+
(constant).
+numeric-buf-sz+
(constant).
all-rows
(function).
cffi-string
(function).
define-row-reader
(macro).
define-sybdb-function
(macro).
field-name-s
(function).
get-results
(function).
lisp-to-sysdb
(function).
mssql-error
(condition).
one-row
(function).
read-alist-row
(function).
read-list-row
(function).
read-plist-row
(function).
read-single-value
(function).
sysdb-data-to-lisp
(function).
transaction-connection
(generic reader).
transaction-handle
(class).
transaction-open-p
(generic reader).
(setf transaction-open-p)
(generic writer).
unsigned-to-signed
(function).
Definitions are sorted by export status, category, package, and then by lexicographic order.
Connects to ‘database‘ on ‘host‘ using ‘user‘ and ‘password‘.
Inside of ‘body‘, the connection is bound to the special variable *database*
Execute the body within a database transaction, committing when the body exits normally, and aborting otherwise. An optional name can be given to the transaction, which can be used to force a commit or abort before the body unwinds.
Immediately commit an open transaction.
Connects to ‘database‘ on ‘host‘ using ‘user‘ and ‘password‘.
The external format defaults to :utf-8.
A CLOS object of type ’database-connection is returned.
Connects to ‘database‘ on ‘host‘ using ‘user‘ and ‘password‘. The connection is bound to the special variable *database*
Is ‘connection‘ available?
Disconnect from ‘connection‘.
Disconnects from *database*
Sends in ‘query‘ to ‘connection‘, return the result as ‘format‘. Format can be any keyword found in *query-formats*.
Immediately rollback an open transaction.
database-connection
) &optional pool) ¶garbage-pools
.
mssql-error
) stream) ¶Formats available for returning from QUERY.
transaction-handle
)) ¶automatically generated reader method
transaction-handle
)) ¶automatically generated reader method
transaction-handle
)) ¶automatically generated writer method
error
.
(quote nil)
:messages
Simple box type for storing the status and the
associated database connection of a transaction. When open-p is nil,
the transaction has been aborted or committed.
Jump to: | %
(
A C D E F G L M O P Q R S T U W |
---|
Jump to: | %
(
A C D E F G L M O P Q R S T U W |
---|
Jump to: | *
+
C D E M O S |
---|
Jump to: | *
+
C D E M O S |
---|
Jump to: | C D E F M P Q R S T |
---|
Jump to: | C D E F M P Q R S T |
---|