[CSCMail-Users] Fw: Antw: Status of DTDs

[Laurent M. <lau...@se...>]

Hello

For response to my last mail, here a mail I receive. It's appear as it in
CSCMail ...

--------<BEGIN>----------------------------------------------

This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--=_4C14078A.3B5A369A
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline


> >>> Vivien Malerba <ma...@li...> 26.07.2000	14.53 Uhr >>>
> Hi all!
>=20
> That would be nice, since a lot of discussion has been around the
DTDs, =
that we
> put all the DTDs (report, database and query) in the CVS, so we have
a =
basis
> for discussions (I have to admit I haven't been able to keep up to
date =
with
> the report and database ones). I know that Gerhard has the query one
=
ready.
> Could you all update/insert your DTD in the gda-common directory?
>=20
> If you don't have the writting access, send them to Rodrigo or me.
>=20
> Thanks,
>=20
> Vivien

I wouldn't call the query DTD ready. I only inserted all(??) the stuff
we =
discussed here and added some new elements for insert/update/delete =
statements.

As usual: comments and suggestion appreciated.

BTW I also made a set of test-docs, that show the mapping of the
xml-querie=
s to SQL (PostgreSQL). If there is some requirement for it, I also can
=
send them to this list.

Gerhard





--=_4C14078A.3B5A369A
Content-Type: text/plain
Content-Disposition: attachment; filename="gda-xml-query.dtd"

<!--	  gda-xml-query.dtd
	  Copyright (C) 2000 Vivien Malerba
	  
	  modified July 2000 Gerhard Dieringer
-->

<!ENTITY  % trailer "union|unionall|intersect|minus|sort">
<!ENTITY  % simplevalue "const|field|func">
<!ENTITY  % boolop "and|or|not">
<!ENTITY  % arithop "eq|ne|lt|le|gt|ge">
<!ENTITY  % sqlop "null|like|between|in|exists">
<!ENTITY  % datatype "struct|array|type">

<!ELEMENT query (select|insert|update|delete|create|drop)>
<!ATTLIST query
	  id NMTOKEN #IMPLIED>

<!ELEMENT select (sources?, joins*, values?, qual?, (%trailer;)?)>

<!ELEMENT insert (target, dest?, (values|query))>

<!ELEMENT update (target, sources?, joins*, (set|setlist), qual?)>

<!ELEMENT delete (target, qual?)>


<!ELEMENT target (table|view)>

<!ELEMENT union     (query)>

<!ELEMENT unionall  (query)>

<!ELEMENT intersect (query)>

<!ELEMENT minus     (query)>

<!ELEMENT dest (field+)>

<!ELEMENT setlist (set+)>

<!ELEMENT set (field,(%simplevalue;))>

<!ELEMENT sources (table|view)*>

<!ELEMENT joins (%boolop;|%arithop;)*>
<!ATTLIST joins
	  type (inner|left|right) "inner"
	  left	IDREF #REQUIRED
	  right IDREF #REQUIRED>

<!ELEMENT values (%simplevalue;|query)+>

<!ELEMENT qual (%boolop;|%arithop;|%sqlop;)*>

<!ELEMENT sort (column)+>

<!ELEMENT table EMPTY>
<!ATTLIST table
	  id	  ID	   #IMPLIED
	  name	  NMTOKEN  #REQUIRED
	  temp (yes|no) "no">

<!ELEMENT view EMPTY>
<!ATTLIST view
	  id	  ID	   #IMPLIED
	  name	  NMTOKEN  #REQUIRED>

<!ELEMENT field EMPTY>
<!ATTLIST field
	  source IDREF	 #REQUIRED
	  name	 NMTOKEN #REQUIRED
	  alias  NMTOKEN #IMPLIED
	  group (yes|no) "no">

<!ELEMENT func (field|const|func)*>
<!ATTLIST func 
	  name	NMTOKEN #REQUIRED
	  alias NMTOKEN #IMPLIED
	  aggregate (yes|no) "no">

<!ELEMENT column EMPTY>
<!ATTLIST column num  NMTOKEN #REQUIRED
		 order (asc|desc) "asc">

<!ELEMENT const EMPTY>
<!ATTLIST const
	  value CDATA	#IMPLIED
	  alias NMTOKEN #IMPLIED
	  type	NMTOKEN #REQUIRED
	  null (yes|no) "no">

<!ELEMENT and (%boolop;|%arithop;|%sqlop;)+>

<!ELEMENT or (%boolop;|%arithop;|%sqlop;)+>

<!ELEMENT not (%boolop;|%arithop;|%sqlop;)>

<!ELEMENT eq ((%simplevalue;),(%simplevalue;|query))>

<!ELEMENT ne ((%simplevalue;),(%simplevalue;|query))>

<!ELEMENT lt ((%simplevalue;),(%simplevalue;|query))>

<!ELEMENT le ((%simplevalue;),(%simplevalue;|query))>

<!ELEMENT gt ((%simplevalue;),(%simplevalue;|query))>

<!ELEMENT ge ((%simplevalue;),(%simplevalue;|query))>

<!ELEMENT null (%simplevalue;)>

<!ELEMENT like ((%simplevalue;),(%simplevalue;|query))>

<!ELEMENT between ((%simplevalue;),(%simplevalue;),(%simplevalue;))>

<!ELEMENT in (field,query)>

<!ELEMENT exists (query)>


<!--
************************************************************
-->

<!ELEMENT create (tabledef|viewdef|sequence|indexdef)>

<!ELEMENT drop	 (table|view|sequence|index)>



<!--
The following elements should be moved to the database DTD
-->

<!ELEMENT tabledef (fielddef+,primary?,foreign*)?>
<!ATTLIST tabledef
	  id	  ID	   #IMPLIED
	  name	  NMTOKEN  #REQUIRED
	  temp (yes|no) "no">

<!ELEMENT viewdef (query)>
<!ATTLIST viewdef 
	  id	  ID	   #IMPLIED
	  name	  NMTOKEN  #REQUIRED>

<!ELEMENT fielddef (%datatype;)>
<!ATTLIST fielddef
	  id   ID      #IMPLIED
	  name NMTOKEN #REQUIRED
	  notnull (yes|no) "no">

<!ELEMENT primary EMPTY>
<!ATTLIST primary
	  key IDREFS #REQUIRED>

<!ELEMENT foreign EMPTY>
<!ATTLIST foreign
	  key	IDREFS	 #REQUIRED
	  table NMTOKEN  #REQUIRED
	  ref	NMTOKENS #REQUIRED>

<!ELEMENT struct (element+)>

<!ELEMENT element (%datatype;)>
<!ATTLIST element 
	  name NMTOKEN #REQUIRED>

<!ELEMENT array (%datatype;)>
<!ATTLIST array
	  size NMTOKENS #REQUIRED>

<!ELEMENT type EMPTY>
<!ATTLIST type 
	  name NMTOKEN	#REQUIRED
	  size NMTOKENS #IMPLIED>

<!ELEMENT sequence (property*)>
<!ATTLIST sequence
	  name	NMTOKEN #REQUIRED>

<!ELEMENT property EMPTY>
<!ATTLIST property
	  name	NMTOKEN #REQUIRED
	  value NMTOKEN #REQUIRED>

<!ELEMENT indexdef EMPTY>
<!ATTLIST indexdef
	  name	  NMTOKEN  #REQUIRED
	  table   NMTOKEN  #REQUIRED
	  columns NMTOKENS #REQUIRED
	  unique  (yes|no) "no">

<!ELEMENT index EMPTY>
<!ATTLIST index
	  name	  NMTOKEN  #REQUIRED>


--=_4C14078A.3B5A369A--

_______________________________________________
gnome-db-list mailing list
gno...@gn...
http://mail.gnome.org/mailman/listinfo/gnome-db-list