Joshua Estes JoshuaEstes

## reset_admin.sql
UPDATE admin_user SET password=CONCAT(MD5('qXpassword'), ':qX') WHERE username='admin';

## ssh-copy-id.sh
cat ~/.ssh/id_rsa.pub | ssh username@host "cat - >> ~/.ssh/authorized_keys"

## delete_categories.sql
TRUNCATE TABLE `catalog_category_entity`;
TRUNCATE TABLE `catalog_category_entity_datetime`;
TRUNCATE TABLE `catalog_category_entity_decimal`;
TRUNCATE TABLE `catalog_category_entity_int`;
TRUNCATE TABLE `catalog_category_entity_text`;
TRUNCATE TABLE `catalog_category_entity_varchar`;
TRUNCATE TABLE `catalog_category_product`;
TRUNCATE TABLE `catalog_category_product_index`;
insert  into `catalog_category_entity`(`entity_id`,`entity_type_id`,`attribute_set_id`,`parent_id`,`created_at`,`updated_at`,`path`,`position`,`level`,`children_count`) values (1,3,0,0,'0000-00-00 00:00:00′,'2009-02-20 00:25:34′,'1′,1,0,1),(2,3,3,0,'2009-02-20 00:25:34′,'2009-02-20 00:25:34′,'1/2′,1,1,0);
insert  into `catalog_category_entity_int`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) values (1,3,32,0,2,1),(2,3,32,1,2,1);

## delete_products.sql
TRUNCATE TABLE `catalog_product_bundle_option`;
TRUNCATE TABLE `catalog_product_bundle_option_value`;
TRUNCATE TABLE `catalog_product_bundle_selection`;
TRUNCATE TABLE `catalog_product_entity_datetime`;
TRUNCATE TABLE `catalog_product_entity_decimal`;
TRUNCATE TABLE `catalog_product_entity_gallery`;
TRUNCATE TABLE `catalog_product_entity_int`;
TRUNCATE TABLE `catalog_product_entity_media_gallery`;
TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;
TRUNCATE TABLE `catalog_product_entity_text`;

## .bashrc
parse_git_branch () {
   git symbolic-ref HEAD 2> /dev/null | sed -e 's/\^0$//' | sed 's#refs\/heads\/\(.*\)#\1#'
}

BLACK="\[\033[0;38m\]"
RED="\[\033[0;31m\]"
RED_BOLD="\[\033[01;31m\]"
BLUE="\[\033[01;34m\]"
GREEN="\[\033[0;32m\]"

## moduleActionsTest.php
<?php
/**
 * Symfony admin generator test template
 * @see https://gist.github.com/1304240
 */

/**
 * The model name
 */
$model = 'ModelName';

## remove_svn.sh
find . -name ".svn" -type d -exec rm -rf {} \;

## convert_to_csv
perl -F"\t" -lane 'print join ",", map {s/"/""/g; /^[\d.]+$/ ? $_ : qq("$_")} @F '

## vim
:w !sudo tee % > /dev/null

## search_and_replace.pl
perl -p -i -e 's/oldstring/newstring/g' `find ./ -name "*.html"`
	TRUNCATE TABLE `catalog_category_entity`;
	TRUNCATE TABLE `catalog_category_entity_datetime`;
	TRUNCATE TABLE `catalog_category_entity_decimal`;
	TRUNCATE TABLE `catalog_category_entity_int`;
	TRUNCATE TABLE `catalog_category_entity_text`;
	TRUNCATE TABLE `catalog_category_entity_varchar`;
	TRUNCATE TABLE `catalog_category_product`;
	TRUNCATE TABLE `catalog_category_product_index`;
	insert into `catalog_category_entity`(`entity_id`,`entity_type_id`,`attribute_set_id`,`parent_id`,`created_at`,`updated_at`,`path`,`position`,`level`,`children_count`) values (1,3,0,0,'0000-00-00 00:00:00′,'2009-02-20 00:25:34′,'1′,1,0,1),(2,3,3,0,'2009-02-20 00:25:34′,'2009-02-20 00:25:34′,'1/2′,1,1,0);
	insert into `catalog_category_entity_int`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) values (1,3,32,0,2,1),(2,3,32,1,2,1);
	TRUNCATE TABLE `catalog_product_bundle_option`;
	TRUNCATE TABLE `catalog_product_bundle_option_value`;
	TRUNCATE TABLE `catalog_product_bundle_selection`;
	TRUNCATE TABLE `catalog_product_entity_datetime`;
	TRUNCATE TABLE `catalog_product_entity_decimal`;
	TRUNCATE TABLE `catalog_product_entity_gallery`;
	TRUNCATE TABLE `catalog_product_entity_int`;
	TRUNCATE TABLE `catalog_product_entity_media_gallery`;
	TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;
	TRUNCATE TABLE `catalog_product_entity_text`;
	parse_git_branch () {
	git symbolic-ref HEAD 2> /dev/null \| sed -e 's/\^0$//' \| sed 's#refs\/heads\/\(.*\)#\1#'
	}

	BLACK="\[\033[0;38m\]"
	RED="\[\033[0;31m\]"
	RED_BOLD="\[\033[01;31m\]"
	BLUE="\[\033[01;34m\]"
	GREEN="\[\033[0;32m\]"
	<?php
	/**
	* Symfony admin generator test template
	* @see https://gist.github.com/1304240
	*/

	/**
	* The model name
	*/
	$model = 'ModelName';