eZ\Publish\Core\Persistence\Legacy\Tests\TestCase::insertDatabaseFixture PHP Method

    protected function insertDatabaseFixture($file)
    {
        $data = (require $file);
        $db = $this->getDatabaseHandler();
        foreach ($data as $table => $rows) {
            // Check that at least one row exists
            if (!isset($rows[0])) {
                continue;
            }
            $q = $db->createInsertQuery();
            $q->insertInto($db->quoteIdentifier($table));
            // Contains the bound parameters
            $values = array();
            // Binding the parameters
            foreach ($rows[0] as $col => $val) {
                $q->set($db->quoteIdentifier($col), $q->bindParam($values[$col]));
            }
            $stmt = $q->prepare();
            foreach ($rows as $row) {
                try {
                    // This CANNOT be replaced by:
                    // $values = $row
                    // each $values[$col] is a PHP reference which should be
                    // kept for parameters binding to work
                    foreach ($row as $col => $val) {
                        $values[$col] = $val;
                    }
                    $stmt->execute();
                } catch (Exception $e) {
                    echo "{$table} ( ", implode(', ', $row), " )\n";
                    throw $e;
                }
            }
        }
        $this->resetSequences();
    }