brendanmckenzie

aws \
  --output json \
  cognito-idp \
  list-users \
  --user-pool-id __pool_id__ | \
 jq -r \
  '["id","email","name"], (.Users | .[] | [.Username, (.Attributes[] | select(.Name=="email") | .Value),(.Attributes[] | select(.Name=="name") | .Value)]) | @csv' \
  > users.csv

brendanmckenzie

/* hledger web ui styles */

/*------------------------------------------------------------------------------------------*/
/* 0. revert some things */

/* don't let bootstrap add link URLs when printing */
@media print {
  a[href]:after { content: none !important; }
}

brendanmckenzie

{
  "title": "K14 tilde",
  "rules": [
    {
      "description": "Opt+Esc to `",
      "manipulators": [
        {
          "type": "basic",
          "from": {
            "key_code": "escape",

brendanmckenzie

# yaml-language-server: $schema=https://json.schemastore.org/github-workflow.json

name: Build packages

on:
  push:
    branches: [main, develop]

jobs:
  build_package:

brendanmckenzie

Woddle user guide

“I found a new workout I want to note down for later”

1. Go to “Workouts”
2. Add a new workout (+)
3. Categorise the workout based on where it came from (optional)
4. Add the movements within the workout (optional, helps with filtering)

“I found a new workout I want to do now”

brendanmckenzie

const express = require("express");
const { postgraphile } = require("postgraphile");
const PostGraphileNestedMutations = require("postgraphile-plugin-nested-mutations");
const SimplifyInflectorPlugin = require("@graphile-contrib/pg-simplify-inflector");

const app = express();

app.use(
  postgraphile(process.env.DATABASE_URL, "public", {
    watchPg: true,

brendanmckenzie

mutation {
  updateQuote(
    input: {
      patch: {
        quoteDaysUsingId: {
          updateById: {
            patch: { propertyToPropertyId: { connectById: { id: 1 } } }
            id: 1
          }
        }

brendanmckenzie

import { PostGraphilePlugin } from "postgraphile";
import * as graphql from "graphql";

const DisableIntrospection: PostGraphilePlugin = {
  ["postgraphile:validationRules:static"](args, _context) {
    if (process.env.ALLOW_INTROSPECTION) {
      return [args];
    }

    return [

brendanmckenzie

with recursive cte as (
  select
    child_id,
    parent_id,
    project_id,
    array [child_id, parent_id] as path,
    1 as level
  from
    child_parent
  union all

brendanmckenzie

using System;
using System.Collections.Specialized;
using System.Configuration;
using System.Security.Cryptography;
using System.Security.Cryptography.X509Certificates;
using System.Security.Cryptography.Xml;
using System.Xml;

namespace MyApp.Core.Security
{