leemour

SELECT
    t.tablename,
    foo.indexname,
    c.reltuples AS num_rows,
    pg_size_pretty(pg_relation_size(quote_ident(t.tablename)::text)) AS table_size,
    pg_size_pretty(pg_relation_size(quote_ident(indexrelname)::text)) AS index_size,
	pg_relation_size(quote_ident(indexrelname)) as index_size_bytes,
    CASE 	WHEN indisunique THEN 'Y'
       		ELSE 'N'
    END AS UNIQUE,

leemour

Code is clean if it can be understood easily – by everyone on the team. Clean code can be read and enhanced by a developer other than its original author. With understandability comes readability, changeability, extensibility and maintainability.

---

General rules

1. Follow standard conventions.
2. Keep it simple stupid. Simpler is always better. Reduce complexity as much as possible.
3. Boy scout rule. Leave the campground cleaner than you found it.
4. Always find root cause. Always look for the root cause of a problem.

Design rules

leemour

sudo apt-get --purge remove wine 

sudo apt-get purge wine* ; sudo dpkg --purge wine*
sudo apt-get purge wine64 ; sudo dpkg --purge wine64
sudo apt-get autoclean
sudo apt-get clean
sudo apt-get autoremove

cd $HOME
rm -r .wine

leemour

module Where
  class <<self
    attr_accessor :editor
    
    def is_proc(proc)
      source_location(proc)
    end
    
    def is_method(klass, method_name)
      source_location(klass.method(method_name))

leemour

CarrierWave.configure do |config|
  if Rails.env.test? || Rails.env.cucumber?
    config.storage = :file
    config.enable_processing = false
  else
    config.asset_host   = Rails.application.secrets.asset_host
    config.fog_provider = 'fog/openstack'
    config.fog_credentials = {
      provider:           'OpenStack',
      openstack_auth_url: 'https://api.selcdn.ru/v3',

leemour

# Remote
git br -r | grep -v 'master\|dev\|new_front' | awk -Forigin/ '{print $2 $3}' | xargs -I {} git push origin :{}
# Local
git branch | grep -v 'master\|dev\|new_front' | xargs -I {} git branch -D {}

leemour

# Show method location
method(:meth).source_location

# Nice gem 'method_source' makes life easier. Use it inside console:
require 'method_source'
# Show method source
method(:meth).source.display
# Show class or method definition
show-source Job
show-source Job.work

leemour

module Fibonacci

  class << self
    def sum_of_even_upto(max)
      upto(max).inject(0) do |sum, item| 
        item.even? ? sum + item : sum  
      end
    end

    def upto(max)

leemour

[1] (pry) main: 0> add = -> (a, b) { a + b }
=> #<Proc:0x007ffde11d72c0@(pry):1 (lambda)>

# Call proc with two arguments
[2] (pry) main: 0> add.(1, 2)
=> 3

# Call proc with one argument
[3] (pry) main: 0> add.(1)
ArgumentError: wrong number of arguments (1 for 2)

leemour

namespace :db do
  desc "Backup DB as separate schema"
  task :backup_to_schema, [:created_at] => :environment do |t, args|
    schema = 'copy'
    created_at = args.created_at || 2.years.ago
    ApplicationRecord.connection.execute(
      "DROP SCHEMA #{schema} CASCADE; 
      CREATE SCHEMA copy"
    )
    ActiveRecord::Base.connection.execute "SET search_path TO public, #{schema}"