Skip to content

Instantly share code, notes, and snippets.

View ajomathew's full-sized avatar
🏠
Working from home

Ajo Mathew ajomathew

🏠
Working from home
View GitHub Profile
@ajomathew
ajomathew / azAPPGW.parameters.json
Created September 30, 2021 01:08
Azure ARM template with multiple copy properties - Parameters
{
"$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentParameters.json#",
"contentVersion": "1.0.0.0",
"parameters": {
"location": {
"value": "australiaeast"
},
"applicationGatewayName": {
"value": "testappgatway"
},
@ajomathew
ajomathew / azAPPGW.json
Created September 30, 2021 01:06
Azure ARM template with multiple copy properties
{
"$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
"contentVersion": "1.0.0.0",
"parameters": {
"location": {
"type": "string"
},
"applicationGatewayName": {
"type": "string"
},
@ajomathew
ajomathew / azNsgCopy.parameters.json
Created September 30, 2021 00:50
azNsGCopy Parameters
{
"$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentParameters.json#",
"contentVersion": "1.0.0.0",
"parameters":{
"networkSecurityGroupsSettings": {
"value": {
"securityRules": [
{
"name": "RDPAllow",
"description": "allow RDP connections",
@ajomathew
ajomathew / azNsgCopy.json
Created September 30, 2021 00:43
Azure ARM Copy Function with Objects
{
"$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
"contentVersion": "1.0.0.0",
"parameters": {
"networkSecurityGroupsSettings": {
"type": "object"
}
},
"resources": [
@ajomathew
ajomathew / azGetVMSKU.ps1
Created June 5, 2021 11:41
This script can be used to find the VM Source Image available SKU in Azure
# Finding your SKUs for your VM
$locName = Read-Host 'Enter which location you want'
#List Publishers
# $locName="<Azure location, such as West US>"
Get-AzVMImagePublisher -Location $locName | Select PublisherName
$pubName=Read-Host 'Enter publisher your want'
Get-AzVMImageOffer -Location $locName -PublisherName $pubName | Select Offer
$offerName=Read-Host 'Enter the offer'
@ajomathew
ajomathew / resume.json
Last active March 21, 2021 15:38
resume.json
{
"$schema": "https://raw.githubusercontent.com/jsonresume/resume-schema/v1.0.0/schema.json",
"basics": {
"name": "Jijo Mathew",
"label": "Accountant",
"image": "",
"phone": "+971.Numb",
"url": "https://linkedin.com/in/jijo-mathew-85925b65",
"summary": "Jijo has earned degrees from MG University Kottayam, Kerala, India. Before starting Noora Pharmacy Group, he worked for an NGO based out of India and firms of auditing and taxation. His work mostly focus on Accounting and Auditing he has experince on Finance and Admin part as well, his non-work interests range widely, everything from <hobby>.",
"location": {
@ajomathew
ajomathew / generateExcel.py
Created November 19, 2020 09:48
Generate a excel sheet from csv files located in a from same folder
import pandas as pd
import numpy as np
import os, fnmatch
listofcsvs = os.listdir(".")
pattern = "*.csv"
GNF = pd.ExcelWriter('Consolidated.xlsx')
for file in listofcsvs:
if fnmatch.fnmatch(file, pattern):
print(file)
@ajomathew
ajomathew / twitterhashgenerator.js
Created October 3, 2020 02:03
Java Script to filter Words from string starting with capital letter and add a # before it
var str = 'Why most Hacktoberfest PRs are from India'
var txt = ""
var hash = str.match(/\b([A-Z].*?)\b/g);
hash.reverse();
hash.pop();
for (i = 0 ; i < hash.length; i++){
txt = txt + ' #'+ hash[i]
}
txt
@ajomathew
ajomathew / sedURL.sh
Last active July 23, 2020 15:34
Find and Replace URL using sed in file
sed -i 's/exports.pw.*/exports.pw= "'$(neo4jPassword)'"/g' $(Build.Repository.LocalPath)/MetadataManagementDashboard_1/app/static/js/JS_neo4j_settings.js
sed -i 's,http://localhost:7474/db,http://'$(acrURL)':7474/db,g' $(Build.Repository.LocalPath)/MetadataManagementDashboard_1/app/static/js/JS_neo4j_settings.js
sed -i 's,http://localhost:3000,http://'$(acrURL)':3000,g' $(Build.Repository.LocalPath)/MetadataManagementDashboard_1/app/static/js/JS_neo4j_settings.js
cat $(Build.Repository.LocalPath)/MetadataManagementDashboard_1/app/static/js/JS_neo4j_settings.js
@ajomathew
ajomathew / sql-windows-azure.tf
Created May 24, 2020 09:43
To deploy Azure SQL VM using terraform - ARM Template referenced https://gist.github.com/ajomathew/a3bf1bc6ce00e9e6967af917ae20c222
# Provider Def
provider "azurerm" {
features {
virtual_machine {
delete_os_disk_on_deletion = true
}
}
version = "2.10"
}