jhnns

#!/bin/bash

if [ -z "$1" ]; then
    echo "Usage: git pr [clean] [<remote>] <id-or-url>"
    echo ""
    echo "Examples:"
    echo "git pr 42                                              -->  git fetch origin pull/42/head:pr/origin/42"
    echo "git pr upstream 42                                     -->  git fetch upstream pull/42/head:pr/upstream/42"
    echo "git pr https://github.com/peerigon/phridge/pull/1      -->  git fetch https://github.com/peerigon/phridge.git pull/1/head:pr/peerigon/phridge/1"
    echo "git pr clean                                           -->  Deletes all branches that match pr/*/* and pr/*/*/*"

jasoncodes

class CreateItemChildrenCountView < ActiveRecord::Migration
  def self.up
    execute <<-SQL
      CREATE VIEW item_children_count AS
      SELECT parent_id AS item_id, COUNT(*) as children_count
      FROM items GROUP BY parent_id;
    SQL
  end

  def self.down