VoltanBro

SELECT * FROM user_accounts WHERE id IN (
          SELECT
              id
          FROM (
              SELECT
                  id,
                  ROW_NUMBER() OVER w AS rnum
              FROM user_accounts
              WINDOW w AS (
                  PARTITION BY user_profile_id

VoltanBro

module DownloadHelper
  TIMEOUT = 3
  PATH = Rails.root.join("tmp/downloads")

  module_function

  def downloads
    Dir[PATH.join("*")]
  end

VoltanBro

    trait :my_custom do
      transient do
      params {{}}
    end

      after(:build) do |field, evaluator|
        field.name = evaluator.params[:name]
      end
    end
    

VoltanBro

  [Line   1]  ✐ NOTE: This is here because sometimes an intermittent issue appears.
  [Line   7]  ↻ OPTIMIZE: This could be reworked to not do a O(N2) lookup.
  [Line   9]  ✓ TODO from John: Add a check here to ensure these are always strings.
  [Line  24]  ✄ HACK: I am doing something here that is horrible, but it works for now...
  [Line  89]  ✗ XXX: Let's do this better next time? It's bad.
  [Line 136]  ☠ FIXME: We sometimes get an undefined index in this array.
  [Line 211]  ☢ BUG: If the user inputs "Easter" we always output "Egg", even if they wanted a "Bunny".

VoltanBro

# frozen_string_literal: true

class CustomerCreator < BaseInteractor
  def call
    validate_bot_owner
    create_stripe_customer
  end

  private

VoltanBro

http://stackoverflow.com/questions/22667401/postgres-json-data-type-rails-query
http://stackoverflow.com/questions/40702813/query-on-postgres-json-array-field-in-rails

#payload: [{"kind"=>"person"}]
Segment.where("payload @> ?", [{kind: "person"}].to_json)

#data: {"interest"=>["music", "movies", "programming"]}
Segment.where("data @> ?",  {"interest": ["music", "movies", "programming"]}.to_json)
Segment.where("data #>> '{interest, 1}' = 'movies' ")
Segment.where("jsonb_array_length(data->'interest') > 1")

VoltanBro

AllCops:
  TargetRubyVersion: 2.7.2
  NewCops: enable
  Exclude:
    - 'db/**/*'
    - 'bin/*'

Layout/LineLength:
  Max: 120

VoltanBro

Vanilla JavaScript Quick Reference / Cheatsheet

Just migrated it from Codepen.io to markdown. Credit goes to David Conner.

Working with DOM	Working with JS	Working With Functions
Accessing Dom Elements	Add/Remove Array Item	Add Default Arguments to Function
Grab Children/Parent Node(s)	Add/Remove Object Properties	Throttle/Debounce Functions
Create DOM Elements	Conditionals

VoltanBro

  requestBody:
        content:
          application/json:
            schema:
              type: object
              properties:
                courier:
                  type: object
                  email:
                    type: string

VoltanBro

Started POST "/api/v1/sign_in" for 127.0.0.1 at 2020-06-06 03:00:06 +0300
   (0.4ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC
Processing by Api::V1::SessionsController#create as JSON
  Parameters: {"courier"=>{"email"=>"testcourier@test.com", "password"=>"[FILTERED]"}, "session"=>{"courier"=>{"email"=>"testcourier@test.com", "password"=>"[FILTERED]"}}}
  Courier Load (0.4ms)  SELECT "couriers".* FROM "couriers" WHERE "couriers"."id" = $1 ORDER BY "couriers"."id" ASC LIMIT $2  [["id", 1], ["LIMIT", 1]]
Completed 500 Internal Server Error in 23ms (ActiveRecord: 4.8ms | Allocations: 9516)


  
TypeError (no implicit conversion of nil into String):