hgdeoro’s gists

hgdeoro / truncate_all_tables.sql

Created October 19, 2012 16:23

Truncate all the tables of 'public' schema

	CREATE OR REPLACE FUNCTION truncate_all_tables() RETURNS void AS $$
	DECLARE
	stmt RECORD;
	statements CURSOR FOR SELECT tablename from pg_tables where schemaname = 'public';
	BEGIN
	FOR stmt IN statements LOOP
	EXECUTE 'TRUNCATE TABLE ' \|\| quote_ident(stmt.tablename) \|\| ' CASCADE;';
	END LOOP;
	END;
	$$ LANGUAGE 'plpgsql';

hgdeoro / test-scp-ciphers.sh

Created August 25, 2012 05:38

Test scp con distintos ciphers

	#!/bin/bash

	if [ -z "$1" ] ; then
	echo "Debe especificar host destino"
	exit 1
	fi

	echo "Para generar archivo con datos aleatorios:"
	echo " $ dd if=/dev/urandom of=random bs=1024k count=512"
	echo ""

hgdeoro / settings.py

Last active July 10, 2022 12:20

Automatically login 'admin' user in Django

	MIDDLEWARE_CLASSES = (
	'django.middleware.common.CommonMiddleware',
	'django.contrib.sessions.middleware.SessionMiddleware',
	'django.middleware.csrf.CsrfViewMiddleware',
	'utils.AutomaticLoginUserMiddleware',
	'django.contrib.auth.middleware.AuthenticationMiddleware',
	'django.contrib.messages.middleware.MessageMiddleware',
	'django.middleware.transaction.TransactionMiddleware',
	)

hgdeoro / gnome_notify_logging_handler.py

Created August 13, 2012 04:07

Python logging handler, to notify errors to the desktop

	# -- coding: utf-8 --

	import logging
	import subprocess


	class CustomHandler(logging.Handler):

	def __init__(self, args, *kwargs):
	logging.Handler.__init__(self, args, *kwargs)

hgdeoro / assertsynced.py

Created July 20, 2012 18:06

Django management command to assert all South migrations are applied

	"""
	Assert migrations are applied management command.
	"""

	import sys

	from optparse import make_option

	from django.core.management.base import BaseCommand
	from django.conf import settings

hgdeoro / riptano.repo

Created July 6, 2012 16:27

File to register the Riptano repository on CentOS 6

	#
	# To be downloaded on /etc/yum.repos.d/riptano.repo
	#
	[riptano]
	name=Riptano Repo for CentOS $releasever – $basearch
	baseurl=http://rpm.riptano.com/community
	failovermethod=priority
	enabled=1
	gpgcheck=0

hgdeoro / zmq_client_2.py

Created February 16, 2012 03:30

Cliente con pyzmq que no bloquea

	# -- coding: utf-8 --

	import logging
	import zmq


	def main():
	logging.basicConfig(level=logging.INFO)
	msg = {'un': 'dict'}

hgdeoro / zmq_client_1.py

Created February 16, 2012 03:29

Cliente básico con pyzmq

	# -- coding: utf-8 --

	import logging
	import zmq


	def main():
	logging.basicConfig(level=logging.INFO)
	msg = {'un': 'dict'}

hgdeoro / zmq_server.py

Created February 16, 2012 03:28

Server ZeroMQ + pyzmq

	# -- coding: utf-8 --

	import logging
	import zmq


	def main():
	logging.basicConfig(level=logging.INFO)

	# Creamos contexto de ZeroMQ

hgdeoro / admin.py

Created February 14, 2012 05:08

Customizacion de Admin para exportar objetos

	from django.core import serializers

	class ModelOneAdmin(admin.ModelAdmin):
	actions = ['exportar']

	def exportar(self, request, queryset):
	response = HttpResponse(content_type="text/javascript")
	response['Content-Disposition'] = 'attachment; filename=exportado.json'
	serializers.serialize("json", queryset, stream=response, ensure_ascii=False, indent=2)
	return response

Horacio G. de Oro hgdeoro