Class MySQL_SQLGenerator

Description
Description | Methods (details)

A MySQLSelectQueryGenerator class provides the tools to build a MySQL query from a Query object.

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

Located in /harmoni/core/DBHandler/MySQL/MySQL_SQLGenerator.class.php (line 25) 

SQLGeneratorInterface
   |
   --MySQL_SQLGenerator
Method Summary
Description | Methods (details)
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
Description | Methods (details)
generateDeleteSQLQuery (line 221)

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 72)

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 95)

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 270)

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 35)

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 154)

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:14 -0400 by phpDocumentor 1.3.0RC3