[{"_1":2,"_172":-5,"_173":-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","4049fd8e684531193de8d0777b9ab11a81dae27e","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,"_169":170,"_171":-5},"handle","w_ache","name","whatsapp","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","a26d6490-3c4f-11f0-9bce-9e149126039e","createdAt",["D",1748497317362],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","c4843430-272f-11f0-a979-7b65770d7727","pinnedFileId","pinPreview","screenshotVersion","likeCount","e05e2dae-c725-4828-80a6-b974e78b7667","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ3WDNRemIzeFd6WnJ6anJGeFljYlJ3MlZKZiJ9","org",{"_93":94,"_131":128,"_12":111},"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",19,"a26db4c2-3c4f-11f0-9bce-9e149126039e","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":32,"_160":161,"_162":163,"_164":20,"_165":-5,"_97":166},"23c4e8ba-3c50-11f0-8c97-9e149126039e","queries.ts","fileId","23c4e950-3c50-11f0-8c97-9e149126039e","parentId","a13c3667-b7f6-429a-b896-a6d68d5fd4e8","branchId","branchVersion",6,"latest",true,["D",1748497534360],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"./migrations.ts\";\nimport type { ScheduledMessage, MessageTemplate, Contact, AppSettings } from \"../../shared/types.ts\";\n\n// Scheduled Messages queries\nexport async function createScheduledMessage(message: Omit): Promise {\n const id = Date.now().toString(36) + Math.random().toString(36).substr(2);\n const createdAt = new Date().toISOString();\n \n await sqlite.execute(`\n INSERT INTO ${TABLES.SCHEDULED_MESSAGES} \n (id, phone_number, contact_name, message, scheduled_time, is_recurring, recurrence_type, status, created_at, attempts)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n id,\n message.phoneNumber,\n message.contactName || null,\n message.message,\n message.scheduledTime,\n message.isRecurring,\n message.recurrenceType || null,\n message.status,\n createdAt,\n 0\n ]);\n\n return {\n ...message,\n id,\n createdAt,\n attempts: 0\n };\n}\n\nexport async function getScheduledMessages(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLES.SCHEDULED_MESSAGES} \n ORDER BY scheduled_time ASC\n `);\n\n return result.map(row => ({\n id: row.id,\n phoneNumber: row.phone_number,\n contactName: row.contact_name,\n message: row.message,\n scheduledTime: row.scheduled_time,\n isRecurring: Boolean(row.is_recurring),\n recurrenceType: row.recurrence_type,\n status: row.status,\n createdAt: row.created_at,\n lastAttempt: row.last_attempt,\n attempts: row.attempts\n }));\n}\n\nexport async function getPendingMessages(): Promise {\n const now = new Date().toISOString();\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLES.SCHEDULED_MESSAGES} \n WHERE status = 'pending' AND scheduled_time <= ?\n ORDER BY scheduled_time ASC\n `, [now]);\n\n return result.map(row => ({\n id: row.id,\n phoneNumber: row.phone_number,\n contactName: row.contact_name,\n message: row.message,\n scheduledTime: row.scheduled_time,\n isRecurring: Boolean(row.is_recurring),\n recurrenceType: row.recurrence_type,\n status: row.status,\n createdAt: row.created_at,\n lastAttempt: row.last_attempt,\n attempts: row.attempts\n }));\n}\n\nexport async function updateMessageStatus(id: string, status: ScheduledMessage['status'], lastAttempt?: string): Promise {\n await sqlite.execute(`\n UPDATE ${TABLES.SCHEDULED_MESSAGES} \n SET status = ?, last_attempt = ?, attempts = attempts + 1\n WHERE id = ?\n `, [status, lastAttempt || new Date().toISOString(), id]);\n}\n\nexport async function deleteScheduledMessage(id: string): Promise {\n await sqlite.execute(`\n DELETE FROM ${TABLES.SCHEDULED_MESSAGES} WHERE id = ?\n `, [id]);\n}\n\n// Message Templates queries\nexport async function getMessageTemplates(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLES.MESSAGE_TEMPLATES} \n ORDER BY is_default DESC, name ASC\n `);\n\n return result.map(row => ({\n id: row.id,\n name: row.name,\n content: row.content,\n category: row.category,\n isDefault: Boolean(row.is_default)\n }));\n}\n\nexport async function createMessageTemplate(template: Omit): Promise {\n const id = Date.now().toString(36) + Math.random().toString(36).substr(2);\n \n await sqlite.execute(`\n INSERT INTO ${TABLES.MESSAGE_TEMPLATES} \n (id, name, content, category, is_default, created_at)\n VALUES (?, ?, ?, ?, ?, ?)\n `, [\n id,\n template.name,\n template.content,\n template.category,\n template.isDefault,\n new Date().toISOString()\n ]);\n\n return { ...template, id };\n}\n\n// Contacts queries\nexport async function getContacts(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLES.CONTACTS} \n ORDER BY last_used DESC, name ASC\n `);\n\n return result.map(row => ({\n id: row.id,\n name: row.name,\n phoneNumber: row.phone_number,\n lastUsed: row.last_used\n }));\n}\n\nexport async function createOrUpdateContact(contact: Omit): Promise {\n // Try to find existing contact by phone number\n const existing = await sqlite.execute(`\n SELECT * FROM ${TABLES.CONTACTS} WHERE phone_number = ?\n `, [contact.phoneNumber]);\n\n if (existing.length > 0) {\n // Update existing contact\n await sqlite.execute(`\n UPDATE ${TABLES.CONTACTS} \n SET name = ?, last_used = ?\n WHERE phone_number = ?\n `, [contact.name, new Date().toISOString(), contact.phoneNumber]);\n \n return {\n id: existing[0].id,\n name: contact.name,\n phoneNumber: contact.phoneNumber,\n lastUsed: new Date().toISOString()\n };\n } else {\n // Create new contact\n const id = Date.now().toString(36) + Math.random().toString(36).substr(2);\n \n await sqlite.execute(`\n INSERT INTO ${TABLES.CONTACTS} \n (id, name, phone_number, last_used, created_at)\n VALUES (?, ?, ?, ?, ?)\n `, [\n id,\n contact.name,\n contact.phoneNumber,\n new Date().toISOString(),\n new Date().toISOString()\n ]);\n\n return {\n id,\n name: contact.name,\n phoneNumber: contact.phoneNumber,\n lastUsed: new Date().toISOString()\n };\n }\n}\n\n// Settings queries\nexport async function getSettings(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLES.APP_SETTINGS}\n `);\n\n const settings: any = {};\n result.forEach(row => {\n let value: any = row.value;\n \n // Parse boolean and number values\n if (value === 'true') value = true;\n else if (value === 'false') value = false;\n else if (!isNaN(Number(value))) value = Number(value);\n \n settings[row.key] = value;\n });\n\n return {\n notifications: settings.notifications ?? true,\n darkMode: settings.darkMode ?? false,\n defaultCountryCode: settings.defaultCountryCode ?? '+1',\n autoOpenWhatsApp: settings.autoOpenWhatsApp ?? true,\n reminderMinutes: settings.reminderMinutes ?? 5\n };\n}\n\nexport async function updateSetting(key: string, value: any): Promise {\n await sqlite.execute(`\n INSERT OR REPLACE INTO ${TABLES.APP_SETTINGS} \n (key, value, updated_at)\n VALUES (?, ?, ?)\n `, [key, String(value), new Date().toISOString()]);\n}","deleted","label",[167,168,149],"backend","database","permalink","https://www.val.town/x/w_ache/whatsapp/code/backend/database/queries.ts","extension","actionData","errors"]