Skip to content

Instantly share code, notes, and snippets.

rake heroku:deploy:migrate[remote,localbranch] # deploy to remote heroku deployment branch (git remote -v), migra...
rake heroku:sync:db:local[from_remote,host,database,username] # sync local DB with heroku
rake heroku:sync:db:remote[to_remote,from_remote] # sync [to_remote] heroku DB from [from_remote] heroku DB
rake heroku:sync:db:staging[from_remote] # sync staging heroku DB from production heroku DB
rake heroku:sync:deploy_migrate[remote,localbranch] # deploy to remote heroku deployment branch (git remote -v), migra...

Ruby

@crawl.v2_reports.select { |r| !r.reported_at.nil? }
  sort_by { |r| r.reported_at.to_i }.
  reverse.
  uniq { |r| r.v2_report_template_id }

Sql

Stack overflow answer

SELECT t.*

## Ruby
@crawl.v2_reports.select { |r| !r.reported_at.nil? }
sort_by { |r| r.reported_at.to_i }.
reverse.
uniq { |r| r.v2_report_template_id }
## Sql
[Stack overflow answer](http://stackoverflow.com/a/7250594)
SELECT t.*
v2_reports = @crawl.v2_reports
.select { |r| !r.reported_at.nil? }
.sort_by { |r| r.reported_at.to_i }
.reverse
.uniq { |r| r.v2_report_template_id}
v2_reports = @crawl.v2_reports_dataset
.order("reported_at DESC")
.exclude(reported_at: nil)
.group(:v2_report_template_id).to_a
{
"auto_upgrade_last_run": null,
"installed_packages":
[
"AdvancedNewFile",
"All Autocomplete",
"Better RSpec",
"Bracketeer",
"BufferScroll",
"CTags",
{
"always_show_minimap_viewport": false,
"auto_complete_commit_on_tab": false,
"bold_folder_labels": true,
"close_windows_when_empty": true,
"color_scheme": "Packages/Color Scheme - Default/Cobalt.tmTheme",
"copy_with_empty_selection": false,
"default_line_ending": "unix",
"detect_indentation": false,
"detect_slow_plugins": true,

Business Models

Advertising

Models Examples
Display ads Yahoo!
Search ads Google
@phocke
phocke / refactoring.rb
Created February 4, 2013 09:08
refactoring old code
#Before
def redirect_blocked_browsers
if params['controller'] == 'page' && params['action'] == 'browser'
return true
end
user_agent = UserAgent.parse(request.env['HTTP_USER_AGENT'])
# Cater to CriOS until we find a better solution
@phocke
phocke / gist:4681049
Created January 31, 2013 07:34
remove image carrierwave
user = User.find_by_email "phocke@gmail.com"
user.remove_image = true
user.save
@phocke
phocke / turbo-sprockets-rails3.md
Created January 27, 2013 16:03
testing turbo sprockets

with turbo-sprockets-rails3

time bundle exec rake assets:precompile --trace
=> 44.11s user 7.97s system 97% cpu 53.467 total

without turbo-sprockets-rails3

time bundle exec rake assets:precompile --trace
=> 120.72s user 9.18s system 97% cpu 2:13.42 total