# DROP CONSTRAINTS ON COLLECTION bookstore; 
# CONSTRAIN COLLECTION bookstore WITH http://www.25hoursaday.com/books.xsd ; 
#CONSTRAIN COLLECTION auctiondata WITH http://www.25hoursaday.com/books.xsd ; 
# CREATE COLLECTION bookstore CONSTRAINED BY http://www.25hoursaday.com/books.xsd ; 
# DROP COLLECTION barbecue/spare-ribs/babyback ; 
# DROP COLLECTION barbecue/spare-ribs ;
# SHOW COLLECTION barbecue ; 
# CREATE COLLECTION barbecue/spare-ribs ; 
# SHOW COLLECTION barbecue; 
# CREATE COLLECTION barbecue/spare-ribs/babyback ; 
# CREATE COLLECTION barbecue ; 
# CREATE INDEX struct-index OF TYPE STRUCTURE_INDEX WITH KEY=/author/last-name, ELEMENT=/bookstore/book ON COLLECTION barbecue ; 
# CREATE INDEX val-index OF TYPE VALUE_INDEX WITH KEY=/name, ELEMENT=/document/person  ON COLLECTION barbecue ;
# CREATE INDEX text-index OF TYPE TEXT_INDEX WITH KEY=/name, ELEMENT=/document/person ON COLLECTION foo ;
# DROP INDEX val-index FROM COLLECTION barbecue; 
#DROP CONSTRAINTS ON COLLECTION bar; 
# DROP COLLECTION bookstore; 
#DROP COLLECTION barbecue; 
#INSERT  http://www.25hoursaday.com/books.xml INTO COLLECTION dare_collection; 
#INSERT http://www.xml-schema.com/examples/schema/editor.xml INTO COLLECTION bookstore; 
# CONSTRAIN COLLECTION bookstore WITH http://www.25hoursaday.com/books.xsd ;
#INSERT http://www.example.com/foo.xml INTO COLLECTION bookstore; 
#INSERT  http://www.25hoursaday.com/C99standard.txt INTO COLLECTION bookstore;
# INSERT  http://www.25hoursaday.com/books.xml INTO COLLECTION bookstore; 
# INSERT  http://www.25hoursaday.com/books.xml INTO COLLECTION bookstore; 
#INSERT %<% 
#<bk:bookstore xmlns:bk="urn:bookstore-schema">
# <bk:book genre="Fantasy">
#  <bk:title>The Hobbit</bk:title>
#  <bk:author>
#   <bk:first-name>J.R.R.</bk:first-name>
#   <bk:last-name>Tolkien</bk:last-name>
#  </bk:author>
#  <bk:price>14.99</bk:price>  
# </bk:book>
#</bk:bookstore> %>% NAMED fantasy-books.xml INTO COLLECTION bookstore; 
#DROP fantasy-books.xml FROM COLLECTION bookstore ; 
#SHOW CONSTRAINTS ON COLLECTION auctiondata ; 
#SHOW INDICES ON COLLECTION barbecue ; 
#SHOW INDICES ON COLLECTION bookstore ; 
#SHOW COLLECTION auctiondata ; 
#SHOW COLLECTION barbecue ; 
#SHOW COLLECTION bookstore ; 
#SELECT //TITLE FROM auctiondata/auction1.xml ;
#SELECT //tr FROM COLLECTION auctiondata ;
#SELECT //tr FROM auctiondata/sort-bidder-.xsl;
#SELECT //bk:title FROM COLLECTION bookstore ;
#SELECT //TITLE[text()='Sandstone'] FROM 
#auctiondata/auction1.xml  AND TRANSFORM WITH XSLT 
#IN %<%
# <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/XSL/Transform/1.0"> 
# <xsl:template match="/"> 
#  <HTML>
#  <HEAD><TITLE><xsl:value-of select='/document/title'/></TITLE></HEAD> 
#  <BODY><xsl:apply-templates/></BODY> 
#  </HTML> 
# </xsl:template> 
#
# <xsl:template match="TITLE">
#  <H1><xsl:apply-templates/></H1>
# </xsl:template>
#
#</xsl:stylesheet> 
# %>% ;
SELECT //TITLE[text()='Sandstone'] FROM auctiondata/auction1.xml  AND TRANSFORM WITH XSLT 
IN http://www.25hoursaday.com/title.xsl ;
#INSERT %<%
#
#<!-- The following element is a book --> 
#
#%>%
#
#BEFORE //bk:book IN COLLECTION bookstore ;
#INSERT %<%
#
#<bk:book xmlns:bk="urn:bookstore-schema" genre="Fantasy/Comedy">
#  <bk:title>Interesting Times</bk:title>
#  <bk:author>
#   <bk:first-name>Terry</bk:first-name>
#   <bk:last-name>Pratchett</bk:last-name>
#  </bk:author>
#  <bk:price>8.99</bk:price>  
# </bk:book>
#%>%
#
#AFTER /bk:bookstore/bk:book[1] IN COLLECTION bookstore ; 
#INSERT %<%
#<bk:book xmlns:bk="urn:bookstore-schema" genre="Fantasy/Comedy">
#  <bk:title>Men At Arms</bk:title>
#  <bk:author>
#   <bk:first-name>Terry</bk:first-name>
#   <bk:last-name>Pratchett</bk:last-name>
#  </bk:author>
#  <bk:price>8.99</bk:price>
# </bk:book>
#%>%
#
#AT //bk:bookstore IN COLLECTION bookstore ;
#INSERT ATTRIBUTE WITH NAME="location", VALUE="Atlanta"
#INTO //bk:book IN bookstore/fantasy-books.xml ;
#INSERT ATTRIBUTE WITH NAME="xmlns:sixdml", VALUE="http://www.25hoursaday.com/sixdml/"  
#INTO //bk:bookstore IN barbecue/fantasy-books.xml ;
#INSERT ATTRIBUTE WITH NAME="bk:status", VALUE="available", NSURI="urn:bookstore-schema" 
#INTO //bk:book IN COLLECTION bookstore ;
#DELETE //@bk:status FROM bookstore/fantasy-books.xml ;
#DELETE /bk:bookstore/bk:book/bk:price FROM COLLECTION bookstore ; 
#DELETE //comment() FROM COLLECTION bookstore ;
#REPLACE //comment() WITH %<%
#
# <?myPI used-to-be-a-comment ?>
#
#%>% IN COLLECTION bookstore ; 
#REPLACE //bk:price WITH %<%
#
#<bk:price xmlns:bk="urn:bookstore-schema">Unavailable</bk:price>
#
#%>% IN COLLECTION bookstore ; 
#REPLACE //bk:price WITH %<%
#
#<bk:price xmlns:bk="urn:bookstore-schema">Unavailable</bk:price>
#<![CDATA[ I am a CDATA section ]]>:
#<bk:rating xmlns:bk="urn:bookstore-schema" >9/10</bk:rating>
#
#%>% IN COLLECTION barbecue/bookstore ; 
#REPLACE /oldRoot  WITH %<%<!-- Before Document --><newRoot /><!-- After Document -->
#
#%>% IN COLLECTION barbecue/bookstore ; 
#RENAME //bar TO foo-bar IN COLLECTION barbecue/bookstore ;
#RENAME //bk:bookstore TO bookstore WITH NSURI="urn:bookstore-schema" IN COLLECTION bookstore ;
#INSERT  http://www.25hoursaday.com/books.xml INTO COLLECTION bookstore; 
#RENAME //bookstore TO  bk:bookstore WITH NSURI="urn:bookstore-schema" IN COLLECTION bookstore ;