Vladimir Evdokimov vladimir-e

## helper.coffee
class App.Helper
  generate_password: (length = 8) ->
    charset = "abcdefghjknpqrstuvwxyzABCDEFGHJKLMNPQRSTUVWXYZ23456789_@=.%"
    password = ""
    i = 0
    n = charset.length
    while i < length
      password += charset.charAt(Math.floor(Math.random() * n))
      ++i
    password

## iconv_latin1_to_utf-8.rb
puts oldproduct.title
# => GestÃ¤nge Stahl lang fÃ¼r Tarps (240cm)
i = Iconv.new('LATIN1','UTF-8')
new_title = i.iconv(oldproduct.title).force_encoding("UTF-8")
puts new_title
# => Gestänge Stahl lang für Tarps (240cm)

## model.rb
# Rails 4
class ExampleModel < ActiveRecord::Base
  self.inheritance_column = '_type_disable'
end

# Rails 3
class ExampleModel < ActiveRecord::Base
  set_inheritance_column do
    'disabled'
  end

## duplicates.sql
SELECT first_name, last_name
FROM users
GROUP BY first_name, last_name
HAVING COUNT(*) > 1

## wp.sh
➜  wordpress  sudo chown -R _www ./
➜  wordpress  sudo chmod -R g+w ./

## Info.plist
<!-- 1. "Show Package Contents" -->
<!-- 2. Open Info.plist -->
<!-- 3. append to "dict" section: -->
<key>LSUIElement</key>
<string>1</string>
<!-- Worked for iTerm. -->

<!-- Or change Info.plist to have: -->
<key>LSUIElement</key>
<true/>

## nginx.conf
server{
  server_name www.domain.com;
  return 301 $scheme://domain.com$request_uri;
}
server{
  server_name domain.com;
  [...]
}

## ssh_key.sh
`mkdir .ssh`

cat ~/.ssh/id_rsa.pub | ssh user@domain.com 'cat >> ~/.ssh/authorized_keys'

# optional
sudo chmod 700 .ssh
sudo chmod 640 .ssh/authorized_keys

## mysql.sh
# dump all databases
mysqldump --user=root --password=pass --all-databases > localhost.sql

# dump specific databases
mysqldump --user=root --password=pass --databases DB_NAME1 DB_NAME2 DB_NAME3 > backup.sql

# restore from file
mysql --verbose --user=root --password=pass DB_NAME < /PATH/TO/DUMPFILE.SQL

# copy database

## find_process.sh
ps aux | grep puma
	class App.Helper
	generate_password: (length = 8) ->
	charset = "abcdefghjknpqrstuvwxyzABCDEFGHJKLMNPQRSTUVWXYZ23456789_@=.%"
	password = ""
	i = 0
	n = charset.length
	while i < length
	password += charset.charAt(Math.floor(Math.random() * n))
	++i
	password
	puts oldproduct.title
	# => GestÃ¤nge Stahl lang fÃ¼r Tarps (240cm)
	i = Iconv.new('LATIN1','UTF-8')
	new_title = i.iconv(oldproduct.title).force_encoding("UTF-8")
	puts new_title
	# => Gestänge Stahl lang für Tarps (240cm)
	# Rails 4
	class ExampleModel < ActiveRecord::Base
	self.inheritance_column = '_type_disable'
	end

	# Rails 3
	class ExampleModel < ActiveRecord::Base
	set_inheritance_column do
	'disabled'
	end
	SELECT first_name, last_name
	FROM users
	GROUP BY first_name, last_name
	HAVING COUNT(*) > 1
	➜ wordpress sudo chown -R _www ./
	➜ wordpress sudo chmod -R g+w ./
	<!-- 1. "Show Package Contents" -->
	<!-- 2. Open Info.plist -->
	<!-- 3. append to "dict" section: -->
	<key>LSUIElement</key>
	<string>1</string>
	<!-- Worked for iTerm. -->

	<!-- Or change Info.plist to have: -->
	<key>LSUIElement</key>
	<true/>
	server{
	server_name www.domain.com;
	return 301 $scheme://domain.com$request_uri;
	}
	server{
	server_name domain.com;
	[...]
	}
	`mkdir .ssh`

	cat ~/.ssh/id_rsa.pub \| ssh user@domain.com 'cat >> ~/.ssh/authorized_keys'

	# optional
	sudo chmod 700 .ssh
	sudo chmod 640 .ssh/authorized_keys
	# dump all databases
	mysqldump --user=root --password=pass --all-databases > localhost.sql

	# dump specific databases
	mysqldump --user=root --password=pass --databases DB_NAME1 DB_NAME2 DB_NAME3 > backup.sql

	# restore from file
	mysql --verbose --user=root --password=pass DB_NAME < /PATH/TO/DUMPFILE.SQL

	# copy database