philipp-zettl

Download helper for Humble-Bundle purchases

The other day I wanted to backup my e-books I purchased on Humble-Bundle. You can use the script below to backup your e-books as well!

Follow these steps:

Log into your huble-bundle account
visit https://www.humblebundle.com/home/library
open the network tabs and look out for a request to https://www.humblebundle.com/api/v1/orders?all_tpkds=true
save the response in a file on your local disk, e.g. ~/Downloads/bundles.json
run the script

Sometimes one wants to execute several commands in a docker container.
To fix the issue with searching for the right container name, proper paths and to prevent running several instances of a container on a single machine. I created a workflow to solve this issue.

The idea is simple, we create a bash script which handles 3 things for us

verify that docker is running
search for container name
run a provided command in an interactive tty

To use this approach company-wide one needs to introduce fixed structure or adjust the script on each machine.
Disclaimer: tested under arch linux, no clue how to handle situations without systemctl as well as absence of commands like awk or docker-compose might cause trouble.

Django

Deprecations:

3.0

dropped support for postgres <= 9.4
django.db.backends.postgresql_psycopg2 now called django.db.backends.postgres
field_name keyword argument of QuerySet.earliest() and latest() is removed

3.1

django.contrib.postgres.fields.JSONField and django.contrib.postgres.forms.JSONField are deprecated in favor of models.JSONField and forms.JSONField.
A model’s Meta.ordering doesn’t affect GROUP BY queries.

	# install prerequisites
	sudo pacman -S k9s terraform helm aws-cli kubectl

	# install tgenv (terragrunt version manager)
	git clone https://github.com/cunymatthieu/tgenv.git ~/.tgenv
	echo 'export PATH="$HOME/.tgenv/bin:$PATH"' >> ~/.bash_profile

	source ~/.bash_profile
	tgenv install 0.58.2
	tgenv use 0.58.2

	#!/usr/bin/env bash

	PYTHON_VERSION=${PYTHON_VERSION:-3.10.14}
	CUR_DIR="$(pwd)"

	TEMP_DIR="$(mktemp -d)"

	cd "${TEMP_DIR}"

	git clone https://github.com/python/cpython .

	/**
	* Proxy API methods to search and retrieve MongoDB collections and their schemas
	*/

	function search(request){
	// Make a POST request with form data.
	var formData = {
	'uri': request.connection,
	'db_name': request.database,
	'collection_name': request.collection,

	package main


	import (
	"bytes"
	"log"
	"io/ioutil"
	"net/url"
	"net/http"
	"net/http/httputil"

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

	#!/bin/bash

	source $(poetry env info \| grep "$(poetry env list \| awk '{print $1}')" \| head -1 \| awk '{print $2}')/bin/activate

	## collapsible markdown?

	<details><summary>CLICK ME</summary>
	<p>

	#### yes, even hidden code blocks!

	```python
	print("hello world!")
	```