michaelminter

# @param [String] account_id
# @param [String] exclusions
def statement(account_id, exclusions = nil)
  <<-STATEMENT
SELECT 
	JSON_AGG(profiles.id) id, 
	JSON_AGG(users.external_id) external_id 
FROM profiles 
LEFT JOIN users ON users.id = profiles.user_id 
WHERE 

michaelminter

nc -vz google.com 80
# Connection to google.com 80 port [tcp/http] succeeded!

michaelminter

ssh -fN -L 5433:db.prod:5432 bastion-prod

aws s3 cp s3://<dir>/prod/ . --recursive --exclude "*" --include "201901*"

michaelminter

title	layout	prism_languages	updated	category	source
PostgreSQL JSON	2017/sheet	sql	2017-09-22	Databases	https://devhints.io/postgresql-json

Operators

michaelminter

scope :by_persons, ->(person1, person2) do
  arel = Communication.arel_table
  up_context1 = arel.grouping(arel[:sender_type].eq(person1.class.name).and(arel[:sender_id].eq(person1.id)))
  dn_context1 = arel.grouping(arel[:sender_type].eq(person2.class.name).and(arel[:sender_id].eq(person2.id)))
  up_context2 = arel.grouping(arel[:recipient_type].eq(person1.class.name).and(arel[:recipient_id].eq(person1.id)))
  dn_context2 = arel.grouping(arel[:recipient_type].eq(person2.class.name).and(arel[:recipient_id].eq(person2.id)))

  context1 = arel.grouping(up_context1.or(dn_context1))
  context2 = arel.grouping(up_context2.or(dn_context2))

michaelminter

// === Arrays

var [a, b] = [1, 2];
console.log(a, b);
//=> 1 2


// Use from functions, only select from pattern
var foo = () => [1, 2, 3];

michaelminter

class ApiLogger < Grape::Middleware::Base
  
  def before
    Rails.logger.info "[api] Requested: #{request_log_data.to_json}\n" +
     "[api] #{response_log_data[:description]} #{response_log_data[:source_file]}:#{response_log_data[:source_line]}"
  end
  
private

  def request_log_data

michaelminter

# Git status bash prompt
#
# In addition to printing the current working directory, this prompt will 
# show a number of things if you are in a git repository:
# - The current branch you are in
# - Whether there are untracked files in the repository (there will be an 
#   asterisk after the branch nome if there are)
# - Whether there are any unmerged/unstaged/staged changes or if the directory
#   is clean. See below for the colors that will be used, and change them if 
#   you'd like.

michaelminter

You can add some special notes to your source code comments in Rails to remind you later of stuff you need to do:

class Article < ActiveRecord::Base
  # TODO add named_scopes
  # FIXME method A is broken
  # OPTIMIZE improve the code 

  has_many :comments
  ....

end

michaelminter

module Contents
  class ExerciseWrapper < Contents::BaseWrapper
    attribute :name, String
    attribute :type

    validate :name, presence: true

    def to_fhir
      {
        one: :attribute_name,