Skip to content

gitflarePublicPartly agent-ready40

neon-drift

Real-time multiplayer arcade racer on Cloudflare Workers and Durable Objects.

main
Add the Apache-2.0 licence3efe3da
TypeScript34 lines1.4 KB
export interface Entry { name: string; score: number; created_at: number } let ready: WeakSet<object> = new WeakSet(); async function ensureSchema(db: any): Promise<void> {  if (ready.has(db)) return;  await db.batch([    db.prepare('CREATE TABLE IF NOT EXISTS scores (id INTEGER PRIMARY KEY, game_mode TEXT, name TEXT, score INTEGER, created_at INTEGER)'),    db.prepare('CREATE INDEX IF NOT EXISTS idx_scores_mode_score ON scores (game_mode, score DESC)'),    db.prepare('CREATE INDEX IF NOT EXISTS idx_scores_created ON scores (created_at)'),  ]);  ready.add(db);} export async function topScores(db: any, mode: string): Promise<{ entries: Entry[]; available: boolean }> {  if (!db) return { entries: [], available: false };  try {    await ensureSchema(db);    const r = await db.prepare('SELECT name, score, created_at FROM scores WHERE game_mode = ? ORDER BY score DESC LIMIT 20').bind(mode).all();    return { entries: (r.results ?? []) as Entry[], available: true };  } catch {    return { entries: [], available: false };  }} export async function writeScores(db: any, mode: string, rows: { name: string; score: number }[]): Promise<void> {  if (!db || rows.length === 0) return;  try {    await ensureSchema(db);    const now = Date.now();    await db.batch(rows.map((r) => db.prepare('INSERT INTO scores (game_mode, name, score, created_at) VALUES (?, ?, ?, ?)').bind(mode, r.name, r.score, now)));  } catch {}}