MANABE Naoyasu naoyes

Multiple MySQL Versions for Development

Options included below:

Using Docker docker-compose
Using Homebrew brew

Using Docker (recommended)

This gist was originally created for Homebrew before the rise of Docker, yet it may be best to avoid installing mysql via brew any longer. Instead consider adding a barebones docker-compose.yml for each project and run docker-compose up to start each project's mysql service.

What's the difference between cascade="remove" and orphanRemoval=true in Doctrine 2

TLDR: The cascade={"remove"} is like a "software" onDelete="CASCADE", and will remove objects from the database only when an explicit call to $em->remove() occurs. Thus, it could result in more than one object being deleted. orphanRemoval can remove objects from the database even if there was no explicit call to ->remove().

I answered this question a few times to different people so I will try to sum things up in this Gist.

Let's take two entities A and B as an example. I will use a OneToOne relationship in this example but it works exactly the same with OneToMany relationships.

class A

	<?php
	use Symfony\Component\PropertyAccess\PropertyAccessor;
	use Symfony\Component\PropertyAccess\PropertyPath;

	/**
	* A property accessor that allows you to rewrite a property path for setters and getters.
	*/
	class CustomPropertyAccessor extends PropertyAccessor
	{
	/**

	// gruntfile dropin used to build a grunt files object with 1:1 structure
	function globToMultiFiles(glob, dest, options) {
	var path = require('path');

	grunt.util = grunt.util \|\| grunt.utils;

	dest = grunt.template.process(dest);

	options = grunt.util._.defaults(options \|\| {}, {
	cwd: '',