[{"_1":2,"_173":-5,"_174":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","0f1790570f24c75ae1c9fc99892327093b413003","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_146":147,"_170":171,"_172":-5},"handle","malcolmocean","name","cogs-v-clippies-2","path","backend/database/queries.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_145":20},"id","2e3c2cde-8e96-11f0-bdee-0224a6c84d84","createdAt",["D",1757543612038],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","53f045b0-fcaa-11ef-9928-c9aafb5d50fa","pinnedFileId","pinPreview","screenshotVersion","likeCount","658b7c0d-aded-45be-b139-8952d52d1479","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydTRFSlhQcUNYWnZFTjJHNURLendoUzgwbGwifQ","org",{"_93":94,"_131":128},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},"version",45,"2e3c7d56-8e96-11f0-bdee-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":148,"_95":149,"_150":151,"_152":153,"_154":136,"_155":156,"_157":158,"_103":159,"_134":160,"_161":162,"_163":164,"_165":20,"_166":-5,"_97":167},"a3573048-8ea2-11f0-be65-0224a6c84d84","queries.ts","fileId","1fbaf0b8-8ea1-11f0-bd41-0224a6c84d84","parentId","b615f2bc-c151-4b3f-aa1f-9dba5844ffd4","branchId","branchVersion",40,"latest",true,["D",1757548962460],14,"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport type { Game, PieceType, Player, PlayerPiece, TurnSnapshot, Move } from \"../../shared/types.ts\";\n\n// Game queries\nexport async function createGame(id: string, mgmtId: string, name: string, rules: string): Promise {\n await sqlite.execute(\n `INSERT INTO games_v2 (id, mgmt_id, name, rules) VALUES (?, ?, ?, ?)`,\n [id, mgmtId, name, rules]\n );\n}\n\nexport async function getGameById(id: string): Promise {\n const result = await sqlite.execute(`SELECT * FROM games_v2 WHERE id = ?`, [id]);\n return result.rows && result.rows.length > 0 ? result.rows[0] as Game : null;\n}\n\nexport async function getGameByMgmtId(mgmtId: string): Promise {\n const result = await sqlite.execute(`SELECT * FROM games_v2 WHERE mgmt_id = ?`, [mgmtId]);\n return result.rows && result.rows.length > 0 ? result.rows[0] as Game : null;\n}\n\nexport async function updateGameSettings(id: string, name: string, rules: string, includePreviousMove: boolean): Promise {\n await sqlite.execute(\n `UPDATE games_v2 SET name = ?, rules = ?, include_previous_move = ? WHERE id = ?`,\n [name, rules, includePreviousMove ? 1 : 0, id]\n );\n}\n\nexport async function gameExists(id: string): Promise {\n const result = await sqlite.execute(`SELECT 1 FROM games_v2 WHERE id = ?`, [id]);\n return result.rows && result.rows.length > 0;\n}\n\n// Piece type queries\nexport async function createPieceType(gameId: string, name: string, description: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO piece_types_v2 (game_id, name, description) VALUES (?, ?, ?) RETURNING id`,\n [gameId, name, description]\n );\n return result.rows[0].id as number;\n}\n\nexport async function getPieceTypesByGame(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM piece_types_v2 WHERE game_id = ? ORDER BY created_at`,\n [gameId]\n );\n return result.rows as PieceType[];\n}\n\nexport async function getPieceTypeById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM piece_types_v2 WHERE id = ?`, [id]);\n return result.rows && result.rows.length > 0 ? result.rows[0] as PieceType : null;\n}\n\n// Player queries\nexport async function createPlayer(gameId: string, username: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO players_v2 (game_id, username) VALUES (?, ?) RETURNING id`,\n [gameId, username]\n );\n return result.rows[0].id as number;\n}\n\nexport async function getPlayerByUsername(gameId: string, username: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM players_v2 WHERE game_id = ? AND username = ?`,\n [gameId, username]\n );\n return result.rows && result.rows.length > 0 ? result.rows[0] as Player : null;\n}\n\nexport async function getPlayersByGame(gameId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM players_v2 WHERE game_id = ? ORDER BY joined_at`,\n [gameId]\n );\n return result.rows as Player[];\n}\n\n// Player piece queries\nexport async function createPlayerPiece(gameId: string, playerId: number, pieceTypeId: number, instructions: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO player_pieces_v2 (game_id, player_id, piece_type_id, instructions) VALUES (?, ?, ?, ?) RETURNING id`,\n [gameId, playerId, pieceTypeId, instructions]\n );\n return result.rows[0].id as number;\n}\n\nexport async function getPlayerPiecesByPlayer(gameId: string, playerId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM player_pieces_v2 WHERE game_id = ? AND player_id = ? ORDER BY created_at`,\n [gameId, playerId]\n );\n return result.rows as PlayerPiece[];\n}\n\nexport async function getAllPlayerPiecesByGame(gameId: string): Promise<(PlayerPiece & { piece_name: string; player_username: string })[]> {\n const result = await sqlite.execute(`\n SELECT pp.*, pt.name as piece_name, p.username as player_username\n FROM player_pieces_v2 pp\n JOIN piece_types_v2 pt ON pp.piece_type_id = pt.id\n JOIN players_v2 p ON pp.player_id = p.id\n WHERE pp.game_id = ?\n ORDER BY pp.created_at\n `, [gameId]);\n return result.rows as (PlayerPiece & { piece_name: string; player_username: string })[];\n}\n\nexport async function updatePlayerPieceInstructions(id: number, instructions: string): Promise {\n await sqlite.execute(\n `UPDATE player_pieces_v2 SET instructions = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [instructions, id]\n );\n}\n\nexport async function updatePlayerPieceLastMove(id: number, lastMove: string): Promise {\n await sqlite.execute(\n `UPDATE player_pieces_v2 SET last_move = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?`,\n [lastMove, id]\n );\n}\n\nexport async function getPlayerPieceById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM player_pieces_v2 WHERE id = ?`, [id]);\n return result.rows && result.rows.length > 0 ? result.rows[0] as PlayerPiece : null;\n}\n\n// Turn snapshot queries\nexport async function createTurnSnapshot(gameId: string, snapshotData: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO turn_snapshots_v2 (game_id, snapshot_data) VALUES (?, ?) RETURNING id`,\n [gameId, snapshotData]\n );\n return result.rows[0].id as number;\n}\n\nexport async function getTurnSnapshotById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM turn_snapshots_v2 WHERE id = ?`, [id]);\n return result.rows && result.rows.length > 0 ? result.rows[0] as TurnSnapshot : null;\n}\n\n// Move queries\nexport async function createMove(turnSnapshotId: number, playerPieceId: number, thinkingProcess: string, moveDescription: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO moves_v2 (turn_snapshot_id, player_piece_id, thinking_process, move_description) VALUES (?, ?, ?, ?) RETURNING id`,\n [turnSnapshotId, playerPieceId, thinkingProcess, moveDescription]\n );\n return result.rows[0].id as number;\n}\n\nexport async function getMovesByTurnSnapshot(turnSnapshotId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM moves_v2 WHERE turn_snapshot_id = ? ORDER BY created_at`,\n [turnSnapshotId]\n );\n return result.rows as Move[];\n}","deleted","label",[168,169,149],"backend","database","permalink","https://www.val.town/x/malcolmocean/cogs-v-clippies-2/code/backend/database/queries.ts","extension","actionData","errors"]