Difference between revisions of "Read from MySQL"

From XdmfWeb
Jump to navigationJump to search
(New page: == '''Accessing a MySQL DataBase''' == Partial support for reading data from a MySQL database is available. MySQL is treated as another HeavyData format like HDF5. Currently database acce...)
 
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
 
== '''Accessing a MySQL DataBase''' ==
 
== '''Accessing a MySQL DataBase''' ==
 +
 +
<pre style="color: red">Note SQL support was removed in xdmf 3.</pre>
  
 
Partial support for reading data from a MySQL database is available.
 
Partial support for reading data from a MySQL database is available.
Line 16: Line 18:
 
                 </DataItem>
 
                 </DataItem>
 
             </Attribute>
 
             </Attribute>
 +
 +
A Valid SQL statement is placed in the CDATA of the DataItem. When the XdmfDataItem is
 +
updated, an atomic query is made and the result is placed in the XdmfArray of the DataItem.
 +
Putting a "<" (less than) in the CDATA will cause an error in the XML parser. The XML example
 +
above shows how to do this correctly.
 +
 +
The Server, User, and DataBase attributes tell Xdmf how to access MySQL. There is also
 +
a Password attribute. Currently this is just clear text which is a really bad idea. This
 +
will change.

Latest revision as of 19:17, 19 August 2014

Accessing a MySQL DataBase

Note SQL support was removed in xdmf 3.

Partial support for reading data from a MySQL database is available. MySQL is treated as another HeavyData format like HDF5. Currently database access is ReadOnly and is accessed by setting the Format of the DataItem in XML equal to MySQL

           <Attribute Name="Cell Centered Values" Center="Cell">
               <DataItem Format="MySQL"
                   Server="localhost"
                   User="root"
                   DataBase="MnmiFromout"
                   Dimensions="3"
                   NumberType="Float">
                   <![CDATA[SELECT X FROM Locations WHERE Time < 0.21]]>
               </DataItem>
           </Attribute>

A Valid SQL statement is placed in the CDATA of the DataItem. When the XdmfDataItem is updated, an atomic query is made and the result is placed in the XdmfArray of the DataItem. Putting a "<" (less than) in the CDATA will cause an error in the XML parser. The XML example above shows how to do this correctly.

The Server, User, and DataBase attributes tell Xdmf how to access MySQL. There is also a Password attribute. Currently this is just clear text which is a really bad idea. This will change.