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'
| 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)) |
| 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>; |
| // 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" |
A Pen by @keyframers on CodePen.
| 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]], |
| 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') |
| 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 |
I hereby claim:
To claim this, I am signing this object: