knudmoeller

knudmoeller

<?php

function parseMarkdownLink(string $link) {
    $pattern = "/^\[(.+?)\]\((.*?)\)$/";
    if (preg_match($pattern, $link, $matches)) {
        return [
            "label" => $matches[1] ,
            "link" => $matches[2]
        ];
    }

knudmoeller

knudmoeller

require 'cgi'

filename = ARGV[0]
File.open(filename).each { |line| puts CGI.unescape(line) }

knudmoeller

curl ${BASE_URI}/catalog.jsonld | jq -r '.[] | select(."@id" | endswith("/catalog.jsonld?page=1")) | ."http://www.w3.org/ns/hydra/core#lastPage" | .[0]."@value" | split("=") | .[1]'

knudmoeller

#!/bin/bash

# The CKAN Action-API endpoint:
DATENREGISTER_API_BASE="https://datenregister.berlin.de/api/3/action/"

# Query filtering datasets that came in through the FIS-Broker harvester
QUERY="berlin_source:harvest-fisbroker"

# date_updated refers to the when the data (not the metadata) was updated last
SORT="date_updated+desc"

knudmoeller

Perform OR queries for categories on Microsoft Outlook for Mac

Bizarrely, one cannot make OR queries in Microsoft Outlook for Mac, at least not easily. For example, I want a smart folder that contains all messages tagged with either the FIS Broker category or the Dubletten category.

The way to do it non-easily is to select Raw Query as the query rule type (in Search > Advanced), and then enter a Spotlight query string. The attribute to query for categories is com_microsoft_outlook_categories. That attribute takes a numeric id - but what the hell is the id for a category like FIS Broker? Outlook doesn't tell me, so I have to go even deeper down the rabbit hole. Here is how:

knudmoeller

drush sqlq 'select count(node.nid) as node_count, node_type.type from node inner join node_type on node.type = node_type.type group by node_type.type'

knudmoeller

from ckanapi import RemoteCKAN
import os

# require ckanapi: https://github.com/ckan/ckanapi

package_names = [
    "versickerung-aus-niederschlagen-2017-umweltatlas-wfs-beb56dfa",
    "versickerung-aus-niederschlagen-ohne-versiegelung-2017-umweltatlas-wfs-e4a931f6",
    "versiegelung-2005-unkorrigierte-versiegelungsgrade-rasterdaten-atom-451f714b",
    "versiegelung-2011-unkorrigierte-versiegelungsgrade-rasterdaten-atom-c973b948",

knudmoeller

jq "{date: .dump_finished, count: .datasets | length}" sorted/*.json | jq -s