<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <title>SDO-DAS-Relational Functions</title> </head> <body><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="sdodasrel.limitations.html">Limitations</a></div> <div class="next" style="text-align: right; float: right;"><a href="sdo-das-relational.applychanges.html">SDO_DAS_Relational::applyChanges</a></div> <div class="up"><a href="book.sdodasrel.html">SDO-DAS-Relational</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div><hr /><div id="ref.sdodasrel" class="reference"> <h1 class="title">SDO-DAS-Relational Functions</h1> <div class="partintro"> <div class="section" id="sdodasrel.classes"> <h2 class="title">Predefined Classes</h2> <p class="para"> The Relational DAS provides two classes: the Relational DAS itself and the subclass of Exception that can be thrown. The Relational DAS has four publicly useful calls: the constructor, the <span class="function"><strong>createRootDataObject()</strong></span> call to obtain the root object of an empty data graph, the <span class="function"><strong>executeQuery()</strong></span> call to obtain a data graph containing data from a relational database, and the <span class="function"><strong>applyChanges()</strong></span> call to write changes made to a data graph back to the relational database. </p> <div class="section" id="sdodasrel.sdo-das-relational"> <h2 class="title"> <strong class="classname">SDO_DAS_Relational</strong> </h2> <p class="para"> The only object other than an SDO_DAS_Relational_Exception with which the application is expected to interact. </p> <div class="section" id="sdodasrel.sdo-das-relational.methods"> <h2 class="title">Methods</h2> <ul class="itemizedlist"> <li class="listitem"> <p class="para"> <a href="sdo-das-relational.construct.html" class="link"> __construct </a> - construct the Relational DAS with a model derived from the passed metadata </p> </li> <li class="listitem"> <p class="para"> <a href="sdo-das-relational.createrootdataobject.html" class="link"> createRootDataObject </a> - obtain an otherwise empty data graph containing just the special root object </p> </li> <li class="listitem"> <p class="para"> <a href="sdo-das-relational.executequery.html" class="link"> executeQuery </a> - execute an SQL query passed as a literal string and return the results as a normalised data graph </p> </li> <li class="listitem"> <p class="para"> <a href="sdo-das-relational.executepreparedquery.html" class="link"> executePreparedQuery </a> - execute an SQL query passed as a prepared statement, with a list of values to substitute for placeholders, and return the results as a normalised data graph </p> </li> <li class="listitem"> <p class="para"> <a href="sdo-das-relational.applychanges.html" class="link"> applyChanges </a> - examine the change summary in the data graph and apply those changes back to the database, subject to an assumption of optimistic concurrency </p> </li> </ul> </div> </div> <div class="section" id="sdodasrel.sdo-das-relational-exception"> <h2 class="title"> <strong class="classname">SDO_DAS_Relational_Exception</strong> </h2> <p class="para"> Is a subclass of PHP's <a href="class.exception.html" class="classname">Exception</a>. It adds no behaviour to <a href="class.exception.html" class="classname">Exception</a>. Thrown, with useful descriptive text, to signal errors in the metadata or unexpected failures to perform SQL operations. </p> </div> </div> </div> <h2>Table of Contents</h2><ul class="chunklist chunklist_reference"><li><a href="sdo-das-relational.applychanges.html">SDO_DAS_Relational::applyChanges</a> — Applies the changes made to a data graph back to the database.</li><li><a href="sdo-das-relational.construct.html">SDO_DAS_Relational::__construct</a> — Creates an instance of a Relational Data Access Service</li><li><a href="sdo-das-relational.createrootdataobject.html">SDO_DAS_Relational::createRootDataObject</a> — Returns the special root object in an otherwise empty data graph. Used when creating a data graph from scratch.</li><li><a href="sdo-das-relational.executepreparedquery.html">SDO_DAS_Relational::executePreparedQuery</a> — Executes an SQL query passed as a prepared statement, with a list of values to substitute for placeholders, and return the results as a normalised data graph.</li><li><a href="sdo-das-relational.executequery.html">SDO_DAS_Relational::executeQuery</a> — Executes a given SQL query against a relational database and returns the results as a normalised data graph.</li></ul> </div> <hr /><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="sdodasrel.limitations.html">Limitations</a></div> <div class="next" style="text-align: right; float: right;"><a href="sdo-das-relational.applychanges.html">SDO_DAS_Relational::applyChanges</a></div> <div class="up"><a href="book.sdodasrel.html">SDO-DAS-Relational</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div></body></html>