[{"_1":2,"_176":-5,"_177":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":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","isTeamOrgMember","ENV",{"_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":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","4e736cb42e83c17c10d9f33412034a74b06f3941","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",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":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",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_150":151,"_173":174,"_175":-5},"handle","ianmenethil","name","ZenServer","path","src/database/database.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":73,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":32,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_149":20},"id","619e7f00-58a9-11f0-a700-f69ea79377d9","createdAt",["D",1751614495896],"deletedAt","legacyEnvVars","privacy","unlisted","description","imageUrl","5856754a-b1b9-4358-87d1-77f1d9f79e45","pinnedFileId","9f5c41ce-58a9-11f0-947f-f69ea79377d9","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","7559f40a-a274-4a9b-8f8b-7486509c3949","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycXU1U2ZIVEk3NnhGTXRySE0wbWdYQncxSnYifQ","org",{"_94":95,"_135":132,"_12":112},"avatar","branch",{"_138":139,"_96":44,"_102":140,"_141":103,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":97,"_148":95},"version",883,"619ecc08-58a9-11f0-a700-f69ea79377d9","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":152,"_96":153,"_154":155,"_156":157,"_158":140,"_159":160,"_161":116,"_104":162,"_138":163,"_164":165,"_166":167,"_168":20,"_169":-5,"_98":170},"5089f336-5fff-11f0-8912-0224a6c84d84","database.ts","fileId","9f9ce486-58a9-11f0-b33c-f69ea79377d9","parentId","9e1c5056-58a9-11f0-8631-f69ea79377d9","branchId","branchVersion",855,"latest",["D",1752421062093],9,"fileType","script","content","/**\r\n * Database service for ZenServer.\r\n * Enhanced with repository pattern, better error handling, and Val Town SQLite compatibility.\r\n */\r\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\r\nimport { SCHEMA_SQL, SAMPLE_BOOKINGS_SQL } from \"./schema.ts\";\r\nimport { logger, logInfo } from \"../utils/logger.ts\";\r\nimport { environment } from \"../config/environment.ts\";\r\nimport { generateSessionId } from \"../utils/crypto.ts\";\r\nimport { getCurrentDateTimeInSydneyInYYYYMMDDTHHMMSS, getCurrentDateTimeInSydneyInMilliseconds } from \"../utils/dateUtils.ts\";\r\n\r\n// Set the environment variable that the Val Town SQLite library expects\r\nDeno.env.set(\"valtown\", environment.VALTOWN_TOKEN);\r\n\r\n// ========================================\r\n// Error Classes\r\n// ========================================\r\n\r\nexport class DatabaseError extends Error {\r\n constructor(message: string, public details?: any) {\r\n super(message);\r\n this.name = \"DatabaseError\";\r\n }\r\n}\r\n\r\n// ========================================\r\n// Type Definitions\r\n// ========================================\r\n\r\nexport interface NonceRecord {\r\n nonce: string;\r\n issued_at: string;\r\n used: number;\r\n state: \"unused\" | \"attempting\" | \"used\" | \"expired\";\r\n ip_address: string;\r\n booking_id: string;\r\n attempt_count: number;\r\n user_agent: string | null;\r\n origin: string | null;\r\n expires_at?: string;\r\n}\r\n\r\nexport interface SecurityContext {\r\n clientIP: string;\r\n userAgent?: string;\r\n origin?: string;\r\n}\r\n\r\nexport interface NonceValidationResult {\r\n valid: boolean;\r\n error?: string;\r\n needsNewToken?: boolean;\r\n bookingId?: string;\r\n}\r\n\r\nexport interface FingerprintStatusResponse {\r\n bookingId: string;\r\n totalAttempts: number;\r\n hasUnusedFingerprint: boolean;\r\n canRetry: boolean;\r\n remainingAttempts: number;\r\n}\r\n\r\n// ========================================\r\n// Database Service Implementation\r\n// ========================================\r\n\r\nexport class Database {\r\n private isInitialized = false;\r\n private tableName = \"app_tp_payment_nonces\";\r\n\r\n async initialize(): Promise {\r\n if (this.isInitialized) return;\r\n\r\n const startTime = performance.now();\r\n\r\n try {\r\n // Execute schema creation - split into individual statements\r\n const schemaStatements = SCHEMA_SQL.split(\";\").filter((stmt) =>\r\n stmt.trim()\r\n );\r\n\r\n for (const statement of schemaStatements) {\r\n if (statement.trim()) {\r\n await sqlite.execute({ sql: statement.trim(), args: [] });\r\n }\r\n }\r\n\r\n // Insert sample bookings for demo\r\n const sampleStatements = SAMPLE_BOOKINGS_SQL.split(\";\").filter((stmt) =>\r\n stmt.trim()\r\n );\r\n for (const statement of sampleStatements) {\r\n if (statement.trim()) {\r\n await sqlite.execute({ sql: statement.trim(), args: [] });\r\n }\r\n }\r\n\r\n // Create additional indexes for performance\r\n const indexes = [\r\n `CREATE INDEX IF NOT EXISTS idx_${this.tableName}_state ON ${this.tableName}(state)`,\r\n `CREATE INDEX IF NOT EXISTS idx_${this.tableName}_issued_at ON ${this.tableName}(issued_at)`,\r\n ];\r\n\r\n for (const indexSQL of indexes) {\r\n try {\r\n await sqlite.execute({ sql: indexSQL, args: [] });\r\n } catch (error) {\r\n // Index might already exist\r\n logger.debug(`Index creation skipped: ${error.message}`);\r\n }\r\n }\r\n\r\n this.isInitialized = true;\r\n const duration = performance.now() - startTime;\r\n const tableNames = await this.getTableNames();\r\n logInfo(\r\n `Database initialized successfully in ${duration.toFixed(\r\n 2\r\n )}ms. Tables: [${tableNames.join(\", \")}]`\r\n );\r\n } catch (error) {\r\n const duration = performance.now() - startTime;\r\n const errorMessage =\r\n error instanceof Error ? error.message : String(error);\r\n const dbError = new DatabaseError(\r\n `Failed to initialize database: ${errorMessage}`,\r\n { duration }\r\n );\r\n\r\n logger.error(\"Failed to initialize database\", {\r\n error: errorMessage,\r\n duration: `${duration.toFixed(2)}ms`,\r\n });\r\n throw dbError;\r\n }\r\n }\r\n\r\n /**\r\n * Execute a query and return rows as objects with column mapping\r\n */\r\n async query(sql: string, params: any[] = []): Promise {\r\n const startTime = performance.now();\r\n\r\n try {\r\n const result = await sqlite.execute({ sql, args: params });\r\n\r\n // Val Town SQLite returns rows as array of arrays, convert to objects\r\n if (!result.rows || result.rows.length === 0) {\r\n return [];\r\n }\r\n\r\n // If columns are provided, map to objects\r\n if (result.columns && result.columns.length > 0) {\r\n return result.rows.map((row) => {\r\n const obj: any = {};\r\n result.columns.forEach((col, idx) => {\r\n obj[col] = row[idx];\r\n });\r\n return obj;\r\n });\r\n }\r\n\r\n // Otherwise return raw rows\r\n return result.rows;\r\n } catch (error) {\r\n const duration = performance.now() - startTime;\r\n const errorMessage =\r\n error instanceof Error ? error.message : String(error);\r\n const dbError = new DatabaseError(\r\n `Database query failed: ${errorMessage}`,\r\n {\r\n sql,\r\n params,\r\n duration,\r\n }\r\n );\r\n\r\n logger.error(\"Database query failed\", {\r\n sql,\r\n params,\r\n error: errorMessage,\r\n duration: `${duration.toFixed(2)}ms`,\r\n });\r\n throw dbError;\r\n }\r\n }\r\n\r\n /**\r\n * Execute a query and return first row\r\n */\r\n async queryOne(sql: string, params: any[] = []): Promise {\r\n try {\r\n const results = await this.query(sql, params);\r\n return results.length > 0 ? results[0] : null;\r\n } catch (error) {\r\n const errorMessage =\r\n error instanceof Error ? error.message : String(error);\r\n logger.error(\"Database queryOne failed\", {\r\n sql,\r\n params,\r\n error: errorMessage,\r\n });\r\n throw error;\r\n }\r\n }\r\n\r\n /**\r\n * Execute a statement (INSERT, UPDATE, DELETE)\r\n */\r\n async execute(\r\n sql: string,\r\n params: any[] = []\r\n ): Promise<{ rows: any[][]; columns: string[]; rowsAffected: number }> {\r\n const startTime = performance.now();\r\n\r\n try {\r\n const result = await sqlite.execute({ sql, args: params });\r\n return result;\r\n } catch (error) {\r\n const duration = performance.now() - startTime;\r\n const errorMessage =\r\n error instanceof Error ? error.message : String(error);\r\n const dbError = new DatabaseError(\r\n `Database execute failed: ${errorMessage}`,\r\n {\r\n sql,\r\n params,\r\n duration,\r\n }\r\n );\r\n\r\n logger.error(\"Database execute failed\", {\r\n sql,\r\n params,\r\n error: errorMessage,\r\n duration: `${duration.toFixed(2)}ms`,\r\n });\r\n throw dbError;\r\n }\r\n }\r\n\r\n // ========================================\r\n // Nonce-specific Operations\r\n // ========================================\r\n\r\n /**\r\n * Stores a nonce in the database with security context\r\n * @deprecated Use NonceService.generateNonce() from publicPayNonceService.ts instead\r\n * which provides full-featured nonce handling with honeypot detection and security checks\r\n */\r\n async storeNonce(\r\n nonce: string,\r\n context: SecurityContext,\r\n bookingId?: string\r\n ): Promise {\r\n await this.ensureInitialized();\r\n\r\n const startTime = performance.now();\r\n\r\n try {\r\n const timestamp = this.getTimestamp();\r\n const nowMs = getCurrentDateTimeInSydneyInMilliseconds();\r\n const expiresAt = new Date(nowMs + 15 * 60 * 1000).toISOString(); // 15 minutes\r\n const actualBookingId = bookingId || \"session_\" + generateSessionId();\r\n\r\n const insertSQL = `INSERT INTO ${this.tableName}\r\n (nonce, issued_at, expires_at, used, booking_id, ip_address, user_agent, origin)\r\n VALUES (?, ?, ?, 0, ?, ?, ?, ?)`;\r\n\r\n await this.execute(insertSQL, [\r\n nonce,\r\n timestamp,\r\n expiresAt,\r\n actualBookingId,\r\n context.clientIP,\r\n context.userAgent || null,\r\n context.origin || null,\r\n ]);\r\n\r\n const duration = performance.now() - startTime;\r\n logInfo(\r\n `Nonce stored: nonce=${nonce.substring(\r\n 0,\r\n 8\r\n )}..., bookingId=${actualBookingId}, clientIP=${\r\n context.clientIP\r\n }, duration=${duration.toFixed(2)}ms`\r\n );\r\n } catch (error) {\r\n const duration = performance.now() - startTime;\r\n const err = error instanceof Error ? error : new Error(String(error));\r\n const dbError = new DatabaseError(\r\n `Failed to store nonce: ${err.message}`,\r\n { nonce: `${nonce.substring(0, 8)}...`, bookingId, error }\r\n );\r\n\r\n logger.error(\"Failed to store nonce\", {\r\n error: err.message,\r\n bookingId,\r\n nonceMasked: `${nonce.substring(0, 8)}...`,\r\n duration: `${duration.toFixed(2)}ms`,\r\n });\r\n throw dbError;\r\n }\r\n }\r\n\r\n /**\r\n * Gets a nonce record from database\r\n */\r\n async getNonce(nonce: string): Promise {\r\n await this.ensureInitialized();\r\n\r\n const startTime = performance.now();\r\n\r\n try {\r\n const selectSQL = `SELECT * FROM ${this.tableName} WHERE nonce = ?`;\r\n const result = await this.queryOne(selectSQL, [nonce]);\r\n\r\n if (!result) {\r\n return null;\r\n }\r\n\r\n // Map database columns to NonceRecord\r\n const nonceRecord: NonceRecord = {\r\n nonce: result.nonce,\r\n issued_at: result.issued_at,\r\n used: result.used || 0,\r\n state: this.determineNonceState(result),\r\n ip_address: result.ip_address,\r\n booking_id: result.booking_id,\r\n attempt_count: result.attempt_count || 0,\r\n user_agent: result.user_agent,\r\n origin: result.origin,\r\n expires_at: result.expires_at,\r\n };\r\n\r\n const duration = performance.now() - startTime;\r\n logger.debug(\"Nonce retrieved\", {\r\n nonce: `${nonce.substring(0, 8)}...`,\r\n state: nonceRecord.state,\r\n duration: `${duration.toFixed(2)}ms`,\r\n });\r\n\r\n return nonceRecord;\r\n } catch (error) {\r\n const duration = performance.now() - startTime;\r\n const err = error instanceof Error ? error : new Error(String(error));\r\n const dbError = new DatabaseError(`Failed to get nonce: ${err.message}`, {\r\n error,\r\n });\r\n\r\n logger.error(\"Failed to get nonce\", {\r\n error: err.message,\r\n duration: `${duration.toFixed(2)}ms`,\r\n });\r\n throw dbError;\r\n }\r\n }\r\n\r\n /**\r\n * Validates and uses a nonce\r\n * @deprecated Use NonceService.validateNonce() and NonceService.markNonceUsed() \r\n * from publicPayNonceService.ts instead for enhanced security validation\r\n */\r\n async validateAndUseNonce(\r\n nonce: string,\r\n context: SecurityContext\r\n ): Promise {\r\n await this.ensureInitialized();\r\n\r\n const startTime = performance.now();\r\n\r\n try {\r\n // Get nonce record\r\n const nonceRecord = await this.getNonce(nonce);\r\n\r\n if (!nonceRecord) {\r\n return { valid: false, error: \"Invalid nonce\" };\r\n }\r\n\r\n // Verify IP address matches\r\n if (\r\n nonceRecord.ip_address &&\r\n nonceRecord.ip_address !== context.clientIP\r\n ) {\r\n logger.warn(\"IP mismatch for nonce validation\", {\r\n nonce: `${nonce.substring(0, 8)}...`,\r\n storedIP: nonceRecord.ip_address,\r\n requestIP: context.clientIP,\r\n });\r\n return { valid: false, error: \"Security validation failed\" };\r\n }\r\n\r\n // Check if nonce is already used\r\n if (nonceRecord.used === 1 || nonceRecord.state === \"used\") {\r\n return {\r\n valid: false,\r\n error: \"Nonce already used. Please request a new secure token.\",\r\n needsNewToken: true,\r\n };\r\n }\r\n\r\n // Check if expired\r\n if (nonceRecord.expires_at) {\r\n const expiresAt = new Date(nonceRecord.expires_at);\r\n const now = new Date();\r\n if (now > expiresAt) {\r\n return {\r\n valid: false,\r\n error: \"Nonce has expired. Please request a new secure token.\",\r\n needsNewToken: true,\r\n };\r\n }\r\n }\r\n\r\n // Mark nonce as used\r\n await this.execute(\r\n `UPDATE ${this.tableName} SET used = 1 WHERE nonce = ?`,\r\n [nonce]\r\n );\r\n\r\n const duration = performance.now() - startTime;\r\n logInfo(\r\n `Nonce validated and used: nonce=${nonce.substring(\r\n 0,\r\n 8\r\n )}..., bookingId=${nonceRecord.booking_id}, duration=${duration.toFixed(\r\n 2\r\n )}ms`\r\n );\r\n\r\n return {\r\n valid: true,\r\n bookingId: nonceRecord.booking_id,\r\n };\r\n } catch (error) {\r\n const duration = performance.now() - startTime;\r\n const err = error instanceof Error ? error : new Error(String(error));\r\n\r\n logger.error(\"Nonce validation failed\", {\r\n error: err.message,\r\n nonceMasked: `${nonce.substring(0, 8)}...`,\r\n clientIP: context.clientIP,\r\n duration: `${duration.toFixed(2)}ms`,\r\n });\r\n\r\n return { valid: false, error: \"Internal server error\" };\r\n }\r\n }\r\n\r\n /**\r\n * Gets fingerprint status for a booking ID\r\n */\r\n async getFingerprintStatus(\r\n bookingId: string\r\n ): Promise {\r\n await this.ensureInitialized();\r\n\r\n const startTime = performance.now();\r\n\r\n try {\r\n const fifteenMinutesAgo = new Date(\r\n getCurrentDateTimeInSydneyInMilliseconds() - 15 * 60 * 1000\r\n ).toISOString();\r\n\r\n const statusSQL = `SELECT\r\n COUNT(*) as total_attempts,\r\n SUM(CASE WHEN used = 0 THEN 1 ELSE 0 END) as unused_count\r\n FROM ${this.tableName}\r\n WHERE booking_id = ? AND issued_at > ?`;\r\n\r\n const result = await this.queryOne(statusSQL, [\r\n bookingId,\r\n fifteenMinutesAgo,\r\n ]);\r\n\r\n const totalAttempts = Number(result?.total_attempts) || 0;\r\n const unusedCount = Number(result?.unused_count) || 0;\r\n const hasUnusedFingerprint = unusedCount > 0;\r\n const canRetry = totalAttempts < 5;\r\n\r\n const response: FingerprintStatusResponse = {\r\n bookingId,\r\n totalAttempts,\r\n hasUnusedFingerprint,\r\n canRetry,\r\n remainingAttempts: Math.max(0, 5 - totalAttempts),\r\n };\r\n\r\n const duration = performance.now() - startTime;\r\n logger.debug(\"Fingerprint status retrieved\", {\r\n bookingId,\r\n totalAttempts,\r\n canRetry,\r\n duration: `${duration.toFixed(2)}ms`,\r\n });\r\n\r\n return response;\r\n } catch (error) {\r\n const duration = performance.now() - startTime;\r\n const err = error instanceof Error ? error : new Error(String(error));\r\n const dbError = new DatabaseError(\r\n `Failed to get fingerprint status: ${err.message}`,\r\n { bookingId, error }\r\n );\r\n\r\n logger.error(\"Failed to get fingerprint status\", {\r\n error: err.message,\r\n bookingId,\r\n duration: `${duration.toFixed(2)}ms`,\r\n });\r\n throw dbError;\r\n }\r\n }\r\n\r\n /**\r\n * Cleanup expired data\r\n */\r\n async cleanup(): Promise {\r\n const startTime = performance.now();\r\n\r\n try {\r\n // Clean expired nonces\r\n const expiredCutoff = new Date(\r\n getCurrentDateTimeInSydneyInMilliseconds() - 24 * 60 * 60 * 1000\r\n ).toISOString();\r\n await this.execute(\r\n \"DELETE FROM app_tp_payment_nonces WHERE expires_at < ?\",\r\n [expiredCutoff]\r\n );\r\n\r\n // Clean old rate limit entries\r\n const rateLimitCutoff = new Date(\r\n getCurrentDateTimeInSydneyInMilliseconds() - 60 * 60 * 1000\r\n ).toISOString();\r\n await this.execute(\"DELETE FROM sys_rate_limits WHERE window_start < ?\", [\r\n rateLimitCutoff,\r\n ]);\r\n\r\n // Clean old security events (keep 30 days)\r\n const securityEventsCutoff = new Date(\r\n getCurrentDateTimeInSydneyInMilliseconds() - 30 * 24 * 60 * 60 * 1000\r\n ).toISOString();\r\n await this.execute(\"DELETE FROM security_events WHERE timestamp < ?\", [\r\n securityEventsCutoff,\r\n ]);\r\n\r\n const duration = performance.now() - startTime;\r\n logInfo(`Database cleanup completed in ${duration.toFixed(2)}ms`);\r\n } catch (error) {\r\n const duration = performance.now() - startTime;\r\n const errorMessage =\r\n error instanceof Error ? error.message : String(error);\r\n logger.error(\"Database cleanup failed\", {\r\n error: errorMessage,\r\n duration: `${duration.toFixed(2)}ms`,\r\n });\r\n }\r\n }\r\n\r\n // ========================================\r\n // Private Utility Methods\r\n // ========================================\r\n\r\n /**\r\n * Ensures the database is initialized before operations\r\n */\r\n private async ensureInitialized(): Promise {\r\n if (!this.isInitialized) {\r\n await this.initialize();\r\n }\r\n }\r\n\r\n /**\r\n * Gets current timestamp in database format\r\n */\r\n private getTimestamp(): string {\r\n return getCurrentDateTimeInSydneyInYYYYMMDDTHHMMSS();\r\n }\r\n\r\n /**\r\n * Determines nonce state based on database record\r\n */\r\n private determineNonceState(record: any): NonceRecord[\"state\"] {\r\n if (record.used === 1) return \"used\";\r\n\r\n if (record.expires_at) {\r\n const expiresAt = new Date(record.expires_at);\r\n const now = new Date();\r\n if (now > expiresAt) return \"expired\";\r\n }\r\n\r\n return \"unused\";\r\n }\r\n\r\n /**\r\n * Get all user table names in the database\r\n */\r\n private async getTableNames(): Promise {\r\n const result = await sqlite.execute({\r\n sql: \"SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%';\",\r\n args: [],\r\n });\r\n return result.rows?.map((row: any[]) => row[0]) ?? [];\r\n }\r\n}\r\n","deleted","label",[171,172,153],"src","database","permalink","https://www.val.town/x/ianmenethil/ZenServer/code/src/database/database.ts","extension","actionData","errors"]