sathishjayapal

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

• 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

• 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"

• By default azure app services expose port 80. To change port in CLI

  • az webapp config appsettings set --resource-group --name --settings WEBSITES_PORT=8080

ACR commands

sathishjayapal

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

* 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

terraform {
  #Required Terraform version
  required_version = "~>1.3.1"
  required_providers {
    azurerm = {
      source  = "hashicorp/azurerm"
      version = ">=3.0, <=3.24.0"
    }

  }

sathishjayapal

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

sathishjayapal

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

package me.sathish;

public class Main {

    public static void main(String[] args) {
        String simpleJSONData = """
                {
                    "fullName": "%s",
                    "aadress": "%s",
                    "title": "%s"

sathishjayapal

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;