Connect to localhost from Docker container

For Win and Mac:

localhost and 127.0.0.1 – These resolve to the container.
host.docker.internal – This resolves to the outside host.

Reference

RabbitMQ CLI tools

Error Message:

CLI tool fails to authenticate with the server (e.g. due to CLI tool's Erlang cookie not matching that of the server)

Solution from here

Ensure cookies are synchronized across 1, 2 and Optionally 3 below

%HOMEDRIVE%%HOMEPATH%\.erlang.cookie (usually C:\Users\%USERNAME%\.erlang.cookie for user %USERNAME%) if both the HOMEDRIVE and HOMEPATH environment variables are set
%USERPROFILE%\.erlang.cookie (usually C:\Users\%USERNAME%\.erlang.cookie) if HOMEDRIVE and HOMEPATH are not both set
For the RabbitMQ Windows service - %USERPROFILE%\.erlang.cookie (usually C:\WINDOWS\system32\config\systemprofile)

Trimming video using FFMpeg

See here

Freeing up disk space - Linux

Reference: article

sudo apt-get autoremove
Remove apt cache: sudo apt-get clean
sudo journalctl --vacuum-time=3d
Remove old revisions of snaps:

#!/bin/bash
# Removes old revisions of snaps
# CLOSE ALL SNAPS BEFORE RUNNING THIS
set -eu
snap list --all | awk '/disabled/{print $1, $3}' |
    while read snapname revision; do
        snap remove "$snapname" --revision="$revision"
    done

Clean the thumbnail cache:

rm -rf ~/.cache/thumbnails/*

Can use ncdu to check disk space from command line as well.

ImageMagick script for converting .heic to .jpg

import os
import subprocess

lst = os.listdir(".")
for entry in lst:
    if entry.lower().endswith(".heic"):
        fname = os.path.basename(entry).split(".")[0] + ".jpg"
        print(f"Converting {entry} to {fname}")
        ran_proc = subprocess.run(["magick",entry,"-quality","100%",fname])
        if ran_proc.stdout:
            print(f"Stdout is {ran_proc.stdout}")
        if ran_proc.stderr:
            print(f"Stderr is {ran_proc.stderr}")

`pip` installing packages globally

When pip inside virtualenv is installing packages globally check the following:

Try checking your bin/pip and bin/activate scripts. In bin/pip, look at the shebang. Is it correct? If not, correct it. Then on line ~42 in your bin/activate, check to see if your virtualenv path is right. It'll look something like this

VIRTUAL_ENV="/Users/me/path/to/virtual/environment"

If that fails, run the virtual environments pip with its full path.

Reference

How to change user

su - john # if john is the user

Python Requests library using proxy

Set environment variables http_proxy and https_proxy. These can be used by pip as well

Using Azure AD access token for non Microsoft Graph API

See here. They key is that the scopes array should have a single element with: "<YourClientId>/.default.

When following the example here, make sure to replace the scopes with "<YourClientId>/.default.

Replace text using Powershell

(Get-Content .\file.txt) -replace "!", ","  | Set-Content -Path .\replaced.txt

Using PugiXML with Qt

Make sure to include pugi's cpp and headers in the .pro file

Neovim restore Windows Terminal cursor on exit

vim.cmd [[
  autocmd VimLeave * set guicursor=a:ver20a:blinkwait700-blinkoff400-blinkon250-Cursor/lCursor,sm:block-blinkwait175-blinkoff150-blinkon175
]]

Frappe Gantt chart

See here

Using PyPDF2 to decrypt a PDF

See here

Might need to install pyCryptodome first pip install pycryptodome

# Decrypt password-protected PDF in Python.
# cleaned-up version of http://stackoverflow.com/a/26537710/329263
# 
# Requirements:
# pip install PyPDF2
#
# Usage: decrypt_pdf('encrypted.pdf', 'decrypted.pdf', 'secret_password')
import sys

from PyPDF2 import PdfFileReader, PdfFileWriter

def decrypt_pdf(input_path, output_path, password):
  with open(input_path, 'rb') as input_file, \
    open(output_path, 'wb') as output_file:
    reader = PdfFileReader(input_file)
    reader.decrypt(password)

    writer = PdfFileWriter()

    for i in range(reader.getNumPages()):
      writer.addPage(reader.getPage(i))

    writer.write(output_file)
    print(f"Done. wrote to {output_file}")

if __name__ == '__main__':
  input_file = sys.argv[1]
  output_file = sys.argv[2]
  password = sys.argv[3]
  # example usage:
  decrypt_pdf(input_file,output_file,password)

Postgres UPSERT operation

Source: here

Excerpt:

CREATE TABLE inventory(
   id INT PRIMARY KEY,
   name VARCHAR(255) NOT NULL,
   price DECIMAL(10,2) NOT NULL,
   quantity INT NOT NULL
);

INSERT INTO inventory(id, name, price, quantity)
VALUES
	(1, 'A', 15.99, 100),
	(2, 'B', 25.49, 50),
	(3, 'C', 19.95, 75)
RETURNING *;

Here, EXCLUDED means "use the new value"

INSERT INTO inventory (id, name, price, quantity)
VALUES (1, 'A', 16.99, 120)
ON CONFLICT(id) 
DO UPDATE SET
  price = EXCLUDED.price,
  quantity = EXCLUDED.quantity;

Git rebase into forked repo

Excerpted from here

Add the remote (original repo that you forked) and call it “upstream”

git remote add upstream https://github.com/original-repo/goes-here.git

Fetch all branches of remote upstream

git fetch upstream

Rewrite your master with upstream’s master using git rebase.

git rebase upstream/master

Push your updates to master. You may need to force the push with “--force”.

git push origin master --force

`Error parsing ws-trust response`

If this happens, use AcquireTokenInteractive.

Cadence `report` command line tool

To get at the Quick Reports from the command line, use the report command line tool like so:

report -v elp <path to .brd file> <output.txt>

To see a list of all the command line parameters type

report -help

`User has not been granted requested logon`

If seeing this error, follow the steps here

Windows disk cleanup script

Remove-Item -Path "$env:tmp\" -Recurse -Force -ErrorAction SilentlyContinue
Remove-Item -Path "$env:userprofile\appdata\local\Packages\MSTeams_8wekyb3d8bbwe\LocalCache\Microsoft\MSTeams\" -Recurse -Force -ErrorAction SilentlyContinue
Remove-Item -Path "$env:appdata\Code\Service Worker\CacheStorage\" -Recurse -Force -ErrorAction SilentlyContinue
Remove-Item -Path "$env:appdata\Teams\Service Worker\CacheStorage\" -Recurse -Force -ErrorAction SilentlyContinue
Remove-Item -Path "$env:userprofile\appdata\local\Microsoft\Edge\User Data\" -Recurse -Force -ErrorAction SilentlyContinue
Remove-Item -Path "$env:userprofile\appdata\local\Microsoft\vscode-cpptools\" -Recurse -Force -ErrorAction SilentlyContinue
Remove-Item -Path "$env:userprofile\Downloads\" -Recurse -Force -ErrorAction SilentlyContinue

Distutils and Python 3.12

Install setuptools using pip instead as python 3.12 removed distutils.

Zip and unzip on Linux

zip -r <backup.zip> <directory_name>

Example:

zip -r backup.zip my_folder/

Notice that the / is very important! To unzip:

unzip [file_name.zip]

Source

Vim find all in file and show in quickfix window

:vimgrep /pattern/ %

and then

:copen

:cwindow

.vimrc for gvim (Windows)

source $VIMRUNTIME/vimrc_example.vim
source $VIMRUNTIME/mswin.vim

imap jk <Esc>
au VimEnter * imap jk <Esc>
"set guifont=Consolas:h11
set guifont=Cascadia\ Code:h12
set number
"set guifont=Cascadia Code:h11
colorscheme onedark
set encoding=utf-8
"colorscheme summerfruit

set nobackup       "no backup files
set nowritebackup  "only in case you don't want a backup file while editing
set noswapfile     "no swap files
set noundofile

set autoindent
set expandtab
set tabstop=4
set shiftwidth=4
set autoread
set autochdir

autocmd BufNewFile,BufRead *.csv   set filetype=csv_semicolon
autocmd BufNewFile,BufRead *.dat   set filetype=csv_pipe

" let g:plug_shallow = 0
call plug#begin('~/.vim/plugged')
" Plug 'mechatroner/rainbow_csv'
Plug 'prabirshrestha/vim-lsp'
Plug 'mattn/vim-lsp-settings'
Plug 'prabirshrestha/asyncomplete.vim'
Plug 'PProvost/vim-ps1'
Plug 'prabirshrestha/asyncomplete-lsp.vim'
Plug 'junegunn/fzf', { 'do': { -> fzf#install() } }
Plug 'junegunn/fzf.vim'
Plug 'shime/vim-livedown'
call plug#end()

" Live down section reference

" launch the Livedown server and preview your markdown file
" :LivedownPreview

" stop the Livedown server
" :LivedownKill

" launch/kill the Livedown server
" :LivedownToggle

nmap mt :LivedownToggle<CR>

" End Live down section!

" < Other Plugins, if they exist >

" Plug 'fatih/vim-go'
"Plug 'neoclide/coc.nvim', {'do': 'yarn install --frozen-lockfile'}
"Plug 'dense-analysis/ale'
" call plug#end()


" Use the internal diff if available.
" Otherwise use the special 'diffexpr' for Windows.
if &diffopt !~# 'internal'
  set diffexpr=MyDiff()
endif
function MyDiff()
  let opt = '-a --binary '
  if &diffopt =~ 'icase' | let opt = opt . '-i ' | endif
  if &diffopt =~ 'iwhite' | let opt = opt . '-b ' | endif
  let arg1 = v:fname_in
  if arg1 =~ ' ' | let arg1 = '"' . arg1 . '"' | endif
  let arg1 = substitute(arg1, '!', '\!', 'g')
  let arg2 = v:fname_new
  if arg2 =~ ' ' | let arg2 = '"' . arg2 . '"' | endif
  let arg2 = substitute(arg2, '!', '\!', 'g')
  let arg3 = v:fname_out
  if arg3 =~ ' ' | let arg3 = '"' . arg3 . '"' | endif
  let arg3 = substitute(arg3, '!', '\!', 'g')
  if $VIMRUNTIME =~ ' '
    if &sh =~ '\<cmd'
      if empty(&shellxquote)
        let l:shxq_sav = ''
        set shellxquote&
      endif
      let cmd = '"' . $VIMRUNTIME . '\diff"'
    else
      let cmd = substitute($VIMRUNTIME, ' ', '" ', '') . '\diff"'
    endif
  else
    let cmd = $VIMRUNTIME . '\diff'
  endif
  let cmd = substitute(cmd, '!', '\!', 'g')
  silent execute '!' . cmd . ' ' . opt . arg1 . ' ' . arg2 . ' > ' . arg3
  if exists('l:shxq_sav')
    let &shellxquote=l:shxq_sav
  endif
endfunction

`git` compare file in different branches

See here

The syntax is as follows

git difftool [| diff] branch1..branch2 -- <path/to/file/file_to_compare>

Example:

git difftool branch1..branch2 -- ./src/myfile.py

Clearing MEF Component cache

Download the "Clear MEF Component cache" extension as shown here if constantly seeing "Could not load file or assembly" when saving files in Visual Studio 2022.

Evite CSV import

The CSV has to be in the following format (pasted from reference link below):

Column A: First Name (and/or last name, plus any additional guest names if adding families under one contact).
Column B: Email address only (can be left blank if adding guests by phone instead).
Column C: Phone numbers only (can be left blank if adding guests by email instead).
No headers.
No special characters or symbols.
No additional columns filled in.

Sample:

Luke Skywalker,,111-111-1111
Han Solo,,999-999-9999
Chewbacca,,333-333-3333
Obi-Wan Kenobi,,222-222-2222

Reference

Recovering flash drive after using Balena Etcher

Summary:

list disk
select disk N # make sure you select the right one from the listing
clean # cleans the disk

"Add a partition back to it and format it, so that it acts like a normal storage device. Do the following"

create partition primary
select partition 1
format quick

Reference

Typst snippets for VSCode

{
	// Place your snippets for typst here. Each snippet is defined under a snippet name and has a prefix, body and 
	// description. The prefix is what is used to trigger the snippet and the body will be expanded and inserted. Possible variables are:
	// $1, $2 for tab stops, $0 for the final cursor position, and ${1:label}, ${2:another} for placeholders. Placeholders with the 
	// same ids are connected.
	// Example:
	// "Print to console": {
	// 	"prefix": "log",
	// 	"body": [
	// 		"console.log('$1');",
	// 		"$2"
	// 	],
	// 	"description": "Log output to console"
	// }

	"AddFigure": {
		"prefix": "addfig",
		"body" : [
			"#figure(image(\"$1\",width:70%),caption:[$2])"
		],
		"description": "Add figure to typst document"
	},
     "AddTable": {
        "prefix": "addtable",
        "body": [
            "#table(columns: (auto,auto)",
            "table.header([*$1*],[*$2*])", 
            "[$3], [$4])"
        ],
        "description": "Add table to typst document"
    }
}

$dirs = Get-ChildItem $PSScriptRoot |
       Where-Object {$_.PSIsContainer} | # analog of `.Where` Linq function in C#
       Foreach-Object {$_.Name} # analog of `.Select` Linq function in C#

Reference: here

Visual Studio Code vim bindings quickstart Notes

{
    "editor.fontSize": 16,
    "vim.insertModeKeyBindings": [
     {
         "before": ["j", "k"],
         "after": ["<esc>"]
     },
    ],
    "vim.useSystemClipboard": true,
    "vim.useCtrlKeys": false,

    
}

Powershell remote execution with parameters

Invoke-Command -ComputerName "computer-name" -FilePath "path\to\local\script.ps1" -ArgumentList "Argument1","Argument2"

Sample script.ps1

param (
  [Parameter(Position=0)][string]$param1,
  [Parameter(Position=1)][string]$param2
)

Write-Output "Param1: $param1, Param2: $param2"

FFMpeg stitch videos together

To concatenate videos without re-encoding:

/Applications/ffmpeg -f concat -safe 0 -i ./all.txt -c copy entire.mp4

Contents of all.txt:

file './C0043.MP4'
file './C0044.MP4'

Command to create compressed MP4:

ffmpeg -i entire.mp4 -vcodec libx265 -crf 28 output.mp4

Software Blog

Connect to localhost from Docker container

RabbitMQ CLI tools

Trimming video using FFMpeg

Freeing up disk space - Linux

ImageMagick script for converting .heic to .jpg

`pip` installing packages globally

How to change user

Python Requests library using proxy

Using Azure AD access token for non Microsoft Graph API

Replace text using Powershell

Using PugiXML with Qt

Neovim restore Windows Terminal cursor on exit

Frappe Gantt chart

Using PyPDF2 to decrypt a PDF

Postgres UPSERT operation

Git rebase into forked repo

`Error parsing ws-trust response`

Cadence `report` command line tool

`User has not been granted requested logon`

Windows disk cleanup script

Distutils and Python 3.12

Zip and unzip on Linux

Vim find all in file and show in quickfix window

.vimrc for gvim (Windows)

`git` compare file in different branches

Clearing MEF Component cache

Evite CSV import

Recovering flash drive after using Balena Etcher

Typst snippets for VSCode

GNOME Tweaks app

Powershell Notes

Get names of all directories in current script root:

Visual Studio Code vim bindings quickstart Notes

Powershell remote execution with parameters

FFMpeg stitch videos together