Something went wrong. Try again.
my own indieAuth provider! indiko.dunkirk.sh/docs
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546/** * Seed the dev database with realistic data so the UI has something to show. * * Usage: * bun scripts/seed-dev.ts # insert seed data * bun scripts/seed-dev.ts --reset # wipe users/apps/etc first, then seed * * Uses DATABASE_URL like the server (default data/indiko.db) and migrates it. * Inserts into users, credentials, sessions, resources, apps, permissions, * invites and tokens; never touches oidc_keys. */
// Same database and migrations as the server, so DATABASE_URL is honored.import { db } from "../src/db";
const reset = process.argv.includes("--reset");if (reset) { console.log("resetting tables..."); for (const table of [ "tokens", "permissions", "invite_uses", "invite_resource_roles", "invites", "authcodes", "challenges", "sessions", "credentials", "apps", "resource_roles", "resource_clients", "resources", "users", ]) { db.run(`DELETE FROM ${table};`); } // Reset autoincrement counters db.run( "DELETE FROM sqlite_sequence WHERE name IN ('users','credentials','sessions','apps','permissions','invites','tokens','resources','invite_uses','authcodes','challenges');", ); console.log("done.");}
const now = Math.floor(Date.now() / 1000);
// --- Users ---// tacy is always the admin (index 0). Look up existing users by username// so we can seed on top of a live db without --reset.const users = [ { username: "tacy", name: "Kieran Klukas", email: "kieran@dunkirk.sh", tier: "admin", status: "active", }, { username: "alice", name: "Alice Carter", email: "alice@example.com", tier: "developer", status: "active", }, { username: "bob", name: "Bob Nguyen", email: "bob@example.com", tier: "user", status: "active", }, { username: "charlie", name: "Charlie Park", email: "charlie@example.com", tier: "user", status: "suspended", }, { username: "dana", name: "Dana Williams", email: "dana@example.com", tier: "developer", status: "active", }, { username: "eve", name: "Eve Martinez", email: null, tier: "user", status: "active", },];
const userIds: number[] = [];let insertedUsers = 0;for (const u of users) { const existing = db .query("SELECT id FROM users WHERE username = ?") .get(u.username) as { id: number } | undefined;
if (existing) { userIds.push(existing.id); } else { const isAdmin = u.tier === "admin" ? 1 : 0; const res = db .query( `INSERT INTO users (username, name, email, tier, status, is_admin, created_at, url) VALUES (?, ?, ?, ?, ?, ?, ?, ?)`, ) .run( u.username, u.name, u.email, u.tier, u.status, isAdmin, now - Math.floor(Math.random() * 30 * 86400), `https://${u.username}.example.com`, ); userIds.push(Number(res.lastInsertRowid)); insertedUsers++; }}console.log( `${insertedUsers} new users inserted, ${users.length - insertedUsers} existing`,);
// --- Credentials (fake passkeys) ---// Only insert fake creds for newly-created users. Existing users keep their real passkeys.let credCount = 0;for (const [i, uid] of userIds.entries()) { const existingCreds = db .query("SELECT COUNT(*) as count FROM credentials WHERE user_id = ?") .get(uid) as { count: number }; if (existingCreds.count > 0) continue;
const numCreds = i === 0 ? 3 : i % 2 === 0 ? 2 : 1; for (let j = 0; j < numCreds; j++) { const credId = crypto.getRandomValues(new Uint8Array(32)); const pubKey = crypto.getRandomValues(new Uint8Array(64)); db.query( `INSERT INTO credentials (user_id, credential_id, public_key, counter, name, created_at) VALUES (?, ?, ?, ?, ?, ?)`, ).run( uid, Buffer.from(credId), Buffer.from(pubKey), Math.floor(Math.random() * 100), j === 0 ? "Main device" : `Backup ${j + 1}`, now - Math.floor(Math.random() * 60 * 86400), ); credCount++; }}console.log(`inserted ${credCount} credentials`);
// --- Sessions (valid for 24h so you can actually log in) ---const sessionToken = "dev-session-tacy";const existingSession = db .query("SELECT id FROM sessions WHERE token = ?") .get(sessionToken) as { id: number } | undefined;if (!existingSession) { db.query( "INSERT INTO sessions (token, user_id, expires_at) VALUES (?, ?, ?)", ).run(sessionToken, userIds[0], now + 86400); console.log("inserted 1 dev session (token: dev-session-tacy)");} else { // Refresh expiry on existing session db.query("UPDATE sessions SET expires_at = ? WHERE token = ?").run( now + 86400, sessionToken, ); console.log("refreshed existing dev session (token: dev-session-tacy)");}
// --- Apps (OAuth clients) ---const apps = [ { client_id: "https://auth.dunkirk.sh", redirect_uris: '["https://auth.dunkirk.sh/callback"]', name: "Dunkirk Auth", logo_url: null, description: "Personal OAuth provider for dunkirk.sh", is_preregistered: 1, client_secret_hash: null, available_roles: '["admin","editor","viewer"]', default_role: "viewer", }, { client_id: "https://blog.dunkirk.sh", redirect_uris: '["https://blog.dunkirk.sh/auth/callback","https://blog.dunkirk.sh/indieauth"]', name: "Dunkirk Blog", logo_url: null, description: "IndieWeb blog with Micropub support", is_preregistered: 0, client_secret_hash: null, available_roles: null, default_role: null, }, { client_id: "https://infra.dunkirk.sh", redirect_uris: '["https://infra.dunkirk.sh/callback"]', name: "Infra Dashboard", logo_url: null, description: "Homelab status page and monitoring", is_preregistered: 1, client_secret_hash: null, available_roles: '["admin","operator"]', default_role: "operator", }, { client_id: "https://webring.dunkirk.sh", redirect_uris: '["https://webring.dunkirk.sh/indieauth"]', name: "Webring", logo_url: null, description: null, is_preregistered: 0, client_secret_hash: null, available_roles: null, default_role: null, }, { client_id: "https://photos.kieranklukas.com", redirect_uris: '["https://photos.kieranklukas.com/auth"]', name: "Photo Gallery", logo_url: null, description: "Photography portfolio site", is_preregistered: 1, client_secret_hash: null, available_roles: '["admin","editor"]', default_role: "editor", },];
let insertedApps = 0;for (const a of apps) { const existing = db .query("SELECT id FROM apps WHERE client_id = ?") .get(a.client_id) as { id: number } | undefined; if (existing) continue;
// An app's roles live on a resource of its own, which it is allowed on. const resourceId = a.available_roles ? db .query( "INSERT INTO resources (identifier, name, available_roles, default_role) VALUES (?, ?, ?, ?)", ) .run(a.client_id, a.name, a.available_roles, a.default_role) .lastInsertRowid : null; db.query( `INSERT INTO apps (client_id, redirect_uris, name, logo_url, description, is_preregistered, client_secret_hash, resource_id, first_seen, last_used) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`, ).run( a.client_id, a.redirect_uris, a.name, a.logo_url, a.description, a.is_preregistered, a.client_secret_hash, resourceId, now - Math.floor(Math.random() * 90 * 86400), now - Math.floor(Math.random() * 7 * 86400), ); if (resourceId) { db.query( "INSERT INTO resource_clients (resource_id, client_id) VALUES (?, ?)", ).run(resourceId, a.client_id); } insertedApps++;}console.log(`${insertedApps} new apps inserted`);
// --- Permissions (user -> app links) ---const perms = [ // Kieran has access to everything { user: 0, client: "https://auth.dunkirk.sh", scopes: '["profile","email","openid"]', role: "admin", }, { user: 0, client: "https://blog.dunkirk.sh", scopes: '["profile","create","update"]', role: null, }, { user: 0, client: "https://infra.dunkirk.sh", scopes: '["profile","email"]', role: "admin", }, { user: 0, client: "https://webring.dunkirk.sh", scopes: '["profile"]', role: null, }, { user: 0, client: "https://photos.kieranklukas.com", scopes: '["profile","email","upload"]', role: "admin", }, // Alice has access to a few { user: 1, client: "https://auth.dunkirk.sh", scopes: '["profile","email"]', role: "editor", }, { user: 1, client: "https://blog.dunkirk.sh", scopes: '["profile","create"]', role: null, }, { user: 1, client: "https://photos.kieranklukas.com", scopes: '["profile","upload"]', role: "editor", }, // Bob has access to 2 { user: 2, client: "https://blog.dunkirk.sh", scopes: '["profile"]', role: null, }, { user: 2, client: "https://infra.dunkirk.sh", scopes: '["profile","email"]', role: "operator", }, // Dana has access to 3 { user: 4, client: "https://auth.dunkirk.sh", scopes: '["profile","email"]', role: "viewer", }, { user: 4, client: "https://photos.kieranklukas.com", scopes: '["profile","upload"]', role: "editor", }, { user: 4, client: "https://webring.dunkirk.sh", scopes: '["profile"]', role: null, }, // Eve has access to 1 { user: 5, client: "https://blog.dunkirk.sh", scopes: '["profile","email"]', role: null, },];
let insertedPerms = 0;for (const p of perms) { const clientId = p.client; const existing = db .query("SELECT id FROM permissions WHERE user_id = ? AND client_id = ?") .get(userIds[p.user], clientId) as { id: number } | undefined; if (existing) continue;
db.query( `INSERT INTO permissions (user_id, client_id, scopes, granted_at, last_used) VALUES (?, ?, ?, ?, ?)`, ).run( userIds[p.user], clientId, p.scopes, now - Math.floor(Math.random() * 60 * 86400), now - Math.floor(Math.random() * 3 * 86400), ); if (p.role) { db.query( `INSERT OR REPLACE INTO resource_roles (resource_id, user_id, role) SELECT resource_id, ?, ? FROM apps WHERE client_id = ? AND resource_id IS NOT NULL`, ).run(userIds[p.user], p.role, clientId); } insertedPerms++;}console.log(`${insertedPerms} new permissions inserted`);
// --- Tokens (active access tokens) ---const tokens = [ { user: 0, client: "https://auth.dunkirk.sh", scope: "profile email openid" }, { user: 0, client: "https://blog.dunkirk.sh", scope: "profile create update", }, { user: 1, client: "https://photos.kieranklukas.com", scope: "profile upload", }, { user: 2, client: "https://infra.dunkirk.sh", scope: "profile email" },];
let insertedTokens = 0;for (const t of tokens) { // Check if this user+client combo already has an active token const existing = db .query( "SELECT id FROM tokens WHERE user_id = ? AND client_id = ? AND revoked = 0", ) .get(userIds[t.user], t.client) as { id: number } | undefined; if (existing) continue;
const tokStr = `tok_${crypto.randomUUID().replace(/-/g, "")}`; db.query( `INSERT INTO tokens (token, user_id, client_id, scope, created_at, expires_at, revoked) VALUES (?, ?, ?, ?, ?, ?, 0)`, ).run(tokStr, userIds[t.user], t.client, t.scope, now - 3600, now + 86400); insertedTokens++;}console.log(`${insertedTokens} new tokens inserted`);
// --- Invites ---const invites = [ { code: "invite-alpha-001", createdBy: 0, maxUses: 5, currentUses: 2, expiresAt: now + 7 * 86400, note: "general community invite", message: "Welcome to Indiko!", }, { code: "invite-beta-002", createdBy: 0, maxUses: 1, currentUses: 1, expiresAt: now - 86400, note: "for Bob", message: null, }, { code: "invite-gamma-003", createdBy: 0, maxUses: 10, currentUses: 0, expiresAt: null, note: "open invite for team", message: "Hey, come join us!", }, { code: "invite-delta-004", createdBy: 1, maxUses: 3, currentUses: 1, expiresAt: now + 30 * 86400, note: null, message: null, }, { code: "invite-epsilon-005", createdBy: 0, maxUses: 1, currentUses: 0, expiresAt: now + 3 * 86400, note: "for the new dev", message: "Welcome aboard!", },];
let insertedInvites = 0;for (const inv of invites) { const existing = db .query("SELECT id FROM invites WHERE code = ?") .get(inv.code) as { id: number } | undefined; if (existing) continue;
db.query( `INSERT INTO invites (code, created_by, used, max_uses, current_uses, expires_at, note, message, created_at) VALUES (?, ?, 0, ?, ?, ?, ?, ?, ?)`, ).run( inv.code, userIds[inv.createdBy], inv.maxUses, inv.currentUses, inv.expiresAt, inv.note, inv.message, now - Math.floor(Math.random() * 14 * 86400), ); insertedInvites++;}console.log(`${insertedInvites} new invites inserted`);
// Mark one invite as used by Bob (idempotent)const bobInvite = db .query("SELECT id FROM invites WHERE code = 'invite-beta-002'") .get() as { id: number } | undefined;if (bobInvite) { const alreadyUsed = db .query("SELECT id FROM invite_uses WHERE invite_id = ? AND user_id = ?") .get(bobInvite.id, userIds[2]) as { id: number } | undefined; if (!alreadyUsed) { db.query( "UPDATE invites SET used = 1, used_by = ?, used_at = ? WHERE id = ?", ).run(userIds[2], now - 86400, bobInvite.id); db.query( "INSERT INTO invite_uses (invite_id, user_id, used_at) VALUES (?, ?, ?)", ).run(bobInvite.id, userIds[2], now - 86400); }}
// Mark one as used by Dana (idempotent)const danaInvite = db .query("SELECT id FROM invites WHERE code = 'invite-delta-004'") .get() as { id: number } | undefined;if (danaInvite) { const alreadyUsed = db .query("SELECT id FROM invite_uses WHERE invite_id = ? AND user_id = ?") .get(danaInvite.id, userIds[4]) as { id: number } | undefined; if (!alreadyUsed) { db.query( "UPDATE invites SET used = 1, used_by = ?, used_at = ? WHERE id = ?", ).run(userIds[4], now - 2 * 86400, danaInvite.id); db.query( "INSERT INTO invite_uses (invite_id, user_id, used_at) VALUES (?, ?, ?)", ).run(danaInvite.id, userIds[4], now - 2 * 86400); }}
console.log("marked 2 invites as used");
console.log("\nseed complete!");console.log("login token: dev-session-tacy");console.log("admin user: tacy");