Dmitry Kovalevsky crossaidi

## tech-sheet.markdown

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                crossaidi
                / tech-sheet.markdown
            
            
              Last active
              December 23, 2015 17:29
                — forked from tamtamchik/tech-sheet.md
            
          
    IT Tech-sheet


Google
HTTP / HTTPS
MVC / MVVM
LAMP
AJAX
Comet / WebSockets / Pooling
git / Mercurial / SVN
BASH


## require_iterator.rb
Dir[File.dirname(__FILE__) + '/support/*'].each{|path| require path}

## rvm_commands
\curl -L https://get.rvm.io | bash -s stable

rvm list known — list of all ruby versions available for install
rvm install 1.9.1 – install ruby 1.9.1
rvm remove 1.9.2 – remove ruby 1.9.2
rvm use 1.9.2 — switch to ruby 1.9.2
rvm use 1.9.2@rails3 --default — install ruby 1.9.2 with gemset rails3 by default
rvm use system — use the system version of ruby
rvm list – list of installed versions of ruby
rvm gemset list – list of gemsets in selected ruby version

## no-rdoc
gem: --no-document

## remove_dublicates_postgres.sql
DELETE FROM table WHERE id IN
                     (SELECT UNNEST(STRING_TO_ARRAY(SUBSTRING(STRING_AGG(id::varchar, ','),
                      POSITION(',' in string_agg(id::varchar, ',')) + 1 ), ','))::integer
                      FROM table
                      GROUP BY field1, field2, field3, field4, field5, field6
                      HAVING COUNT(*) > 1)

## gist:7020655
rspec --fail-fast

## set_union.rb
tags = %w[foo bar]
tags |= %w[foo buz] # => ["foo", "bar", "buz"]

## 1st_of_month.sql
(NOW()::date - interval '1 day' * (EXTRACT(DAY FROM NOW()) - 1))::date

## gist:7630515
1.apt-get update / apt-get upgrade
2.dpkg-reconfigure tzdata
3.adduser admin

4.ssh-keygen
  copy rsa key from local machine to authorized_keys
  nano /etc/ssh/sshd_config:
  Port 2772
  PermitRootLogin no


## gist:7676106
Возникли проблемы со взаимодействием Guard и Zeus в RubyMine 6.
Конечный вариант решения: Tools -> Start Zeus Server / Start Guard и cmd: "zeus rspec" в методе rspec Guardfile'а.
Автоматический запуск Zeus'а Guard'ом не виден из RubyMine и rake-таски а также генераторы запускаются не из под Zeus'а.
	\curl -L https://get.rvm.io \| bash -s stable

	rvm list known — list of all ruby versions available for install
	rvm install 1.9.1 – install ruby 1.9.1
	rvm remove 1.9.2 – remove ruby 1.9.2
	rvm use 1.9.2 — switch to ruby 1.9.2
	rvm use 1.9.2@rails3 --default — install ruby 1.9.2 with gemset rails3 by default
	rvm use system — use the system version of ruby
	rvm list – list of installed versions of ruby
	rvm gemset list – list of gemsets in selected ruby version
	DELETE FROM table WHERE id IN
	(SELECT UNNEST(STRING_TO_ARRAY(SUBSTRING(STRING_AGG(id::varchar, ','),
	POSITION(',' in string_agg(id::varchar, ',')) + 1 ), ','))::integer
	FROM table
	GROUP BY field1, field2, field3, field4, field5, field6
	HAVING COUNT(*) > 1)
	tags = %w[foo bar]
	tags \|= %w[foo buz] # => ["foo", "bar", "buz"]
	1.apt-get update / apt-get upgrade
	2.dpkg-reconfigure tzdata
	3.adduser admin

	4.ssh-keygen
	copy rsa key from local machine to authorized_keys
	nano /etc/ssh/sshd_config:
	Port 2772
	PermitRootLogin no
	Возникли проблемы со взаимодействием Guard и Zeus в RubyMine 6.
	Конечный вариант решения: Tools -> Start Zeus Server / Start Guard и cmd: "zeus rspec" в методе rspec Guardfile'а.
	Автоматический запуск Zeus'а Guard'ом не виден из RubyMine и rake-таски а также генераторы запускаются не из под Zeus'а.