checco

--
-- Change database owner
--

ALTER DATABASE "db_name" OWNER TO user;

--
-- List schemas
--

checco

#!/bin/bash

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

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

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

function deleteWorkouts() {
    const deleteWorkoutElements = document.querySelectorAll('.delete-workout');

    if (deleteWorkoutElements.length === 0) {
        console.log('No more "delete-workout" elements found.');
        return;
    }

    deleteWorkoutElements[0].click();