shrkw

CREATE TABLE addresses (
	id INTEGER NOT NULL, 
	email VARCHAR NOT NULL, 
	owner_id INTEGER, 
	PRIMARY KEY (id)
);
CREATE TABLE users (
	id INTEGER NOT NULL, 
	name VARCHAR NOT NULL, 
	PRIMARY KEY (id)

wowo

<?php

namespace Acme\Example\Tests;

use Symfony\Component\Console\Input\ArrayInput;
use Symfony\Bundle\FrameworkBundle\Console\Application;
use Doctrine\DBAL\Driver\PDOSqlite\Driver as PDOSqliteDriver;

require_once(__DIR__ . IsolatedTestsTrait::$kernelRootDir . '/AppKernel.php');

hofmannsven

Git

Global Settings

• Related Setup: https://gist.github.com/hofmannsven/6814278
• Related Pro Tips: https://ochronus.com/git-tips-from-the-trenches/
• Interactive Beginners Tutorial: http://try.github.io/
• Git Cheatsheet by GitHub: https://services.github.com/on-demand/downloads/github-git-cheat-sheet/

Reminder

Press minus + shift + s and return to chop/fold long lines!

scy

Opening and closing an SSH tunnel in a shell script the smart way

I recently had the following problem:

• From an unattended shell script (called by Jenkins), run a command-line tool that accesses the MySQL database on another host.
• That tool doesn't know that the database is on another host, plus the MySQL port on that host is firewalled and not accessible from other machines.

We didn't want to open the MySQL port to the network, but it's possible to SSH from the Jenkins machine to the MySQL machine. So, basically you would do something like

ssh -L 3306:localhost:3306 remotehost

henriquemoody

<?php

/**
 * Content from http://en.wikipedia.org/wiki/List_of_HTTP_status_codes
 *
 * You may also want a list of unofficial codes:
 *
 *  103 => 'Checkpoint',
 *  218 => 'This is fine', // Apache Web Server
 *  419 => 'Page Expired', // Laravel Framework

grenade

#!/bin/bash

mkdir -p ~/.ssh

# generate new personal ed25519 ssh keys
ssh-keygen -o -a 100 -t ed25519 -f ~/.ssh/id_ed25519 -C "rob thijssen <[email protected]>"
ssh-keygen -o -a 100 -t ed25519 -f ~/.ssh/id_robtn -C "rob thijssen <[email protected]>"

# generate new host cert authority (host_ca) ed25519 ssh key
# used for signing host keys and creating host certs

damphat

#! /bin/bash
# Description: show dependency tree
# Author: damphat

if [ $# != 1 ]; then
	echo 'Usage: apt-rdepends-tree <package>'
	echo 'Required packages: apt-rdepends'
	exit 1  
fi

flomotlik

We have changed our check_url implementation from curl to wget for three reasons

1. It gives us the ability to retry on connection refused. Compare the command we used previously with curl:

curl -sSfL --retry 3 URL

to the current one:

willurd

Each of these commands will run an ad hoc http static server in your current (or specified) directory, available at http://localhost:8000. Use this power wisely.

Discussion on reddit.

Python 2.x

$ python -m SimpleHTTPServer 8000

ianpetzer

{{#linkTo 'contact' contact tagName="tr"}}
   <td>{{name}}</td>
   <td><button {{action destroy contact bubbles=false}}>Destroy!</button></td>
   <td>{{#linkTo 'somewhere else' foo}}something{{/linkTo}}</td>
{{/linkTo}}