i didn't think it was core to my identity that i know sql but apparently it is
rkletr
@merkletr.ee
345 followers 191 following 3.9K posts
cryptography liker. ctf player. array languager? music enjoyer. en/frCA. SPDX-License-Identifier: 0BSD
cryptography liker. ctf player. array languager? music enjoyer. en/frCA. SPDX-License-Identifier: 0BSD
![const idArgs = () => {
args._.filter(it => typeof it !== "number").forEach(it => console.error(`warn: ${it} is not a valid item id`));
return args._.filter(it => typeof it === "number");
};
const requireDef = <T>(t: T, msg: string): NonNullable<T> => { if (t === undefined) throw new Error(msg); return t!; }
const requireArg = <T extends keyof typeof args>(arg: T) => requireDef(args[arg], `argument ${arg} is required`);
const J = (x: unknown) => console.log(JSON.stringify(x)); // TODO: --human
const cmds = {
"prime": async () => {
const parts: Record<string, string> = {
itemTypes: itemTypes.join("|"), statuses: statuses.join("|"),
linkArgs: linkTypes.map(([a,b]) => `--${a} <id> --${b} <id>`).join(" "),
wqSrc: resolve(src, "wq"),
};
console.log(await Deno.readTextFile(resolve(src, "PRIMER.md"))
.then(it => it.replaceAll(/\{([^\}]+)\}/g, (_,k) => parts[k])));
},
"show": () => J(idArgs().map(id => show(id) || console.error(`warn: item ${id} does not exist`)).filter(it => it)),
"create": () => J(show(db.cItem(requireArg("type"), args.status || "open", requireArg("name"), requireArg("description"))!)),
"update": () => pipe(pipe(issueFields.filter(k => args[k]), fields => pipe(E(`UPDATE item SET ${binds(fields)} WHERE id = ?`), stmt =>
pipe(fields.map(k => args[k]), vals => pose<[number], RestBindParameters, void>(stmt, id => [...vals, id])))), doUpdate =>
J(idArgs().map(id => { doUpdate(id); return show(id); }))),](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:ezhjhbzqt32bqprrn6qjlkri/bafkreiebgynsbfibxguvlfqtlnjpv76zjjd5cucxqmw5b6r4mspihwefy4)
