/**
* Returns a string representing the SQL query corresonding to the specified Query object.
* @param object QueryInterface $query The object from which to generate the SQL string.
* @return mixed Either a string (this would be the case, normally) or an array of strings.
* Each string is corresponding to an SQL query.
* @static
* @access public
*/
static function generateSQLQuery(Query $query)
{
switch ($query->getType()) {
case INSERT:
$result = MySQL_SQLGenerator::generateInsertSQLQuery($query);
break;
case UPDATE:
$result = MySQL_SQLGenerator::generateUpdateSQLQuery($query);
break;
case DELETE:
$result = MySQL_SQLGenerator::generateDeleteSQLQuery($query);
break;
case SELECT:
$result = MySQL_SQLGenerator::generateSelectSQLQuery($query);
break;
case GENERIC:
$result = MySQL_SQLGenerator::generateGenericSQLQuery($query);
break;
default:
throw new DatabaseException("Unsupported query type.");
}
// switch
// echo "<pre>\n";
// echo $result;
// echo "</pre>\n";
return $result;
}
/**
* Returns a string representing the SQL query corresonding to the specified Query object.
* @param object QueryInterface $query The object from which to generate the SQL string.
* @return mixed Either a string (this would be the case, normally) or an array of strings.
* Each string is corresponding to an SQL query.
* @static
* @access public
*/
static function generateSQLQuery(Query $query)
{
switch ($query->getType()) {
case INSERT:
return PostgreSQL_SQLGenerator::generateInsertSQLQuery($query);
break;
case UPDATE:
return PostgreSQL_SQLGenerator::generateUpdateSQLQuery($query);
break;
case DELETE:
return PostgreSQL_SQLGenerator::generateDeleteSQLQuery($query);
break;
case SELECT:
return PostgreSQL_SQLGenerator::generateSelectSQLQuery($query);
break;
case GENERIC:
return MySQL_SQLGenerator::generateGenericSQLQuery($query);
break;
default:
throw new DatabaseException("Unsupported query type.");
}
// switch
}