| -- show running queries (9.2) | |
| SELECT pid, age(query_start, clock_timestamp()), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- kill running query | |
| SELECT pg_cancel_backend(procpid); | |
| -- kill idle query |
| (defprotocol IStack | |
| (printStack [this]) | |
| (push [this value]) | |
| (pop [this])) | |
| (defrecord Stack [storage] IStack | |
| (printStack [this] | |
| (println storage)) | |
| (push [this value] | |
| (swap! storage conj value)) |
| (ns fibonacci.core) | |
| (defn fibonacci | |
| [x] | |
| (cond | |
| (= x 0) 0 | |
| (= x 1) 1 | |
| :else (+ (fibonacci (dec x)) (fibonacci (- x 2))))) | |
| (defn fib |
| MULTI_VALUE_METHODS = [:includes, :eager_load, :preload, :select, :group, | |
| :order, :joins, :where, :having, :bind, :references, | |
| :extending] | |
| require 'benchmark' | |
| class Test | |
| Benchmark.bm(1) do |x| | |
| x.report("class_eval:"){ | |
| MULTI_VALUE_METHODS.each do |name| | |
| Kernel.class_eval <<-CODE, __FILE__, __LINE__ + 1 | |
| def #{name}_values # def select_values |
| # encoding: UTF-8 | |
| # gem install capybara | |
| # gem install rspec | |
| # rspec capybara_test.rb | |
| require 'rubygems' | |
| require 'capybara' | |
| require 'capybara/rspec' | |
| Capybara.configure do |c| |
| #!/bin/bash | |
| USAGE="Usage: -p Project path" | |
| while getopts p: options; do | |
| case $options in | |
| p ) PROJECT="$OPTARG";; | |
| esac | |
| done |
