mattlong’s gists

mattlong / launch.json

Last active April 26, 2023 21:23 — forked from cecilemuller/launch.json

Run ts-node in VSCode Debugger

	{
	"version": "0.2.0",
	"configurations": [
	{
	"name": "ts-node",
	"type": "node",
	"request": "launch",
	"args": ["${relativeFile}"],
	"runtimeArgs": ["-r", "ts-node/register/transpile-only"],
	"env": { "NODE_OPTIONS": "--max_old_space_size=1024" },

mattlong / postgres_queries_and_commands.sql

Created June 29, 2021 03:39 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- 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%'

Created June 16, 2021 22:48 — forked from phlegx/Rails 4 - how to give alias names to includes() and joins() in active record quering

Rails 4 - how to give alias names to includes() and joins() in active record quering

	See question on stack overflow: http://stackoverflow.com/questions/28595636/rails-4-how-to-give-alias-names-to-includes-and-joins-in-active-record-que

	- Model Student and model Teacher are both STI models with super class model User
	- Model Story is a STI model with super class model Task
	- includes() and joins(), both fails

	Rails alias naming convention (includes() and joins())

	- One model as parameter
	- is base model (includes(:users))

mattlong / active_record_extension.rb

Created June 16, 2021 22:47 — forked from ozydingo/active_record_extension.rb

ActiveRecord left join

	module ActiveRecordExtension
	extend ActiveSupport::Concern

	module ClassMethods
	# Simple left join taking advantage of existing Rails & Arel code
	def left_joins(*args)
	inner_joins = self.joins(*args).arel.join_sources
	left_joins = inner_joins.map do \|join\|
	Arel::Nodes::OuterJoin.new(join.left, join.right)
	end

mattlong / left_join_arel_example.rb

Created June 16, 2021 22:47 — forked from mildmojo/left_join_arel_example.rb

LEFT JOIN in ARel for ActiveRecord in Ruby on Rails

	# Here's a contrived example of a LEFT JOIN using ARel. This is an example of
	# the mechanics, not a real-world use case.

	# NOTE: In the gist comments, @ozydingo linked their general-purpose ActiveRecord
	# extension that works for any named association. That's what I really wanted!
	# Go use that! Go: https://gist.github.com/ozydingo/70de96ad57ab69003446

	# == DEFINITIONS
	# - A Taxi is a car for hire. A taxi has_many :passengers.
	# - A Passenger records one person riding in one taxi one time. It belongs_to :taxi.

mattlong / Gemfile

Created July 13, 2020 21:03 — forked from dhh/Gemfile

HEY's Gemfile

	ruby '2.7.1'

	gem 'rails', github: 'rails/rails'
	gem 'tzinfo-data', '>= 1.2016.7' # Don't rely on OSX/Linux timezone data

	# Action Text
	gem 'actiontext', github: 'basecamp/actiontext', ref: 'okra'
	gem 'okra', github: 'basecamp/okra'

	# Drivers

mattlong / pihole-whitelist.txt

Created April 20, 2020 20:28

Pihole whitelist

mattlong / csrf_tokens.rb

Created April 6, 2020 17:40

Rails CSRF token analyzer

	def real_csrf_token(token)
	Base64.strict_decode64(token)
	end

	def xor_byte_strings(s1, s2)
	s2_bytes = s2.bytes
	s1.each_byte.with_index { \|c1, i\| s2_bytes[i] ^= c1 }
	s2_bytes.pack("C*")
	end

mattlong / fix-sound.sh

Created February 7, 2020 18:44

Fix OSX sound

	#!/bin/bash

	sudo kextunload /System/Library/Extensions/AppleHDA.kext
	sudo kextload /System/Library/Extensions/AppleHDA.kext

mattlong / .bashrc

Created February 4, 2020 18:57

Fix GPG decrypting

	# If you get "Inappropriate ioctl for device" when decrypting
	# Thanks to https://github.com/keybase/keybase-issues/issues/2798
	export GPG_TTY=$(tty)

Matt Long mattlong