X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fref-connect.xml;h=a30aaf13e0a78e69c7765499a27087fbbfc5d267;hb=406feeb749bb475bec8077a2716a5b6089bd9072;hp=84b33e519faaeb34355a07f122fcf3913d70908e;hpb=fdd069770e32d0cfa4b66d6e5cfd4540197660ba;p=clsql.git diff --git a/doc/ref-connect.xml b/doc/ref-connect.xml index 84b33e5..a30aaf1 100644 --- a/doc/ref-connect.xml +++ b/doc/ref-connect.xml @@ -22,7 +22,7 @@ DATABASE - Class DATABASE + DATABASE The super-type of all &clsql; databases Class @@ -71,7 +71,7 @@ *CONNECT-IF-EXISTS* - Variable *CONNECT-IF-EXISTS* + *CONNECT-IF-EXISTS* Default value for the if-exists parameter of connect. @@ -80,7 +80,7 @@ Value Type A valid argument to the if-exists - parameter of connect, i.e. one of + parameter of connect, that is, one of :new :warn-new @@ -131,7 +131,7 @@ *DEFAULT-DATABASE* - Variable *DEFAULT-DATABASE* + *DEFAULT-DATABASE* The default database object to use. Variable @@ -241,7 +241,7 @@ *DEFAULT-DATABASE-TYPE* - Variable *DEFAULT-DATABASE-TYPE* + *DEFAULT-DATABASE-TYPE* The default database type to use Variable @@ -300,7 +300,7 @@ *INITIALIZED-DATABASE-TYPES* - Variable *INITIALIZED-DATABASE-TYPES* + *INITIALIZED-DATABASE-TYPES* List of all initialized database types Variable @@ -365,14 +365,13 @@ CONNECT - Function CONNECT + CONNECT create a connection to a database. Function Syntax - Syntax - connect connection-spec &key if-exists database-type pool make-default => database + connect connection-spec &key if-exists database-type pool make-default => database Arguments and Values @@ -380,8 +379,14 @@ connection-spec - A vendor specific connection specification supplied - as a list or as a string. + A SQL backend specific connection specification + supplied as a list or as a string. + For the MySQL backend, this list includes an + optional associative list of connection options. The + options list is parsed and supplied to the MySQL API + using mysql_options in between the + calls to mysql_init + and mysql_real_connect. @@ -589,7 +594,7 @@ CONNECTED-DATABASES - Function CONNECTED-DATABASES + CONNECTED-DATABASES Return the list of active database objects. Function @@ -681,7 +686,7 @@ DATABASE-NAME - Generic Function DATABASE-NAME + DATABASE-NAME Get the name of a database object Generic Function @@ -798,7 +803,7 @@ DATABASE-NAME-FROM-SPEC - Generic Function DATABASE-NAME-FROM-SPEC + DATABASE-NAME-FROM-SPEC Return the database name string corresponding to the given connection specification. Generic Function @@ -911,7 +916,7 @@ DATABASE-TYPE - Generic Function DATABASE-TYPE + DATABASE-TYPE Get the type of a database object. Generic Function @@ -1000,7 +1005,7 @@ DISCONNECT - Function DISCONNECT + DISCONNECT close a database connection Function @@ -1115,7 +1120,7 @@ DISCONNECT-POOLED - Function DISCONNECT-POOLED + DISCONNECT-POOLED closes all pooled database connections Function @@ -1179,7 +1184,7 @@ FIND-DATABASE - Function FIND-DATABASE + FIND-DATABASE >Locate a database object through it's name. Function @@ -1331,7 +1336,7 @@ INITIALIZE-DATABASE-TYPE - Function INITIALIZE-DATABASE-TYPE + INITIALIZE-DATABASE-TYPE Initializes a database type Function @@ -1445,7 +1450,7 @@ RECONNECT - Function RECONNECT + RECONNECT Re-establishes the connection between a database object and its RDBMS. Function @@ -1570,7 +1575,7 @@ STATUS - Function STATUS + STATUS Print information about connected databases. Function @@ -1677,7 +1682,7 @@ CLSQL STATUS: 2004-06-13 15:08:08 CREATE-DATABASE - Function CREATE-DATABASE + CREATE-DATABASE create a database Function @@ -1775,7 +1780,7 @@ error: 'Access denied for user: 'root@localhost' (Using password: YES)' DESTROY-DATABASE - Function DESTROY-DATABASE + DESTROY-DATABASE destroys a database Function @@ -1826,7 +1831,7 @@ error: 'Access denied for user: 'root@localhost' (Using password: YES)' => Error: While trying to access database localhost/test2/root using database-type POSTGRESQL: - Error database-destory failed: dropdb: database removal failed: ERROR: database "test2" does not exist + Error database-destroy failed: dropdb: database removal failed: ERROR: database "test2" does not exist has occurred. [condition type: CLSQL-ACCESS-ERROR] @@ -1872,7 +1877,7 @@ Error: While trying to access database localhost/test2/root PROBE-DATABASE - Function PROBE-DATABASE + PROBE-DATABASE tests for existence of a database Function @@ -1955,7 +1960,7 @@ Error: While trying to access database localhost/test2/root LIST-DATABASES - Function LIST-DATABASES + LIST-DATABASES List databases matching the supplied connection spec and database type. Function @@ -2053,7 +2058,7 @@ Error: While trying to access database localhost/test2/root WITH-DATABASE - Macro WITH-DATABASE + WITH-DATABASE Execute a body of code with a variable bound to a specified database object. Macro @@ -2069,7 +2074,7 @@ Error: While trying to access database localhost/test2/root db-var - A variable to which the specified database is bound. + A variable which is bound to the specified database. @@ -2083,7 +2088,12 @@ Error: While trying to access database localhost/test2/root connect-args - Other optional arguments to connect. + Other optional arguments to + connect. This macro use a value of + &nil; for connect's + make-default key, This is in + contrast to to the connect function which has a default + value of &t; for make-default. @@ -2169,7 +2179,7 @@ Error: While trying to access database localhost/test2/root WITH-DEFAULT-DATABASE - Macro WITH-DEFAULT-DATABASE + WITH-DEFAULT-DATABASE Execute a body of code with *default-database* bound to a specified database. Macro