|
From: <me...@us...> - 2002-10-03 03:41:17
|
Update of /cvsroot/cayenne/cayenne/xdocs/userguide/quickstart
In directory usw-pr-cvs1:/tmp/cvs-serv7502/xdocs/userguide/quickstart
Modified Files:
comline.xml
Log Message:
straightened Cayenne cmd tutorial
Index: comline.xml
===================================================================
RCS file: /cvsroot/cayenne/cayenne/xdocs/userguide/quickstart/comline.xml,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -d -r1.18 -r1.19
--- comline.xml 2 Oct 2002 04:54:21 -0000 1.18
+++ comline.xml 3 Oct 2002 03:41:14 -0000 1.19
@@ -143,21 +143,33 @@
would match the word "metro"), the following output will be printed:
</p>
<source>
-SEVERE access.QueryLogger 0: --- will run 1 query.
-SEVERE access.QueryLogger 40: SELECT t0.GALLERY_NAME, t0.GALLERY_ID FROM GALLERY t0
-WHERE UPPER(t0.GALLERY_NAME) LIKE UPPER(?) [params: '%metro%']
-SEVERE access.QueryLogger 140: === returned 1 row.
+--- will run 1 query.
+SELECT t0.GALLERY_NAME, t0.GALLERY_ID FROM GALLERY t0 WHERE UPPER(t0.GALLERY_NAME) LIKE UPPER(?)
+[params: '%metro%'] - prepared in 20 ms.
+=== returned 1 row. - took 10 ms.
Found gallery 'The Metropolitan Museum of Art'.
-SEVERE access.QueryLogger 210: --- will run 2 queries.
-SEVERE access.QueryLogger 220: INSERT INTO ARTIST (ARTIST_ID, DATE_OF_BIRTH, ARTIST_NAME)
-VALUES (?, ?, ?) [params: 41, NULL, 'Salvador Dali']
-SEVERE access.QueryLogger 220: === updated 1 row.
-SEVERE access.QueryLogger 230: INSERT INTO PAINTING (PAINTING_ID, PAINTING_TITLE,
-ESTIMATED_PRICE, ARTIST_ID) VALUES (?, ?, ?, ?) [params: 41, 'Sleep', NULL, 41]
-SEVERE access.QueryLogger 240: === updated 1 row.
-SEVERE access.QueryLogger 250: +++ transaction committed.
+--- will run 2 queries.
+SELECT NEXT_ID FROM AUTO_PK_SUPPORT WHERE TABLE_NAME = 'ARTIST'
+=== returned 1 row. - took 0 ms.
+UPDATE AUTO_PK_SUPPORT SET NEXT_ID = NEXT_ID + 20 WHERE TABLE_NAME = 'ARTIST'
+=== updated 1 row.
++++ transaction committed.
+--- will run 2 queries.
+SELECT NEXT_ID FROM AUTO_PK_SUPPORT WHERE TABLE_NAME = 'PAINTING'
+=== returned 1 row. - took 0 ms.
+UPDATE AUTO_PK_SUPPORT SET NEXT_ID = NEXT_ID + 20 WHERE TABLE_NAME = 'PAINTING'
+=== updated 1 row.
++++ transaction committed.
+--- will run 2 queries.
+INSERT INTO ARTIST (ARTIST_ID, DATE_OF_BIRTH, ARTIST_NAME) VALUES (?, ?, ?)
+[params: 280, NULL, 'Salvador Dali']
+=== updated 1 row.
+INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, ESTIMATED_PRICE, PAINTING_TITLE) VALUES (?, ?, ?, ?)
+[params: 280, 280, NULL, 'Sleep']
+=== updated 1 row.
++++ transaction committed.
</source>
</subsection>
</subsection>
|