Bryan Corey mrpunkin

mrpunkin / gist:3908242

Created October 17, 2012 21:16

	def fetch(col)
	t = self.class.arel_table
	ar = t.project(t[col]).where(t[:id].eq(id))
	self.class.uncached do
	self.class.connection.select_value(ar.to_sql)
	end
	end

mrpunkin / gist:3955045

Created October 25, 2012 19:58

	render(:template=>'base/header', :formats=>[:mustache], :handlers=>[:erb])

	## ActionView::Template::Error (Missing template base/header with {:locale=>[:en], :formats=>[:html], :handlers=>[:erb, :builder, :rabl, :rjs]}

mrpunkin / mobile.json.erb

Created October 25, 2012 23:11

	{
	"status": <%= response.status %>,
	<% if @error %>"error": <%= @error.to_json.html_safe %>,<% end %>
	"version": "<%= version(yield) %>",
	"template": "<%= controller.controller_name %>-<%= controller.action_name %>",
	"result": <%= yield %>
	}

mrpunkin / gist:4075780

Created November 15, 2012 00:12

	## Initial request / response, appcache is outdated so second request won't use cached page but will re-request it.

	Processing by Mobile::PhotosController#show as HTML
	Parameters: {"id"=>"1052"}

	...

	Rendered text template within layouts/mobile (0.0ms)
	Completed 200 OK in 49ms (Views: 33.0ms \| ActiveRecord: 3.1ms \| Sphinx: 0.0ms)

mrpunkin / comments.json.rabl

Created November 16, 2012 17:10

	object(nil)
	node(:total){ @comments.total_entries }
	node(:page){ @comments.page }
	node(:per_page){ @comments.per_page }
	child(@comments => :items) do
	extends 'comments/base'
	end

mrpunkin / gist:4342616

Created December 20, 2012 03:04

mrpunkin / gist:4502921

Created January 10, 2013 15:37

Recently moved signup / login to our homepage. Any reason not to do this?

	root :to => 'application#index', :as => :home
	root :to => 'application#index', :as => :new_user, :via=>:get, :defaults=>{:anchor=>"signup"}
	root :to => 'application#index', :as => :login_users, :via=>:get

mrpunkin / gist:4552853

Created January 17, 2013 01:58

	validate :group_is_real
	def group_is_real
	errors.add(:group, "must be an already existing group") if group_id and !group
	end

mrpunkin / challenge.rb

Created January 31, 2013 20:44

	class Challenge < ActiveRecord::Base
	has_many :challenge_photos, :dependent=>:destroy
	has_many :photos, :through=>:challenge_photo
	end

mrpunkin / gist:4694401

Last active December 12, 2015 01:49

	SELECT photos.id FROM photos
	LEFT OUTER JOIN votes ON votes.photo_id = photos.id
	LEFT OUTER JOIN flags ON flags.photo_id = photos.id AND flags.type="Love"
	LEFT OUTER JOIN comments ON comments.photo_id = photos.id
	WHERE photos.user_id = 38218
	GROUP BY photos.id;