Skip to content

Instantly share code, notes, and snippets.

View bartekbrak's full-sized avatar

Bartek Brak bartekbrak

  • Warsaw
View GitHub Profile
@bartekbrak
bartekbrak / postgres_queries_and_commands.sql
Created June 11, 2019 12:05 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
$ cat re.py
print('local re being imported')
$ python2.6 -c 'import re'
local re being imported
$ python2.6 -c 'from __future__ import absolute_import;import re'
local re being imported
$ python2.6 -c 'from re import *'
local re being imported
$ python2.6 -c 'from .re import *'
# pseudo django project, the bare minimum
$ tree
.
├── manage.py
├── settings.py
├── setup.py
└── urls.py
# mae this a package
$ cat setup.py
@bartekbrak
bartekbrak / gist:4994828
Created February 20, 2013 11:06
rebuild mptt tree
# -*- coding: UTF-8 -*-
from django.core.management.base import BaseCommand, CommandError
from cms.models.pagemodel import Page
from optparse import make_option
def rebuild_tree(parent, left=1, recursion_level=0, commit=False):
right = left + 1