nojimage

参考（Windowsとかはこっち）:

• How to disable column-statistics in MySQL 8 permanently? - Stack Overflow
• MYSQL WORKBENCH vs MARIADB problem in data export - Stack Overflow

前提

• MySQL Workbench 8.0.29
• macOS
• mysqldump (Homebrew で入れた MySQL 8.0に付属しているもの)
• エクスポートしようとすると、「COLUMN_STATISTICSテーブルがない」とかで怒られる

nojimage

Xdebug 3 アップグレードガイド

原文: https://xdebug.org/docs/upgrade_guide

Xdebug 2 から 3 へのアップグレード

An upgrade guide detailing which changes there are between Xdebug 2 and 3, and how to reconfigure your set-up to do similar things.

このアップグレードガイドは、Xdebug 2から3への変更点と、同様のことを行うようにセットアップを再構成する方法を詳しく説明します。

nojimage

#!/bin/sh

#
# Running on macOS Recovery Mode Terminal
#
# 1. Save this script to Your home dir.
#    eg) /Users/your-name/init-vmware-catalina.sh
#
# 2. Restart the machine and go to Recovery Mode.
#    (hold [⌘ + R] when the computer starts until you see an Apple logo)

nojimage

## install openssl 1.0.2t
cd /usr/local/Homebrew/Library/Taps/homebrew/homebrew-core/
git checkout 8b9d6d688f483a0f33fcfc93d433de501b9c3513 -- openssl.rb
brew install openssl

## build php: "/usr/local/Cellar/icu4c/64.2" is a specific icu4c version.
LDFLAGS=-L/usr/local/Cellar/icu4c/64.2 \
CONFIGURE_OPTS="--with-pear --with-openssl=/usr/local/Cellar/openssl/1.0.2t --with-icu-dir=/usr/local/Cellar/icu4c/64.2" \
phpenv install 5.6.40

nojimage

docker run --rm -v "$(pwd)":/app -w /app --entrypoint /rector/bin/rector rector/rector process src --dry-run

nojimage

#!/usr/bin/env php
<?php
/**
 * composer init && composer require cakephp/utility:^3.8
 *
 * Try < PHP 5.6: ./genuuid4.php 65536 | sort | uniq -d
 */
require 'vendor/autoload.php';

use Cake\Utility\Text;

nojimage

<?php
// in bootstrap_cli.php
if (PHP_SAPI === 'cli' && Configure::read('debug')) {
    // Bake書き換え
    EventManager::instance()->on('Bake.beforeRender', static function (Event $event) {
        $view = $event->getSubject();
        /* @var $view View */
        // for Bake Entity
        if ($view->get('propertySchema') && $view->get('table') && $view->get('name')) {
            // propertySchemaを書き換えてスキーマコメントを付与する

nojimage

function hash_get(key, haystack) {
    const keys = key.split('.');
    if (!Object.prototype.hasOwnProperty.call(haystack, keys[0])) {
        return null;
    }

    const matched = haystack[keys[0]];
    if (keys.length === 1) {
        return matched;
    }

nojimage

<?php
namespace App\TestSuite\Fixture;

use Cake\Datasource\ConnectionInterface;
use Cake\TestSuite\Fixture\TestFixture;

/**
 * ChunkInsertTestFixture
 */
abstract class ChunkInsertTestFixture extends TestFixture

nojimage

<?php
/**
 * Copyright 2018 Takashi Nojima.
 */

namespace App\Routing;

use Cake\Controller\Controller;
use Cake\Http\ControllerFactory;
use Cake\Http\Response;