|
SDO_DAS_Relational::executeQuery
Executes a given SQL query against a relational database
and returns the results as a normalised data graph.
()
Warning:
This function is EXPERIMENTAL. The behaviour of this function, the name of this function, and anything else documented about this function may change without notice in a future release of PHP. Use this function at your own risk. Executes a given query against the relational database, using the supplied PDO database handle. Uses the model that it built from the the metadata to interpret the result set. Returns a data graph. Parameters
Return ValuesReturns a data graph. Specifically, it returns a root object of a special type. Under this root object will be the data from the result set. The root object will have a multi-valued containment property with the same name as the application root type specified on the constructor, and that property will contain one or more data objects of the application root type. In the event that the query returns no data, the special root object will still be returned but the containment property for the application root type will be empty. Errors/ExceptionsSDO_DAS_Relational::executeQuery() can throw an SDO_DAS_Relational_Exception if it is unable to construct the data graph correctly. This can occur for a number of reasons: for example if it finds that it does not have primary keys in the result set for all the objects. It also catches any PDO exceptions and obtains PDO diagnostic information which it includes in an SDO_DAS_Relational_Exception which it then throws. ExamplesPlease see the Examples section in the general information about the Relational DAS for many examples of calling this method. |