Mario Bisignani bisignam

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

## read csv and print single quotes around values
 cat gun_to_change.csv | awk -F ',' '{print "update t_company set gun_number = \x27"$3"\x27 where gun_number = \x27"$2"\x27;" }'

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

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

## gist:a204907f3488abbfe15ddf4ef8e2ffa2
split -n6 FR_TH01HOTE_201909271427_clean.sql FR_TH01HOTE_201909271427_clean FR_TH01HOTE_201909271427_clean --additional-suffix=.sql

## add CA cert on CentOS Debian Ubuntu.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                bisignam
                / add CA cert on CentOS Debian Ubuntu.md
            
            
              Created
              September 13, 2019 10:47
                — forked from kekru/add CA cert on CentOS Debian Ubuntu.md
            
              
                Add CA cert to local trust store on CentOS, Debian or Ubuntu
              
          
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


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

## gist:a6f8b84a15d9d4436063b1d5239e6476
git branch -d feature/login
git push origin --delete feature/login

## find_largest_tables.sql
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;

## debug_requests.py
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)
	git branch -d feature/login
	git push origin --delete feature/login
	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;
	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)