simonthompson99

Running

python -m pudb <python_file> - opens up the script in pudb window, not executed anything yet. For fire modules better to make separate script that executes the individual function of interest, difficult to debug the original main file. Need pudb in virtualenv.

Or:

from pudb import set_trace
...
set_trace()

simonthompson99

Ranger Cheatsheet

General

Shortcut	Description
ranger	Start Ranger
Q	Quit Ranger
R	Reload current directory
?	Ranger Manpages / Shortcuts

simonthompson99

%s/_\(\d\{9}\).png/, '\1',/g - Find an underscore followied by 9 digits and then .png and replace it with the 9-digit number

simonthompson99

Basics

Command	Alias	Description
git init <directory>		Create empty Git repo in specified directory. Run with no arguments to initialize the current directory as a git repository.
git clone <repo>	gcl	Clone repo located atonto local machine. Original repo can be located on the local filesystem or on a remote machine via HTTP or SSH.
git config user.name <name>		Define author name to be used for all commits in current repo. Devs commonly use --global flag to set config options for current user.
git add <directory>	ga/gaa	Stage all changes in for the next commit. Replace with a to stage a specific file.
git commit -m "<message>"	gc/gcmsg	Commit the staged snapshot, but instead of launching a text editor, use as the commit message.
git status	gst/gss	List which files are staged, unstaged, and untracked.

simonthompson99

update schema.table t
set cola = u.cola
from 
(
    select * from (values
      (1, 'fdjkl'),
      (2, 'reiuuio'),
      (3, 'adfgd')
    ) as t (id, cola)
) u 

simonthompson99

#!/bin/bash
# script to rsync then move load of files, quicker than individual scp
# usage: bash rsync_rename.sh files.txt
# where files.txt is a pipe-separated file of <remote_path>|<local_path_to_move_to>
input_file=$1
files_to_rsync=$(cut "-d|" -f1 $input_file)
echo $files_to_rsync | tr " " "\n" | rsync -arvzh --progress sthompson@10.1.24.38:/ /tmp --files-from=- 
cat $input_file | while IFS='|' read src dest; do
src="/tmp${src}"
mkdir -p "$(dirname "${dest}")"

simonthompson99

#!/bin/bash
current_time=$(date "+%Y%m%d-%H%M")
file_name="db_bu_$current_time.sql"
echo $file_name
pg_dump -h 10.1.24.39 -U cdt_user --schema consent_audit metrics > $file_name

simonthompson99

create sequence testes.test_id_seq
;

create or replace function pseudo_encrypt(value int) returns int as $$
declare
l1 int;
l2 int;
r1 int;
r2 int;
i int:=0;

simonthompson99

def progress_bar(iterable, prefix='Progress', suffix='Complete', decimals=1,
                 length=50, fill='=', printEnd="\r"):
    """
    shows a terminal progreess bar as iterations are passed through, use as
    for i in progress_bar(range(1000)):
    	pass
    :params: iteration: current iteration
    :params: total: total iterations
    :params: prefix: prefix string
    :params: suffix: suffix string

simonthompson99

brew services stop postgresql
rm /usr/local/var/postgres/postmaster.pid
brew services start postgresql