Skip to content

Instantly share code, notes, and snippets.

@Hidendra
Hidendra / lxc-create-ct.py
Created January 13, 2020 00:42
Helper script for creating LXC containers on Proxmox
#!/usr/bin/env python3
import argparse
import os
import subprocess
import sys
import time
def execute_shell(cmd) -> str:
@Hidendra
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
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
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
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;