[{"_1":2,"_175":-5,"_176":-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","64602b05c9a02becc3d4aac52b7346fd8c14b4dc","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,"_153":154,"_172":173,"_174":-5},"handle","dcm31","name","styled","path","db.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":111,"_112":-5,"_12":113,"_114":-5,"_115":20,"_116":-5,"_117":-5,"_118":32,"_14":119,"_120":-5,"_121":-5,"_122":123,"_124":123,"_125":126,"_127":126,"_128":126,"_129":123,"_130":123,"_23":131,"_134":135,"_139":140,"_152":20},"id","b3137990-ef3e-11f0-b2ea-42dde27851f2","createdAt",["D",1768171301987],"deletedAt","legacyEnvVars","privacy","public","description","Two-sided marketplace matching stylists with event clients","imageUrl","9319c175-2593-4f88-ba21-04f2ef7b1c28","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","d663a026-6449-42f6-9156-1d4a2d64d38c","tursoName","tursoHostname","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_132":133},"profileImageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/260ec866-bb5d-4641-4bfe-526cca896a00/square512","org",{"_94":95,"_136":133,"_12":113,"_137":138},"avatar","tier","pro","branch",{"_141":142,"_96":44,"_102":143,"_144":103,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":97,"_151":95},"version",4,"b313c530-ef3e-11f0-b2ea-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":155,"_96":99,"_156":157,"_158":-5,"_159":143,"_160":161,"_162":163,"_104":164,"_141":32,"_165":166,"_167":168,"_169":20,"_170":-5,"_98":171},"be48402a-ef3e-11f0-a0f4-42dde27851f2","fileId","be4840d4-ef3e-11f0-a0f4-42dde27851f2","parentId","branchId","branchVersion",1,"latest",true,["D",1768171320784],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst EVENTS_TABLE = \"styled_events_1\";\nconst STYLISTS_TABLE = \"styled_stylists_1\";\nconst INTERESTS_TABLE = \"styled_interests_1\";\n\nawait createTables();\n\nexport interface Event {\n id: number;\n timestamp: number;\n name: string;\n email: string;\n event_type: string;\n event_date: string;\n description: string;\n budget: string;\n location: string;\n}\n\nexport interface Stylist {\n id: number;\n timestamp: number;\n name: string;\n email: string;\n specialties: string;\n bio: string;\n portfolio_url: string;\n}\n\nexport interface Interest {\n id: number;\n timestamp: number;\n stylist_id: number;\n event_id: number;\n message: string;\n}\n\n// Events\nexport async function createEvent(data: Omit) {\n await sqlite.execute(\n `INSERT INTO ${EVENTS_TABLE} (timestamp, name, email, event_type, event_date, description, budget, location)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [Date.now(), data.name, data.email, data.event_type, data.event_date, data.description, data.budget, data.location]\n );\n}\n\nexport async function getAllEvents(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${EVENTS_TABLE} ORDER BY timestamp DESC`);\n return rowsToObjects(result);\n}\n\nexport async function getEventById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${EVENTS_TABLE} WHERE id = ?`, [id]);\n const events = rowsToObjects(result);\n return events[0] || null;\n}\n\n// Stylists\nexport async function createStylist(data: Omit) {\n await sqlite.execute(\n `INSERT INTO ${STYLISTS_TABLE} (timestamp, name, email, specialties, bio, portfolio_url)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [Date.now(), data.name, data.email, data.specialties, data.bio, data.portfolio_url]\n );\n}\n\nexport async function getAllStylists(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${STYLISTS_TABLE} ORDER BY timestamp DESC`);\n return rowsToObjects(result);\n}\n\nexport async function getStylistById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${STYLISTS_TABLE} WHERE id = ?`, [id]);\n const stylists = rowsToObjects(result);\n return stylists[0] || null;\n}\n\n// Interests (stylist expressing interest in an event)\nexport async function createInterest(data: Omit) {\n await sqlite.execute(\n `INSERT INTO ${INTERESTS_TABLE} (timestamp, stylist_id, event_id, message)\n VALUES (?, ?, ?, ?)`,\n [Date.now(), data.stylist_id, data.event_id, data.message]\n );\n}\n\nexport async function getInterestsForEvent(eventId: number): Promise<(Interest & { stylist_name: string; stylist_email: string })[]> {\n const result = await sqlite.execute(\n `SELECT i.*, s.name as stylist_name, s.email as stylist_email \n FROM ${INTERESTS_TABLE} i \n JOIN ${STYLISTS_TABLE} s ON i.stylist_id = s.id \n WHERE i.event_id = ?\n ORDER BY i.timestamp DESC`,\n [eventId]\n );\n return rowsToObjects(result);\n}\n\nexport async function getInterestsByStylelist(stylistId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${INTERESTS_TABLE} WHERE stylist_id = ? ORDER BY timestamp DESC`,\n [stylistId]\n );\n return rowsToObjects(result);\n}\n\n// Helpers\nfunction rowsToObjects(result: { columns: string[]; rows: unknown[][] }): T[] {\n return result.rows.map((row) => {\n const obj: Record = {};\n result.columns.forEach((col, idx) => {\n obj[col] = row[idx];\n });\n return obj as T;\n });\n}\n\nasync function createTables() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${EVENTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp INTEGER NOT NULL,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n event_type TEXT NOT NULL,\n event_date TEXT NOT NULL,\n description TEXT NOT NULL,\n budget TEXT NOT NULL,\n location TEXT NOT NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${STYLISTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp INTEGER NOT NULL,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n specialties TEXT NOT NULL,\n bio TEXT NOT NULL,\n portfolio_url TEXT\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${INTERESTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp INTEGER NOT NULL,\n stylist_id INTEGER NOT NULL,\n event_id INTEGER NOT NULL,\n message TEXT NOT NULL,\n FOREIGN KEY (stylist_id) REFERENCES ${STYLISTS_TABLE}(id),\n FOREIGN KEY (event_id) REFERENCES ${EVENTS_TABLE}(id)\n )\n `);\n}\n","deleted","label",[99],"permalink","https://www.val.town/x/dcm31/styled/code/db.ts","extension","actionData","errors"]