marcosgz

SELECT
  pid,
  now() - pg_stat_activity.query_start AS duration,
  query,
  state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '1 minutes' and state<>'idle'
order by pg_stat_activity.query_start desc;

marcosgz

# Remove orphaned items (documents without an equivalent database record) from elasticsearch/opensearch index

index = AccountsIndex # Target index
index.search(query: { match_all: {} }, _source: false).scroll_hits do |hits|
  print(".")
  es_ids = hits.map { |hit| hit.fetch("_id").to_i }
  db_ids = index.repo.dataset.except(:includes, :preload).where(id: es_ids).pluck(:id)
  prune_ids = es_ids - db_ids
  next if prune_ids.none?

marcosgz

docker-compose run --rm -v $(readlink -f $SSH_AUTH_SOCK):/ssh-agent -e SSH_AUTH_SOCK=/ssh-agent -e BRANCH=master app bundle exec cap staging deploy

marcosgz

git diff --name-only HEAD..staging | grep -E -i 'rake|*.rb|*.erb' | perl -ne 'chomp(); if (-e $_) {print "$_\n"}' | xargs rubocop -A

marcosgz

module AdapterOne
  def instance_method
    ':one instance method'
  end
  alias one instance_method
end

module AdapterTwo
  def instance_method
    ':two instance method'

marcosgz

# Generate keys
# $ openssl genrsa -des3 -out private.pem 2048
# $ openssl rsa -in private.pem -outform PEM -pubout -out public.pem

# $ irb
require 'openssl'
require 'base64'

# Encrypt
public_key = OpenSSL::PKey::RSA.new(File.read('public.pem'))

marcosgz

>> authenticate?(3, 'one')
=> false
>> authenticate?(1, 'one1')
=> false
>> authenticate?(1, 'one')
=> true

marcosgz

require 'openssl'

key = OpenSSL::PKey::RSA.new(2048)
p encrypted_string = key.public_encrypt('my plaintext string', OpenSSL::PKey::RSA::PKCS1_OAEP_PADDING)
p decrypted_string = key.private_decrypt(encrypted_string, OpenSSL::PKey::RSA::PKCS1_OAEP_PADDING)

marcosgz

#!/usr/bin/env ruby

# It's ODM (Object Document Mapper) to the RGB data
class RGB
  COLORS = {
    r: ->(val) { "\e[31m#{val}\e[0m" },
    g: ->(val) { "\e[32m#{val}\e[0m" },
    b: ->(val) { "\e[34m#{val}\e[0m" },
  }.freeze

marcosgz

#!/usr/bin/env ruby

# It's ODM (Object Document Mapper) to the RGB data
class RGB
  # @overload initialize(r, g, b, value)
  #   @param r [Integer] Value for R
  #   @param g [Integer] Value for G
  #   @param b [Integer] Value for B
  #   @param value [Object] describe value param
  # @overload initialize(r, g, b)