Johannes johtso

Keybase proof

I hereby claim:

I am johtso on github.
I am johtso (https://keybase.io/johtso) on keybase.
I have a public key whose fingerprint is 480D 27DC 20A4 E61E F849 037C 581B 992E 7F19 4964

To claim this, I am signing this object:

Canvas Drawing! | 7GUI Tasks Challenge | @keyframers 7.8.6

Problem

A normal query like this is fragile and opaque, if we insert a column we have to update all our references, and without column names it's really hard to tell what it's doing.

=QUERY('My Data'!A4:AAC, "
select Col5, sum(Col4), sum(Col10)
where Col3 = FALSE
and Col5 is not null
and Col2 <> 'Head Office'

	getdirentries64(0x6, 0x7FD7728E2A00, 0x1000) = 1192 0
	close_nocancel(0x6) = 0 0
	fstat64(0x5, 0x7FFF50CE06D0, 0x1000) = 0 0
	fstat64(0x5, 0x7FFF50CE0720, 0x1000) = 0 0
	open_nocancel("/Users/human/.virtualenvs/main/lib/python2.7/site-packages/salt/renderers/mako.pyc\0", 0x0, 0x1B6) = 6 0
	fstat64(0x6, 0x7FFF50CE04F8, 0x1B6) = 0 0
	read_nocancel(0x6, "\003\363\r\nK\2012Tc\0", 0x1000) = 1282 0
	fstat64(0x6, 0x7FFF50CE0608, 0x1000) = 0 0
	read_nocancel(0x6, "\n .hostmask: IPv4Address('0.0.0.31')\n .broadcast: IPv4Address('1.2.3.31')\n .netmask: IPv4Address('255.255.255.224')\n .prefixlen: 27\n\n i\377\0", 0x1000) = 0 0
	close_nocancel(0x6) = 0 0

	import sys
	import json
	import websocket

	ws = websocket.create_connection('ws://tracker.archiveteam.org:1337/api/live_stats')

	username = sys.argv[1]

	while True:
	data = json.loads(ws.recv()).get('live_new')

	import inspect
	from typing import Callable, Generator, Awaitable, TypeVar, Union

	YieldType = TypeVar("YieldType")
	SendType = TypeVar("SendType")
	ReturnType = TypeVar("ReturnType")

	def friendly_generator_decorator(
	genfunction: Callable[..., Generator[YieldType, SendType, ReturnType]],
	handler: Callable[[YieldType], Union[Awaitable[SendType], SendType]],

	// Name: daily note
	// Description: Open today's daily note in obsidian

	// You must install the Actions URI plugin and have the daily notes plugin enabled
	// Currently MacOS only

	import "@johnlindquist/kit"
	import { homedir } from "os"
	import { join as joinPath } from "path"

	// Name: daily note
	// Description: Open today's daily note in obsidian

	// You must install the Actions URI plugin and have the daily notes plugin enabled
	// Currently MacOS only

	import "@johnlindquist/kit"
	import { homedir } from "os"
	import { join as joinPath } from "path"

	import * as build from "@remix-run/dev/server-build";
	import { createRoutes } from "@remix-run/server-runtime/dist/routes";
	import { Dedupe, ExtraErrorData, Transaction } from "@sentry/integrations";
	import { hasTracingEnabled } from "@sentry/tracing";
	import { Toucan } from "toucan-js";
	import createEventHandler from "./createEventHandler";
	import instrumentBuild, { getTransactionName, startRequestHandlerTransaction } from "./instrumentBuild";

	interface Environment {
	__STATIC_CONTENT: KVNamespace<string>;

	import { Schema as S, AST } from "@effect/schema"
	import * as Errors from "./errors"
	import { Either, Option } from "effect"

	const overwriteTag = <Tag extends AST.LiteralValue>(tag: Tag) =>
	S.optionalToRequired(S.Unknown, S.Literal(tag), {
	decode: () => tag,
	encode: () => Option.none()
	}).pipe(S.withConstructorDefault(() => tag))