Skip to content

Instantly share code, notes, and snippets.

View sathishjayapal's full-sized avatar
🎯
Focusing

dotsky sathishjayapal

🎯
Focusing
View GitHub Profile
@sathishjayapal
sathishjayapal / console.sql
Created August 25, 2024 03:47
Sampel DB SQL
SELECT datname FROM pg_database;
CREATE TYPE gender AS ENUM ('male', 'female', 'other');
create table test_db.students (id serial primary key, name varchar(100), age int, gender gender,contact_no varchar(10)
,enroll_date date, created_at timestamp default now(), updated_at timestamp default now());
SELECT column_name, data_type, character_maximum_length, is_nullable, column_default
FROM information_schema.columns
WHERE table_name = 'students' AND table_schema = 'test_db';
INSERT INTO test_db.students (name, age, gender, contact_no, enroll_date)
VALUES ('John Doe', 20, 'male', '1234567890', '2023-10-01');
@sathishjayapal
sathishjayapal / dockercmds.md
Created March 12, 2024 15:45
Docker copy paste commands
  • docker pull artifactory.company.com:portnumber/postgres
  • docker container ls --format "table {{.ID}}\t{{.Image}}\t{{.Names}}" (awesome output)
  • docker container ls --filter "status=paused" (paused container)
  • docker container ls (Running Containers)
  • docker container ls -a (all running containers)
  • docker container ls -n 2 (last two containers)
  • docker container ls -q (quiet mode)
  • docker container ls --latest -s (container size)
  • docker rm 8b17532f30c6 (remove container)
  • docker rm -f mycontainer (forcefully remove container)
@sathishjayapal
sathishjayapal / commands.md
Last active July 4, 2023 19:32
az commands list
  • az login --use-device-code
  • az vm list
  • az vm list --query '[].{name:name, resourceGroup:resourceGroup, tags:tags}' -o json
  • az vm update -g 1-3EA18CD3-PLAYGROUND-SANDBOX -n sathish-tags-testvm --set tags.MarkForDeletion=Yes
  • az network vnet list --query '[].{name:name, resourceGroup:resourceGroup, tags:tags}' -o json
  • az resource tag --tags "Dept=IT" "Environment=Production" "CreatedBy=Sathish" --resource-group playground-sandbox -n sathish-tags-testvm-vnet --resource-type "Microsoft.Network/VirtualNetworks"
    • az webapp config appsettings set --resource-group --name --settings WEBSITES_PORT=8080

ACR commands

@sathishjayapal
sathishjayapal / ParseFile.java
Last active February 26, 2023 00:03
Boiler plate for Parsing filr
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.IOException;
class Scratch {
private static final Logger logger = LoggerFactory.getLogger(Scratch.class);
@sathishjayapal
sathishjayapal / dockerissue-md
Last active February 8, 2023 04:07
Docker startup issues -mac
* With the mac OS Monterey, there is an issue when Docker startup from a startup, which is not a one-off issue for me. With the latest docker desktop, when Docker tries to startup, this is the error that I get.
Creating "rootNode" subnodes: constructing "BackendServices" in "rootNode": doing migrations: migrating daemon.json: invalid character '{' after top-level value
* There was no specific issue/answer I could get from the community, so I looked up the daemon.json file, and there that led me to this folder in my machine, /Users/<mymacid>/Library/Group Containers/group.com.docker.
* To start the daemon, I deleted the folder
* Restart the Docker desktop.
Things are working well. Hopefully, this gist helps.
@sathishjayapal
sathishjayapal / multiple-providers-sample
Created October 6, 2022 02:02
sample for multiple providers template
terraform {
#Required Terraform version
required_version = "~>1.3.1"
required_providers {
azurerm = {
source = "hashicorp/azurerm"
version = ">=3.0, <=3.24.0"
}
}
azure
account
list [options] #List the imported subscriptions
show [options] [subscriptionNameOrId] #Show details about a subscription
set [options] <subscriptionNameOrId> #Set the current subscription
clear [options] #Remove a subscription or environment, or clear all of the stored account and environment info
import [options] <file> #Import a publishsettings file or certificate for your account
download [options] #Launch a browser to download your publishsettings file
env... #Commands to manage your account environment

AZ- Service principal commands

Loging with service principal credentials. Remember the tenant parameter

az login --service-principal -u -p --tenant

List the role definitions - List all the role definitions

az role definition list --all

List the role assignments - Lists all the role assignments

az role assignment list --all

You can find the same information by running the following command in the Cloud Shell. They are listed in the Additional Outbound IP Addresses field.

az webapp show \

@sathishjayapal
sathishjayapal / Main.java
Created March 24, 2022 04:11
Java 18 JSON String
package me.sathish;
public class Main {
public static void main(String[] args) {
String simpleJSONData = """
{
"fullName": "%s",
"aadress": "%s",
"title": "%s"
package me.sathish.aws.common;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import software.amazon.awscdk.core.Tags;
import software.amazon.awscdk.services.s3.Bucket;
import java.io.IOException;
import java.io.InputStream;
import java.time.LocalDateTime;