class CitizenCodeScripts::KillDbSessions

Public Class Methods

description() click to toggle source
# File lib/citizen_code_scripts/kill_db_sessions.rb, line 2
def self.description
  "Kills active Postgres sessions"
end

Public Instance Methods

run() click to toggle source
# File lib/citizen_code_scripts/kill_db_sessions.rb, line 6
  def run
    print "Loading Rails... "
    require app_root.join("./config/environment")

    puts "done"

    print "Killing DB sessions... "
    ActiveRecord::Base.connection.execute(<<-SQL)
      SELECT pg_terminate_backend(pg_stat_activity.pid)
      FROM pg_stat_activity
      WHERE datname = current_database()
      AND pid <> pg_backend_pid()
    SQL

    puts "done"
  end