manuthu

import os
import pyarrow.parquet as pq
import pandas as pd
import mysql.connector
import concurrent.futures
import logging
import time

logging.basicConfig(level=logging.INFO)
logger = logging.getLogger('DB')

manuthu

-- 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%' 

manuthu

# Install the nifty client
# pip install git+https://github.com/east36/python-nifty-client.git

import logging
from niftyclient import NiftyClient


logging.basicConfig(level=logging.DEBUG)
logger = logging.getLogger('STK')

manuthu

sudo su postgres
psql

update pg_database set datistemplate=false where datname='template1';
drop database Template1;
create database template1 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;
update pg_database set datistemplate=true where datname='template1';

manuthu

#!/usr/bin/env bash

set -e


DB_USER=<db-user>
DB_HOST=<db-host>
DB_NAME=<db-name>

CSV_FILE_NAME=<Reports>

manuthu

# Sample Nginx config with sane caching settings for modern web development
#
# Motivation: 
# Modern web development often happens with developer tools open, e. g. the Chrome Dev Tools. 
# These tools automatically deactivate all sorts of caching for you, so you always have a fresh 
# and juicy version of your assets available.
# At some point, however, you want to show your work to testers, your boss or your client. 
# After you implemented and deployed their feedback, they reload the testing page – and report 
# the exact same issues as before! What happened? Of course, they did not have developer tools 
# open, and of course, they did not empty their caches before navigating to your site. 

manuthu

#!/bin/bash

set -e

# Database clone script.

# ENV
# dev, staging, demo, prod
ENV=dev

manuthu

Get the user_id from the console/portal

List all the files belonging to the user . For this case, we use - 6a76bf01-dc90-4996-a846-8472cb086565

rados ls -p .rgw.buckets | grep 6a76bf01-dc90-4996-a846-8472cb086565

Save the files to a log file

manuthu

-- db=# \d order_payment
--                    Table "public.order_payment"
--      Column       |            Type             | Collation | Nullable | Default
-- -----------------+-----------------------------+-----------+----------+---------
-- id                | uuid                        |           | not null |
-- order_id          | uuid                        |           |          |
-- amount_paid       | numeric                     |           |          |
-- ...

select

manuthu

# Get all running routers. Routers in cloudstack are prefixed with `r-DIGIT`
RUNNING_VMS=$(xe vm-list | grep -A2 -B2 'r-[0-9]' | grep uuid | awk -F':' '{print $2}')
SRID=8c269040-fc42-c12d-b091-8958784ec65e

for vm_id in $RUNNING_VMS
do
  xe vbd-list vm-uuid=$vm_id | grep vdi-uuid | awk -F':' '{print $2}' | xargs -I {} xe vdi-list uuid={} | grep $SRID  && echo $vm_id
done