Flavian Missi flavianmissi

	-- show
	SELECT * from pg_stat_activity;

	-- Get the pid from the above query. Then:

	-- kill
	SELECT
	pg_terminate_backend(pid) -- this is your pid
	FROM
	pg_stat_activity

	for svc in $(kubectl get svc -o jsonpath='{.items[*].metadata.name}')
	do
	kubectl get deploy $svc -o jsonpath='{.items[*].metadata.name}'
	failed_to_find=$?
	if [ "$failed_to_find" -eq "1" ]
	then
	echo "Could not find deploy for service " $svc ", deleting the service..."
	kubectl delete svc $svc
	else
	echo "Found deploy for svc " $svc # ", look!"

	#!/bin/sh
	#/etc/init.d/redshift
	set -e

	. /lib/lsb/init-functions

	BASE=$(basename $0)
	REDSHIFT=/usr/bin/$BASE
	REDSHIFT_PIDFILE=/var/run/$BASE.pid

	wget https://pypi.python.org/packages/source/d/distribute/distribute-0.6.31.tar.gz

	workon myvenv # or you venv name

	pip uninstall setuptools # needs confirmation (y)

	tar -xvf distribute-0.6.31.tar.gz

	cd distribute-0.6.31

	from celery.task import task

	@task
	def prerender_obj(obj_id):
	try:
	myobj = MyModel.objects.get(pk=obj_id)
	myobj.prerender()
	except MyModel.DoesNotExist:
	# do stuff
	return True

	find . -name *.py -type f -print0 -exec sed -i '' 's/pattern/new_pattern/g' {} +
	# the above code seems to be bugged, instead:

	for p in ` find . -name "*.html" -type f`;do sed -i '' 's/slug/tobase64/g' $p;done

	# if you're not on OS X there is no need to pass -i '' to sed, just run:

	find . -name *.py -type f -print0 -exec sed -i 's/pattern/new_pattern/g' {} +

	# this avoids the "invalid command code ." error (on OS X)

	ps -ef \|grep "python challange" \| awk '{print $2;}' > tmp

	# to kill them:
	kill -9 $(cat tmp)