Skip to content

Instantly share code, notes, and snippets.

View evilkost's full-sized avatar

Valentin Gologuzov evilkost

24 followers · 5 following
  • Czech Republic, Prague
View GitHub Profile
@evilkost
evilkost / gist:a091e57e6adadf4834c4
Created April 9, 2015 13:25
touch -h -d '-100 day' --time=mtime /etc/mock/*
@evilkost
evilkost / gist:cec8b14703c06e714d95
Created May 26, 2015 13:36
docker images -q --filter "dangling=true" | xargs docker rmi
@evilkost
evilkost / pg_stat.md
Last active August 29, 2015 14:22

Enable module:

vim /var/lib/pgsql/data/postgresql.conf

add at the end:

shared_preload_libraries = 'pg_stat_statements'
# Increase the max size of the query strings Postgres records
track_activity_query_size = 2048
@evilkost
evilkost / linkage_example.txt
Created March 29, 2016 21:01
Root/Video Games & Consoles/Video Game Consoles [Video Game Consoles]:
-> Root/Video Games/Categories/Xbox 360/Consoles[score 52.9318181818182]
Root/Sporting Goods/Indoor Games/Billiards/Tables [Tables]:
-> Root/Sports & Outdoors/Categories/Sports & Fitness/Leisure Sports & Game Room/Billiards & Pool/Tables & Accessories/Tables[score 59.9232954545455]
-> Root/Toys & Games/Categories/Games/Game Room Games[score 26.72]
-> Root/Toys & Games/Categories/Games/Game Room Games/Billiards[score 14.58125]
-> Root/Sports & Outdoors/Categories/Sports & Fitness/Leisure Sports & Game Room/Arcade & Table Games/Tabletop Billiards & Pool[score 8.74875]
Root/Sporting Goods/Cycling/Bicycle Components & Parts/Tires [Tires]:
@evilkost
evilkost / tmp
Created June 3, 2016 19:03
root@85ba14b2a8ab:/opt/pow# echo $PYTHONPATH
/opt/pow:/opt/pow/csn:/opt/pow/zozzymodels:/opt/pow/libs:
root@85ba14b2a8ab:/opt/pow# echo $DJANGO_SETTINGS_MODULE
'csn.settingsdocker'
root@85ba14b2a8ab:/opt/pow# ls -laht /opt/pow/csn/settingsdocker.py
-rw-rw-r-- 1 root root 1.2K Jun 3 13:38 /opt/pow/csn/settingsdocker.py
root@85ba14b2a8ab:/opt/pow# django-admin
Traceback (most recent call last):
File "/usr/local/bin/django-admin", line 11, in <module>
sys.exit(execute_from_command_line())
@evilkost
evilkost / get_host_from_docker.py
Created February 18, 2017 08:23
from subprocess import check_output
host_ip = check_output("/sbin/ip route|awk '/default/ { print $3 }'", shell=True).decode().strip()
@evilkost
evilkost / update all git repos
Created May 2, 2017 09:33
for i in */.git; do ( echo $i; cd $i/..; git pull; ); done
@evilkost
evilkost / pg_check.sh
Created June 18, 2017 21:39
#!/bin/bash
set -e
while [[ `pg_isready &>/dev/null && echo "1"` -ne "1" ]]; do
sleep 1;
echo "pg is not ready";
done
echo "pg is ready";
@evilkost
evilkost / psql drop all tables in schema
Created August 16, 2018 13:50
DO $$ DECLARE
tabname RECORD;
BEGIN
FOR tabname IN (SELECT tablename
FROM pg_tables
WHERE schemaname = current_schema())
LOOP
EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(tabname.tablename) || ' CASCADE';
END LOOP;
END $$;
@evilkost
evilkost / gist:e9889e39752a41b0215a7ce53aa5ab4c
Created January 9, 2019 07:33
pre-commit run --files `git diff --name-only HEAD~ | tr '\r\n' ' '`