Benoît Hubert bhubr

PostgreSQL quickstart macOS/homebrew

https://stackoverflow.com/questions/15301826/psql-fatal-role-postgres-does-not-exist

install: brew install postgres
initdb /usr/local/var/postgres
/usr/local/Cellar/postgresql@11/11.22_1/bin/createuser -s postgres

Run psql -U postgres

Sanitize WordPress SQL dump

You might run into errors while injecting a WP SQL dump into a local db (say your remote db is MySQL 5+ and your local one is MySQL 8).

In this case…

1. make a copy of the dump

cp orig-dump.sql sanitized-dump.sql

Convert macOS ANSI-colored terminal output to HTML

ansi2html is a much better solution. Why didn't I think of it before 😅🤷‍♂️?

Tested on macOS but should work on Linux.
Requires Node.js (any recent version will do).
Put package.json and convert.js in the same dir, and run npm i there.
In macOS Terminal, run shell command and redirect its stdout or stderr to a file, e.g. gls --color ~/Documents > gls-output.txt.
Run node convert gls-output.txt.
Open out.html in your browser.

bzip2 progress bar with pv (Pipe Viewer)

Context: I was attempting to compress a fairly big (16Gb) file with bzip2, but had no idea of how much time it would take.

The solution I came up with isn't perfect, since it doesn't show an actual percentage, but it still gives an idea of what's going on, since it prints the compressed file's current size, along with the elapsed time.

Sources

VBoxManage

List VMs

VBoxManage list vms

Result:

	// paste & run in browser console, at:
	// https://gitlab.com/<login>/<repo>/-/pipelines/<pipeline id>/builds
	(() => {
	const jobsTable = document.querySelector("[data-testid=jobs-tab-table]");
	const rows = jobsTable.querySelectorAll("tbody tr");
	const jobs = Array.from(rows)
	.reverse()
	.map((row) => {
	const duration = row
	.querySelector("[data-testid=job-duration]")

	// test/specs/cart.e2e.ts
	import { expect, browser, $ } from "@wdio/globals";
	import registerUser from "../helpers/register-user";

	describe("Cart", () => {
	// Ce test comporte plusieurs problèmes
	// 1. bug de l'app qui fait qu'on ne peut ajouter des items au panier que connecté
	// CORRIGÉ si vous avez mergé la dernière version de main
	// 2. composante aléatoire qui fait qu'on est pas sûr qu'un produit soit dispo
	it("user connected - should add items to cart", async () => {

	Assuming I put this in `~/.ssh/config`:

	```

	Host gitlab-public
	HostName gitlab.com
	User gluser
	ForwardAgent yes
	IdentityFile /Users/myuser/.ssh/id_ed25519_gitlab_public
	```

	[Unit]
	Description=SonarQube service
	After=syslog.target network.target

	[Service]
	Type=forking

	ExecStart=/opt/sonarqube/bin/linux-x86-64/sonar.sh start
	ExecStop=/opt/sonarqube/bin/linux-x86-64/sonar.sh stop

	{
	"singleQuote": true
	}