Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

View davidsword's full-sized avatar

David Sword davidsword

16 followers · 0 following
View GitHub Profile
@davidsword
davidsword / rpi-oled-sys+pihole-stats.py
Last active January 31, 2021 22:16
rpi-oled-sys+pihole-stats.py
# System and PiHole stats for 128x32 OLED screen
#
# Add to: `/etc/rc.local` for boot start.
#
# @author learn.adafruit.com, davidsword
# @link https://gist.github.com/davidsword/0e9556ac19b5ef02d93d73931fec659e
# @version 20210131
import time
import subprocess
@davidsword
davidsword / mysql-cheat-sheet.md
Last active January 17, 2021 00:34
🔥🍺 MySQL cheat sheet
@davidsword
davidsword / ssbl-README.md
Last active December 30, 2020 23:40
My personal list of statuses for Slack that I use in a custom Alfred Workflow to change my Slack presense and status as well as send a ping to HomeAssistant to change a physical busy light RGB LED for my office so my family knows my current state/focus.
State Slack Status Emoji Slack Presense Busy Light
Active 🟢 🟢
In a Meeting red-dot 🟢 🔴
On Call red-dot 🟢 🔴
Red 🟢 🔴
Busy red-dot ⚪️ 🔴
BRB yellow-dot ⚪️ 🟡
Lunch yellow-dot ⚪️ 🟡
Family yellow-dot ⚪️ 🟡
@davidsword
davidsword / ESP8266 NodeMCU RGB LED Busy Server.ino
Last active August 19, 2020 14:42
ESP8266 NodeMCU RGB LED Busy Server
/* ESP8266 NodeMCU RGB LED Busy Server
*
* Set an RGB LED to current status via web request
*
* 1. Flash this file to a ESP-12E
* 2. Open Serial to get the IP address of board
* 3. Optionally set a dedicated DHCP reservation at the router level to ensure same IP address is used
* 4. Connect common anode or common cathode RGB LED (see pins below)
* 5. Make `GET` request to `http://<IP>/<status>`
*
@davidsword
davidsword / rgb-led-status.py
Last active July 10, 2020 06:55
https://davidsword.ca/a-cheaper-diy-status-light/ - Raspberry Pi control a common anode or common cathode RGB LED. e sure to know the difference of your RGB LED. Usage: `python3 rgb-led-status.py <avaliable|busy|offline>` to set as green, red, or off respectively.
# https://davidsword.ca/a-cheaper-diy-status-light/
import sys
import RPi.GPIO as GPIO
GPIO.setwarnings(False)
# Note this is BOARD numbering.
GPIO.setmode(GPIO.BOARD)
redPin = 3
@davidsword
davidsword / oled-count-game.py
Last active June 25, 2020 21:19
https://davidsword.ca/learning-to-count-to-5-with-a-raspberry-pi/ Raspberry Pi - Learn to count to 5 game. Pressing button, count up to number on OLED screen, then celebrate once reached.
# https://davidsword.ca/learning-to-count-to-5-with-a-raspberry-pi/
import time
import busio
import adafruit_ssd1306
import RPi.GPIO as GPIO
from board import SCL, SDA
from PIL import Image, ImageDraw, ImageFont
# settings
@davidsword
davidsword / get-assoc-pr.sh
Last active June 2, 2020 22:14
Github GraphQL API - Trace a commit back to a PR and get the username of who approved it
GH_TOKEN=""
GH_REPO=""
GH_OWNER=""
GH_SHA=""
# Get the PULL number that's realted to the commit on this build
PULL=$(curl -H "Authorization: bearer ${GH_TOKEN}" -s -d "{ \
\"query\": \"query { \
repository(owner: \\\"$GH_OWNER\\\", name: \\\"$GH_REPO\\\") { \
commit: object(expression: \\\"$GH_SHA\\\") { \
@davidsword
davidsword / unicorn-phat.html
Last active May 8, 2020 16:44
A local HTML copy of https://github.com/davidsword/node-unicorn 's state
<style type="text/css">
:root {
--padding: 2px;
--size: 5px;
--total: 7px;
}
body {
background: black;
padding:2px;
margin:0;
@davidsword
davidsword / x_cache_seg.php
Created November 25, 2019 18:46
Example of Cache Varients on VIP Go
<?php
/**
* Example of Cache Varients on VIP Go
*
* @see https://github.com/Automattic/vip-go-mu-plugins/blob/master/cache/examples/segmentation-maintenance-mode-bypass/vip-config.php
*/
function x_cache_seg() {
// Set the response header to let CDN know of possible varient.
header( 'Vary: X-VIP-Go-Segmentation' );
@davidsword
davidsword / darkmode-toggle.html
Created October 16, 2019 15:31
Toggle Darkmode w/ a body class
<a href='#' data-darkmode-btn>Toggle Darkmode</a>
<script type="text/javascript">
/* eslint-disable */
var darkModeBtn = document.querySelector('a[data-darkmode-btn]');
var bodyEle = document.querySelector('body');
if (localStorage.getItem('darkmode') === 'yes') {
bodyEle.classList.add("darkmode");
}
function darkmodetoggle(e) {