Skip to content

Instantly share code, notes, and snippets.

View JoshuaEstes's full-sized avatar
👨‍💻

Joshua Estes JoshuaEstes

👨‍💻
86 followers · 5 following
View GitHub Profile
@JoshuaEstes
JoshuaEstes / mysqlformatter.sed
Created February 8, 2012 21:03
Takes a mysqldump output and converts some of the values and breaks up "(values),(values),(values);" into "(values),\n(values)\n(values);"
sed -ri 's/(\([^\)]+\),)/&\n/ig' dump.sql
@JoshuaEstes
JoshuaEstes / ircbot.php
Created February 1, 2012 16:47
shitty irc bot to fire jarvis
<?php
/**
*
*/
set_time_limit(0);
ini_set('display_errors', 'on');
class jBot {
@JoshuaEstes
JoshuaEstes / git_rm.sh
Created January 27, 2012 03:16
Bash one liner to remove all the files from git repo that are marked as deleted
for file in $(git ls-files --deleted); do git rm "$file"; done
@JoshuaEstes
JoshuaEstes / search_and_replace.pl
Created December 13, 2011 17:29
command line function to search and replace text
perl -p -i -e 's/oldstring/newstring/g' `find ./ -name "*.html"`
@JoshuaEstes
JoshuaEstes / vim
Created December 12, 2011 21:10
vim sudo write
:w !sudo tee % > /dev/null
@JoshuaEstes
JoshuaEstes / convert_to_csv
Created December 2, 2011 17:37
convert something to csv
perl -F"\t" -lane 'print join ",", map {s/"/""/g; /^[\d.]+$/ ? $_ : qq("$_")} @F '
@JoshuaEstes
JoshuaEstes / remove_svn.sh
Created October 22, 2011 00:41
remove all svn folders in a directory and sub directories
find . -name ".svn" -type d -exec rm -rf {} \;
@JoshuaEstes
JoshuaEstes / moduleActionsTest.php
Created October 21, 2011 16:16
Test template for a symfony 1.4 admin generated action
<?php
/**
* Symfony admin generator test template
* @see https://gist.github.com/1304240
*/
/**
* The model name
*/
$model = 'ModelName';
@JoshuaEstes
JoshuaEstes / .bashrc
Created September 16, 2011 16:04
Add this to the end of your ~/.bashrc to display what branch you are working in with git
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\]"
@JoshuaEstes
JoshuaEstes / delete_categories.sql
Created September 14, 2011 00:33
Delete all categories in Magento
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);