Skip to content

Instantly share code, notes, and snippets.

View chetanppatil's full-sized avatar

Chetan Patil chetanppatil

7 followers · 3 following
View GitHub Profile
@chetanppatil
chetanppatil / install-postman.sh
Last active June 10, 2023 17:11
Install Native Postman On Linux
#!/bin/bash
# Download Postman
cd /tmp || exit
echo "Downloading Postman..."
wget -q https://dl.pstmn.io/download/latest/linux?arch=64 -O postman.tar.gz
# Extract and install Postman to /opt
echo "Extracting and installing to /opt..."
sudo tar -xzf postman.tar.gz -C /opt/
@chetanppatil
chetanppatil / Github Pages IMP Links
Last active October 28, 2019 08:43
@chetanppatil
chetanppatil / angularCaseSensitiveRouting.js
Created April 17, 2018 05:31
AngularJs 1.x Case Sensitive Routing
/* ============= Angular-Case-Insensitive-State-Routing ============== */
var app = angular.module('urlRoute', [])
.config(['$stateProvider', '$urlRouterProvider', function($stateProvider, $urlRouterProvider) {
$urlRouterProvider.otherwise('/login');
$urlRouterProvider.rule(function ($injector, $location) {
//what this function returns will be set as the $location.url
var path = $location.path(), normalized = path.toLowerCase();
if (path != normalized) {
@chetanppatil
chetanppatil / get_all_depending_functions.sql
Created April 24, 2018 11:07
Get all functions depending on specified table in postgre
/* HERE
table name is "my_table"
\m and \M mark the beginning and end of a word in the regexp match.
*/
SELECT n.nspname AS schema_name
,p.proname AS function_name
,pg_get_function_arguments(p.oid) AS args
,pg_get_functiondef(p.oid) AS func_def
FROM (SELECT oid, * FROM pg_proc p WHERE NOT p.proisagg) p
@chetanppatil
chetanppatil / regex.js
Created April 30, 2018 05:50
Most commonly used regex, ES6
const phoneRegx = RegExp(/^[0]?[789]\d{9}$/)
const emailRegx = RegExp( /^(([^<>()\[\]\\.,;:\s@"]+(\.[^<>()\[\]\\.,;:\s@"]+)*)|(".+"))@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}])|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2,}))$/)
let phoneNumber = '9999999999'
let email = 'a@gmail.com'
console.log('PHONE REGX:= ', phoneRegx.test(phoneNumber));
console.log('EMAIL REGX:= ', emailRegx.test(email));
@chetanppatil
chetanppatil / get_json_key_value.sql
Last active May 11, 2018 10:31
Get/Select values from array of json in PostgreSQL
SELECT ele->>'partCode' FROM json_array_elements('[{"partCode": "sdvsv", "partName": "sdvfv", "problemCatagory": "Dock Related"}]'::json) AS ele
@chetanppatil
chetanppatil / get_values_as_column_from_json.sql
Created May 11, 2018 10:26
Select data from json and insert it into single row and multiple column
CREATE TABLE my_table(col text, col2 text)
/* SELECT DATA FROM JSON */
SELECT * FROM json_each('{"a":"foo", "b":"bar"}') AS e
/* INSERT INTO TABLE */
INSERT INTO my_table(col, col2)
SELECT * FROM json_to_record('{"a":"foo", "b":"bar"}') AS x(col text, col2 text) -- as can have different column name
SELECT * FROM my_table
@chetanppatil
chetanppatil / ngRepeat-ngModel-example.html
Created May 11, 2018 11:56
Get data for each row in ng-repeat, ng-model radio button and text box
<!DOCTYPE html>
<html>
<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.6.9/angular.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/underscore.js/1.9.0/underscore-min.js"></script>
<body>
<div ng-app="myApp" ng-controller="myCtrl">
<div ng-repeat="item in myArr" class="form-group row">
@chetanppatil
chetanppatil / install-sonar-scanner.sh
Last active December 28, 2023 04:31
Install sonar-scanner in linux mint, ubuntu...
#!/bin/bash
cd /tmp || exit
echo "Downloading sonar-scanner....."
if [ -d "/tmp/sonar-scanner-cli-4.7.0.2747-linux.zip" ];then
sudo rm /tmp/sonar-scanner-cli-4.7.0.2747-linux.zip
fi
wget -q https://binaries.sonarsource.com/Distribution/sonar-scanner-cli/sonar-scanner-cli-4.7.0.2747-linux.zip
echo "Download completed."
@chetanppatil
chetanppatil / teminate-connection-postgres.sql
Created July 26, 2018 06:04
Terminate connection/session in PostgreSQL
SELECT
pg_terminate_backend(pid)
FROM
pg_stat_activity
WHERE
-- don't kill my own connection!
pid <> pg_backend_pid()
-- don't kill the connections to other databases
AND datname = '<db-name-here>';