Pinned

1. postgres-connect-ssh-tunnel.py postgres-connect-ssh-tunnel.py

   1

   from sshtunnel import SSHTunnelForwarder

   2

   from sqlalchemy.orm import sessionmaker

   3

   from sqlalchemy import create_engine

   4

   from sqlalchemy import inspect

   5

   import pandas as pd

2. Send Message To Telegram From Shell/... Send Message To Telegram From Shell/Terminal

   1

   # Dependency : `Curl` must be preinstalled

   2

   3

   tgm () {

   4

   TOKEN="XXXX" 

   5

   ID="-000000"

3. Maintains directory structure while ... Maintains directory structure while decompiling ".pyc" to ".py" recursively

   1

   # --------- USAGE -----------

   2

   # USE THIS FILE IF YOU WANT TO MAINTAIN DIRECTORY STRUCTURE WHILE DECOMPILING ".PYC" TO ".PY" RECURSIVELY

   3

   # Install Python 

   4

   # Run -> pip install uncompyle6

   5

   # Run -> python decompile_pyc_recursively.py -p [PATH-OF-PYC-DIR]

4. An automated way to install essentia... An automated way to install essential applications on Linux

   1

   #!/bin/bash

   2

   3

   # [+] - USAGE

   4

   #     RUN chmod +x {filename}.sh

   5

   #     RUN as ROOT

5. Helpful_Postgres_Queries_Commands.sql Helpful_Postgres_Queries_Commands.sql

   1

   2

   3

   4

   /*	[+] SHOW RUNNING QUERIES (PRE 9.2) */

   5

   SELECT procpid, age(clock_timestamp(), query_start), usename, current_query

6. python implementation of JSON Struct... python implementation of JSON Structured data pretty print

   1

   import json

   2

   3

   dict="{"employee":{"name":"fahad", "age":0, "city":"No"}}"

   4

   5

   json_data = json.dumps(dict)