Tyler Blair Hidendra

Hidendra / lwc_convert_old_experimental_uuid.py

Created December 23, 2014 07:01

Converts protection database from the feature/811-uuid-conversion branch back to master.

	import MySQLdb
	import json

	conn = MySQLdb.connect(host = "127.0.0.1", user = "root", passwd = "", db = "lwc")

	"""

	Protections:

	RENAME TABLE lwc_protections TO lwc_protections_old_uuid;

Hidendra / redis-aggregate.lua

Last active December 5, 2019 02:33

Aggregate values in a redis sorted set. Returns {count, sum, min, max}

	local result = redis.call('zrange', KEYS[1], 0, -1, 'withscores')

	local count = 0
	local sum = 0
	local min = 0
	local max = 0

	for i=1, #result, 2 do
	local score = result[i + 1]

Hidendra / redis-zadd-sum.lua

Last active August 4, 2022 10:53

zadd that keeps track of sums

	-- keys: key dest
	-- argv: score member [score member ...]
	-- e.g. keys: "data:test:1:2" "data-sum:test:1:2"
	-- argv: 10 a 15 b

	local key = KEYS[1]
	local dest = KEYS[2]
	local sum = tonumber(redis.call('get', dest)) or 0

	for i=1, #ARGV, 2 do

Hidendra / postgres-table-queries.py

Created March 21, 2016 19:39

Create postgres import query files for MCStats graph data

	import sys
	import glob
	import os.path


	def main():
	if len(sys.argv) != 3:
	print('Usage: %s <directory of csv files> <output directory>' % sys.argv[0])
	sys.exit(1)

Hidendra / lxc-create-ct.py

Created January 13, 2020 00:42

Helper script for creating LXC containers on Proxmox