Skip to content

Instantly share code, notes, and snippets.

@mckeed
mckeed / heroku-chart-dataclip.sql
Created October 15, 2024 16:09
A template for a PostgreSQL Heroku Dataclip to be viewed in chart mode. Makes it easy to change what you're querying and the time periods.
with vars as (select
date_trunc('hour', localtimestamp -
'24 hours'::interval) as start, -- how far back to start the chart
'30 minutes'::interval as bin_width -- width of time slices
),
data as (
select
created_at as "timestamp", -- column to use as timestamp of the record
1 as "value" -- use 1 to just count records, or specify a column to aggregate (by sum currently, can be changed below)
from users -- table to query; can add where clause here to restrict results
@mckeed
mckeed / pre-commit
Last active July 4, 2024 03:14
Run rubocop on only staged files in git pre-commit
#!/bin/sh
STAGED_FILES=$(git diff-index HEAD --name-only --cached)
if [[ -z $STAGED_FILES ]]
then
exit # no staged files, no need to run rubocop
fi
# Checks if any staged files have unstaged changes
# otherwise rubocop isn't running on what is actually
@mckeed
mckeed / gemsite.sh
Created June 14, 2024 19:39
Open the homepage of an installed Ruby gem
#! /usr/bin/env zsh
[[ -n $1 ]] || { echo "Usage: $(basename $0) <gem_name>"; exit 1; }
url=$(gem info $1 | sed -En '/ *Homepage: (.*)/{s//\1/p; q;}')
[[ -n $url ]] || { echo "Couldn't find homepage for $1"; gem info $1; exit 2; }
echo "Opening $url"
open $url # if not using macOS, replace open with xdg-open or whatever
@mckeed
mckeed / LoadView.swift
Created August 12, 2022 20:02
SwiftUI view that calls a load function and shows a `LoadingView: UIView` until the `isLoading` binding is changed to false, then displays its contents.
import SwiftUI
typealias IsLoadingBool = Bool // To help remember which way the bool goes (false means ready to display)
protocol LoadedView {
func load() -> Binding<IsLoadingBool>
}
// LoadingView is an existing full-screen UIView in my codebase.
// This could be replaced by any custom View
@mckeed
mckeed / strong_parameters.rb
Created June 5, 2012 22:24
Before filters to make rails/strong_parameters work with CanCan's load_resource or load_and_authorize_resource.
require 'strong_parameters'
class ActiveRecord::Base
include ActiveModel::ForbiddenAttributesProtection
end
class ActionController::Base
# Use this with CanCan's load_resource to permit a set of params before
# it tries to build or update a resource with them.
@mckeed
mckeed / zigbee_catchall
Last active November 3, 2020 18:06
Catchall ZigBee packet format
FIELD BYTES
profile ID: 2
cluster ID: 2
source EP: 1
dest EP: 1
options: 2
type: 1
source: 2
clustersp: 1
mfgsp: 1
@mckeed
mckeed / intermatic-dimmer.groovy
Created July 31, 2014 22:04
Intermatic Dimmer SmartThings Device Type
metadata {
// Automatically generated. Make future change here.
definition (name: "Intermatic Dimmer", namespace: "mckeed", author: "Duncan") {
capability "Switch Level"
capability "Actuator"
capability "Switch"
capability "Refresh"
capability "Sensor"
}
@mckeed
mckeed / zwave-smoke-alarm.groovy
Created October 10, 2013 15:48
SmartThings device type handler for the BRK First Alert ZSMOKE
metadata {
simulator {
}
tiles {
standardTile("smoke", "device.smoke", width: 2, height: 2) {
state("clear", label:"clear", icon:"st.alarm.smoke.clear", backgroundColor:"#ffffff")
state("detected", label:"SMOKE", icon:"st.alarm.smoke.smoke", backgroundColor:"#e86d13")
state("tested", label:"TEST", icon:"st.alarm.smoke.test", backgroundColor:"#e86d13")
}
@mckeed
mckeed / ridiculously-automated-zwave-garage-door.groovy
Last active March 20, 2019 17:53
Ridiculously Automated Garage Door for GD00Z
/**
* Ridiculously Automated Garage Door
*
* Author: SmartThings
*
* Monitors arrival and departure of car(s) and
*
* 1) opens door when car arrives,
* 2) closes door after car has departed (for N minutes),
* 3) opens door when car door motion is detected,
@mckeed
mckeed / aeon-siren-with-sound-cmds.groovy
Last active October 24, 2018 01:56
Aeon Siren w/sound commands
/**
* Aeon Siren with Sound Commands + revert to default
*
* Author: SmartThings
* Date: 2014-07-15
*/
metadata {
definition (name: "Aeon Siren", namespace: "smartthings", author: "SmartThings") {
capability "Actuator"
capability "Alarm"