Nick Venenga nijave

## borg-qdirstat.py
"""
See section about "Reading and writing cache files" for how this works
with QDirStat https://github.com/shundhammer/qdirstat/blob/master/README.md?plain=1#L848

`borg list` should run without prompting for credentials. See borg docs for configuring
environment variables https://borgbackup.readthedocs.io/en/stable/quickstart.html#automating-backups
"""
import dataclasses
import datetime
import gzip

## fix_truncate_json.py
def fix_truncated_json(err_json: str) -> str:
    """closes open delimiters so json is parseable"""
    stack = []
    expect_literal = False
    last_literal = []
    for i, c in enumerate(err_json):
        if c == '"':
            if i > 0 and err_json[i-1] == '\\':
                continue
            if stack[-1] == '"':

## Python requests with retries configured
# see https://findwork.dev/blog/advanced-usage-python-requests-timeouts-retries-hooks/

import requests

from requests.adapters import HTTPAdapter, Retry

class TimeoutHTTPAdapter(HTTPAdapter):
    DEFAULT_TIMEOUT = 30

    def __init__(self, *args, **kwargs):

## directory-stats-watcher.py
#!/usr/bin/env python3

"""
Use inotify to monitor the file count and size of a given directory.

There may be small race conditions that lead to count/size errors
so output should be considered a close estimate.

* Requires only Python 3 stdlib & Linux
"""

## leekduck-box-scraper.py
from bs4 import BeautifulSoup
import pandas as pd
import requests
import re
import json

search_url = "https://leekduck.com/boxsales/"

headers = {
    "User-Agent": "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0",

## archive-org-capture-dates.py
import requests

search_url = "https://leekduck.com/boxsales/"

headers = {
    "User-Agent": "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0",
    "Referer": "https://web.archive.org/web/*"
}

sparklines = requests.get(

## migrate.sh
#!/bin/bash

export PGSSLMODE=prefer

DATABASE=postgres
USER=postgres
SOURCE_PASSWORD=postgres

SOURCE_HOST=$(docker inspect postgres-5433 | jq -r '.[0].NetworkSettings.IPAddress')
SOURCE_PORT=5432

## ssh-pod.sh
#!/usr/bin/env bash

pod_name=nick-ssh

# the first node
k8s_node=$(kubectl get nodes -o jsonpath='{.items[0].metadata.name}')

cat <<EOF | kubectl create -f -
apiVersion: v1
kind: Pod

## crystal-disk-mark-fio-bench.sh
#!/bin/bash

LOOPS=3 # How many times to run each test
SIZE=10240 # Size of each test, multiples of 32 recommended for Q32 tests to give the most accurate results.
WRITEZERO=0 # Set whether to write zeroes or randoms to testfile (random is the default for both fio and crystaldiskmark); dd benchmarks typically only write zeroes which is why there can be a speed difference.

QSIZE=$(($SIZE / 32)) #Size of Q32Seq tests
SIZE+=m
QSIZE+=m

## jellyfin-contine-watching.sql
SELECT
  key, COALESCE(ti.SortName, mi.sortname) SortName, COALESCE(ti.Path, mi.Path) Path
FROM UserDatas u
LEFT JOIN TypedBaseItems ti
ON
  u.key = ti.UserDataKey
  OR REPLACE(u.key, '-', '') = ti.PresentationUniqueKey
LEFT JOIN MediaItems mi
ON
  REPLACE(u.key, '-', '') = mi.PresentationUniqueKey
	"""
	See section about "Reading and writing cache files" for how this works
	with QDirStat https://github.com/shundhammer/qdirstat/blob/master/README.md?plain=1#L848

	`borg list` should run without prompting for credentials. See borg docs for configuring
	environment variables https://borgbackup.readthedocs.io/en/stable/quickstart.html#automating-backups
	"""
	import dataclasses
	import datetime
	import gzip
	def fix_truncated_json(err_json: str) -> str:
	"""closes open delimiters so json is parseable"""
	stack = []
	expect_literal = False
	last_literal = []
	for i, c in enumerate(err_json):
	if c == '"':
	if i > 0 and err_json[i-1] == '\\':
	continue
	if stack[-1] == '"':
	# see https://findwork.dev/blog/advanced-usage-python-requests-timeouts-retries-hooks/

	import requests

	from requests.adapters import HTTPAdapter, Retry

	class TimeoutHTTPAdapter(HTTPAdapter):
	DEFAULT_TIMEOUT = 30

	def __init__(self, args, *kwargs):
	#!/usr/bin/env python3

	"""
	Use inotify to monitor the file count and size of a given directory.

	There may be small race conditions that lead to count/size errors
	so output should be considered a close estimate.

	* Requires only Python 3 stdlib & Linux
	"""
	from bs4 import BeautifulSoup
	import pandas as pd
	import requests
	import re
	import json

	search_url = "https://leekduck.com/boxsales/"

	headers = {
	"User-Agent": "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0",
	#!/bin/bash

	export PGSSLMODE=prefer

	DATABASE=postgres
	USER=postgres
	SOURCE_PASSWORD=postgres

	SOURCE_HOST=$(docker inspect postgres-5433 \| jq -r '.[0].NetworkSettings.IPAddress')
	SOURCE_PORT=5432
	#!/usr/bin/env bash

	pod_name=nick-ssh

	# the first node
	k8s_node=$(kubectl get nodes -o jsonpath='{.items[0].metadata.name}')

	cat <<EOF \| kubectl create -f -
	apiVersion: v1
	kind: Pod
	#!/bin/bash

	LOOPS=3 # How many times to run each test
	SIZE=10240 # Size of each test, multiples of 32 recommended for Q32 tests to give the most accurate results.
	WRITEZERO=0 # Set whether to write zeroes or randoms to testfile (random is the default for both fio and crystaldiskmark); dd benchmarks typically only write zeroes which is why there can be a speed difference.

	QSIZE=$(($SIZE / 32)) #Size of Q32Seq tests
	SIZE+=m
	QSIZE+=m
	SELECT
	key, COALESCE(ti.SortName, mi.sortname) SortName, COALESCE(ti.Path, mi.Path) Path
	FROM UserDatas u
	LEFT JOIN TypedBaseItems ti
	ON
	u.key = ti.UserDataKey
	OR REPLACE(u.key, '-', '') = ti.PresentationUniqueKey
	LEFT JOIN MediaItems mi
	ON
	REPLACE(u.key, '-', '') = mi.PresentationUniqueKey