Skip to content

Instantly share code, notes, and snippets.

Hay Kranen hay

Block or report user

Report or block hay

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View telegram-history-json-to-csv.py
# Converts a JSONL file generated with telegram-history-dump (1) to CSV
# Usage: python telegram-csv.py <path to json file> <path to output csv file>
# Example: python telegram-csv.py Bob.json Bob.csv
# 1: https://github.com/tvdstaaij/telegram-history-dump
from datetime import datetime
import unicodecsv as csv
import json, sys
def get_isodate(msg):
date = msg.get("date", None)
@hay
hay / cheatsheet.md
Last active Nov 3, 2019
Hay's dev cheatsheet
@hay
hay / gist:1351230
Created Nov 9, 2011
Enterprisify your Java Class Names!
View gist:1351230
<!doctype html>
<html>
<head>
<title></title>
<style>
body {
background: white;
text-align: center;
padding: 20px;
font-family: Georgia, serif;
View resit-2b
Sean,706883
Adam,90500
Grace,407103
Sean,836266
Kelly,28335
View resit-2a
Welcome to the fake people database!
No people database yet
Make a choice:
1) Remove a person
2) Add a person
3) Quit the program
Make your choice: [1/2/3]: 2
Added Jane with phone number 52334
Saved the database with 1 people
There are 1 people in the database:
View resit-1
Hey, welcome to Number Guessr
Please state your name Hay
Welcome Hay! You'll have 5 tries to guess a number
The number will be between 1 and 100
You have 5 guesses remaining
What's your guess? 50
50 is not correct, the number is lower
You have 4 guesses remaining
What's your guess? 25
@hay
hay / fix-sql.py
Created Nov 11, 2018
A pretty horrible Python script to fix the SQL errors in the Rijksmonumenten dump mentioned here: https://github.com/clytras/AccessConverter/issues/5
View fix-sql.py
#!/usr/bin/env python3
from tqdm import tqdm
from sys import argv, exit
from os.path import getsize
def fix_token(token):
if token == ",":
return "'',"
elif token == "(,":
return "('',"
@hay
hay / dlcat.py
Created Nov 6, 2010
Download all images in a category on Wikimedia Commons. Requires pywikipedia
View dlcat.py
#!/usr/bin/python
# -*- coding: utf-8 -*-
# -cat:Images_from_Wiki_Loves_Monuments
import sys, os
# Set your path to pywikipedia here
sys.path.append("/Users/hay/htdocs/checkouts/pywikipedia/")
import wikipedia, config, pagegenerators
import urllib2, codecs
@hay
hay / app.js
Last active Dec 16, 2016
Learn Javascript MVC: create a todo list using Stapes.js in less than 100 lines code (part 1) examples
View app.js
var TodosModel = Stapes.subclass();
var TodosView = Stapes.subclass({
constructor : function(model) {
var self = this;
this.$el = $("#inputform");
this.model = model
var $input = this.$el.find("input");
@hay
hay / WMStats.java
Last active Aug 30, 2016
Wikipedia statistics parser comparison
View WMStats.java
import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
public class WMStats {
private static final String FILE_NAME = "pagecounts-20141029-230000";
You can’t perform that action at this time.