Kubectl copy list verify

 export ms1_dir="24624"

export ms2_dir="2327"

case "$1" in

  copy)

    echo "Copying file to pod..."

kubectl cp -n uatcom /home/dev-user-oss/OrderReasonMap.xml uatcom-uat-ms1:/tmp/vfs_cache_oracle/tmp_${ms1_dir}_osmmodel/OracleComms_OSM_O2A_COM_CSO_Solution/2.1.0.3.2/resources/Custom/CustomSolutionConfig/OrderReasonMap.xml

kubectl cp -n uatcom /home/dev-user-oss/OrderReasonMap.xml uatcom-uat-ms1:/tmp/vfs_cache_oracle/tmp_${ms1_dir}_osmmodel/OracleComms_OSM_O2A_COM_CSO_Solution/default/resources/Custom/CustomSolutionConfig/OrderReasonMap.xml

kubectl cp -n uatcom /home/dev-user-oss/OrderReasonMap.xml uatcom-uat-ms2:/tmp/vfs_cache_oracle/tmp_${ms2_dir}_osmmodel/OracleComms_OSM_O2A_COM_CSO_Solution/2.1.0.3.2/resources/Custom/CustomSolutionConfig/OrderReasonMap.xml

kubectl cp -n uatcom /home/dev-user-oss/OrderReasonMap.xml uatcom-uat-ms2:/tmp/vfs_cache_oracle/tmp_${ms2_dir}_osmmodel/OracleComms_OSM_O2A_COM_CSO_Solution/default/resources/Custom/CustomSolutionConfig/OrderReasonMap.xml

;;

  verify)

  echo -e "\n=======Timestamp check $(date)==========\n"

  echo -e "=======MS1==========\n"

  kubectl exec -n uatcom uatcom-uat-ms1 -- ls -ltr /tmp/vfs_cache_oracle/tmp_${ms1_dir}_osmmodel/OracleComms_OSM_O2A_COM_CSO_Solution/2.1.0.3.2/resources/Custom/CustomSolutionConfig/OrderReasonMap.xml

  echo -e "=======MS2==========\n"

  kubectl exec -n uatcom uatcom-uat-ms2 -- ls -ltr /tmp/vfs_cache_oracle/tmp_${ms2_dir}_osmmodel/OracleComms_OSM_O2A_COM_CSO_Solution/2.1.0.3.2/resources/Custom/CustomSolutionConfig/OrderReasonMap.xml

  ;;

  

  list)

    echo "Listing osmmodel directories..."

    echo -e "\n=======MS1 Cache======="

kubectl exec -n uatcom uatcom-uat-ms1 -- ls -ltr /tmp/vfs_cache_oracle

echo -e "\n=======MS2 Cache======="

kubectl exec -n uatcom uatcom-uat-ms2 -- ls -ltr /tmp/vfs_cache_oracle

echo -e "\n***** Update the $0 Script file with the model dir numbers ******\n"

echo -e "\n***** Current values are \n MS1=${ms1_dir} \n MS2=${ms2_dir}\n****** Needs an update ******\n"

    ;;

  *)

    echo "Invalid option"

    echo "Usage: $0 {copy|list|verify}"

    exit 1

    ;;

esac

4*4 Helper

Last 2 Edge pieces

UW => Top 2 rows to be rotated.

Rules : Unsolved edge pieces to be in same Rows with same color

Face the cube in such a way, both Unsolved edges to be kept on right side.

UW←

R↑, U←, R↓

F↻ (Clockwise),R↓,F↺ (Anti-Clockwise)

R↑,UW→

OLL Parity (Final Row + is not formed - 3 Edges are set except one Edge in Top Row For eg : Yellow last layer)

R or L => Block of 2 Columns to be rotated

U => Single Row to be rotated

X => Rotate the whole cube one time, Yellow facing away from you.

R↑ U2, X, R↑ U2, R↑ U2

R↓ U2,L↓ U2,R↓ U2

R↑ U2,

R↓ U2,R↓ U2

PLL Parity ( 2 Corners not solved)

r => 3rd column to be rotated

U => Top Row to be rotated

UW => Top 2 Rows to be rotated

r2, U2

r2, UW2

r2, UW2

Oracle DB All Table rows count

SET SERVEROUTPUT ON; 

DECLARE

    v_table_name VARCHAR2(128);

    v_row_count NUMBER;

BEGIN

    DBMS_OUTPUT.PUT_LINE('TableName#RowsCount');

--owner is schema name

    FOR t IN (SELECT table_name FROM all_tables WHERE owner = 'PROD_ORDERMGMT' and (table_name like 'BTC%' or table_name like 'OM_%')) LOOP

        v_table_name := t.table_name;

        EXECUTE IMMEDIATE 'SELECT COUNT(1) FROM ' || v_table_name INTO v_row_count;

        DBMS_OUTPUT.PUT_LINE(v_table_name ||'#'|| v_row_count);

    END LOOP;

END;

/

Grep text with output as Filename and its count.

 njgrep()
{
if [ $# -eq 0 ] 
then 
echo "Usage: njgrep <Txt to Search> <File Extension>";
elif [ $# -eq 1 ]
then "Only one Argument";
elif [ $# -eq 2 ]
then 
grep -l $1 *.*$2* | xargs grep -c $1;
else 
echo "$# Usage: nj_copy filename [filename]";
fi
}

Testing :

$njgrep "Fallout" out

Search files in Unix which doesn't contain specific Text

Simple Grep command to search all files in a directory 

grep -RiL "Text to search" <Directory to be searched>

Grep command with Find together, searching only those file names which doesn't have a specific text.

find . -name *.automationTask | xargs grep -RiL "sendNullMessage" ;

find . -iname "*.txt" -exec grep -Li "mystring" {} \+

Connect to SQL in Command

 sqlplus user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname.network)(Port=1521))(CONNECT_DATA=(SID=remote_SID)))

Unix : Empty Log files

For multiple files you can use wildcard, example: 

truncate -s 0 /dir/log/*log 

For nested folders: 

truncate -s 0 /dir/log/**/*.log