This is the mssql Reference Manual, version 0.0.3, generated automatically by Declt version 4.0 beta 2 "William Riker" on Tue Jul 15 04:08:06 2025 GMT+0.
The main system appears first, followed by any subsystem dependency.
mssqlA 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/srcmssql (system).
packages.lisp (file).
init.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.asdmssql/src/packages.lispmssql/src/init.lispmssql/src/mssql.lispmssql/src/connection.lispmssql/src/query.lispmssql/src/execute.lispmssql/src/remote.lispmssql/src/init.lispmssql.lisp (file).
src (module).
mssql/src/mssql.lisppackages.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.lispmssql.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.lispconnection.lisp (file).
src (module).
foreach-rows-from-query (macro).
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.lispconnection.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.lispquery.lisp (file).
src (module).
call-remote-procedure (function).
%dbrpcinit (function).
%dbrpcparam (function).
%dbrpcsend (function).
lisp-to-sysdb (function).
Packages are listed by definition order.
mssqlcffi.
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).
exit (function).
foreach-rows-from-query (macro).
init (function).
query (function).
rollback-transaction (function).
with-connection (macro).
with-transaction (macro).
%%dbcancel (function).
%%dbcmd (function).
%%dbinit (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).
%dbexit (function).
%dbinit (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.
Sends in ‘query‘ to ‘connection‘, and iterate over each row of db result set.
In ‘before-loop‘, you can get the headers. It is executed before the body of iteration.
In ‘loop-body‘, you can get the headers and the column values. It is the body of iteration. It uses ‘do‘.
In ‘result‘, return the result.
Local Function:
‘row-MAX-CIDX‘: Gets the maximum value of the column index.
‘row-CIDX->NAME‘: Gets the column name from the column index.
‘row-CIDX->VAL‘: Gets the value from the column index of the current row(only uses in ‘loop-body‘).
Local Variable:
‘row‘: ‘before-loop‘ - 0;
‘loop-body‘ - current row number;
‘result‘ - row number at last loop.
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 I L M O P Q R S T U W |
|---|
| Jump to: | %
(
A C D E F G I 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 I M P Q R S T |
|---|
| Jump to: | C D E F I M P Q R S T |
|---|