dmmeteo

"""
Single Responsibility Principle
“…You had one job” — Loki to Skurge in Thor: Ragnarok
A class should have only one job. 
If a class has more than one responsibility, it becomes coupled. 
A change to one responsibility results to modification of the other responsibility.
"""

class Animal:
    def __init__(self, name: str):

harshithjv

# Killing all celery processes involves 'grep'ing on 'ps' command and run kill command on all PID. Greping
# on ps command results in showing up self process info of grep command. In order to skip that PID, 'grep
# -v grep' command is piplined which executes 'not' condition on 'grep' search key. The 'awk' command is
# used to filter only 2nd and 'tr' command translates result of 'awk' command output from rows to columns. 
# Piplining 'kill' command did not work and so the entire process has been set as command substitution, i.e.,
#  '$()'. The redirection at the end is not mandatory. Its only to supress the enitre output into background.

kill -9 $(ps aux | grep celery | grep -v grep | awk '{print $2}' | tr '\n' ' ') > /dev/null 2>&1

Nikolay-Lysenko

from time import sleep
from io import StringIO

import psycopg2


def upsert_df_into_postgres(df, target_table, primary_keys, conn_string,
                            n_trials=5, quoting=None, null_repr=None):
    """
    Uploads data from `df` to `target_table`

JamesMGreene

Initialize

gitflow	git
git flow init	git init
	git commit --allow-empty -m "Initial commit"
	git checkout -b develop master

Connect to the remote repository

rgreenjr

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'