|#Broken somehow. need to fix|
|SELECT COUNT(*) as datname, datname, datid FROM pg_stat_activity GROUP BY datname;|
|#Works without id|
|SELECT COUNT(*) as datname, datname FROM pg_stat_activity GROUP BY datname;|
|#based on a stackoverflow answer, I currently can't find.|
|def unicode_csv_reader(utf8_data, dialect=csv.excel, **kwargs):|
|helper function: a generic csv reader function adapted to unicode|
|unicode_reader = csv.reader(utf8_data, dialect=dialect, encoding = 'windows-1255', **kwargs)# opening the file with python csv reader|
#Setting up a windows 7 python dev computer
Set up a dev folder in root with subfolders: projects, programs, custom, envs.
Set a HOME (Check specific) variable to point to c:\dev\custom so .dot files should go there.
Python: install python 2.7.X 32bit in dev\programs also easy_install pip,and pip install virtualenv.
Install virtualenv-wrapper for windows and sets WORKON_HOME to c:\dev\envs
|#Inspired by https://gist.github.com/jbergantine/3870080|
|#Since every `git pull` is actually a merge. We can use it to automaticly run basic Django tasks after pulling from the upstream master branch (or any other)|
|#Notice: This won't run at git fetch. since fetch doesn't merge anything|
|# copy this script with the name:`post-merge.sh` to your project root folder|
|# symlink it to the ./git/hooks/post-merge: `ln post-merge.sh .git/hooks/post-merge|
|#You should have bash (windows users, means cygwin/mingw anything that works for you|
|#Based on the instructions here: https://oknesset-devel.readthedocs.org/en/latest/workflow.html#before-coding|