Matt Winckler mwinckler

PostgreSQL things that might be useful

\x changes query output to "expanded" mode so table columns in results are listed vertically instead of horizontally. Run \x again to disable.

Start with a list that looks like this:

public string MyProperty
public int MySecondProperty
public bool HoweverManyPropertiesYouWant

...then run a Find/Replace using regular expressions as follows:

Find:

	<?php
	// functions.php

	add_shortcode( 'contentbox', 'mw_shortcode_contentbox' );

	function mw_shortcode_contentbox( $attrs, $content = '' ) {
	$parsed_attrs = shortcode_atts( array(
	'align' => ''
	), $attrs );

	<?php

	// Populate this array with your shortcode tag names (not including brackets).
	$shortcodes = array( 'contextbox' );

	// Leave this array alone; it's what we'll use to stash shortcode content in until wpautop has safely passed.
	$shortcode_replacements = array();

	// See wp-includes/default-filters.php for core WordPress filter priorities
	// 9 comes right before wpautop at 10

	[alias]
	alias = config --get-regexp ^alias
	editconfig = !sub ~/.gitconfig
	lol = log --graph --decorate --pretty=oneline --abbrev-commit --all
	mylog = log --graph --decorate --all --oneline
	tlog = !TortoiseGitProc.exe /command:log &
	ci = commit
	s = status -s
	lg = log --graph --decorate --all --oneline
	dt = difftool -y --dir-diff

	location / {
	proxy_pass http://<ip-address-of-new-server>;
	proxy_set_header Host $http_host;
	proxy_redirect off;
	proxy_buffering off;
	}

	-- From http://stackoverflow.com/a/4849704/81554

	SELECT c.name AS ColName, t.name AS TableName
	FROM sys.columns c
	JOIN sys.tables t ON c.object_id = t.object_id
	WHERE c.name LIKE '%MyName%'

	SELECT COLUMN_NAME, TABLE_NAME
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE COLUMN_NAME LIKE '%MyName%'

	remove_filter( 'the_content', 'wpautop' );
	remove_filter( 'the_excerpt', 'wpautop' );

	# Prompts for filename then base64-encodes the given file's contents and
	# writes a new .base64 file in the same directory with the encoded contents.
	# Handy for encoding stuff via irb.
	require 'base64'
	Proc.new {\|filename\| IO.write(filename.chomp(File.extname(filename)) + '.base64', Base64.strict_encode64(IO.binread(filename))) }.call([(print 'Filename: '), gets.rstrip][1])