brccabral

SQL Custom Script

Set the environment variable DB_PASS. It will briefly create a temp file, execute it and load the password as PSSQL variable. The file is deleted.
Then, connect to the DB and run custom.sql.

set DB_PASS=secret
sqlplus /nolog @run_custom.sql

brccabral

CMake print all variables matching pattern

Helper function that prints all variables matching pattern

function(print_cmake_variables_matching pattern)
    get_cmake_property(_variableNames VARIABLES)
    string(TOLOWER "${pattern}" pattern_lower)
    foreach (_variableName ${_variableNames})
        string(TOLOWER "${_variableName}" variable_lower)

brccabral

import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText


class Email:
    def __init__(self, from_: str, to: list[str], subject: str):

        self.from_ = from_
        self.to = to

brccabral

Git Tips

Hook: post-receive

I have a repo on my machine, MyApp, I have a Bare Git Repo on a remote server production at /home/userName/MyApp.
When pushing to remote production, I need to update the code in the actual location /var/www/MyApp, but it needs root/sudo permission.

In the bare repo, add file /home/userName/MyApp/hooks/post-receive. This file is always executed after a push.
The idea is to execute this:

#!/bin/bash

brccabral

Firefly III with Plaid Connector

A free and open source personal finance manager https://firefly-iii.org/

Documentation https://docs.firefly-iii.org/

Need to setup .env, .db.env and .importer.env before running docker compose.

The Importer is a separated web app (created by Firefly III) to support import of external files (CSV and other formats).
More details https://docs.firefly-iii.org/how-to/data-importer/installation/docker/

brccabral

VNC server on Ubuntu Desktop

Followed these initial instructions
https://www.youtube.com/watch?v=3K1hUwxxYek

The video asks to install lightdm, but there is no need, we can use gdm3.
Install x11vnc.

sudo apt update

brccabral

// Original from https://gist.github.com/jouyouyun/669726de58df8d333666
// Compile: gcc xgrabkey.c `pkg-config --cflags --libs x11` -o xgrabkey

#include <stdio.h>
#include <string.h>
#include <X11/Xlib.h>
#include <X11/Xutil.h>

int main()
{

brccabral

Pihole

Before anything, check your docker log settings. I had Unbound consuming 17GB alone.
https://docs.docker.com/config/containers/logging/json-file/
/etc/docker/daemon.json

{
  "log-opts": {
    "max-size": "20m",
    "max-file": "3"

brccabral

Screen Capture

C++

Linux

Get the pixels from X11 display and open the image in OpenCV window. Wayland yet to find out.

apt install libopencv-dev

brccabral

Keystroke

C++

Linux

Send a keystroke to focused window.
Compile with -lX11 -lXtst

Python