This is the mssql Reference Manual, version 0.0.3, generated automatically by Declt version 4.0 beta 2 "William Riker" on Mon Feb 26 15:29:08 2024 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).
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/mssql.lispmssql/src/connection.lispmssql/src/query.lispmssql/src/execute.lispmssql/src/remote.lispmssql/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).
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).
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 |
|---|