nsomaru

This TRIGGER function calls PosgreSQL's NOTIFY command with a JSON payload. You can listen for these calls and then send the JSON payload to a message queue (like AMQP/RabbitMQ) or trigger other actions.

Create the trigger with notify_trigger.sql.

When declaring the trigger, supply the column names you want the JSON payload to contain as arguments to the function (see create_triggers.sql)

The payload returns a JSON object:

How to change your commit messages in Git?

At some point you’ll find yourself in a situation where you need edit a commit message. That commit might already be pushed or not, be the most recent or burried below 10 other commits, but fear not, git has your back 🙂.

Not pushed + most recent commit:

git commit --amend

This will open your $EDITOR and let you change the message. Continue with your usual git push origin master.

django-invitations & django-allauth: Invitation Accepted Only on Account Creation

The Problem

As per this django-invitations issue, django-invitations considers an invite "accepted" if the invite link is clicked. This is problematic for two reasons (or more):

Automatic mail crawlers which visit links checking for malware etc., and verifying that you're not a spammer
A user which clicks a link to "check out" an invite, but doesn't necessarily want to sign up right now

Something to consider is that this solution assumes you're using django-allauth as it uses the EmailAddress model of that package.

	import asyncio
	import psycopg2

	# dbname should be the same for the notifying process
	conn = psycopg2.connect(host="localhost", dbname="example", user="example", password="example")
	conn.set_isolation_level(psycopg2.extensions.ISOLATION_LEVEL_AUTOCOMMIT)

	cursor = conn.cursor()
	cursor.execute(f"LISTEN match_updates;")

	CREATE TRIGGER person_notify AFTER INSERT OR UPDATE OR DELETE ON income
	FOR EACH ROW EXECUTE PROCEDURE notify_trigger(
	'id',
	'email',
	'username'
	);

	CREATE TRIGGER income_notify AFTER INSERT OR UPDATE OR DELETE ON income
	FOR EACH ROW EXECUTE PROCEDURE notify_trigger(
	'id',

	#!/usr/bin/env sh

	##
	# This is script with usefull tips taken from:
	# https://github.com/mathiasbynens/dotfiles/blob/master/.osx
	#
	# install it:
	# curl -sL https://raw.github.com/gist/2108403/hack.sh \| sh
	#