bhubr

// 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]")

bhubr

PostgreSQL quickstart macOS/homebrew

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

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

Run psql -U postgres

bhubr

// 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 () => {

bhubr

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

bhubr

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
```

bhubr

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.

bhubr

[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

bhubr

{
  "singleQuote": true
}

bhubr

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

• GZIP/BZIP2 progress indicator
• Pipe Viewer home page

bhubr

VBoxManage

List VMs

VBoxManage list vms

Result: