mwinckler

PostgreSQL things that might be useful

https://tomcam.github.io/postgres/

Expanded mode

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

How to quit/exit/terminate/leave

mwinckler

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

mwinckler

<?php
// functions.php

add_shortcode( 'contentbox', 'mw_shortcode_contentbox' );

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

mwinckler

<?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

mwinckler

[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

mwinckler

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

mwinckler

javascript:(function() { var input = document.createElement('input'); input.setAttribute('type', 'hidden'); input.setAttribute('name', 'title'); input.setAttribute('value', prompt('New title:')); document.getElementById('lockable-summary').parentNode.appendChild(input); })();

mwinckler

-- 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%'

mwinckler

# 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])

mwinckler

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: