jlainezs

# ---------------------------------------------------------------
# add the service in the docker-compose.yml file
# use .env file to define
#   CLOUD_SQL_INSTANCE
#   CLOUD_SQL_PORT
#   GC_SQL_SERVICE_CREDENTIALS_FILE
#
# @link https://cloud.google.com/sql/docs/sqlserver/connect-docker
# ----------------------------------------------------------------
cloud_sql_service:

jlainezs

#! /usr/bin/env bash

# Add Ondrej's PPA - Follow screen indications
sudo add-apt-repository ppa:ondrej/php
sudo apt update

# installs PHP 8.1, 8.2, 8.3 with some usual packages
sudo apt install php8.{1,2,3}-{cli,common,curl,mbstring,mysql,opcache,readline,xdebug,xml,zip,bz2,intl}

# Choose PHP version - Follow screen indications

jlainezs

#!/usr/bin/env bash
# ------------------------------------------------
# Downloads last backup from production
# and restores it into the local database
#
# requires:
#   - gcloud with authenticated access
#   - mysqlcredentials.cnf file
# ------------------------------------------------

jlainezs

#!/usr/bin/env bash

# Build tool
# Writes the compiled executables in ./build
#
# see https://www.digitalocean.com/community/tutorials/how-to-build-go-executables-for-multiple-platforms-on-ubuntu-16-04
package=$1
if [[ -z "$package" ]]; then
  echo "usage: $0 <package-name>"
  exit 1

jlainezs

#!/usr/bin/env bash

# Backup up database tables
# Requires a credentials files on
# ./mysqlcredentials.cnf
#
# CAUTION
# If you have running Google's sqlproxy you could end messing with the remote mysql!

CURRENT_TIME=$(date "+%Y%m%d-%H%M%S")

jlainezs

Using several accounts on the same git service with ssh

We need to create an alternative certificate for the second account (pk stored in id_rsa.myotheridentity).

WARNING: when generating the new credentials take care not to overwrite any id_rsa and id_rsa.pub files you may have in ~/.ssh

Edit ssh config in ~/.ssh/config . Create it if not exists.

Host gitlabmyproject

jlainezs

# https://golangdocs.com/golang-download-files
package main
 
import (
    "fmt"
    "io"
    "log"
    "net/http"
    "net/url"
    "os"

jlainezs

<?php
namespace Traits;

use Joomla\CMS\Factory;
use Throwable;
use Exceptions\NestedSetNodeNotFoundException;
use Exceptions\ParentNotDefinedException;
use Exceptions\UnexpectedException;
use NestedSetPointer;

jlainezs

# Zip changed files on a branch checked out from an initial branch.
# Open a terminal on the repository root.
# Tested with Git Bash. Requires 7z installed

# get the last commit on the updated branch 
git merge-base initial_branch_name updated_branch_name

# get the changed files name (with full path)
git diff --name-only COMMIT_ID > diff-filelist.txt

jlainezs

wsl --export docker-desktop-data docker-desktop-data.tar
wsl --unregister docker-desktop-data
wsl --import docker-desktop-data <NEW_PATH>\docker-desktop-data.tar

eventually restarting docker desktop is required.