Class Oracle_SQLGenerator

Description

A OracleQueryGenerator class provides the tools to build a Oracle query from a Query object.

  • version: $Id: Oracle_SQLGenerator.class.php,v 1.11 2007/09/05 21:39:00 adamfranco Exp $
  • license: GNU General Public License (GPL)
  • copyright: Copyright © 2005, Middlebury College

Located in /harmoni/core/DBHandler/Oracle/Oracle_SQLGenerator.class.php (line 24)

SQLGeneratorInterface
   |
   --Oracle_SQLGenerator
Method Summary
string generateDeleteSQLQuery (DeleteQueryInterface $query)
string generateGenericSQLQuery (GenericSQLQueryInterface $query)
string generateInsertSQLQuery (InsertQueryInterface $query)
string generateSelectSQLQuery (SelectQueryInterface $query)
mixed generateSQLQuery (Query $query)
string generateUpdateSQLQuery (UpdateQueryInterface $query)
Methods
generateDeleteSQLQuery (line 225)

Returns a string representing the DELETE SQL query corresonding to the Query object.

  • return: A string representing the DELETE SQL query corresonding to the Query object.
  • access: public
  • static:
string generateDeleteSQLQuery (DeleteQueryInterface $query)
generateGenericSQLQuery (line 68)

Returns a string representing the SQL query corresonding to this Query object.

  • return: A string representing the SQL query corresonding to this Query object.
  • static:
  • access: public
string generateGenericSQLQuery (GenericSQLQueryInterface $query)
generateInsertSQLQuery (line 92)

Returns a string representing the SQL query corresonding to this Query object.

  • return: A string representing the SQL query corresonding to this Query object.
  • static:
  • access: public
string generateInsertSQLQuery (InsertQueryInterface $query)
generateSelectSQLQuery (line 275)

Returns a string representing the SELECT SQL query corresonding to the Query object.

  • return: A string representing the SELECT SQL query corresonding to the Query object.
  • access: public
string generateSelectSQLQuery (SelectQueryInterface $query)
generateSQLQuery (line 36)

Returns a string representing the SQL query corresonding to the specified Query object.

  • return: Either a string (this would be the case, normally) or an array of strings. Each string is corresponding to an SQL query.
  • access: public
  • static:
mixed generateSQLQuery (Query $query)
  • object QueryInterface $query: The object from which to generate the SQL string.

Redefinition of:
SQLGeneratorInterface::generateSQLQuery()
Returns a string representing the SQL query corresonding to the specified Query object.
generateUpdateSQLQuery (line 157)

Returns a string representing the SQL query corresonding to this Query object.

  • return: A string representing the SQL query corresonding to this Query object.
  • access: public
  • static:
string generateUpdateSQLQuery (UpdateQueryInterface $query)

Inherited Methods

Inherited From SQLGeneratorInterface

SQLGeneratorInterface::generateSQLQuery()

Documentation generated on Wed, 19 Sep 2007 10:25:21 -0400 by phpDocumentor 1.3.0RC3