This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#! /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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
FIELD BYTES | |
profile ID: 2 | |
cluster ID: 2 | |
source EP: 1 | |
dest EP: 1 | |
options: 2 | |
type: 1 | |
source: 2 | |
clustersp: 1 | |
mfgsp: 1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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" | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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") | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* 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, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* 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" |
NewerOlder