Skip to content

Instantly share code, notes, and snippets.

@alexshpilkin
alexshpilkin / unfuck.py
Last active Sep 26, 2021
Data obfuscation on the Russian Central Election Commission website
View unfuck.py
#!/usr/bin/env python3
#{ SPDX-License-Identifier: CC0-1.0 }
from collections import namedtuple
from fontTools.ttLib import TTFont
from io import BytesIO
from lxml.html import document_fromstring
from lxml.etree import tostring
from re import finditer, compile as re_compile
from requests import get
@alexshpilkin
alexshpilkin / quantiles.py
Created May 6, 2021
Quantiles of the binomial and normal distributions
View quantiles.py
#!/usr/bin/env python3
# SPDX-License-Identifier: CC0-1.0
from math import exp, factorial, pi, sqrt
def binom(n, k):
if n - k < 0 or n + k < 0:
return 0
assert (n - k) % 2 == 0 and (n + k) % 2 == 0
return factorial(n) / (2**n * factorial((n-k)//2) * factorial((n+k)//2))
def gauss(n, k):
@alexshpilkin
alexshpilkin / grades.js
Created Mar 14, 2021
Google Apps Script program to post student grades
View grades.js
// SPDX-License-Identifier: CC0-1.0
const EMAIL = 3 /* C */, TUTOR = 5 /* E */, PROBLEMS = 7 /* G: */;
const TOKEN = 'SLACK_TOKEN';
function slack(url, payload) {
var token = PropertiesService.getDocumentProperties().getProperty(TOKEN);
if (token === null)
throw new Error('Slack bot token not set');
var req = {headers: {'Authorization': `Bearer ${token}`}};
@alexshpilkin
alexshpilkin / periodically.py
Last active Jan 8, 2021
Rate-limiting utility for tracing and such
View periodically.py
#!/usr/bin/env python3
from time import monotonic
class periodically:
def __init__(self, interval):
self.interval = interval
self._previous = None
def __enter__(self):
if self._previous is not None:
@alexshpilkin
alexshpilkin / trio_priority.py
Created Jan 7, 2021
Trio channels with priorities
View trio_priority.py
from heapq import heappush, heappop
from math import inf
from trio import BrokenResourceError, ClosedResourceError, EndOfChannel, WouldBlock
from trio.abc import ReceiveChannel, SendChannel
from trio.lowlevel import ParkingLot, checkpoint, checkpoint_if_cancelled, cancel_shielded_checkpoint
from trio._channel import MemoryChannelStats
from trio._util import NoPublicConstructor
class MemoryChannelState:
__slots__ = ('data', 'max_buffer_size', 'number', 'open_send_channels',
@alexshpilkin
alexshpilkin / gstream.py
Created Jun 17, 2019
Pipe video from DVR to GStreamer
View gstream.py
#!/usr/bin/env python3
from gi import require_version
require_version('Gst', '1.0')
require_version('Gtk', '3.0')
from gi.repository import GObject, Gst, Gtk
from os.path import abspath
from sys import argv, stderr
from threading import Thread
@alexshpilkin
alexshpilkin / moscow.tsv
Last active May 10, 2019
Administrative divisions of Moscow
View moscow.tsv
45 Город Москва
45 301 муниципальный округ Богородское
45 302 муниципальный округ Вешняки
45 303 муниципальный округ Восточное Измайлово
45 304 муниципальный округ Восточный
45 304 000 106 п Восточный
45 304 000 111 п Акулово
45 305 муниципальный округ Гольяново
45 306 муниципальный округ Ивановское
45 307 муниципальный округ Измайлово
@alexshpilkin
alexshpilkin / diffs.sh
Last active Apr 24, 2019
Add diffs to results posts
View diffs.sh
#!/bin/sh -eu
# NB: Contains literal tabs
caption() {
python -c '
from os import getenv
from sys import argv
from telegram import Bot
from telegram.error import BadRequest, TimedOut
@alexshpilkin
alexshpilkin / drv.wsdl
Last active Sep 4, 2019
Access SOAP APIs of the Ukrainian DRV with Python and Zeep
View drv.wsdl
<?xml version="1.0" encoding="utf-8"?>
<wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap12/"
xmlns:tns="http://www.drv.gov.ua/"
xmlns:s="http://www.w3.org/2001/XMLSchema"
xmlns:http="http://schemas.xmlsoap.org/wsdl/http/"
targetNamespace="http://www.drv.gov.ua/"
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
<wsdl:types>
<s:schema elementFormDefault="qualified" targetNamespace="http://www.drv.gov.ua/">
@alexshpilkin
alexshpilkin / aggregate.py
Last active Apr 14, 2019
Aggregate multiple CVK scrapes into precinct histories
View aggregate.py
#!/usr/bin/env python3
# NB Depends on dict preserving the insert order (CPython >= 3.6, PyPy all)
from csv import DictReader
from datetime import datetime as DateTime
from os import scandir
from simplejsonseq import dump
from sys import argv, stderr, stdout
import ietfcsv # ietf-tab CSV dialect