Back to ChangeSet class

Method getUpdateQueries

private array
getUpdateQueries
(array $sqlfiles)
Get array of SQL queries
Parameters
  • array $sqlfiles Array of .sql update filenames.
Returns
  • array Array of \stdClass objects where: file=filename, update_query = text of SQL update query
Since
  • 2.5
Class: ChangeSet
Project: Joomla

Method getUpdateQueries - Source code

/**
 * Get array of SQL queries
 *
 * @param   array  $sqlfiles  Array of .sql update filenames.
 *
 * @return  array  Array of \stdClass objects where:
 *                    file=filename,
 *                    update_query = text of SQL update query
 *
 * @since   2.5
 */
private function getUpdateQueries(array $sqlfiles)
{
    // Hold results as array of objects
    $result = array();
    foreach ($sqlfiles as $file) {
        $buffer = file_get_contents($file);
        // Create an array of queries from the sql file
        $queries = DatabaseDriver::splitSql($buffer);
        foreach ($queries as $query) {
            $fileQueries = new \stdClass();
            $fileQueries->file = $file;
            $fileQueries->updateQuery = $query;
            $result[] = $fileQueries;
        }
    }
    return $result;
}