Exportable messages

[drm]

$pdo = new PDO('mysql:host=mysql;dbname=conc053', 'dev');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->query('SET NAMES utf8;');
$q = sprintf('SELECT message, domain, locale, translation FROM message INNER JOIN message_translation ON message.id=message_id WHERE message IN(%s)', join(',', array_map([$pdo, 'quote'], $names)));

$group = [];
foreach ($pdo->query($q)->fetchAll(\PDO::FETCH_ASSOC) as $row) {
    if (!isset($group[$row['domain']])) {
        $group[$row['domain']] = [];
    }
    if (!isset($group[$row['domain']][$row['locale']])) {
        $group[$row['domain']][$row['locale']] = [];
    }
    $group[$row['domain']][$row['locale']][$row['message']] = $row['translation'];
}

chdir("exported-messages");
foreach ($group as $domain => $locales) {
    foreach ($locales as $locale => $messages) {
        $filename = sprintf('%s.%s.yml', $domain, $locale);
        file_put_contents($filename, Yaml::dump($messages));
        printf("%s written\n", $filename);
    }
}