Mike Branderhorst mikebranderhorst

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.

Script to "safely" clean up the core_session table without causing lock wait timeouts.

Not thoroughly vetted but met the client's needs.

Requires disabling Mage_Core_Model_Resource_Session:gc(), e.g.

--- a/app/code/core/Mage/Core/Model/Resource/Session.php
+++ b/app/code/core/Mage/Core/Model/Resource/Session.php
@@ -74,7 +74,7 @@ class Mage_Core_Model_Resource_Session implements Zend_Session_SaveHandler_Inter

NOTE: This assumes that you have Valet, Homebrew, Sublime Text and PHP properly installed and functioning and will only focus on the setup and installation and setup of Xdebug. There are other tutorials that go into great depth explaining how to get those tools installed on your mac.

Let's get started right away!

Installing Xdebug

You need to know which version of PHP you are running in your machine. To do so, from the terminal run the command php -v and this will display something like this

PHP 7.0.14 (cli) (built: Dec  8 2016 23:34:17) ( NTS )

	<?php
	if($product->getSpecialPrice() && $product->getSpecialPrice() > 0 && $product->getSpecialPrice() < $product->getPrice()) {
	$specialPriceInclTax = Mage::helper('tax')->getPrice($product, $product->getSpecialPrice(), true);
	$conditionalSpecialPrice = '<g:sale_price>' . $specialPriceInclTax . '</g:sale_price>' . PHP_EOL;
	$specialFromDate = $product->getSpecialFromDate();
	$specialToDate = $product->getSpecialToDate();
	if($specialFromDate && !$specialToDate) {
	$specialToDate = '2100-01-01';
	}
	if($specialToDate && !$specialFromDate) {

	<?php

	chdir(dirname(__FILE__));

	require_once '../app/Mage.php';
	Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
	umask(0);

	$resource = Mage::getModel('core/resource');
	$db = $resource->getConnection('core_write');

	#!/bin/bash
	#
	# Restart Bluetooth Module on Mac OS X
	#
	# Requires Blueutil to be installed: http://brewformulas.org/blueutil

	BT="/usr/local/bin/blueutil"

	log() {
	echo "$@"

	#!/bin/bash

	# Check if command was ran as root.
	if [[ $(id -u) -eq 0 ]]; then
	echo "The command \"sphp\" should not be executed as root or via sudo directly."
	echo "When a service requires root access, you will be prompted for a password as needed."
	exit 1
	fi

	# Usage

	{
	"id": "6b940a31-113d-109f-f36a-75c1604ef7d4",
	"name": "ExampleShop",
	"description": "",
	"order": [
	"2658e264-981e-4786-7f05-88f3fce0f4e6",
	"8c81cf7c-e188-b8bd-0970-a96aa3a8d6a3",
	"a1e3c72f-6fde-d46b-7896-e1627f7e5f64",
	"c050284d-14bd-bdd6-256e-30111f354ef6",
	"3b0ac9f0-3544-4797-fd4f-56b436ecd029",

	# By default, Docker containers run as the root user. This is bad because:
	# 1) You're more likely to modify up settings that you shouldn't be
	# 2) If an attacker gets access to your container - well, that's bad if they're root.
	# Here's how you can run change a Docker container to run as a non-root user

	## CREATE APP USER ##

	# Create the home directory for the new app user.
	RUN mkdir -p /home/app