ブログをGhostへ移行した

簡単に言えばWPとGhostのDBに接続、記事タイトルが一致するもののslugをnginx conf用に整形して出力という感じ。

<?php

declare(strict_types=1);

/* Nginx configuration
location / {
    proxy_pass http://ghost/;

    if ( $arg_p = "10" ) { return 301 /hoge-id/; }
    location = /archives/10 { return 301 /hoge-id/; }
}
*/

$WP_DB_HOST = '10.0.0.24';
$WP_DB_NAME = 'WordPress';
$WP_DB_USER = 'wordpress';
$WP_DB_PASS = 'example';

$GHOST_DB_HOST = '127.0.0.1';
$GHOST_DB_NAME = 'ghost';
$GHOST_DB_USER = 'root';
$GHOST_DB_PASS = 'example';

$wpPdo = new PDO("mysql:host=$WP_DB_HOST;dbname=$WP_DB_NAME", $WP_DB_USER, $WP_DB_PASS);
$wpPdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$stmt = $wpPdo->prepare('SELECT * FROM wp_posts WHERE post_type = "post" AND post_status = "publish" ORDER BY post_date_gmt ASC');
$stmt->execute();
$wpPosts = $stmt->fetchAll(PDO::FETCH_ASSOC);

$ghostPdo = new PDO("mysql:host=$GHOST_DB_HOST;dbname=$GHOST_DB_NAME", $GHOST_DB_USER, $GHOST_DB_PASS);
$wpPdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$pArgRedirects = [];
$archiveRedirects = [];

foreach ($wpPosts as $post) {
    $postId = $post['ID'];
    $postTitle = $post['post_title'];

    $stmt = $ghostPdo->prepare('SELECT * FROM posts WHERE title = :title');
    $stmt->execute(['title' => $postTitle]);
    $ghostPost = $stmt->fetch(PDO::FETCH_ASSOC);
    if (!$ghostPost) {
        echo "No ghost post found for $postTitle\n";
        continue;
    }
    $ghostSlug = $ghostPost['slug'];

    $pArgRedirects[] = [
        'oldPostId' => $postId,
        'newUrl' => "/$ghostSlug/",
    ];

    $archiveRedirects[] = [
        'oldPath' => "/archives/$postId",
        'newUrl' => "/$ghostSlug/",
    ];
}

$pArgString = '';
foreach ($pArgRedirects as $redirect) {
    $pArgString .= "if ( \$arg_p = \"{$redirect['oldPostId']}\" ) { return 301 {$redirect['newUrl']}; }\n";
}
file_put_contents(__DIR__ . '/p-arg-redirects.conf', $pArgString);


$slashString = '';
foreach ($archiveRedirects as $redirect) {
    $slashString .= "location = {$redirect['oldPath']} { return 301 {$redirect['newUrl']}; }\n";
}
file_put_contents(__DIR__ . '/archive-redirects.conf', $slashString);