Tag: if

Shell: Misc Commands

In this tutorial I will show a few useful commands when working with linux shell.

Check Directory Exists:

  1. if [ -d /opt/test/ ]; then
  2.     echo 'Directory Exists'
  3. fi

Check Directory Not Exists:

  1. if [ ! -d /opt/test/ ]; then
  2.     echo 'Directory Does Not Exist'
  3. fi

Check File Exists:

  1. if [ -f /opt/test/test.log ]; then
  2.     echo 'File Exists'
  3. fi

Check File Not Exists:

  1. if [ ! -f /opt/test/test.log ]; then
  2.     echo 'File Does Not Exist'
  3. fi

Lowercase Variable:

  1. val='TEXT'
  2. echo "${val,,}"

Echo Variable:
This will print the value of “test”. Notice we use double quotes.

  1. test='My Test Val'
  2. echo "$test"

Echo String:

  1. echo 'My test string'

Split:
This will split on the comma into an array list and then loop through it.

  1. test='test 1,test 2'
  2. split_test=(${test//,/ })
  3.  
  4. for val in "${split_test[@]}"
  5. do
  6.     echo $val
  7. done

Date:
This will print the date in the format YYYY-MM-dd

  1. my_date="$(date +Y-%m-%d)"
  2. echo "$my_date"

Remove Space From Variable:

  1. VAL='test string'
  2. echo "${VAL//\ /}"

Increment Variable:

  1. index=0
  2. index=$((index+1))

Substring

  1. VAL='test string'
  2. echo "${VAL:4:4}"

If value is equal to

  1. VAL='hello'
  2. if [ "$VAL" == 'hello' ] ; then
  3.     echo 'Is Equal'
  4. fi

If with OR

  1. VAL='hello'
  2. if [ "$VAL" == 'hello' ] || [ "$VAL" != 'hi' ] ; then
  3.     echo 'Is Hello'
  4. fi

If Variable is Empty

  1. VAL=''
  2. if [ -z "$VAL" ] ; then
  3.     echo 'Is Empty'
  4. fi

Append to File

  1. echo 'Hi' >> file_to_log_to.log

Write to File

  1. echo 'Hi' > file_to_log_to.log

While Loop: Increment to 10

This will loop till the value is 9 then exit.

  1. i=0
  2. while [ $i -lt 10 ];
  3. do
  4.     echo "$i"
  5. done

whoami

  1. USER=$(whoami)

If Variable Contains Text

  1. VAL='my Test String'
  2. if [[ "${VAL,,}" == *"test"* ]] ; then
  3.     echo "Found test"
  4. fi

Color Coding

  1. NoColor=$'\033[0m'
  2. READ=$'\033[0;31m'
  3. GREEN=$'\033[0;32m'
  4. YELLOW=$'\033[1;33;40m'
  5.  
  6. printf "%s Variable Not Set %s\n" "${RED}" "${NoColor}"

Get Log to a logfile and console

  1. SOME_COMMAND 2>&1 | tee -a "${LOG_FILE_PATH}"

Read a JSON config

  1. JSON=$(cat "/path/to/json/file.json")
  2. export MY_VAR=$(echo "${JSON}" | python -c 'import json,sys;obj=json.load(sys.stdin);print(obj["MyKey"])')

Extract tar to Folder

  1. sudo tar -xvf /the/location/file.tar -C /to/location/ --force-local --no-same-owner

Update Certificates

This will update certificates. After you put a certificate in /usr/local/share/ca-certificates/

  1. update-ca-certificates

PipeStatus

  1. somecommand
  2. RETURN_CODE=${PIPESTATUS[0]}

Postgres: Misc

Here are some misc things you can do in postgres 9.4.

Print to Console:

  1.  raise notice 'VALUE: %', value;

Json Build Object:

  1.  json_build_object('name', value, 'name2': value2)

Json Array:

  1.  json_agg(data)

Extract Month:
You can also extract year, day, etc.

  1.  extract(month from date_column)

Json Querying:
You can extract a field from a json field. You can do:

  1.  rec->>'id'
  2. rec#>'{field, sub_field,value}'
  3. rec->'object'

Row To Json:

  1.  SELECT row_to_json(t)
  2. FROM mytable t

Update With FROM:

  1.  UPDATE mytable l
  2. SET old_val_id=sub.new_val_id
  3. FROM (
  4.      SELECT l2.id, s.id as new_val_id
  5.      FROM mytable l2
  6.           INNER JOIN mysupertable s ON s.id=l2.old_val_id
  7. ) sub
  8. WHERE sub.id=l.id;

Inline Script:

  1.  DO $do$
  2. DECLARE id integer;
  3. BEGIN      
  4.  
  5. END $do$ LANGUAGE plpgsql;

If:

  1.  IF CONDITION THEN
  2. END IF;

Let’s say you have a json field and in that field you have a field which tells you what key you should select for certain data. It could be customizable from the user entering data. To dynamically select that field you can do the below.

  1. jsonField->((to_json((jsonField->'key'->'sub_key'))#>>'{}')::text)

Upsert:
Sometimes we want to perform update if the record exists or an insert if it doesn’t. Most of the time we write a function that deals with this on a record by record basis. But what if we want to do a batch update or insert. What do we do then. We perform an upsert. See below. We write the update and return the result in the remainder of the query  we check if upsert gave us anything. If it didn’t we perform the insert.

  1. WITH upsert AS (UPDATE MyTable mt
  2.             SET column_name = sub.new_value
  3.             FROM (SELECT mot.id, mot.new_value 
  4.                  FROM MyOtherTable mot
  5.                  ) sub
  6.             WHERE sub.id=mt.related_id 
  7. RETURNING *) 
  8. INSERT INTO MyTable (id, column_name, related_id) 
  9. SELECT ?, ?, ? 
  10. WHERE NOT EXISTS (SELECT * FROM upsert)

Regex Substring:
There are different ways of using regex. This is one way.

  1. substring(column_name from '([0-9]{4}-[0-9]{2}-[0-9]{2})')

PGSQL Loop:
This is one way to loop using pgsql.

  1. DO $do$
  2. DECLARE rec RECORD;
  3. BEGIN
  4. 	FOR rec IN SELECT * FROM MyTable
  5. 	LOOP
  6. 		--We can then use rec like rec.colum_name
  7. 	END LOOP;
  8. END $do$ LANGUAGE plpgsql;

Milliseconds to timestamp:

This will return 2017-08-17 21:26:04

  1. select to_timestamp(1503005165);