maskenfreiheit fucked around with this message at 21:32 on Apr 28, 2019

# unicorn_rails -c /usr/local/appname/shared/config/unicorn.rb -E production -D

rack_env = ENV['RACK_ENV'] || 'production'

# 4 workers and 1 master since we're running on a VM that only has two cores
worker_processes (rack_env == 'production' ? 4 : 2)
working_directory '/usr/local/appname/current'

# Load rails+app into the master before forking workers
# for super-fast worker spawn times
preload_app true

# Restart any workers that haven't responded in 15 since [appname] should be pretty drat fast and if a worker hasn't
# done anything in 15 seconds then something went terribly wrong.
timeout 15

# Listen on a Unix data socket
listen '/tmp/unicorn.sock', :backlog => 2048
pid '/tmp/pids/unicorn.pid'

before_fork do |server, worker|
  ##
  # When sent a USR2, Unicorn will suffix its pidfile with .oldbin and
  # immediately start loading up a new version of itself (loaded with a new
  # version of our app). When this new Unicorn is completely loaded
  # it will begin spawning workers. The first worker spawned will check to
  # see if an .oldbin pidfile exists. If so, this means we've just booted up
  # a new Unicorn and need to tell the old one that it can now die. To do so
  # we send it a QUIT.
  #
  # Using this method we get 0 downtime deploys.

  old_pid = '/tmp/pids/unicorn.pid.oldbin'
  if File.exists?(old_pid) && server.pid != old_pid
    begin
      Process.kill("QUIT", File.read(old_pid).to_i)
    rescue Errno::ENOENT, Errno::ESRCH
      # someone else did our job for us
    end
  end
end


after_fork do |server, worker|
  ##
  # Unicorn master loads the app then forks off workers - because of the way
  # Unix forking works, we need to make sure we aren't using any of the parent's
  # sockets, e.g. db connection
 
  ActiveRecord::Base::establish_connection(YAML.load_file('config/database.yml')[ENV['RACK_ENV']])

  ##
  # Unicorn master is started as root, which is fine, but let's
  # drop the workers

  begin
    uid, gid = Process.euid, Process.egid
    user, group = 'appname', 'webdeploy'
    target_uid = Etc.getpwnam(user).uid
    target_gid = Etc.getgrnam(group).gid
    worker.tmp.chown(target_uid, target_gid)
    if uid != target_uid || gid != target_gid
      Process.initgroups(user, target_gid)
      Process::GID.change_privilege(target_gid)
      Process::UID.change_privilege(target_uid)
    end
  rescue => e
    if RAILS_ENV == 'development'
      STDERR.puts "couldn't change user, oh well"
    else
      raise e
    end
  end
end

dexter fucked around with this message at 04:12 on Sep 29, 2011

class EventsController < ApplicationController
    @events = Event.date_filter(params[:from], params[:to])
                   .group_filter(params[:group])
                   .search(params[:keyword])
                   .order('starts_at')
                   .paginate(:page => params[:page], :per_page => 15 )
...
end

class Event < ActiveRecord::Base
  ...

  has_and_belongs_to_many :groups

  ...

  def self.group_filter(arg={})
    unless arg['group_id'].empty?
      g_id = arg['group_id']
      where 'group_ids = ?', g_id
    else
      scoped
    end
  end

end

schema.rb, join table:
  create_table "events_groups", :id => false, :force => true do |t|
    t.integer "event_id"
    t.integer "group_id"
  end

PGError: ERROR:  column "group_ids" does not exist

A MIRACLE fucked around with this message at 16:21 on Oct 14, 2011