Loading files
This file is pinned to the selected release. Download the original to open it in your design tool.
import { getDb } from "../src/lib/community/server/db";
import { newId } from "../src/lib/community/server/queries";
import { territories } from "../src/lib/community/server/schema";
// Seeds the map with the directions the project is actually open to.
//
// Territories are moderator data — there is no admin screen for them yet, so
// this script is the editor. Run it again after editing the list and it
// updates matching codes in place rather than duplicating them, so a title or
// a position can be corrected without losing the threads and pins hanging off
// that code.
//
// npm run seed:map
//
// These are DIRECTIONS, not milestones: things somebody could pick up and take
// somewhere, which is a different list from /roadmap (what ships, and when).
// Positions are laid out for the constellation's 1440×640 stage, arranged
// around the device in the middle rather than in a row.
type Seed = {
code: string;
title: string;
description: string;
/** Floor-plan width, in columns of six. */
span: number;
/** Constellation position on the 1440×640 stage. */
x: number;
y: number;
shippingNext?: boolean;
questions?: string[];
};
const SEEDS: Seed[] = [
{
code: "A1",
title: "Wired control — OSC",
description:
"Drive the panel from a program over a wire: OSC in, knobs and pattern selection out. Ableton, TouchDesigner, anything that speaks it.",
span: 3,
x: 270,
y: 140,
questions: ["USB or Ethernet?", "who owns the clock?"],
},
{
code: "A2",
title: "Laser-cut version",
description:
"A body that comes off a laser bed instead of a printer — flat parts, one material, cuttable anywhere there is a makerspace.",
span: 3,
x: 1090,
y: 128,
shippingNext: true,
questions: ["acrylic or ply?"],
},
{
code: "A3",
title: "Bigger panels",
description:
"Port the firmware to larger and chained HUB75 panels. More pixels changes what a pattern can be, and what the frame has to hold.",
span: 2,
x: 1200,
y: 420,
questions: ["128×128?", "chained or one panel?"],
},
{
code: "B1",
title: "Pattern language",
description:
"What people can write in a pattern: helpers, colour ramps, shared building blocks — and what the editor should know about them.",
span: 2,
x: 960,
y: 560,
},
{
code: "B2",
title: "Sound and sensors",
description:
"Patterns that answer to something: a microphone, a light sensor, a knob somebody else is turning in another room.",
span: 2,
x: 520,
y: 520,
},
{
code: "B3",
title: "Getting one made",
description:
"Sourcing, assembly and the guide: how somebody with no kit and no help ends up with a working device.",
span: 4,
x: 175,
y: 380,
},
];
async function main() {
const db = getDb();
const now = new Date();
let added = 0;
let updated = 0;
for (const [index, seed] of SEEDS.entries()) {
const result = await db
.insert(territories)
.values({
id: newId(),
code: seed.code,
title: seed.title,
description: seed.description,
span: seed.span,
position: index,
x: seed.x,
y: seed.y,
shippingNext: seed.shippingNext ?? false,
questions: seed.questions?.join("\n") ?? null,
createdAt: now,
})
// The code is the identity — threads and pins point at the row it names,
// so re-running this edits a territory rather than replacing it.
.onConflictDoUpdate({
target: territories.code,
set: {
title: seed.title,
description: seed.description,
span: seed.span,
position: index,
x: seed.x,
y: seed.y,
shippingNext: seed.shippingNext ?? false,
questions: seed.questions?.join("\n") ?? null,
},
})
.returning({ id: territories.id, createdAt: territories.createdAt });
// Drizzle's timestamp mode stores seconds, so the millisecond part of
// `now` does not survive the round trip — compare at that resolution or a
// freshly inserted row looks like an old one.
const seconds = (date: Date) => Math.floor(date.getTime() / 1000);
if (result[0] && seconds(result[0].createdAt) === seconds(now)) added += 1;
else updated += 1;
}
console.log(`Map seeded: ${added} added, ${updated} updated, ${SEEDS.length} total.`);
}
void main();
98b423c28This file is pinned to the selected release. Download the original to open it in your design tool.