cgdangelo

for i in `git ls-files --other --exclude-standard`; do rm -ir $i; done

cgdangelo

<?php
require 'app/Mage.php';
umask(0);
Mage::app();

$attribute = Mage::getModel('catalog/entity_attribute')->loadByCode(
    Mage::getModel('eav/entity')->setType('catalog_product')->getTypeId(),
    'tiger_cost'
);

cgdangelo

#!/bin/sh

# Run from /docroot/app/design/[adminhtml|frontend|install]/[package]/[theme]
vimdiff ../../base/default/${1} ${1}

cgdangelo

#!/bin/sh

GC_OPTS=$@

for item in `git clean $@ | grep -v git-iclean | grep "Would remove" | cut -d' ' -f 3`; do
    rm -ir $item
done

cgdangelo

# one-liner for generating this: mysqldump --no-data -uroot magento1600 | nawk '{if(match($0, /CREATE TABLE `(.*)`/, matchesT)) { the_table = matchesT[1]; } if(match($0, /(CONSTRAINT .*),?/, matchesK) && the_table) { the_key = gensub(/,?$/, "", matchesK[1]); the_key = gensub(/^ */, "", the_key); print "ALTER TABLE `" the_table "` ADD", the_key ";"; }}'

ALTER TABLE `admin_rule` ADD CONSTRAINT `FK_ADMIN_RULE_ROLE_ID_ADMIN_ROLE_ROLE_ID` FOREIGN KEY (`role_id`) REFERENCES `admin_role` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `api_rule` ADD CONSTRAINT `FK_API_RULE_ROLE_ID_API_ROLE_ROLE_ID` FOREIGN KEY (`role_id`) REFERENCES `api_role` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `api_session` ADD CONSTRAINT `FK_API_SESSION_USER_ID_API_USER_USER_ID` FOREIGN KEY (`user_id`) REFERENCES `api_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `catalog_category_entity_datetime` ADD CONSTRAINT `FK_CAT_CTGR_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id

cgdangelo

#!/bin/bash

if [ -e "$1" ]; then
    dataset=$(cat $1)
elif [ ! -z $1 ]; then
    dataset=$@
else
    exit 1
fi