doekman

/*Trello rule*/
.card-label .label-text::after {
	content: ' ⚪️'; /*clear label*/
}
.card-label-green .label-text::after {
	content: ' 🟢';
}
.card-label-yellow .label-text::after {
	content: ' 🟡';
}

doekman

#!/usr/bin/env python3

# See blog article: 
#   https://blog.zanstra.com/2020/10/05/Pretty-printing-JSON-with-a-twist.html

import json, re, sys

def json_stringify(obj, indent=2):
    if not isinstance(indent, str):
        indent = ' ' * indent

doekman

Query Trello data with Postgres (JSON)

Recently, I was working on a project to automatically create Trello-cards via their API. To do that, I needed some id-values from the Trello-board which are not shown in the user-interface. But where does one get these values?

Glad you asked. Every Trello-board can be [exported to JSON][trello_export], and the values I was looking for are available in this export. However, JSON gives you the data in one big piece of text. Wouldn't it be handier to have it available as tabular data in a database?

So I created [this git-repository][git_repo] to do just that (you will need the [Postgres][postgresql]-database for this).

The table in which the JSON is stored, is modelled after an [idea of Rob Conery][conery] which basically is: store the JSON in a column, along with another column that uniquely identifies the document. This unique value is also available within the JSON itself.

doekman

class OkBash < Formula
  desc ".ok folder profiles for bash"
  homepage "https://github.com/secretGeek/ok-bash"
  url "https://github.com/secretGeek/ok-bash/archive/v0.8.1.tar.gz"
  sha256 "ec2d65dc617948d071012b7076f47fa0e23e2f47bf3b56ee07a7c5978dd07b50"

  bottle :unneeded

  def install
    (prefix/"etc/profile.d").install "ok.sh"

doekman

#!/usr/bin/env bash
# Unofficial Bash Strict Mode
set -euo pipefail
IFS=$'\n\t'

function group_on_date {
    awk $'NR==1 {
            cur_year=substr($1,1,4)
            cur_month=substr($1,6,2)
            printf "## %s\\n", cur_year

doekman

#!/usr/bin/env bash
# Unofficial Bash Strict Mode
set -euo pipefail
IFS=$'\n\t'

function git_url_to_https {
    local git_url

    git_url=$(cat)
    if [[ $git_url =~ ^git@([^:]+):(.+)(\.git)?$ ]]; then

doekman

#!/usr/bin/env bash

# Unofficial Bash Strict Mode
set -euo pipefail
IFS=$'\n\t'

# import ok
if [[ -r "$_OK__PATH_TO_ME/ok.sh" ]]; then
    . "$_OK__PATH_TO_ME/ok.sh" prompt '=> ' prompt_default
fi

doekman

Keybase proof

I hereby claim:

• I am doekman on github.
• I am doekman (https://keybase.io/doekman) on keybase.
• I have a public key ASDhb5zNrn5eL3RhB4nBo_1cfnuGQTArjuOMtBi-mUt_tQo

To claim this, I am signing this object:

doekman

#!/usr/bin/env bash

function usage {
	echo "Usage: $(basename $0) $1 [-n|-i|-a]

Arguments:
  -n or --name:  show name of language (default)
  -i or --id:    show id of language
  -a or --all:   show 'id:name' of language 
  -e or --error: (for TESTING) to generate an AppleScript error"

doekman

import logging
from enum import Enum

def _has_newline(line):
    """Used by has_bad_header to check for \\r or \\n"""
    if line and ('\r' in line or '\n' in line):
        return True
    return False

def _is_bad_subject(subject):