Alec Bedzir alecbedzir

###Composer Cheat Sheet for developers

Composer is the dependency manager for PHP and you are on a one-page-only documentation for this tool. Official documentation is on the official website, this page just brings you the essential.

One line installer

curl -sS https://getcomposer.org/installer | php

composer.phar command line

	---
	name: plan-exit-review
	version: 2.0.0
	description: \|
	Review a plan thoroughly before implementation. Challenges scope, reviews
	architecture/code quality/tests/performance, and walks through issues
	interactively with opinionated recommendations.
	allowed-tools:
	- Read
	- Grep

	-- ----------------------------------
	select "Deleting all but 50 customers" debug;
	drop procedure if exists minify_customers;

	delimiter #

	create procedure minify_customers()
	begin
	select @remaining_customers := count(*) from `customer_entity`;
	while @remaining_customers > 50 do

	#!/bin/bash
	# scp-speed-test.sh
	# Author: Alec Jacobson alecjacobsonATgmailDOTcom
	# http://www.alecjacobson.com/weblog/?p=635
	#
	# Test ssh connection speed by uploading and then downloading a 10000kB test
	# file (optionally user-specified size)
	#
	# Usage:
	# ./scp-speed-test.sh user@hostname [test file size in kBs]

	<?php

	// Transforms a HAR (HTTP Archive) file into a BK file to analyze it using
	// Blackfire Profiler (https://blackfire.io/)
	//
	// USAGE:
	// $ php har2blackfire.php name-of-the-HAR-file.har

	$harFile = $argv[1];
	$harData = json_decode(file_get_contents($harFile), true);

	<?php

	/**
	* Optimized version of attribute source options model
	*
	* That allows to preload options once and reuse them instead of doing calls to db all the time
	*
	*/
	class EcomDev_Optimization_Model_Resource_Attribute_Source_Table
	extends Mage_Eav_Model_Entity_Attribute_Source_Table

	delimiter ;;
	drop procedure if exists build_catalog;;
	create procedure build_catalog(IN categories INT, IN products INT)
	begin
	SET @category_count = 1;
	SET @CATNAMEPREFIX = "Category ";
	SET @CATURLKEYPREFIX = "cat-";
	SET @CATURLPATHPREFIX = "catpath-";
	SET @ROOTCATEGORY = 2;
	SET @INCLUDEINMENU = 1;