Shawn Milochik ShawnMilo

One of eclectic interests and ephemeral hobbies.

ShawnMilo / ksuid_to_timestamp.sql

Created May 2, 2023 18:38

Convert a ksuid to a datetime/timestamp with time zone in PostgreSQL (plpgsql)

	CREATE OR REPLACE FUNCTION ksuid_to_datetime(ksuid_base62 TEXT)
	RETURNS TIMESTAMP WITH TIME ZONE AS $$
	DECLARE
	v_alphabet CHAR ARRAY[62] := ARRAY[
	'0', '1', '2', '3', '4', '5', '6', '7', '8', '9',
	'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J',
	'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T',
	'U', 'V', 'W', 'X', 'Y', 'Z',
	'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j',
	'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't',

ShawnMilo / adoc.py

Created July 21, 2022 03:36

Convert .adoc file to PDF using AsciiDoctor

	#!/usr/bin/env python3
	"""
	Convert .adoc files to .pdf.

	Periodically check for updated tags:
	https://hub.docker.com/r/asciidoctor/docker-asciidoctor/tags
	"""
	import sys
	import os
	from subprocess import check_output

ShawnMilo / audit.py

Created October 5, 2021 13:27

audit.py

	#!/usr/bin/env python3
	"""
	Find files to audit so that all files are looked
	at regularly.
	"""

	from os.path import abspath, dirname, join
	from os import walk

	import re

ShawnMilo / sendkeys.py

Created March 2, 2020 02:42

	#!/usr/bin/env python

	import os
	import sys
	from time import sleep
	from random import randrange
	import re

	fkey = re.compile(r'^F\d$')

ShawnMilo / simple_cookies.go

Created July 26, 2019 19:25

Simple use of cookies in Go

ShawnMilo / find_ssh.go

Created February 26, 2018 02:19

	package main

	import (
	"fmt"
	"net"
	"sync"
	"time"
	)

	var addresses = make(chan string)

ShawnMilo / webhook.go

Created October 9, 2017 15:35

Listen for GitHub webhooks and keep local repos up to date.

	package main

	/*
	Listen for calls from GitHub and update local repositories.
	*/

	import (
	"encoding/json"
	"fmt"
	"io/ioutil"

ShawnMilo / klog.go

Created July 26, 2017 23:22

kubernetes log combiner

ShawnMilo / auth.py

Last active August 29, 2015 14:19

	from hashlib import sha512
	from uuid import uuid4

	from redis import StrictRedis

	__all__ = (
	'hash_password', 'create_user', 'login_is_valid',
	)

	conn = StrictRedis()

ShawnMilo / foe.go

Created January 6, 2015 20:08

foe. A file search that opens the files found in vim.