X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;ds=inline;f=doc%2Fcsql.xml;h=011c04663878bdc42759418ab1c07390526fa5cc;hb=3a18cef462f8fb90652450128cd3dff5f7feaf7f;hp=d0d09fa4c76caaa7efab2ccecd36dd4d1a59eac1;hpb=595658021ebaf450894bb143a346e409b55e02af;p=clsql.git
diff --git a/doc/csql.xml b/doc/csql.xml
index d0d09fa..011c046 100644
--- a/doc/csql.xml
+++ b/doc/csql.xml
@@ -135,20 +135,16 @@
-CREATE TABLE EMPLOYEE (
- emplid NOT NULL number(38),
- first_name NOT NULL varchar2(30),
- last_name NOT NULL varchar2(30),
- emall varchar2(100),
- companyid NOT NULL number(38),
- managerid number(38)
-)
-
-CREATE TABLE COMPANY (
- companyid NOT NULL number(38),
- name NOT NULL varchar2(100),
- presidentid NOT NULL number(38)
-)
+CREATE TABLE EMPLOYEE ( emplid NOT NULL number(38),
+ first_name NOT NULL varchar2(30),
+ last_name NOT NULL varchar2(30),
+ email varchar2(100),
+ companyid NOT NULL number(38),
+ managerid number(38))
+
+CREATE TABLE COMPANY ( companyid NOT NULL number(38),
+ name NOT NULL varchar2(100),
+ presidentid NOT NULL number(38))
@@ -189,7 +185,7 @@ mapped into a database). They would be defined as follows:
(clsql:def-view-class company ()
((companyid
- :db-type :key
+ :db-kind :key
:db-constraints :not-null
:type integer
:initarg :companyid)
@@ -251,16 +247,14 @@ mapped into a database). They would be defined as follows:
- :db-type - A string which will be used as the
+ :column- - A string which will be used as the
type specifier for this slots column definition in the database.
- :nulls-ok - If &t;, all &sql; &null; values
- retrieved from the database become nil; if &nil;, all &null;
- values retrieved are converted by
- DATABASE-NULL-VALUE.
+ :void-value - The Lisp value to return if the
+ field is &null;. The default is &nil;.
@@ -303,7 +297,7 @@ mapped into a database). They would be defined as follows:
In an &sql; only application, the EMPLOYEE and
COMPANY tables can be queried to determine things
-like, "Who is Vladamir's manager?", What company does Josef work
+like, "Who is Vladamir's manager?", "What company does Josef work
for?", and "What employees work for Widgets Inc.". This is done by
joining tables with an &sql; query.
@@ -469,7 +463,7 @@ first need to create our tables in the database:
-Note: the file doc/clsql-tutorial.lisp contains
+Note: the file examples/clsql-tutorial.lisp contains
view class definitions which you can load into your list at this point
in order to play along at home.