From dna-commits at lists.jboss.org Thu Dec  3 17:10:38 2009
Content-Type: multipart/mixed; boundary="===============7867924380790735899=="
MIME-Version: 1.0
From: dna-commits at lists.jboss.org
To: dna-commits at lists.jboss.org
Subject: [dna-commits] DNA SVN: r1392 -
 trunk/docs/reference/src/main/docbook/en-US/content/sequencers.
Date: Thu, 03 Dec 2009 17:10:38 -0500
Message-ID: <200912032210.nB3MAcS0029158@svn01.web.mwc.hst.phx2.redhat.com>

--===============7867924380790735899==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

Author: blafond
Date: 2009-12-03 17:10:38 -0500 (Thu, 03 Dec 2009)
New Revision: 1392

Modified:
   trunk/docs/reference/src/main/docbook/en-US/content/sequencers/ddl.xml
Log:
DNA-49 Updated doc section and content for new DDL Sequencer to include exa=
mple DDL and node properties.

Modified: trunk/docs/reference/src/main/docbook/en-US/content/sequencers/dd=
l.xml
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/docs/reference/src/main/docbook/en-US/content/sequencers/ddl.xml	=
2009-12-03 22:09:38 UTC (rev 1391)
+++ trunk/docs/reference/src/main/docbook/en-US/content/sequencers/ddl.xml	=
2009-12-03 22:10:38 UTC (rev 1392)
@@ -64,7 +64,35 @@
             </listitem>
         </itemizedlist>
     </para>
+    <sect1>
+        <title>Example</title>
+	    <para>Sequencing results in graph nodes basically representing the BN=
F structure of each DDL statement. Below is an example DDL
+	        schema definition statement containing table and view definition =
statements.
+	    </para>
+	    <programlisting>
+CREATE SCHEMA hollywood
+	  CREATE TABLE films (title varchar(255), release date, producerName varc=
har(255))
+	  CREATE VIEW winners AS SELECT title, release FROM films WHERE producerN=
ame IS NOT NULL;
+	    </programlisting>
+	    <para>The resulting graph structure, shown below contains the raw sta=
tement expression, pertinent table, column and key
+	        reference information as well as critical integer position values=
 (line number, column number and character index) to
+	        tie the statement back to the original DDL file.
+	    </para>
+	    <programlisting>
+	<![CDATA[
+<name =3D "statements" primaryType =3D "nt:unstructured" uuid =3D "ee3db6e=
6-fa59-46db-bd3f-c555b4fa4a50" parserId =3D "POSTGRES">
+      <name =3D "hollywood" startLineNumber =3D "1" primaryType =3D "nt:un=
structured" uuid =3D "3e084a7d-7da8-4068-9b03-b1aed9ac9c7a" startColumnNumb=
er =3D "1" mixinTypes =3D "ns001:createSchemaStatement" expression =3D "CRE=
ATE SCHEMA hollywood" startCharIndex =3D "0">
+            <name =3D "films" startLineNumber =3D "2" primaryType =3D "nt:=
unstructured" uuid =3D "b622cdcb-69fa-4aa2-8510-f35c0a8ddcbe" startColumnNu=
mber =3D "5" mixinTypes =3D "ns001:createTableStatement" expression =3D "CR=
EATE TABLE films (title varchar(255), release date, producerName varchar(25=
5))" startCharIndex =3D "28">
+            <name =3D "title" datatypeName =3D "VARCHAR" datatypeLength =
=3D "255" primaryType =3D "nt:unstructured" uuid =3D "d7e962bb-cd37-4df4-ab=
53-ab78fd72c153" mixinTypes =3D "ns001:columnDefinition">
+            <name =3D "release" datatypeName =3D "DATE" primaryType =3D "n=
t:unstructured" uuid =3D "83aa7c21-82f7-416e-8c23-5c308a1c4257" mixinTypes =
=3D "ns001:columnDefinition">
+            <name =3D "producerName" datatypeName =3D "VARCHAR" datatypeLe=
ngth =3D "255" primaryType =3D "nt:unstructured" uuid =3D "a51ed903-4d2c-4c=
d9-83e2-a76884b923aa" mixinTypes =3D "ns001:columnDefinition">
+      <name =3D "winners" startLineNumber =3D "3" primaryType =3D "nt:unst=
ructured" uuid =3D "9eeef501-ad7e-4e25-9891-b86485e48dc1" startColumnNumber=
 =3D "5" mixinTypes =3D "ns001:createViewStatement" expression =3D "CREATE =
VIEW winners AS SELECT title, release FROM films WHERE producerName IS NOT =
NULL;" queryExpression =3D " SELECT title, release FROM films WHERE produce=
rName IS NOT NULL" startCharIndex =3D "113">
+	]]>
+	    </programlisting>
+    </sect1>
     <para>
+    </para>
+    <para>
         To use this sequencer, simply include the <code>dna-sequencer-ddl<=
/code> JAR
         in your application and configure the &JcrConfiguration; to use th=
is sequencer using something similar to:
     </para>


--===============7867924380790735899==--