Jonathan Bailey jonathanpbailey2

## osx_docker_port_forwarding
VBoxManage controlvm boot2docker-vm natpf1 "name,tcp,127.0.0.1,8080,,8080"

## mysql_qry_to_csv
mysql -u [user name] -p [db name] -B -e "[select query]"| sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > output.csv

## vim_num_list
:2,$ s/^/\=printf('%d,', (line('.') - 1))

## disable_root_ssh
First change the following line in /etc/sshd/sshd_config

from:
   PermitRootLogin yes
to:
   PermitRootLogin no

Then restart the service:

either

## jpa2_find_max_of_many_attribute
CriteriaQuery<Integer> yourQuery = criteriaBuilder.createQuery(Integer.class);
Root<YourRootClass> rootClass = yourQuery.from(YourRootClass.class);
Join<YourRootClass, YourManyAttributeClass> theAttribute = rootClass.join("theAttributes");

Expression<Integer> attributeFieldToCheck = theAttribute.get("attributeFieldToCheck");
yourQuery.select(criteriaBuilder.max(attributeFieldToCheck));

Integer maxValue = 0;
try {
  maxValue = getEntityManager().createQuery(yourQuery).getSingleResult();

## get currency symbol in magento
$currencySymbol = Mage::app()->getLocale()->currency(Mage::app()->getStore()->
                                                     getCurrentCurrencyCode())->getSymbol();

## bash for loop int range
for i in {1..5000}; do echo 'Doing something 5000 times'; done

## perl search and replace
perl -pi -e "s:toSearch:toReplaceWith:g" path/to/file(s)
	First change the following line in /etc/sshd/sshd_config

	from:
	PermitRootLogin yes
	to:
	PermitRootLogin no

	Then restart the service:

	either
	CriteriaQuery<Integer> yourQuery = criteriaBuilder.createQuery(Integer.class);
	Root<YourRootClass> rootClass = yourQuery.from(YourRootClass.class);
	Join<YourRootClass, YourManyAttributeClass> theAttribute = rootClass.join("theAttributes");

	Expression<Integer> attributeFieldToCheck = theAttribute.get("attributeFieldToCheck");
	yourQuery.select(criteriaBuilder.max(attributeFieldToCheck));

	Integer maxValue = 0;
	try {
	maxValue = getEntityManager().createQuery(yourQuery).getSingleResult();
	$currencySymbol = Mage::app()->getLocale()->currency(Mage::app()->getStore()->
	getCurrentCurrencyCode())->getSymbol();