tinogis

import redis

r = redis.StrictRedis(host='redis')
l = r.keys('rq:job:*')
deleted_jobs = 0
total_jobs = len(l)
for j in l:
    if 'dependents' in j:
        continue
    print 'Job {}'.format(j)

tinogis

# -*- coding: utf-8 -*-
from ftplib import FTP
import click
from datetime import datetime
try:
    from urllib.parse import urlparse
except:
    from urlparse import urlparse
import os

tinogis

from erppeek import Client
import sys
import base64
from subprocess import call
import time

#report = 'giscedata.facturacio.factura'
#ids = [1513047, 1513049, 1513057, 1513042]
#ids = [1513042]

ecarreras

Checklist

• Create user replication in the master

sudo -u postgres psql -c "CREATE USER rep REPLICATION \
LOGIN ENCRYPTED PASSWORD 'thepassword';"

• Modify postgresql.conf in the master

listen_address = # make sure we're listening as appropriate
wal_level = hot_standby

ecarreras

Sitecustomize

Fix for unicode can't decode ascii...

tinogis

#!/bin/bash
d_repo=( $(git remote -v | grep '\(push\)' | cut -d':' -f 2 | \
cut -d' ' -f 1 | cut -d '.' -f 1) )
d_base="developer"
d_from=gisce:$(git branch --no-color 2> /dev/null | grep '^\*' | \
cut -d ' ' -f 2)

read -p "User:" user
read -sp "Password:" password
echo

ecarreras

Paralize your scripts with Redis

1. Setup your redis server
2. Install python-rq
3. Clone this gist
4. Start n workers
5. Run tas_rq.py
6. Wait workers do the job :)

ecarreras

VERSION="2.35.0"

ecarreras

#!/usr/bin/env python

import xmlrpclib
import sys

def run_test(host, port, dbname, uid, pwd, tid):
    sock = xmlrpclib.ServerProxy('https://%s:%d/xmlrpc/ws_transaction'
                                 % (host, port))
    sock.commit(dbname, uid, pwd, tid)
    sock.close(dbname, uid, pwd, tid)

andreyvit

tmux cheat sheet

(C-x means ctrl+x, M-x means alt+x)

Prefix key

The default prefix is C-b. If you (or your muscle memory) prefer C-a, you need to add this to ~/.tmux.conf:

remap prefix to Control + a