swateek

// pm.globals.clear(); // Be careful with this usage

// Save common tests in a global variable
postman.setGlobalVariable("commonTests", () => {
  pm.test("Common Tests - Response Time", function(){
    pm.expect(pm.response.responseTime).is.lessThan(500);
  });

  pm.test("Common Tests - Content Type", function(){
    pm.expect(pm.response.headers.get('Content-Type')).equals('application/json');

swateek

-- https://www.digitalocean.com/community/tutorials/working-with-json-in-mysql

-- select rows where isPrivate field is ""
SELECT * FROM ecom_categories WHERE JSON_EXTRACT(`attributes` , '$.isPrivate') = "";

-- select rows where isPrivate field is not a part of JSON object
SELECT * FROM ecom_categories WHERE JSON_EXTRACT(`attributes` , '$.isPrivate') IS NULL;

-- add isPrivate field to attributes which are not present
UPDATE ecom_categories SET `attributes` = JSON_INSERT(`attributes`, '$.isPrivate', false);

swateek

#!/bin/bash

# Print an introduction line in cyan
printf "\033[0;36mPre-commit hook - For Checking Tabs in Golang Files...\033[0m \n"

# Grab feed of staged files 
files=$(git diff --name-only --cached  -- "*.go")
numfiles=$( printf '%s' "$files" | grep -c '^' )

if [ $numfiles -eq 0 ]

swateek

# using mongodump
mkdir swateek
mongodump --db="stats" --out="./swateek" --gzip
cd swateek
tar cvzf ../db_backup.tar.gz *

# using mongorestore
tar -xvzf db_backup.tar.gz
mongorestore --gzip --db="stats" --noIndexRestore stats/

swateek

# Everything Pymongo

swateek

'''
  https://stackoverflow.com/a/43491315/1844056
'''

def keys_exists(element, *keys):
    '''
    Check if *keys (nested) exists in `element` (dict).
    '''
    if not isinstance(element, dict):
        raise AttributeError('keys_exists() expects dict as first argument.')

swateek

#!/bin/bash

help()
{
    echo "Invalid Arguments Supplied.."
    echo "############## Use one from below ##############"
    echo "'./run_db.sh --start' for starting MongoDB server"
    echo "'./run_db.sh --stop' for stopping MongoDB server"
    echo "'./run_db.sh --clean' for clean restart of MongoDB server"
}

swateek

#!/usr/bin/bash

echo -ne "[#]   10%\r"
sleep 1
echo -ne "[##]  20%\r"
sleep 1
echo -ne "[###]  30%\r"
sleep 1
echo -ne "[####]  40%\r"
sleep 1

swateek

import numpy as np
from numpy.linalg import norm


class Kmeans:
    '''Implementing Kmeans algorithm.'''

    def __init__(self, n_clusters, max_iter=100, random_state=123):
        self.n_clusters = n_clusters
        self.max_iter = max_iter

swateek

#!/usr/bin/python

import os
import sys
import tarfile
import subprocess
from datetime import datetime
from pymongo import MongoClient

class UpgradeMongo():