bisignam

find . -maxdepth 1 -type f '!' -newermt '2020-12-31' -print0 | xargs -0 rm

bisignam

 cat gun_to_change.csv | awk -F ',' '{print "update t_company set gun_number = \x27"$3"\x27 where gun_number = \x27"$2"\x27;" }'

bisignam

find . -mtime +10 -type d -exec rm -rf {} \;

bisignam

sed $'s/[^[:print:]\t]//g' FR_TH01HOTE_201909271427.sql

bisignam

split -n6 FR_TH01HOTE_201909271427_clean.sql FR_TH01HOTE_201909271427_clean FR_TH01HOTE_201909271427_clean --additional-suffix=.sql

bisignam

• Open a webpage that uses the CA with Firefox
• Click the lock-icon in the addressbar -> show information -> show certificate
• the certificate viewer will open
• click details and choose the certificate of the certificate-chain, you want to import to CentOS
• click "Export..." and save it as .crt file
• Copy the .crt file to /etc/pki/ca-trust/source/anchors on your CentOS machine
• run update-ca-trust extract
• test it with wget https://thewebsite.org

bisignam

egrep  '^.*?[#~%@¢?^$£§¬¼¿½¤]+.*?$' file.txt

bisignam

git branch -d feature/login
git push origin --delete feature/login

bisignam

SELECT CONCAT(table_schema, '.', table_name),
       CONCAT(ROUND(table_rows / 1000000, 2), 'M')                                    rows,
       CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G')                    DATA,
       CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G')                   idx,
       CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
       ROUND(index_length / data_length, 2)                                           idxfrac
FROM   information_schema.TABLES
ORDER  BY data_length + index_length DESC;

bisignam

import requests
import logging
import httplib

# Debug logging
httplib.HTTPConnection.debuglevel = 1
logging.basicConfig()
logging.getLogger().setLevel(logging.DEBUG)
req_log = logging.getLogger('requests.packages.urllib3')
req_log.setLevel(logging.DEBUG)