checco

#!/bin/bash

for dir in `find . -type d -not -path '*/.*'`; 
do 
  echo -en "${dir}: "; 
  find ${dir} -type f -not -path '*/.*' -exec md5sum {} \; | md5sum | awk '{print $1}'; 
done

checco

# FusionAuth database has tables which don't have primary keys this is a problem from the Digital Ocean perspective,
# because they are using row-based replication with the MySQL engine to provide backups and read replicas.
# We have migrated 2 environments, from MySQL 8 to PostgreSQL 12

# pgloader help
docker run --rm --name pgloader dimitri/pgloader:latest pgloader --help

# run pgloader
docker run --rm --name pgloader dimitri/pgloader:latest pgloader --no-ssl-cert-verification --verbose --debug \
"mysql://odyssey-auth:${mysql_password}@${digitalocean_mysql_host}:25060/odyssey-auth"

checco

#!/bin/bash

git for-each-ref --format '%(refname:short)' refs/heads | grep -v master | xargs git branch -D

checco

--
-- Change database owner
--

ALTER DATABASE "db_name" OWNER TO user;

--
-- List schemas
--

checco

#!/bin/bash

url="https://releases.hashicorp.com/vault"
latest_version=`curl -s ${url}/ | grep -A6 "<a href=\"../\">../</a>" | grep vault | cut -d '_' -f 2 | cut -d '<' -f 1`
bin="/usr/local/bin/vault"

install () {
  cd /tmp && \
  /bin/wget -q ${url}/${latest_version}/vault_${latest_version}_linux_amd64.zip && \
  /bin/unzip -qq vault_${latest_version}_linux_amd64.zip

checco

#!/bin/bash

url="https://releases.hashicorp.com/terraform"
latest_version=`curl -s ${url}/ | grep -A6 "<a href=\"../\">../</a>" | grep terraform | cut -d '_' -f 2 | cut -d '<' -f 1`
bin="/usr/local/bin/terraform"

install () {
  cd /tmp && \
  /bin/wget -q ${url}/${latest_version}/terraform_${latest_version}_linux_amd64.zip && \
  /bin/unzip -qq terraform_${latest_version}_linux_amd64.zip

checco

--
-- Read only 
--

-- Create a group
CREATE ROLE postgres_ro_group;

-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO postgres_ro_group;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO postgres_ro_group;

checco

require 'uri'
require 'net/http'

url = URI("http://www.hostelspoint.com/webservices/affiliates/json.php?IDSite=2336&requestType=AvailSearchCity&day=11&year_month=2016-11&nights=1&guests=1&currency=EUR&cat=&lang=en&order=&room_type=&city=190")

http = Net::HTTP.new(url.host, url.port)

request = Net::HTTP::Get.new(url)
request["cache-control"] = 'no-cache'

checco

require 'uri'
require 'openssl'
require 'net/http'

url = URI("https://www.hostelspoint.com/xml/xml.php")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
http.verify_mode = OpenSSL::SSL::VERIFY_NONE

checco

require 'uri'
require 'openssl'
require 'net/http'

url = URI("https://www.hostelspoint.com/xml/xml.php")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
http.verify_mode = OpenSSL::SSL::VERIFY_NONE