Richard B. Porter richardbporter

richardbporter / dbsize.sh

Created May 9, 2022 12:37

Drupal database size

	## Check the size of database used by Drupal (MySQL is expected).
	drupal_db_name="$(drush sql-conf \| grep "database" \| grep -Eo "\S+$")"

	if [[ -z "$drupal_db_name" ]]; then
	echo "usage: run this command under a drupal instance directory."
	return
	fi

	$(drush sql-connect) -e "SELECT table_schema AS \"Database\", SUM(ROUND(((data_length + index_length) / 1024 / 1024), 2)) AS \"Size in MB\" FROM information_schema.TABLES WHERE table_schema = \"$drupal_db_name\""

richardbporter / .gitconfig

Last active May 18, 2022 20:44

git config

richardbporter / .bash_profile

Created May 2, 2022 17:36

.bash_profile

	# Bash completions.
	[[ -r "/usr/local/etc/profile.d/bash_completion.sh" ]] && . "/usr/local/etc/profile.d/bash_completion.sh"

	# Set the default system editor.
	export EDITOR='code'

	# Set CLI color.
	export CLICOLOR=1

	# Git prompt.

richardbporter / flush memcache

Created November 23, 2015 16:31

echo 'flush_all' | nc localhost 11211

richardbporter / gist:18cab240ef36468dbfeb

Created June 3, 2015 16:07

Git pull recursive

find . -type d -name .git -exec sh -c "cd \"{}\"/../ && pwd && git pull" \;

richardbporter / gist:485753078e91dcf871f6

Created October 15, 2014 16:12

git post-receive checkout

	cd /path/to/work/tree
	git --git-dir=/path/to/git/repo --work-tree=/path/to/work/tree checkout -f

richardbporter / drupal_tz_offset.php

Created August 1, 2012 15:53

Drupal format_date timezone offset

	<?php

	$my_date = strtotime($node->field_date[0]['value']);
	$tz_offset = strtotime(date("M d Y H:i:s")) - strtotime(gmdate("M d Y H:i:s"));
	$my_date += $tz_offset;
	print format_date($my_date, 'custom', 'D d F Y', NULL);

	?>