Vigneshwaran Sivalingam vigneshblue

## gist:2237293d9451b3bb15e26d4dc00b8ecd
"extract(dow from starting_time::TIMESTAMPTZ AT TIME ZONE INTERVAL '#{Time.zone.now.formatted_offset}'::INTERVAL) = ?"

## npm install permission denied issue
sudo npm install -g electron --unsafe-perm=true --allow-root

## pg dump and restore
pg_dump  -F c -h  localhost -U pg_user -d db_name  | gzip -c > sql_dump.gz

#-F format c -> custom


#Restore

pg_restore -U username  -d db_name -v dumpfile_location   -h localhost

## google_image_crawl.rb
require 'capybara'
require 'capybara/dsl'
require 'capybara/poltergeist'
option = { js_errors: false, timeout: 120 }
Capybara.register_driver :poltergeist do |app|
  Capybara::Poltergeist::Driver.new(app, option)
end
session = Capybara::Session.new(:poltergeist)
url = "https://www.google.com/imghp?"
session.visit url

## FTP credential trouble in ubuntu localhost for Wordpress
sudo chown -R www-data:www-data /var/www/html/wordpress
	pg_dump -F c -h localhost -U pg_user -d db_name \| gzip -c > sql_dump.gz

	#-F format c -> custom


	#Restore

	pg_restore -U username -d db_name -v dumpfile_location -h localhost
	require 'capybara'
	require 'capybara/dsl'
	require 'capybara/poltergeist'
	option = { js_errors: false, timeout: 120 }
	Capybara.register_driver :poltergeist do \|app\|
	Capybara::Poltergeist::Driver.new(app, option)
	end
	session = Capybara::Session.new(:poltergeist)
	url = "https://www.google.com/imghp?"
	session.visit url