Avishay Zarad avshyz

## snippet.sql
SELECT pg_terminate_backend(b.pid)
from (SELECT pid,
             now() - pg_stat_activity.query_start AS duration,
             query,
             state
      FROM pg_stat_activity
      WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes') as b
where pid <> pg_backend_pid();

## snippet.py
%load_ext autoreload
%autoreload 2

## snippet.zsh
alembic upgrade +2
alembic downgrade -1
alembic downgrade HASH+2

## snippet.zsh
alembic revision -m "REVISIONNAME" --autogenerate
alembic upgrade head

## snippet.zsh
docker run -it --rm nginx:1.16.0-alpine /bin/sh
	SELECT pg_terminate_backend(b.pid)
	from (SELECT pid,
	now() - pg_stat_activity.query_start AS duration,
	query,
	state
	FROM pg_stat_activity
	WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes') as b
	where pid <> pg_backend_pid();
	alembic upgrade +2
	alembic downgrade -1
	alembic downgrade HASH+2
	alembic revision -m "REVISIONNAME" --autogenerate
	alembic upgrade head