Skip to content

Instantly share code, notes, and snippets.

@deinspanjer
deinspanjer / test_a_sayer.go
Created November 9, 2016 16:25 — forked from anonymous/test_a_sayer.go
Example of cross-package interfaces in golang
package a
import "fmt"
type Sayer interface {
Say() string
}
type Formal struct{}
@deinspanjer
deinspanjer / verify_google_jwt.sql
Created October 6, 2016 00:34
A PostgreSQL function using the plv8 language that can validate a JWT token from Google Sign-In
CREATE EXTENSION plv8;
CREATE OR REPLACE FUNCTION verify_google_jwt(jwt_token TEXT)
RETURNS JSONB
LANGUAGE plv8 IMMUTABLE STRICT
AS $$
function logerror(msg) {
plv8.elog(ERROR, msg);
}
@deinspanjer
deinspanjer / date_and_time_dimensions.sql
Created June 29, 2016 20:08
Magic Date and Time dimensions in PostgreSQL for a data warehouse
BEGIN;
CREATE TABLE dwh.d_date
(
date_key CHAR(10) PRIMARY KEY NOT NULL,
full_date DATE NOT NULL
);
CREATE UNIQUE INDEX d_date_full_date_uindex ON dwh.d_date (full_date);
INSERT INTO dwh.d_date
@deinspanjer
deinspanjer / BulkLoadTester.java
Created September 5, 2012 20:59
Quick and dirty tester for different Vertica bulk load methods
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
import java.io.PipedInputStream;
import java.io.PipedOutputStream;
import java.nio.ByteBuffer;
import java.nio.ByteOrder;
apiVersion: v1
data:
# Docker for Mac uses vpnkit to handle LoadBalancer ingresses, but it doesn't show an external IP, so the default
# ArgoCD health check for the ingress service doesn't show as Healthy. This custom health check fixes that issue.
resource.customizations: |
extensions/Service:
health.lua: |
hs = {}
hs.status = "Progressing"
if obj.status ~= nil then
#!/bin/bash
usage ()
{
cat <<UsageHERE
boot2docker-fwd -- Helper function to quickly manage port forwards between the boot2docker-vm and the host
Usage: boot2docker-fwd [ -n RULE_NAME ] [ -h HOST_PORT ] [ -p {tcp|udp} ] [ -i HOST_IP ] GUEST_PORT
or boot2docker-fwd -d RULE_NAME
or boot2docker-fwd -l
or boot2docker-fwd -A
/*
* Available context bindings:
* COLUMNS List<DataColumn>
* ROWS Iterable<DataRow>
* OUT { append() }
* FORMATTER { format(row, col); formatValue(Object, col) }
* TRANSPOSED Boolean
* plus ALL_COLUMNS, TABLE, DIALECT
*
* where:
@deinspanjer
deinspanjer / testdash.go
Created March 13, 2018 17:13
A toy termui example to get the basic structure down
package main
import (
ui "github.com/gizak/termui" // use ui as an alias
"strconv"
"fmt"
"math/rand"
"container/ring"
)
@deinspanjer
deinspanjer / Handle the data changed event.yaml
Created January 30, 2018 13:12
This snippet shows how to register a handler for the data-changed event. - Shared with Script Lab
name: Handle the data changed event
description: This snippet shows how to register a handler for the data-changed event.
author: deinspanjer
host: EXCEL
api_set: {}
script:
content: |
$("#setup").click(() => tryCatch(setup));
$("#register-data-changed-handler").click(() => tryCatch(registerDataChangedHandler));
@deinspanjer
deinspanjer / Create a table.yaml
Created January 28, 2018 17:22
Creates a table with four columns and seven rows. - Shared with Script Lab
name: Create a table
description: Creates a table with four columns and seven rows.
author: deinspanjer
host: EXCEL
api_set: {}
script:
content: |
$("#create-table").click(createTable);
$("#delete-rows").click(deleteRows);