Amitesh

Query pg_stat_activity and get the pid values you want to kill and issue select pg_terminate_backend(pid int) to them.

PostgreSQL 9.1 and below:

SELECT pg_terminate_backend(pg_stat_activity.procpid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'mydb_prod_jan';


PostgreSQL 9.2 and above:

Amitesh

#apache-cron-watcher.sh

#!/bin/sh
run=`ps ax | grep /usr/sbin/apache2 | grep -v grep | cut -c1-5 | paste -s -`
if [ "$run" ];
then
echo “Apache is running”
else
echo "Apache not running"
/etc/init.d/apache2 restart

Amitesh

  desc "convert a latin1 database with utf8 data into proper utf8"
  task :convert_to_utf8 => :environment do
    puts Time.now
    dryrun = ENV['DOIT'] != '1'
    conn = ActiveRecord::Base.connection
    if dryrun
      def conn.run_sql(sql)
        puts(sql)
      end
    else

Amitesh

SELECT default_character_set_name FROM information_schema.SCHEMATA S
WHERE schema_name = "database_name";

show FULL columns from table_name;

For Schemas:

SELECT default_character_set_name FROM information_schema.SCHEMATA S
WHERE schema_name = "schemaname";
For Tables:

Amitesh

Device wise apps :
<pre>
<%= JSON.pretty_generate(JSON.parse(@info.to_json)) %>
</pre>

Amitesh

// Place all the behaviors and hooks related to the matching controller here.
// All this logic will automatically be available in application.js.

/**
 * Module for SampleWebApp Application
 * @author : Amitesh Kumar
 * 
 */
 ( function( $ ){
  

Amitesh

/**
 * Description
 * Author: Amitesh Kumar ([email protected])
 * Date: 20th May, 2012
 *
 */

/**
 * Module to display social info about a place
 */

Amitesh

$('#cities')
            .textext({
                plugins : 'autocomplete tags ajax prompt',
                prompt : 'Enter a city or town',
                ajax : {
                    url : DrumBeatGlobals.get_cities_url,
                    data : {country : 'US' },
                    dataType : 'json',
                    loading : { message : 'Loading...'}
                },

Amitesh

Accessing Helper modules in rails

http://www.funonrails.com/2010/12/accessing-helper-modules-in-rails.html

1. Helper methods all the time for views

class ApplicationController < ActionController::Base
 helper :all# include all helpers, all the time for views
end

Amitesh

<%= form_for OpenStruct.new(:message => ''), :url => ... do |f| %>
  <%= f.text_field :message %>
<% end %>


# config/initializers/open_struct_extensions.rb

class OpenStruct

  def respond_to?(symbol, include_private = false)