SELECT C.relname AS table_name,
pg_size_pretty(pg_total_relation_size(C.oid)) AS total_size,
S.n_live_tup AS total_rows
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
LEFT JOIN pg_stat_user_tables S ON (C.relname = S.relname)
WHERE nspname NOT IN ('pg_catalog', 'information_schema')
AND C.relkind <> 'i'
AND nspname !~ '^pg_toast'
ORDER BY pg_total_relation_size(C.oid) DESC
LIMIT 5;
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'db' -- ! replace db with the target database name AND pid <> pg_backend_pid();
def f1(lIn):
l1 = sorted(lIn)
l2 = [i for i in l1 if i>0.5]
return [i*i for i in l2]
def f2(lIn):
l1 = [i for i in lIn if i>0.5]
l2 = sorted(l1)
return [i*i for i in l2]
def f3(lIn):
l1 = [i*i for i in lIn]
l2 = sorted(l1)
return [i for i in l1 if i>(0.5*0.5)]
class C:
pass
type (C ())
type (C) big_num_1 = 1000 big_num_2 = 1000 small_num_1 = 1 small_num_2 = 1 big_num_1 is big_num_2 >>> False small_num_1 is small_num_2 >>> True
_MangledGlobal__mangled = 23
class MangledGlobal:
def test(self):
return __mangled
>>> MangledGlobal().test()
23
Inspired by this article.
#!/usr/bin/env bash
# Prerequisites
# $WORKDIR/.env - environment variables
# awscli installed virtualenv env dir in $WORKDIR
set -e
WORKDIR=
PROJECT=project name
DOCKER_REPO=codebuild docker image
REPO_TAG=latest
cd $WORKDIR
while [[ $# -gt 0 ]]
do
key="$1"
case $key in
-h|--help)
echo ' -s|--skip-build - skip building image'
exit 0
;;
-s|--skip-build)
SKIP_BUILD=yes
;;
*)
echo "Unknown option $2."
exit 2
;;
esac
shift
done
print() {
echo -e "\033[0;33m$1\033[0m"
}
if [ -z "$SKIP_BUILD" ]
then
print 'Starting build'
ARN=$(env/bin/aws codebuild start-build --project-name $PROJECT | python -c 'import json,sys;print(json.load(sys.stdin))["build"]["arn"]')
print "Build started (ARN $ARN)"
print "Waiting 3m"
secs=180
while [ $secs -gt 0 ]; do
echo -ne "Time remaining: ${secs}s...\033[0K\r"
sleep 1
: $((secs--))
done
echo -ne '\033[0K\r'
print "Checking if it's ready."
while [ $(env/bin/aws codebuild batch-get-builds --ids "$ARN" | python -c 'import json,sys;print(json.load(sys.stdin))["builds"][0]["buildComplete"]') != 'True' ]
do
echo "...not ready yet. Waiting 5s."
sleep 5s
done
print "Build's ready. Update docker container."
else
print "Using existing build."
fi
sudo $(env/bin/aws ecr get-login --no-include-email --region us-east-1)
sudo docker pull $DOCKER_REPO:$REPO_TAG
sudo docker tag $DOCKER_REPO $PROJECT
sudo docker rm -f $PROJECT
sudo docker run -d --restart=always --env-file $WORKDIR/.env -p 8001:8000 --name=$PROJECT $PROJECT
print "Update finished."
2016-02-25 15:57:47 DEBUG utils.py:89 (0.055) SET SQL_AUTO_IS_NULL = 0; args=None 2016-02-25 15:57:47 DEBUG utils.py:89 (0.435) SELECT `table`.`id` FROM `table` ORDER BY `table`.`id` ASC LIMIT 10000; args=()
DB_LOG = True
from settings import LOGGING
if DB_LOG:
import logging, re
class QueryFilter(logging.Filter):
def filter(self, record):
# exclude PyCharm debug window queries
return 'LIMIT 21' not in getattr(record, 'sql', '')
class SqlFormatter(logging.Formatter):
def format(self, record):
record.msg = re.sub(r"((?:u?')?\d+(?:u?')?)"
r"(?:,\s*(?:u?')?\d+(?:u?')?)+",
r'\1, ...', record.msg)
return super(SqlFormatter, self).format(record)
params = {
'filters': {
'db_query_filter': {
'()': QueryFilter,
},
},
'formatters': {
'debugging': {
'()': SqlFormatter,
'format': '%(asctime)s %(levelname)-8s %(filename)s:%(lineno)d %(message)s',
'datefmt' : '%Y-%m-%d %H:%M:%S',
},
},
'handlers': {
'db_console': {
'level': 'DEBUG',
'filters': ['require_debug_true', 'db_query_filter'],
'class': 'logging.StreamHandler',
'formatter': 'debugging',
},
},
'loggers': {
'django.db': {
'level': 'DEBUG',
'handlers': ['db_console'],
'propagate': False,
},
}
}
for key, param in params.items():
try:
LOGGING[key].update(param)
except KeyError:
LOGGING[key] = params
#!/bin/sh
if git rev-parse --verify HEAD >/dev/null 2>&1
then
against=HEAD
else
# Initial commit: diff against an empty tree object
against=4b825dc642cb6eb9a060e54bf8d69288fbee4904
fi
# Redirect output to stderr.
exec 1>&2
for F in $(git status --short -uno --porcelain | egrep -v '^D' | awk '{ printf $2"\n"; }')
do
if grep -iq nocommit "$F"; then
cat <<EOF
Error: '$F' containts "no commit" comment.
You must delete it before it can be committed.
EOF
exit 1
fi
done
# NOCOMMIT import pdb a = foo(1, 4) pdb.set_trace()
tar xvfz GeoIP-latest.tar.gzcd GeoIP-1.5.1./configuremakemake checkmake installfunction stringToFloat(str) {
var fractional_part, integer, fractional = "", found = false, i;
// remove leading and trailing non-digit symbols
str = str.replace(/[^\d,\.]+$/, '').replace(/^[^\d,\.]+/, '');
fractional_part = str.slice(-3);
for (i = fractional_part.length - 1; i >= 0; i--) {
if (/\d/.test(fractional_part[i])) {
fractional = fractional_part[i] + fractional;
} else {
found = true;
break;
}
}
if (fractional && found) {
integer = str.slice(0, i - 3);
} else {
integer = str;
fractional = "";
}
return parseFloat(integer.replace(/[^\d]/g, '') + "." + fractional);
}
# remove tags on origin
git ls-remote --tags | awk '/tags\/release.*[^\}]$/ {print ":" $2}' | xargs git push origin
# remove locally
git tag -l | awk '/^release.*$/ {print $1}' | xargs git tag -d
open ~/Library/Preferences/.GlobalPreferences.plist
Drag Me!
$(function () {
var dragImage = document.createElement("img");
dragImage.src = "/image/to/show/when/dragging.jpg";
function handleDragStart(e) {
e.dataTransfer.effectAllowed = 'move';
e.dataTransfer.setDragImage(dragImage, e.layerX, e.layerY);
}
$("#draggableObject").get(0).addEventListener('dragstart', handleDragStart, false);
});
| Command | Description |
|---|---|
:0 | move cursor to the first |
:42 42gg 42G | move cursor to 42nd |
:G | move cursor to the last |
:set number
:set nonumber