Skip to content

Instantly share code, notes, and snippets.

View miketheman's full-sized avatar

Mike Fiedler miketheman

255 followers · 25 following
View GitHub Profile
@miketheman
miketheman / query.sql
Created August 24, 2024 12:25
PyPI Download stats, past 7 days, grouped by whether user-agent self-reports `ci: true`
SELECT
DATE(timestamp) AS download_date,
COUNTIF(details.ci = TRUE) AS ci_downloads,
COUNTIF(details.ci IS NULL OR details.ci = FALSE) AS non_ci_downloads
FROM `bigquery-public-data.pypi.file_downloads`
WHERE DATE(timestamp) >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
GROUP BY download_date
ORDER BY download_date;
@miketheman
miketheman / example.py
Created February 28, 2023 21:51
Mock side_effect https://docs.python.org/3/library/unittest.mock.html#unittest.mock.Mock.side_effect
from unittest.mock import patch
import boto3
from botocore.stub import Stubber
# create an ssm client
ssm = boto3.client("ssm")
# create an sqs client
sqs = boto3.client("sqs")
@miketheman
miketheman / main.py
Last active December 22, 2022 19:20
Add a bunch of AWS Heroes (and some other folks, too) to a Mastodon list.
"""
Add users to a Mastodon instance list.
Uses https://mastodonpy.readthedocs.io/
"""
from os import environ
from pathlib import Path
from mastodon import Mastodon
from mastodon.errors import MastodonNotFoundError, MastodonServiceUnavailableError
@miketheman
miketheman / testing_gfm_pre.md
Last active July 13, 2022 11:52

Tests how GitHub renders code blocks

Code fence, no language set

    ```
    echo "foo"
    ```
@miketheman
miketheman / Makefile
Created November 22, 2021 17:32
Makefile with targets to generate static renderings from PlantUML sources
DIAGRAMS := $(wildcard *.puml */*puml)
SVGS := $(DIAGRAMS:.puml=.svg)
PNGS := $(DIAGRAMS:.puml=.png)
all: $(SVGS) $(PNGS)
%.png: %.puml
plantuml -tpng "$<"
%.svg: %.puml
@miketheman
miketheman / my_package.py
Last active March 20, 2021 23:22 — forked from benkehoe/package_with_single_sourced_version.py
Single sourcing a python package version using importlib.metadata.version()
try:
# importlib.metadata is present in Python 3.8 and later
import importlib.metadata as importlib_metadata
except ImportError:
# use the shim package importlib-metadata pre-3.8
import importlib_metadata as importlib_metadata
try:
__version__ = importlib_metadata.version(__package__ or __name__)
except importlib_metadata.PackageNotFoundError:
@miketheman
miketheman / hypermail.rb
Created December 12, 2020 21:20
Sample Homebrew forumla for Hypermail http://www.hypermail-project.org/
class Hypermail < Formula
desc "Hypermail is a free (GPL) program to convert email from Unix mbox format to html."
homepage "http://www.hypermail-project.org/"
url "https://github.com/hypermail-project/hypermail/releases/download/v2.4.0/hypermail-2.4.0.tar.gz"
sha256 "f97995b9bb1ece888968467cdad05e3daa7662ff3e3a5739e378b4f3adeb26c6"
license "GPL-2.0"
depends_on "bison" => :build
depends_on "gcc"
@miketheman
miketheman / main.dart
Created October 16, 2020 23:59
flip(inputInt) {
return inputInt = 1 - inputInt;
}
void main() {
print(flip(0));
print(flip(1));
}
@miketheman
miketheman / _how_to.md
Last active June 4, 2020 20:44
Mike's Super Janky Manual GitHub Vuln Alert Query

How To

Prerequsites:

  • GitHub account with admin-level rights to repos, possibly even org-level admin.
  • Command Line familiarity
  • jq tool

Note: Commands have been written assuming a macOS machine, they may work on other platforms, but I haven't tested those.

@miketheman
miketheman / enable_alerting.py
Created February 14, 2020 14:39
A simple script to enable GitHub's Data Services & Vulnerability Scanning on a given Organization's Repositories
from github import Github
gh = Github('SET_GITHUB_ACCESS_TOKE_HERE')
org = gh.get_organization('SET_ORG_NAME_HERE')
repos = org.get_repos()
for repo in repos:
if repo.archived: