bokwoon95

#!/usr/bin/env bash
set -e
set -u
set -o pipefail
INPUT_PATH="$1"
OUTPUT_PATH="$2"
if test ! -f "$INPUT_PATH"; then
echo "INPUT_PATH $INPUT_PATH does not exist"
exit 1
fi

bokwoon95

#!/usr/bin/env bash
sudo apt-get update -y
sudo apt-get install -y git tmux libvips libvips-tools sqlite3
sudo apt-get upgrade -y
curl --location --output go.tgz "https://dl.google.com/go/$(curl https://go.dev/dl/?mode=json | grep -o '"version": "go.*"' | head -n 1 | xargs | cut -d ' ' -f 2).linux-$(dpkg --print-architecture).tar.gz"
sudo tar -xzf go.tgz --directory /usr/local
rm go.tgz
sudo ln -sf /usr/local/go/bin/go /usr/local/bin/go
sudo ln -sf /usr/local/go/bin/gofmt /usr/local/bin/gofmt
sudo ln -sf "$HOME/go/bin/notebrew" /usr/local/bin/notebrew

bokwoon95

#!/bin/sh

echo 'linux amd64 "Intel Linux"
linux arm64 "ARM Linux"
darwin amd64 "Intel macOS"
darwin arm64 "Apple Silicon macOS"
windows amd64 "Intel Windows"' | tr '\n' '\0' | xargs -0 -I{} -P4 sh -c 'f() {
  echo "os=$1 arch=$2 desc=$3";
}; f {}'

bokwoon95

nmap <buffer> <expr> <Plug>(fern-my-open-expand-collapse)
  \ fern#smart#leaf(
  \   "<Plug>(fern-action-open)",
  \   "<Plug>(fern-action-expand)",
  \   "<Plug>(fern-action-collapse)",
  \ )
nmap <buffer> <CR> <Plug>(fern-my-open-expand-collapse)
nmap <buffer> <2-LeftMouse> <Plug>(fern-my-open-expand-collapse)

bokwoon95

Twitter Official Consumer Key

Twitter for Android

type:            PIN
Consumer key:    3nVuSoBZnx6U4vzUxf5w
Consumer secret: Bcs59EFbbsdF6Sl9Ng71smgStWEGwXXKSjYvPVt7qys

Twitter for iPhone

type:            PIN

Consumer key: IQKbtAYlXLripLGPWd0HUA

bokwoon95

package main

import (
	"fmt"
	"os"

	"github.com/frioux/shellquote"
	gsq "github.com/kballard/go-shellquote"
)

bokwoon95

------------
-- SELECT --
------------

-- TODO: need a formalized structure for testing the following queries. Results
-- must always be the same, no matter the dialect. Only for
-- insert/update/delete are there some dialect-specific queries.

-- TODO: also need OLTP queries where you scan into a nested structure. Either
-- aggregate manually in the application or aggregate into json and unmarshal

bokwoon95

DROP TABLE comment;

CREATE TABLE comment (
    comment_id INTEGER PRIMARY KEY
    ,body TEXT
    ,parent_id INT REFERENCES comment (comment_id)
);

DELETE FROM comment;

bokwoon95

#!/bin/bash

# == USAGE ==
# Put Github URLs inside a file called `plugins.start.txt` inside your vim
# directory (either `$HOME/.vim/plugins.start.txt` or
# `$HOME/.config/nvim/plugins.start.txt`). Then, run this script which will
# clone or update the plugins accordingly.
#
# == EXAMPLE ==
# $ cat "$HOME/.config/nvim/plugins.start.txt"

bokwoon95

func (v V_APPLICATIONS) View(dialect string) sq.Query {
    USERS := sq.New[USERS]("u")
    USER_ROLES := sq.New[USER_ROLES]("ur")
    USER_ROLES_APPLICANTS := sq.New[USER_ROLES_APPLICANTS]("ura")
    PERIODS := sq.New[PERIODS]("p")
    FORMS := sq.New[FORMS]("f")
    APPLICATIONS := sq.New[APPLICATIONS]("a")

    applicants := NewCTE("applicants", nil, Postgres.
        Select(