amzar96

CREATE OR REPLACE PROCEDURE grant_all_permissions(target_user TEXT)
AS $$
DECLARE
    schema_record RECORD;
BEGIN
    IF target_user IS NULL OR target_user = '' THEN
        RAISE EXCEPTION 'username cannot be null or empty';
    END IF;

    FOR schema_record IN 

amzar96

Text to Comma-Separated String Converter

Setup

1. Ensure Python is installed on your system.
2. Save convert-text-list.py and convert-to-list.sh in the same directory.
3. Make the bash script executable:

   chmod +x convert-to-list.sh
   

amzar96

function awslogin() {
    local profile_name=$1
    aws sso login --profile $profile_name
    export AWS_PROFILE_NAME=$profile_name
    echo change the AWS_PROFILE_NAME to $profile_name
}

RPROMPT='%{$fg[cyan]%}%* %{$fg[yellow]%}($AWS_PROFILE_NAME)%{$reset_color%}'

amzar96

datelist=('20240501' '20240502' '20240503' '20240504')

for date in "${datelist[@]}"; do
    mkdir -p "/Users/mohdamzar96/Downloads/$date"
    aws s3 sync "s3://bucket-name/by-date/$date/" "/Users/mohdamzar96/Downloads/$date"
done

amzar96

unset SSH_AUTH_SOC && \
podman machine stop && \
podman machine set --cpus 4 --memory 3048 && \
podman machine start && \
podman image ls

amzar96

'''
Credit to https://github.com/vitalik/django-ninja/issues/104#issuecomment-805939752 🔥

python '3.11.6'
django '4.2.7'
ninja '1.0.1'
pydantic '2.5.2'
'''

from ninja import Router

amzar96

terraform {

  cloud {
    organization = "xxxx"

    workspaces {
      name = "s3-creation"
    }
  }