<?php
$cfg = require_once __DIR__ . '/typo3conf/LocalConfiguration.php';

$db = new PDO(
    'mysql:dbname=' . $cfg['DB']['database'] . ';host=' . $cfg['DB']['host'],
    $cfg['DB']['username'],
    $cfg['DB']['password']
);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$useIgBinary = extension_loaded('igbinary');
$res = $db->query('SELECT * FROM cf_extbase_reflection ORDER BY identifier');
foreach ($res as $row) {
    echo $row['identifier'] . ' (expires: ' . $row['expires'] . ")\n";

    if ($useIgBinary) {
        $data = igbinary_unserialize($row['content']);
    } else {
        $data = unserialize($row['content']);
    }

    ksort($data['reflectedClassNames']);
    foreach ($data['reflectedClassNames'] as $class => $dummy) {
        echo '  ' . $class . "\n";
    }

    if (!isset($data['reflectedClassNames']['In2code\Powermail\Domain\Model\Page'])) {
        continue;
    }
    //var_dump($data['classSchemata']['In2code\Powermail\Domain\Model\Page']);
}
?>