Bolin Hsu bolin-hsu

bolin-hsu / gist:0e1e1c5baa7cf806b92c

Last active August 29, 2015 14:05

MySQL cleanup script

	#!/usr/bin/env python
	from datetime import datetime
	import mysql.connector
	from itertools import chain
	import time

	class MySQL:
	def __init__(self):
	self.connector = mysql.connector.connect(
	user='usr',

bolin-hsu / gist:0d92e68ef1943b08f8b6

Last active August 29, 2015 14:05

MySQL utility class

	class MySQL:
	def __init__(self):
	self.connector = mysql.connector.connect(
	user='usr',
	password='pwd',
	host='127.0.0.1',
	port='20033', # tunnel to server
	database='db')
	self.cursor = self.connector.cursor()

bolin-hsu / check.sh

Created July 27, 2014 03:59

	for s in remote1 remote2 ... remote87
	do
	ssh $s ls -lrt /var/lib/jelli/audio-recording/ \| tail -1
	done

bolin-hsu / ssh-ls.txt

Created July 27, 2014 03:57

$ ssh remote ls -lrt /mnt/data/ | tail -1

bolin-hsu / check_sequential.py

Created July 27, 2014 02:31

	#!/usr/bin/env python
	import argparse
	import subprocess

	def check_one_station(station):
	cmd = 'ssh {0} ls -alrt /var/lib/jelli/audio-recording/ \| grep -v ^d \| tail -1'.format(station)
	p = subprocess.Popen(cmd.split(), stdout=subprocess.PIPE, stderr=subprocess.PIPE)
	(out, err) = p.communicate()
	idx = err.find('cannot access')
	if idx >= 0:

bolin-hsu / check_recording.py

Created July 27, 2014 00:55

	#!/usr/bin/env python
	import argparse
	import subprocess
	import threading
	import Queue
	import string
	import time

	class CheckOneStation(threading.Thread):
	_err_marker = '###'