toyama0919 · November 21, 2013 16:19
diff --git a/database.yml b/database.yml
 redshift:
  adapter: redshift
  database: applog
  host: *****.**********.ap-northeast-1.redshift.amazonaws.com
  port: 5439
  username: app
  password: 
  encoding: utf8
  pool: 5
  timeout: 30000 # タイムアウトは長めに
diff --git a/file0.txt b/file0.txt
 sudo yum install postgresql postgresql-devel
diff --git a/file2.txt b/file2.txt
 bundle install
diff --git a/file4.txt b/file4.txt
 ActiveRecord::Base.establish_connection(:redshift)
 result = ActiveRecord::Base.connection.execute "select * from table_name where log_date='#{d.strftime("%Y-%m-%d")}'"
 result.each{|record|
    p record # hash
 }
diff --git a/Gemfile b/Gemfile
 gem "activerecord-redshift-adapter"
	redshift:
	adapter: redshift
	database: applog
	host: ***.********.ap-northeast-1.redshift.amazonaws.com
	port: 5439
	username: app
	password:
	encoding: utf8
	pool: 5
	timeout: 30000 # タイムアウトは長めに
	ActiveRecord::Base.establish_connection(:redshift)
	result = ActiveRecord::Base.connection.execute "select * from table_name where log_date='#{d.strftime("%Y-%m-%d")}'"
	result.each{\|record\|
	p record # hash
	}