| #!/bin/bash | |
| # Assumes you have a DIGITALOCEAN_TOKEN env var pre-set | |
| # Assumes you have terraform and mutagen installed | |
| # Assumes DO has an SSH key uploaded | |
| DO_REGION="sgp1" # Set to DO region: https://www.digitalocean.com/docs/platform/availability-matrix/ | |
| SSH_KEY_FINGERPRINT="your-key-fingerprint" # You can find this in your control panel | |
| if [ -z $DIGITALOCEAN_TOKEN ]; then | |
| exit 1 |
| 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") |
FWIW: I (@rondy) am not the creator of the content shared here, which is an excerpt from Edmond Lau's book. I simply copied and pasted it from another location and saved it as a personal note, before it gained popularity on news.ycombinator.com. Unfortunately, I cannot recall the exact origin of the original source, nor was I able to find the author's name, so I am can't provide the appropriate credits.
| ;;; runs eslint --fix on the current file after save | |
| ;;; alpha quality -- use at your own risk | |
| (defun eslint-fix-file () | |
| (interactive) | |
| (message "eslint --fixing the file" (buffer-file-name)) | |
| (shell-command (concat "eslint --fix " (buffer-file-name)))) | |
| (defun eslint-fix-file-and-revert () | |
| (interactive) |
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
| module Stop | |
| module CantTouchThis | |
| def self.included(mod) | |
| %w[instance_variable_get instance_variable_set].each do |m| | |
| send(:protected, m) | |
| end | |
| eigenclass = class << mod; self; end | |
| %w[const_set class_variable_get class_variable_set public_class_method attr attr_reader attr_writer].each do |m| |
| =Navigating= | |
| visit('/projects') | |
| visit(post_comments_path(post)) | |
| =Clicking links and buttons= | |
| click_link('id-of-link') | |
| click_link('Link Text') | |
| click_button('Save') | |
| click('Link Text') # Click either a link or a button | |
| click('Button Value') |