Complete	ID	Title
\n \n	{goal.id}	{goal.title}

\n );\n};\n\nconst TodosTable = ({ todos }) => {\n if (!todos || todos.length === 0) return <>;\n return (\n \n \n \n \n \n \n \n \n \n {todos.map((todo) => (\n \n \n \n \n \n ))}\n \n

Complete	ID	Title
\n \n	{todo.id}	{todo.title}

\n );\n};\n\nfunction Table({ data }) {\n return (\n <>\n \n
\n \n \n );\n}\n\nexport default async function(e: Email) {\n if (!Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\")) {\n throw new Error(\"INSTANTDB_ADMIN_TOKEN not set\");\n }\n\n if (!Deno.env.get(\"INSTANTDB_APP_ID\")) {\n throw new Error(\"INSTANTDB_APP_ID not set\");\n }\n\n if (e.subject && e.subject.startsWith(\"Re:\")) {\n return await email({\n to: e.from,\n from: e.to,\n subject: e.subject,\n text: \"I'm sorry, I can only reply to new email threads.\",\n });\n }\n\n try {\n const client = new OpenAI();\n\n const systemPrompt = `\n You are a helpful email assistant. You have access to an instantdb database. When people ask for info you will provide it for \n them by creating an instantdb query for the server to query the database. Return the query param json string only -- the json object that query is assigned to. Note that the results\n be rendered into 2 tables, one for goals and one for todos, so and associations will not be displayed, instead you should create a query that uses both tables.\n \n --------------------------------------------------------------------------\n Here is an example instantdb query (the examples use an unrelated database):\n \n Fetch namespace\n One of the simplest queries you can write is to simply get all entities of a namespace:\n const query = { goals: {} };\n \n Fetch multiple namespaces\n You can fetch multiple namespaces at once:\n const query = { goals: {}, todos: {} };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n }\n \n Fetch a specific entity\n If you want to filter entities, you can use the where keyword. Here we fetch a specific goal:\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n },\n };\n \n console.log(data)\n {\n \"goals\": [...],\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n ...\n ]\n }\n \n Fetch associations\n We can fetch goals and their related todos:\n \n const query = {\n goals: {\n todos: {},\n },\n };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n Fetch associations for filtered namespace\n We can fetch a specific entity in a namespace as well as it's related associations.\n\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n {\n \"id\": sleepId,\n \"title\": \"Go to bed early\"\n },\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n }\n ]\n }\n\n Filter namespace by associated values\n We can filter namespaces by their associations\n\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': 'Code a bunch',\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n {\n \"id\": standupId,\n \"title\": \"Do standup\"\n }\n ]\n }\n ]\n }\n\n Filter associations\n We can also filter associated data.\n\n const query = {\n goals: {\n todos: {\n $: {\n where: {\n 'todos.title': 'Go on a run',\n },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": []\n }\n ]\n }\n\n Inverse Associations\n Associations are also available in the reverse order.\n const query = {\n todos: {\n goals: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\",\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n },\n ...,\n ]\n }\n\n And key\n The and key is useful when you want an entity to match multiple conditions. In this case we want to find goals that have both Drink protein and Go on a run todos.:\n\n const query = {\n goals: {\n $: {\n where: {\n and: [\n { 'todos.title': 'Drink protein' },\n { 'todos.title': 'Go on a run' },\n ],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n OR\n The where clause supports or queries that will filter entities that match any of the clauses in the provided list:\n \n const query = {\n todos: {\n $: {\n where: {\n or: [{ title: 'Code a bunch' }, { title: 'Review PRs' }],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n ]\n }\n\n $in\n The where clause supports $in queries that will filter entities that match any of the items in the provided list. You can think of this as a shorthand for or on a single key.\n \n const query = {\n todos: {\n $: {\n where: {\n title: { $in: ['Code a bunch', 'Review PRs'] },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n }\n ]\n }\n\n Comparison operators\n The where clause supports comparison operators on fields that are indexed and have checked types.\n\n Operator\tDescription\tJS equivalent\n $gt\tgreater than\t>\n $lt\tless than\t<\n $gte\tgreater than or equal to\t>=\n $lte\tless than or equal to\t<=\n \n const query = {\n todos: {\n $: {\n where: {\n timeEstimateHours: { $gt: 24 },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": buildShipId,\n \"title\": \"Build a starship prototype\",\n \"timeEstimateHours\": 5000\n }\n ]\n }\n \n Dates can be stored as timestamps (milliseconds since the epoch, e.g. Date.now()) or as ISO 8601 strings (e.g. JSON.stringify(new Date())) and can be queried in the same formats:\n \n const now = '2024-11-26T15:25:00.054Z';\n const query = {\n todos: {\n $: { where: { dueDate: { $lte: now } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": slsFlightId,\n \"title\": \"Space Launch System maiden flight\",\n \"dueDate\": \"2017-01-01T00:00:00Z\"\n }\n ]\n }\n \n If you try to use comparison operators on data that isn't indexed and type-checked, you'll get an error:\n \n const query = {\n todos: {\n $: { where: { priority: { $gt: 2 } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(error);\n {\n \"message\": \"Validation failed for query\",\n \"hint\": {\n \"data-type\": \"query\",\n \"errors\": [\n {\n \"expected?\": \"indexed?\",\n \"in\": [\"priority\", \"$\", \"where\", \"priority\"],\n \"message\": \"The \\`todos.priority\\` attribute must be indexed to use comparison operators.\"\n }\n ],\n \"input\": {\n \"todos\": {\n \"$\": {\n \"where\": {\n \"priority\": {\n \"$gt\": 2\n }\n }\n }\n }\n }\n }\n }\n\n $not\n The where clause supports $not queries that will return entities that don't match the provided value for the field, including entities where the field is null or undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $not: 'work' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n },\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $isNull\n The where clause supports $isNull queries that will filters entities by whether the field value is either null or undefined.\n \n Set $isNull to true to return entities where where the field is null or undefined.\n \n Set $isNull to false to return entities where the field is not null and not undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: false },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n }\n ]\n }\n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: true },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $like\n The where clause supports $like on fields that are indexed with a checked string type.\n \n $like queries will return entities that match a case sensitive substring of the provided value for the field.\n \n For case insensitive matching use $ilike in place of $like.\n \n Here's how you can do queries like startsWith, endsWith and includes.\n \n Example\tDescription\tJS equivalent\n { $like: \"Get%\" }\tStarts with 'Get'\tstartsWith\n { $like: \"%promoted!\" }\tEnds with 'promoted!'\tendsWith\n { $like: \"%fit%\" }\tContains 'fit'\tincludes\n Here's how you can use $like to find all goals that end with the word \"promoted!\"\n \n // Find all goals that end with the word \"promoted!\"\n const query = {\n goals: {\n $: {\n where: {\n title: { $like: '%promoted!' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n }\n ]\n }\n You can use $like in nested queries as well\n \n // Find goals that have todos with the word \"standup\" in their title\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $like: '%standup%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n Returns\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n }\n ]\n }\n Case-insensitive matching with $ilike:\n \n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $ilike: '%stand%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n },\n {\n \"id\": standId,\n \"title\": \"Stand up a food truck.\",\n }\n ]\n }\n ------------------------------------------------\n \n Here is the schema of the instantdb database:\n \n const _schema = i.schema({\n entities: {\n $users: i.entity({\n email: i.string().unique().indexed(),\n }),\n goals: i.entity({\n title: i.string(),\n }),\n todos: i.entity({\n title: i.string(),\n }),\n },\n links: {\n goalsTodos: {\n forward: {\n on: \"goals\",\n has: \"many\",\n label: \"todos\",\n },\n reverse: {\n on: \"todos\",\n has: \"many\",\n label: \"goals\",\n },\n },\n },\n });\n `;\n\n const completion = await client.chat.completions.create({\n messages: [{ role: \"developer\", content: systemPrompt }, { role: \"user\", content: e.text! }],\n model: \"gpt-4o-mini\",\n response_format: { \"type\": \"json_object\" },\n });\n\n const results = completion.choices[0].message.content;\n\n const db = init({\n appId: Deno.env.get(\"INSTANTDB_APP_ID\")!,\n adminToken: Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\"),\n });\n\n const query = JSON.parse(results!);\n console.log(query);\n\n const data = await db.query(query);\n\n await email({\n to: e.from,\n from: e.to,\n subject: `Re: ${e.subject}`,\n html: renderToString(),\n });\n } catch (err) {\n \n console.log(err);\n try {\n await email({\n to: e.from,\n from: e.to,\n subject: `Re: ${e.subject}`,\n text: err.toString(),\n });\n } catch (err) {\n return\n }\n \n }\n}",[],[171],"files",[150,169],"counts",{"_183":31,"_184":123,"_185":31,"_186":31},"pulls","branches","forks","envVars","contents",[189,192],{"_107":151,"_100":152,"_153":154,"_155":-5,"_156":140,"_157":123,"_158":113,"_109":190,"_104":31,"_160":161,"_162":163,"_164":27,"_165":-5,"_103":191},["D",1736992400637],[152],{"_107":170,"_100":171,"_153":172,"_155":-5,"_156":140,"_157":139,"_158":113,"_109":193,"_104":174,"_160":175,"_162":176,"_164":27,"_165":-5,"_103":194},["D",1737002329354],[171],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name.branch.$branch.history",{"_98":99,"_100":101,"_102":42,"_105":201,"_205":206,"_269":31,"_270":27},{"_107":108,"_100":101,"_109":202,"_111":-5,"_112":113,"_114":115,"_116":-5,"_117":-5,"_12":118,"_119":-5,"_120":113,"_121":-5,"_122":123,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_133":27,"_21":203,"_137":204},["D",1746139191928],{"_98":99,"_135":136},{"_104":139,"_100":42,"_107":140,"_141":108,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":101,"_147":99},"history",[207,212,220,228,236,244,252,259],{"_153":172,"_104":139,"_109":208,"_156":140,"_179":209},["D",1737002329354],[210],{"_107":170,"_156":140,"_153":172,"_100":171,"_162":176,"_160":175,"_104":174,"_155":-5,"_109":208,"_157":139,"_165":-5,"_158":113,"_164":27,"_103":211},[171],{"_153":172,"_104":174,"_109":213,"_156":140,"_179":214},["D",1737002304443],[215],{"_107":216,"_156":140,"_153":172,"_100":171,"_162":217,"_160":175,"_104":218,"_155":-5,"_109":213,"_157":174,"_165":-5,"_158":27,"_164":27,"_103":219},"325b7c14-26dd-11f0-a5b3-569c3dd06744","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server\";\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { id, init, tx } from \"npm:@instantdb/admin\"; // seems to be a bug with esm.sh at time of completion\n\nconst GoalsTable = ({ goals }) => {\n if (!goals || goals.length === 0) return <>;\n return (\n

\n \n \n \n \n \n \n \n \n {goals.map((goal) => (\n \n \n \n \n \n ))}\n \n

Complete	ID	Title
\n \n	{goal.id}	{goal.title}

\n );\n};\n\nconst TodosTable = ({ todos }) => {\n if (!todos || todos.length === 0) return <>;\n return (\n \n \n \n \n \n \n \n \n \n {todos.map((todo) => (\n \n \n \n \n \n ))}\n \n

Complete	ID	Title
\n \n	{todo.id}	{todo.title}

\n );\n};\n\nfunction Table({ data }) {\n return (\n <>\n \n
\n \n \n );\n}\n\nexport default async function(e: Email) {\n if (!Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\")) {\n throw new Error(\"INSTANTDB_ADMIN_TOKEN not set\");\n }\n\n if (!Deno.env.get(\"INSTANTDB_APP_ID\")) {\n throw new Error(\"INSTANTDB_APP_ID not set\");\n }\n\n if (e.subject && e.subject.startsWith(\"Re:\")) {\n return await email({\n to: e.from,\n from: e.to,\n subject: e.subject,\n text: \"I'm sorry, I can only reply to new email threads.\",\n });\n }\n\n try {\n const client = new OpenAI();\n\n const systemPrompt = `\n You are a helpful email assistant. You have access to an instantdb database. When people ask for info you will provide it for \n them by creating an instantdb query for the server to query the database. Return the query param json string only -- the json object that query is assigned to. Note that the results\n be rendered into 2 tables, one for goals and one for todos, so and associations will not be displayed, instead you should create a query that uses both tables.\n \n --------------------------------------------------------------------------\n Here is an example instantdb query (the examples use an unrelated database):\n \n Fetch namespace\n One of the simplest queries you can write is to simply get all entities of a namespace:\n const query = { goals: {} };\n \n Fetch multiple namespaces\n You can fetch multiple namespaces at once:\n const query = { goals: {}, todos: {} };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n }\n \n Fetch a specific entity\n If you want to filter entities, you can use the where keyword. Here we fetch a specific goal:\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n },\n };\n \n console.log(data)\n {\n \"goals\": [...],\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n ...\n ]\n }\n \n Fetch associations\n We can fetch goals and their related todos:\n \n const query = {\n goals: {\n todos: {},\n },\n };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n Fetch associations for filtered namespace\n We can fetch a specific entity in a namespace as well as it's related associations.\n\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n {\n \"id\": sleepId,\n \"title\": \"Go to bed early\"\n },\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n }\n ]\n }\n\n Filter namespace by associated values\n We can filter namespaces by their associations\n\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': 'Code a bunch',\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n {\n \"id\": standupId,\n \"title\": \"Do standup\"\n }\n ]\n }\n ]\n }\n\n Filter associations\n We can also filter associated data.\n\n const query = {\n goals: {\n todos: {\n $: {\n where: {\n 'todos.title': 'Go on a run',\n },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": []\n }\n ]\n }\n\n Inverse Associations\n Associations are also available in the reverse order.\n const query = {\n todos: {\n goals: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\",\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n },\n ...,\n ]\n }\n\n And key\n The and key is useful when you want an entity to match multiple conditions. In this case we want to find goals that have both Drink protein and Go on a run todos.:\n\n const query = {\n goals: {\n $: {\n where: {\n and: [\n { 'todos.title': 'Drink protein' },\n { 'todos.title': 'Go on a run' },\n ],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n OR\n The where clause supports or queries that will filter entities that match any of the clauses in the provided list:\n \n const query = {\n todos: {\n $: {\n where: {\n or: [{ title: 'Code a bunch' }, { title: 'Review PRs' }],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n ]\n }\n\n $in\n The where clause supports $in queries that will filter entities that match any of the items in the provided list. You can think of this as a shorthand for or on a single key.\n \n const query = {\n todos: {\n $: {\n where: {\n title: { $in: ['Code a bunch', 'Review PRs'] },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n }\n ]\n }\n\n Comparison operators\n The where clause supports comparison operators on fields that are indexed and have checked types.\n\n Operator\tDescription\tJS equivalent\n $gt\tgreater than\t>\n $lt\tless than\t<\n $gte\tgreater than or equal to\t>=\n $lte\tless than or equal to\t<=\n \n const query = {\n todos: {\n $: {\n where: {\n timeEstimateHours: { $gt: 24 },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": buildShipId,\n \"title\": \"Build a starship prototype\",\n \"timeEstimateHours\": 5000\n }\n ]\n }\n \n Dates can be stored as timestamps (milliseconds since the epoch, e.g. Date.now()) or as ISO 8601 strings (e.g. JSON.stringify(new Date())) and can be queried in the same formats:\n \n const now = '2024-11-26T15:25:00.054Z';\n const query = {\n todos: {\n $: { where: { dueDate: { $lte: now } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": slsFlightId,\n \"title\": \"Space Launch System maiden flight\",\n \"dueDate\": \"2017-01-01T00:00:00Z\"\n }\n ]\n }\n \n If you try to use comparison operators on data that isn't indexed and type-checked, you'll get an error:\n \n const query = {\n todos: {\n $: { where: { priority: { $gt: 2 } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(error);\n {\n \"message\": \"Validation failed for query\",\n \"hint\": {\n \"data-type\": \"query\",\n \"errors\": [\n {\n \"expected?\": \"indexed?\",\n \"in\": [\"priority\", \"$\", \"where\", \"priority\"],\n \"message\": \"The \\`todos.priority\\` attribute must be indexed to use comparison operators.\"\n }\n ],\n \"input\": {\n \"todos\": {\n \"$\": {\n \"where\": {\n \"priority\": {\n \"$gt\": 2\n }\n }\n }\n }\n }\n }\n }\n\n $not\n The where clause supports $not queries that will return entities that don't match the provided value for the field, including entities where the field is null or undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $not: 'work' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n },\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $isNull\n The where clause supports $isNull queries that will filters entities by whether the field value is either null or undefined.\n \n Set $isNull to true to return entities where where the field is null or undefined.\n \n Set $isNull to false to return entities where the field is not null and not undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: false },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n }\n ]\n }\n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: true },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $like\n The where clause supports $like on fields that are indexed with a checked string type.\n \n $like queries will return entities that match a case sensitive substring of the provided value for the field.\n \n For case insensitive matching use $ilike in place of $like.\n \n Here's how you can do queries like startsWith, endsWith and includes.\n \n Example\tDescription\tJS equivalent\n { $like: \"Get%\" }\tStarts with 'Get'\tstartsWith\n { $like: \"%promoted!\" }\tEnds with 'promoted!'\tendsWith\n { $like: \"%fit%\" }\tContains 'fit'\tincludes\n Here's how you can use $like to find all goals that end with the word \"promoted!\"\n \n // Find all goals that end with the word \"promoted!\"\n const query = {\n goals: {\n $: {\n where: {\n title: { $like: '%promoted!' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n }\n ]\n }\n You can use $like in nested queries as well\n \n // Find goals that have todos with the word \"standup\" in their title\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $like: '%standup%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n Returns\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n }\n ]\n }\n Case-insensitive matching with $ilike:\n \n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $ilike: '%stand%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n },\n {\n \"id\": standId,\n \"title\": \"Stand up a food truck.\",\n }\n ]\n }\n ------------------------------------------------\n \n Here is the schema of the instantdb database:\n \n const _schema = i.schema({\n entities: {\n $users: i.entity({\n email: i.string().unique().indexed(),\n }),\n goals: i.entity({\n title: i.string(),\n }),\n todos: i.entity({\n title: i.string(),\n }),\n },\n links: {\n goalsTodos: {\n forward: {\n on: \"goals\",\n has: \"many\",\n label: \"todos\",\n },\n reverse: {\n on: \"todos\",\n has: \"many\",\n label: \"goals\",\n },\n },\n },\n });\n `;\n\n const completion = await client.chat.completions.create({\n messages: [{ role: \"developer\", content: systemPrompt }, { role: \"user\", content: e.text! }],\n model: \"gpt-4o-mini\",\n response_format: { \"type\": \"json_object\" },\n });\n\n const results = completion.choices[0].message.content;\n\n const db = init({\n appId: Deno.env.get(\"INSTANTDB_APP_ID\")!,\n adminToken: Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\"),\n });\n\n const query = JSON.parse(results!);\n console.log(query);\n\n const data = await db.query(query);\n\n await email({\n to: e.from,\n from: e.to,\n subject: `Re: ${e.subject}`,\n html: renderToString(),\n });\n } catch (err) {\n console.log(err);\n try {\n await email({\n to: e.from,\n from: e.to,\n subject: `Re: ${e.subject}`,\n text: err.toString(),\n });\n } catch (err) {\n }\n }\n}",6,[171],{"_153":172,"_104":218,"_109":221,"_156":140,"_179":222},["D",1737002273575],[223],{"_107":224,"_156":140,"_153":172,"_100":171,"_162":225,"_160":175,"_104":226,"_155":-5,"_109":221,"_157":218,"_165":-5,"_158":27,"_164":27,"_103":227},"3254d814-26dd-11f0-a5b3-569c3dd06744","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server\";\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { id, init, tx } from \"npm:@instantdb/admin\"; // seems to be a bug with esm.sh at time of completion\n\nconst GoalsTable = ({ goals }) => {\n if (!goals || goals.length === 0) return <>;\n return (\n

\n \n \n \n \n \n \n \n \n {goals.map((goal) => (\n \n \n \n \n \n ))}\n \n

Complete	ID	Title
\n \n	{goal.id}	{goal.title}

\n );\n};\n\nconst TodosTable = ({ todos }) => {\n if (!todos || todos.length === 0) return <>;\n return (\n \n \n \n \n \n \n \n \n \n {todos.map((todo) => (\n \n \n \n \n \n ))}\n \n

Complete	ID	Title
\n \n	{todo.id}	{todo.title}

\n );\n};\n\nfunction Table({ data }) {\n return (\n <>\n \n
\n \n \n );\n}\n\nexport default async function(e: Email) {\n if (!Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\")) {\n throw new Error(\"INSTANTDB_ADMIN_TOKEN not set\");\n }\n\n if (!Deno.env.get(\"INSTANTDB_APP_ID\")) {\n throw new Error(\"INSTANTDB_APP_ID not set\");\n }\n\n if (e.subject && e.subject.startsWith(\"Re:\")) {\n return await email({\n to: e.from,\n from: e.to,\n subject: e.subject,\n text: \"I'm sorry, I can only reply to new email threads.\",\n });\n }\n\n try {\n const client = new OpenAI();\n\n const systemPrompt = `\n You are a helpful email assistant. You have access to an instantdb database. When people ask for info you will provide it for \n them by creating an instantdb query for the server to query the database. Return the query param json string only -- the json object that query is assigned to. Note that the results\n be rendered into 2 tables, one for goals and one for todos, so and associations will not be displayed, instead you should create a query that uses both tables.\n \n --------------------------------------------------------------------------\n Here is an example instantdb query (the examples use an unrelated database):\n \n Fetch namespace\n One of the simplest queries you can write is to simply get all entities of a namespace:\n const query = { goals: {} };\n \n Fetch multiple namespaces\n You can fetch multiple namespaces at once:\n const query = { goals: {}, todos: {} };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n }\n \n Fetch a specific entity\n If you want to filter entities, you can use the where keyword. Here we fetch a specific goal:\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n },\n };\n \n console.log(data)\n {\n \"goals\": [...],\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n ...\n ]\n }\n \n Fetch associations\n We can fetch goals and their related todos:\n \n const query = {\n goals: {\n todos: {},\n },\n };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n Fetch associations for filtered namespace\n We can fetch a specific entity in a namespace as well as it's related associations.\n\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n {\n \"id\": sleepId,\n \"title\": \"Go to bed early\"\n },\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n }\n ]\n }\n\n Filter namespace by associated values\n We can filter namespaces by their associations\n\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': 'Code a bunch',\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n {\n \"id\": standupId,\n \"title\": \"Do standup\"\n }\n ]\n }\n ]\n }\n\n Filter associations\n We can also filter associated data.\n\n const query = {\n goals: {\n todos: {\n $: {\n where: {\n 'todos.title': 'Go on a run',\n },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": []\n }\n ]\n }\n\n Inverse Associations\n Associations are also available in the reverse order.\n const query = {\n todos: {\n goals: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\",\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n },\n ...,\n ]\n }\n\n And key\n The and key is useful when you want an entity to match multiple conditions. In this case we want to find goals that have both Drink protein and Go on a run todos.:\n\n const query = {\n goals: {\n $: {\n where: {\n and: [\n { 'todos.title': 'Drink protein' },\n { 'todos.title': 'Go on a run' },\n ],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n OR\n The where clause supports or queries that will filter entities that match any of the clauses in the provided list:\n \n const query = {\n todos: {\n $: {\n where: {\n or: [{ title: 'Code a bunch' }, { title: 'Review PRs' }],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n ]\n }\n\n $in\n The where clause supports $in queries that will filter entities that match any of the items in the provided list. You can think of this as a shorthand for or on a single key.\n \n const query = {\n todos: {\n $: {\n where: {\n title: { $in: ['Code a bunch', 'Review PRs'] },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n }\n ]\n }\n\n Comparison operators\n The where clause supports comparison operators on fields that are indexed and have checked types.\n\n Operator\tDescription\tJS equivalent\n $gt\tgreater than\t>\n $lt\tless than\t<\n $gte\tgreater than or equal to\t>=\n $lte\tless than or equal to\t<=\n \n const query = {\n todos: {\n $: {\n where: {\n timeEstimateHours: { $gt: 24 },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": buildShipId,\n \"title\": \"Build a starship prototype\",\n \"timeEstimateHours\": 5000\n }\n ]\n }\n \n Dates can be stored as timestamps (milliseconds since the epoch, e.g. Date.now()) or as ISO 8601 strings (e.g. JSON.stringify(new Date())) and can be queried in the same formats:\n \n const now = '2024-11-26T15:25:00.054Z';\n const query = {\n todos: {\n $: { where: { dueDate: { $lte: now } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": slsFlightId,\n \"title\": \"Space Launch System maiden flight\",\n \"dueDate\": \"2017-01-01T00:00:00Z\"\n }\n ]\n }\n \n If you try to use comparison operators on data that isn't indexed and type-checked, you'll get an error:\n \n const query = {\n todos: {\n $: { where: { priority: { $gt: 2 } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(error);\n {\n \"message\": \"Validation failed for query\",\n \"hint\": {\n \"data-type\": \"query\",\n \"errors\": [\n {\n \"expected?\": \"indexed?\",\n \"in\": [\"priority\", \"$\", \"where\", \"priority\"],\n \"message\": \"The \\`todos.priority\\` attribute must be indexed to use comparison operators.\"\n }\n ],\n \"input\": {\n \"todos\": {\n \"$\": {\n \"where\": {\n \"priority\": {\n \"$gt\": 2\n }\n }\n }\n }\n }\n }\n }\n\n $not\n The where clause supports $not queries that will return entities that don't match the provided value for the field, including entities where the field is null or undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $not: 'work' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n },\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $isNull\n The where clause supports $isNull queries that will filters entities by whether the field value is either null or undefined.\n \n Set $isNull to true to return entities where where the field is null or undefined.\n \n Set $isNull to false to return entities where the field is not null and not undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: false },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n }\n ]\n }\n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: true },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $like\n The where clause supports $like on fields that are indexed with a checked string type.\n \n $like queries will return entities that match a case sensitive substring of the provided value for the field.\n \n For case insensitive matching use $ilike in place of $like.\n \n Here's how you can do queries like startsWith, endsWith and includes.\n \n Example\tDescription\tJS equivalent\n { $like: \"Get%\" }\tStarts with 'Get'\tstartsWith\n { $like: \"%promoted!\" }\tEnds with 'promoted!'\tendsWith\n { $like: \"%fit%\" }\tContains 'fit'\tincludes\n Here's how you can use $like to find all goals that end with the word \"promoted!\"\n \n // Find all goals that end with the word \"promoted!\"\n const query = {\n goals: {\n $: {\n where: {\n title: { $like: '%promoted!' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n }\n ]\n }\n You can use $like in nested queries as well\n \n // Find goals that have todos with the word \"standup\" in their title\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $like: '%standup%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n Returns\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n }\n ]\n }\n Case-insensitive matching with $ilike:\n \n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $ilike: '%stand%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n },\n {\n \"id\": standId,\n \"title\": \"Stand up a food truck.\",\n }\n ]\n }\n ------------------------------------------------\n \n Here is the schema of the instantdb database:\n \n const _schema = i.schema({\n entities: {\n $users: i.entity({\n email: i.string().unique().indexed(),\n }),\n goals: i.entity({\n title: i.string(),\n }),\n todos: i.entity({\n title: i.string(),\n }),\n },\n links: {\n goalsTodos: {\n forward: {\n on: \"goals\",\n has: \"many\",\n label: \"todos\",\n },\n reverse: {\n on: \"todos\",\n has: \"many\",\n label: \"goals\",\n },\n },\n },\n });\n `;\n\n const completion = await client.chat.completions.create({\n messages: [{ role: \"developer\", content: systemPrompt }, { role: \"user\", content: e.text! }],\n model: \"gpt-4o-mini\",\n response_format: { \"type\": \"json_object\" },\n });\n\n const results = completion.choices[0].message.content;\n\n const db = init({\n appId: Deno.env.get(\"INSTANTDB_APP_ID\")!,\n adminToken: Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\"),\n });\n\n const query = JSON.parse(results!);\n console.log(query);\n\n const data = await db.query(query);\n\n await email({\n to: e.from,\n from: e.to,\n subject: `Re: ${e.subject}`,\n html: renderToString(),\n });\n } catch (err) {\n console.log(err);\n\n await email({\n to: e.from,\n from: e.to,\n subject: `Re: ${e.subject}`,\n text: err.toString() ?? \"\",\n });\n }\n}",5,[171],{"_153":172,"_104":226,"_109":229,"_156":140,"_179":230},["D",1737001957493],[231],{"_107":232,"_156":140,"_153":172,"_100":171,"_162":233,"_160":175,"_104":234,"_155":-5,"_109":229,"_157":226,"_165":-5,"_158":27,"_164":27,"_103":235},"324ead40-26dd-11f0-a5b3-569c3dd06744","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server\";\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { id, init, tx } from \"npm:@instantdb/admin\"; // seems to be a bug with esm.sh at time of completion\n\nconst GoalsTable = ({ goals }) => {\n if (!goals || goals.length === 0) return <>;\n return (\n

\n \n \n \n \n \n \n \n \n {goals.map((goal) => (\n \n \n \n \n \n ))}\n \n

Complete	ID	Title
\n \n	{goal.id}	{goal.title}

\n );\n};\n\nconst TodosTable = ({ todos }) => {\n if (!todos || todos.length === 0) return <>;\n return (\n \n \n \n \n \n \n \n \n \n {todos.map((todo) => (\n \n \n \n \n \n ))}\n \n

Complete	ID	Title
\n \n	{todo.id}	{todo.title}

\n );\n};\n\nfunction Table({ data }) {\n return (\n <>\n \n
\n \n \n );\n}\n\nexport default async function(e: Email) {\n if (!Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\")) {\n throw new Error(\"INSTANTDB_ADMIN_TOKEN not set\");\n }\n\n if (!Deno.env.get(\"INSTANTDB_APP_ID\")) {\n throw new Error(\"INSTANTDB_APP_ID not set\");\n }\n\n if (e.subject && e.subject.startsWith(\"Re:\")) {\n return await email({\n to: e.from,\n from: e.to,\n subject: e.subject,\n text: \"I'm sorry, I can only reply to new email threads.\",\n });\n }\n\n try {\n const client = new OpenAI();\n\n const systemPrompt = `\n You are a helpful email assistant. You have access to an instantdb database. When people ask for info you will provide it for \n them by creating an instantdb query for the server to query the database. Return the query param json string only -- the json object that query is assigned to. Note that the results\n be rendered into 2 tables, one for goals and one for todos, so and associations will not be displayed, instead you should create a query that uses both tables.\n \n --------------------------------------------------------------------------\n Here is an example instantdb query (the examples use an unrelated database):\n \n Fetch namespace\n One of the simplest queries you can write is to simply get all entities of a namespace:\n const query = { goals: {} };\n \n Fetch multiple namespaces\n You can fetch multiple namespaces at once:\n const query = { goals: {}, todos: {} };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n }\n \n Fetch a specific entity\n If you want to filter entities, you can use the where keyword. Here we fetch a specific goal:\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n },\n };\n \n console.log(data)\n {\n \"goals\": [...],\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n ...\n ]\n }\n \n Fetch associations\n We can fetch goals and their related todos:\n \n const query = {\n goals: {\n todos: {},\n },\n };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n Fetch associations for filtered namespace\n We can fetch a specific entity in a namespace as well as it's related associations.\n\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n {\n \"id\": sleepId,\n \"title\": \"Go to bed early\"\n },\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n }\n ]\n }\n\n Filter namespace by associated values\n We can filter namespaces by their associations\n\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': 'Code a bunch',\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n {\n \"id\": standupId,\n \"title\": \"Do standup\"\n }\n ]\n }\n ]\n }\n\n Filter associations\n We can also filter associated data.\n\n const query = {\n goals: {\n todos: {\n $: {\n where: {\n 'todos.title': 'Go on a run',\n },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": []\n }\n ]\n }\n\n Inverse Associations\n Associations are also available in the reverse order.\n const query = {\n todos: {\n goals: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\",\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n },\n ...,\n ]\n }\n\n And key\n The and key is useful when you want an entity to match multiple conditions. In this case we want to find goals that have both Drink protein and Go on a run todos.:\n\n const query = {\n goals: {\n $: {\n where: {\n and: [\n { 'todos.title': 'Drink protein' },\n { 'todos.title': 'Go on a run' },\n ],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n OR\n The where clause supports or queries that will filter entities that match any of the clauses in the provided list:\n \n const query = {\n todos: {\n $: {\n where: {\n or: [{ title: 'Code a bunch' }, { title: 'Review PRs' }],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n ]\n }\n\n $in\n The where clause supports $in queries that will filter entities that match any of the items in the provided list. You can think of this as a shorthand for or on a single key.\n \n const query = {\n todos: {\n $: {\n where: {\n title: { $in: ['Code a bunch', 'Review PRs'] },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n }\n ]\n }\n\n Comparison operators\n The where clause supports comparison operators on fields that are indexed and have checked types.\n\n Operator\tDescription\tJS equivalent\n $gt\tgreater than\t>\n $lt\tless than\t<\n $gte\tgreater than or equal to\t>=\n $lte\tless than or equal to\t<=\n \n const query = {\n todos: {\n $: {\n where: {\n timeEstimateHours: { $gt: 24 },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": buildShipId,\n \"title\": \"Build a starship prototype\",\n \"timeEstimateHours\": 5000\n }\n ]\n }\n \n Dates can be stored as timestamps (milliseconds since the epoch, e.g. Date.now()) or as ISO 8601 strings (e.g. JSON.stringify(new Date())) and can be queried in the same formats:\n \n const now = '2024-11-26T15:25:00.054Z';\n const query = {\n todos: {\n $: { where: { dueDate: { $lte: now } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": slsFlightId,\n \"title\": \"Space Launch System maiden flight\",\n \"dueDate\": \"2017-01-01T00:00:00Z\"\n }\n ]\n }\n \n If you try to use comparison operators on data that isn't indexed and type-checked, you'll get an error:\n \n const query = {\n todos: {\n $: { where: { priority: { $gt: 2 } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(error);\n {\n \"message\": \"Validation failed for query\",\n \"hint\": {\n \"data-type\": \"query\",\n \"errors\": [\n {\n \"expected?\": \"indexed?\",\n \"in\": [\"priority\", \"$\", \"where\", \"priority\"],\n \"message\": \"The \\`todos.priority\\` attribute must be indexed to use comparison operators.\"\n }\n ],\n \"input\": {\n \"todos\": {\n \"$\": {\n \"where\": {\n \"priority\": {\n \"$gt\": 2\n }\n }\n }\n }\n }\n }\n }\n\n $not\n The where clause supports $not queries that will return entities that don't match the provided value for the field, including entities where the field is null or undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $not: 'work' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n },\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $isNull\n The where clause supports $isNull queries that will filters entities by whether the field value is either null or undefined.\n \n Set $isNull to true to return entities where where the field is null or undefined.\n \n Set $isNull to false to return entities where the field is not null and not undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: false },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n }\n ]\n }\n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: true },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $like\n The where clause supports $like on fields that are indexed with a checked string type.\n \n $like queries will return entities that match a case sensitive substring of the provided value for the field.\n \n For case insensitive matching use $ilike in place of $like.\n \n Here's how you can do queries like startsWith, endsWith and includes.\n \n Example\tDescription\tJS equivalent\n { $like: \"Get%\" }\tStarts with 'Get'\tstartsWith\n { $like: \"%promoted!\" }\tEnds with 'promoted!'\tendsWith\n { $like: \"%fit%\" }\tContains 'fit'\tincludes\n Here's how you can use $like to find all goals that end with the word \"promoted!\"\n \n // Find all goals that end with the word \"promoted!\"\n const query = {\n goals: {\n $: {\n where: {\n title: { $like: '%promoted!' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n }\n ]\n }\n You can use $like in nested queries as well\n \n // Find goals that have todos with the word \"standup\" in their title\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $like: '%standup%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n Returns\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n }\n ]\n }\n Case-insensitive matching with $ilike:\n \n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $ilike: '%stand%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n },\n {\n \"id\": standId,\n \"title\": \"Stand up a food truck.\",\n }\n ]\n }\n ------------------------------------------------\n \n Here is the schema of the instantdb database:\n \n const _schema = i.schema({\n entities: {\n $users: i.entity({\n email: i.string().unique().indexed(),\n }),\n goals: i.entity({\n title: i.string(),\n }),\n todos: i.entity({\n title: i.string(),\n }),\n },\n links: {\n goalsTodos: {\n forward: {\n on: \"goals\",\n has: \"many\",\n label: \"todos\",\n },\n reverse: {\n on: \"todos\",\n has: \"many\",\n label: \"goals\",\n },\n },\n },\n });\n `;\n\n const completion = await client.chat.completions.create({\n messages: [{ role: \"developer\", content: systemPrompt }, { role: \"user\", content: e.text! }],\n model: \"gpt-4o-mini\",\n response_format: { \"type\": \"json_object\" },\n });\n\n const results = completion.choices[0].message.content;\n\n const db = init({\n appId: Deno.env.get(\"INSTANTDB_APP_ID\")!,\n adminToken: Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\"),\n });\n\n const query = JSON.parse(results!);\n console.log(query);\n\n const data = await db.query(query);\n\n await email({\n to: e.from,\n from: e.to,\n subject: `Re: ${e.subject}`,\n html: renderToString(),\n });\n } catch (err) {\n console.log(err);\n\n await email({\n to: e.from,\n from: e.to,\n subject: `Re: ${e.subject}`,\n text: err.toString(),\n });\n }\n}",4,[171],{"_153":172,"_104":234,"_109":237,"_156":140,"_179":238},["D",1737001954167],[239],{"_107":240,"_156":140,"_153":172,"_100":171,"_162":241,"_160":175,"_104":242,"_155":-5,"_109":237,"_157":234,"_165":-5,"_158":27,"_164":27,"_103":243},"3248757e-26dd-11f0-a5b3-569c3dd06744","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server\";\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { id, init, tx } from \"npm:@instantdb/admin\"; // seems to be a bug with esm.sh at time of completion\n\nconst GoalsTable = ({ goals }) => {\n if (!goals || goals.length === 0) return <>;\n return (\n

\n \n \n \n \n \n \n \n \n {goals.map((goal) => (\n \n \n \n \n \n ))}\n \n

Complete	ID	Title
\n \n	{goal.id}	{goal.title}

\n );\n};\n\nconst TodosTable = ({ todos }) => {\n if (!todos || todos.length === 0) return <>;\n return (\n \n \n \n \n \n \n \n \n \n {todos.map((todo) => (\n \n \n \n \n \n ))}\n \n

Complete	ID	Title
\n \n	{todo.id}	{todo.title}

\n );\n};\n\nfunction Table({ data }) {\n return (\n <>\n \n
\n \n \n );\n}\n\nexport default async function(e: Email) {\n if (!Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\")) {\n throw new Error(\"INSTANTDB_ADMIN_TOKEN not set\");\n }\n\n if (!Deno.env.get(\"INSTANTDB_APP_ID\")) {\n throw new Error(\"INSTANTDB_APP_ID not set\");\n }\n\n if (e.subject && e.subject.startsWith(\"Re:\")) {\n return await email({\n to: e.from,\n from: e.to,\n subject: e.subject,\n text: \"I'm sorry, I can only reply to new email threads.\",\n });\n }\n\n try {\n const client = new OpenAI();\n\n const systemPrompt = `\n You are a helpful email assistant. You have access to an instantdb database. When people ask for info you will provide it for \n them by creating an instantdb query for the server to query the database. Return the query param json string only -- the json object that query is assigned to. Note that the results\n be rendered into 2 tables, one for goals and one for todos, so and associations will not be displayed, instead you should create a query that uses both tables.\n \n --------------------------------------------------------------------------\n Here is an example instantdb query (the examples use an unrelated database):\n \n Fetch namespace\n One of the simplest queries you can write is to simply get all entities of a namespace:\n const query = { goals: {} };\n \n Fetch multiple namespaces\n You can fetch multiple namespaces at once:\n const query = { goals: {}, todos: {} };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n }\n \n Fetch a specific entity\n If you want to filter entities, you can use the where keyword. Here we fetch a specific goal:\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n },\n };\n \n console.log(data)\n {\n \"goals\": [...],\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n ...\n ]\n }\n \n Fetch associations\n We can fetch goals and their related todos:\n \n const query = {\n goals: {\n todos: {},\n },\n };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n Fetch associations for filtered namespace\n We can fetch a specific entity in a namespace as well as it's related associations.\n\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n {\n \"id\": sleepId,\n \"title\": \"Go to bed early\"\n },\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n }\n ]\n }\n\n Filter namespace by associated values\n We can filter namespaces by their associations\n\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': 'Code a bunch',\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n {\n \"id\": standupId,\n \"title\": \"Do standup\"\n }\n ]\n }\n ]\n }\n\n Filter associations\n We can also filter associated data.\n\n const query = {\n goals: {\n todos: {\n $: {\n where: {\n 'todos.title': 'Go on a run',\n },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": []\n }\n ]\n }\n\n Inverse Associations\n Associations are also available in the reverse order.\n const query = {\n todos: {\n goals: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\",\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n },\n ...,\n ]\n }\n\n And key\n The and key is useful when you want an entity to match multiple conditions. In this case we want to find goals that have both Drink protein and Go on a run todos.:\n\n const query = {\n goals: {\n $: {\n where: {\n and: [\n { 'todos.title': 'Drink protein' },\n { 'todos.title': 'Go on a run' },\n ],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n OR\n The where clause supports or queries that will filter entities that match any of the clauses in the provided list:\n \n const query = {\n todos: {\n $: {\n where: {\n or: [{ title: 'Code a bunch' }, { title: 'Review PRs' }],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n ]\n }\n\n $in\n The where clause supports $in queries that will filter entities that match any of the items in the provided list. You can think of this as a shorthand for or on a single key.\n \n const query = {\n todos: {\n $: {\n where: {\n title: { $in: ['Code a bunch', 'Review PRs'] },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n }\n ]\n }\n\n Comparison operators\n The where clause supports comparison operators on fields that are indexed and have checked types.\n\n Operator\tDescription\tJS equivalent\n $gt\tgreater than\t>\n $lt\tless than\t<\n $gte\tgreater than or equal to\t>=\n $lte\tless than or equal to\t<=\n \n const query = {\n todos: {\n $: {\n where: {\n timeEstimateHours: { $gt: 24 },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": buildShipId,\n \"title\": \"Build a starship prototype\",\n \"timeEstimateHours\": 5000\n }\n ]\n }\n \n Dates can be stored as timestamps (milliseconds since the epoch, e.g. Date.now()) or as ISO 8601 strings (e.g. JSON.stringify(new Date())) and can be queried in the same formats:\n \n const now = '2024-11-26T15:25:00.054Z';\n const query = {\n todos: {\n $: { where: { dueDate: { $lte: now } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": slsFlightId,\n \"title\": \"Space Launch System maiden flight\",\n \"dueDate\": \"2017-01-01T00:00:00Z\"\n }\n ]\n }\n \n If you try to use comparison operators on data that isn't indexed and type-checked, you'll get an error:\n \n const query = {\n todos: {\n $: { where: { priority: { $gt: 2 } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(error);\n {\n \"message\": \"Validation failed for query\",\n \"hint\": {\n \"data-type\": \"query\",\n \"errors\": [\n {\n \"expected?\": \"indexed?\",\n \"in\": [\"priority\", \"$\", \"where\", \"priority\"],\n \"message\": \"The \\`todos.priority\\` attribute must be indexed to use comparison operators.\"\n }\n ],\n \"input\": {\n \"todos\": {\n \"$\": {\n \"where\": {\n \"priority\": {\n \"$gt\": 2\n }\n }\n }\n }\n }\n }\n }\n\n $not\n The where clause supports $not queries that will return entities that don't match the provided value for the field, including entities where the field is null or undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $not: 'work' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n },\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $isNull\n The where clause supports $isNull queries that will filters entities by whether the field value is either null or undefined.\n \n Set $isNull to true to return entities where where the field is null or undefined.\n \n Set $isNull to false to return entities where the field is not null and not undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: false },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n }\n ]\n }\n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: true },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $like\n The where clause supports $like on fields that are indexed with a checked string type.\n \n $like queries will return entities that match a case sensitive substring of the provided value for the field.\n \n For case insensitive matching use $ilike in place of $like.\n \n Here's how you can do queries like startsWith, endsWith and includes.\n \n Example\tDescription\tJS equivalent\n { $like: \"Get%\" }\tStarts with 'Get'\tstartsWith\n { $like: \"%promoted!\" }\tEnds with 'promoted!'\tendsWith\n { $like: \"%fit%\" }\tContains 'fit'\tincludes\n Here's how you can use $like to find all goals that end with the word \"promoted!\"\n \n // Find all goals that end with the word \"promoted!\"\n const query = {\n goals: {\n $: {\n where: {\n title: { $like: '%promoted!' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n }\n ]\n }\n You can use $like in nested queries as well\n \n // Find goals that have todos with the word \"standup\" in their title\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $like: '%standup%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n Returns\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n }\n ]\n }\n Case-insensitive matching with $ilike:\n \n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $ilike: '%stand%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n },\n {\n \"id\": standId,\n \"title\": \"Stand up a food truck.\",\n }\n ]\n }\n ------------------------------------------------\n \n Here is the schema of the instantdb database:\n \n const _schema = i.schema({\n entities: {\n $users: i.entity({\n email: i.string().unique().indexed(),\n }),\n goals: i.entity({\n title: i.string(),\n }),\n todos: i.entity({\n title: i.string(),\n }),\n },\n links: {\n goalsTodos: {\n forward: {\n on: \"goals\",\n has: \"many\",\n label: \"todos\",\n },\n reverse: {\n on: \"todos\",\n has: \"many\",\n label: \"goals\",\n },\n },\n },\n });\n `;\n\n const completion = await client.chat.completions.create({\n messages: [{ role: \"developer\", content: systemPrompt }, { role: \"user\", content: e.text! }],\n model: \"gpt-4o-mini\",\n response_format: { \"type\": \"json_object\" },\n });\n\n const results = completion.choices[0].message.content;\n\n const db = init({\n appId: Deno.env.get(\"INSTANTDB_APP_ID\")!,\n adminToken: Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\"),\n });\n\n const query = JSON.parse(results!);\n console.log(query);\n\n const data = await db.query(query);\n\n await email({\n to: e.from,\n from: e.to,\n subject: `Re: ${e.subject}`,\n html: renderToString(),\n });\n } catch (err) {\n console.log(err);\n await email({\n to: e.from,\n from: e.to,\n subject: `Re: ${e.subject}`,\n text: err.toString(),\n });\n }\n}",3,[171],{"_153":172,"_104":242,"_109":245,"_156":140,"_179":246},["D",1737001948010],[247],{"_107":248,"_156":140,"_153":172,"_100":171,"_162":249,"_160":175,"_104":250,"_155":-5,"_109":245,"_157":242,"_165":-5,"_158":27,"_164":27,"_103":251},"32425a90-26dd-11f0-a5b3-569c3dd06744","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server\";\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { id, init, tx } from \"npm:@instantdb/admin\"; // seems to be a bug with esm.sh at time of completion\n\nconst GoalsTable = ({ goals }) => {\n if (!goals || goals.length === 0) return <>;\n return (\n

\n \n \n \n \n \n \n \n \n {goals.map((goal) => (\n \n \n \n \n \n ))}\n \n

Complete	ID	Title
\n \n	{goal.id}	{goal.title}

\n );\n};\n\nconst TodosTable = ({ todos }) => {\n if (!todos || todos.length === 0) return <>;\n return (\n \n \n \n \n \n \n \n \n \n {todos.map((todo) => (\n \n \n \n \n \n ))}\n \n

Complete	ID	Title
\n \n	{todo.id}	{todo.title}

\n );\n};\n\nfunction Table({ data }) {\n return (\n <>\n \n
\n \n \n );\n}\n\nexport default async function(e: Email) {\n if (!Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\")) {\n throw new Error(\"INSTANTDB_ADMIN_TOKEN not set\");\n }\n\n if (!Deno.env.get(\"INSTANTDB_APP_ID\")) {\n throw new Error(\"INSTANTDB_APP_ID not set\");\n }\n\n if (e.subject && e.subject.startsWith(\"Re:\")) {\n return await email({\n to: e.from,\n from: e.to,\n subject: e.subject,\n text: \"I'm sorry, I can only reply to new email threads.\",\n });\n }\n\n try {\n const client = new OpenAI();\n\n const systemPrompt = `\n You are a helpful email assistant. You have access to an instantdb database. When people ask for info you will provide it for \n them by creating an instantdb query for the server to query the database. Return the query param json string only -- the json object that query is assigned to. Note that the results\n be rendered into 2 tables, one for goals and one for todos, so and associations will not be displayed, instead you should create a query that uses both tables.\n \n --------------------------------------------------------------------------\n Here is an example instantdb query (the examples use an unrelated database):\n \n Fetch namespace\n One of the simplest queries you can write is to simply get all entities of a namespace:\n const query = { goals: {} };\n \n Fetch multiple namespaces\n You can fetch multiple namespaces at once:\n const query = { goals: {}, todos: {} };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n }\n \n Fetch a specific entity\n If you want to filter entities, you can use the where keyword. Here we fetch a specific goal:\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n },\n };\n \n console.log(data)\n {\n \"goals\": [...],\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n ...\n ]\n }\n \n Fetch associations\n We can fetch goals and their related todos:\n \n const query = {\n goals: {\n todos: {},\n },\n };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n Fetch associations for filtered namespace\n We can fetch a specific entity in a namespace as well as it's related associations.\n\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n {\n \"id\": sleepId,\n \"title\": \"Go to bed early\"\n },\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n }\n ]\n }\n\n Filter namespace by associated values\n We can filter namespaces by their associations\n\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': 'Code a bunch',\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n {\n \"id\": standupId,\n \"title\": \"Do standup\"\n }\n ]\n }\n ]\n }\n\n Filter associations\n We can also filter associated data.\n\n const query = {\n goals: {\n todos: {\n $: {\n where: {\n 'todos.title': 'Go on a run',\n },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": []\n }\n ]\n }\n\n Inverse Associations\n Associations are also available in the reverse order.\n const query = {\n todos: {\n goals: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\",\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n },\n ...,\n ]\n }\n\n And key\n The and key is useful when you want an entity to match multiple conditions. In this case we want to find goals that have both Drink protein and Go on a run todos.:\n\n const query = {\n goals: {\n $: {\n where: {\n and: [\n { 'todos.title': 'Drink protein' },\n { 'todos.title': 'Go on a run' },\n ],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n OR\n The where clause supports or queries that will filter entities that match any of the clauses in the provided list:\n \n const query = {\n todos: {\n $: {\n where: {\n or: [{ title: 'Code a bunch' }, { title: 'Review PRs' }],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n ]\n }\n\n $in\n The where clause supports $in queries that will filter entities that match any of the items in the provided list. You can think of this as a shorthand for or on a single key.\n \n const query = {\n todos: {\n $: {\n where: {\n title: { $in: ['Code a bunch', 'Review PRs'] },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n }\n ]\n }\n\n Comparison operators\n The where clause supports comparison operators on fields that are indexed and have checked types.\n\n Operator\tDescription\tJS equivalent\n $gt\tgreater than\t>\n $lt\tless than\t<\n $gte\tgreater than or equal to\t>=\n $lte\tless than or equal to\t<=\n \n const query = {\n todos: {\n $: {\n where: {\n timeEstimateHours: { $gt: 24 },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": buildShipId,\n \"title\": \"Build a starship prototype\",\n \"timeEstimateHours\": 5000\n }\n ]\n }\n \n Dates can be stored as timestamps (milliseconds since the epoch, e.g. Date.now()) or as ISO 8601 strings (e.g. JSON.stringify(new Date())) and can be queried in the same formats:\n \n const now = '2024-11-26T15:25:00.054Z';\n const query = {\n todos: {\n $: { where: { dueDate: { $lte: now } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": slsFlightId,\n \"title\": \"Space Launch System maiden flight\",\n \"dueDate\": \"2017-01-01T00:00:00Z\"\n }\n ]\n }\n \n If you try to use comparison operators on data that isn't indexed and type-checked, you'll get an error:\n \n const query = {\n todos: {\n $: { where: { priority: { $gt: 2 } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(error);\n {\n \"message\": \"Validation failed for query\",\n \"hint\": {\n \"data-type\": \"query\",\n \"errors\": [\n {\n \"expected?\": \"indexed?\",\n \"in\": [\"priority\", \"$\", \"where\", \"priority\"],\n \"message\": \"The \\`todos.priority\\` attribute must be indexed to use comparison operators.\"\n }\n ],\n \"input\": {\n \"todos\": {\n \"$\": {\n \"where\": {\n \"priority\": {\n \"$gt\": 2\n }\n }\n }\n }\n }\n }\n }\n\n $not\n The where clause supports $not queries that will return entities that don't match the provided value for the field, including entities where the field is null or undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $not: 'work' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n },\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $isNull\n The where clause supports $isNull queries that will filters entities by whether the field value is either null or undefined.\n \n Set $isNull to true to return entities where where the field is null or undefined.\n \n Set $isNull to false to return entities where the field is not null and not undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: false },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n }\n ]\n }\n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: true },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $like\n The where clause supports $like on fields that are indexed with a checked string type.\n \n $like queries will return entities that match a case sensitive substring of the provided value for the field.\n \n For case insensitive matching use $ilike in place of $like.\n \n Here's how you can do queries like startsWith, endsWith and includes.\n \n Example\tDescription\tJS equivalent\n { $like: \"Get%\" }\tStarts with 'Get'\tstartsWith\n { $like: \"%promoted!\" }\tEnds with 'promoted!'\tendsWith\n { $like: \"%fit%\" }\tContains 'fit'\tincludes\n Here's how you can use $like to find all goals that end with the word \"promoted!\"\n \n // Find all goals that end with the word \"promoted!\"\n const query = {\n goals: {\n $: {\n where: {\n title: { $like: '%promoted!' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n }\n ]\n }\n You can use $like in nested queries as well\n \n // Find goals that have todos with the word \"standup\" in their title\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $like: '%standup%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n Returns\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n }\n ]\n }\n Case-insensitive matching with $ilike:\n \n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $ilike: '%stand%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n },\n {\n \"id\": standId,\n \"title\": \"Stand up a food truck.\",\n }\n ]\n }\n ------------------------------------------------\n \n Here is the schema of the instantdb database:\n \n const _schema = i.schema({\n entities: {\n $users: i.entity({\n email: i.string().unique().indexed(),\n }),\n goals: i.entity({\n title: i.string(),\n }),\n todos: i.entity({\n title: i.string(),\n }),\n },\n links: {\n goalsTodos: {\n forward: {\n on: \"goals\",\n has: \"many\",\n label: \"todos\",\n },\n reverse: {\n on: \"todos\",\n has: \"many\",\n label: \"goals\",\n },\n },\n },\n });\n `;\n\n const completion = await client.chat.completions.create({\n messages: [{ role: \"developer\", content: systemPrompt }, { role: \"user\", content: e.text! }],\n model: \"gpt-4o-mini\",\n response_format: { \"type\": \"json_object\" },\n });\n\n const results = completion.choices[0].message.content;\n\n const db = init({\n appId: Deno.env.get(\"INSTANTDB_APP_ID\")!,\n adminToken: Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\"),\n });\n\n const query = JSON.parse(results!);\n console.log(query);\n\n const data = await db.query(query);\n\n await email({\n to: e.from,\n from: e.to,\n subject: `Re: ${e.subject}`,\n html: renderToString(),\n });\n } catch (err) {\n console.log(err);\n await email({\n to: e.from,\n from: e.to,\n subject: `Re: ${e.subject}`,\n text:err.toString(),\n });\n }\n}",2,[171],{"_153":172,"_104":250,"_109":253,"_156":140,"_179":254},["D",1736992405519],[255],{"_107":256,"_156":140,"_153":172,"_100":171,"_162":257,"_160":175,"_104":123,"_155":-5,"_109":253,"_157":250,"_165":-5,"_158":27,"_164":27,"_103":258},"322cca0e-26dd-11f0-a5b3-569c3dd06744","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server\";\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { id, init, tx } from \"npm:@instantdb/admin\"; // seems to be a bug with esm.sh at time of completion\n\nconst GoalsTable = ({ goals }) => {\n if (!goals || goals.length === 0) return <>;\n return (\n

\n \n \n \n \n \n \n \n \n {goals.map((goal) => (\n \n \n \n \n \n ))}\n \n

Complete	ID	Title
\n \n	{goal.id}	{goal.title}

\n );\n};\n\nconst TodosTable = ({ todos }) => {\n if (!todos || todos.length === 0) return <>;\n return (\n \n \n \n \n \n \n \n \n \n {todos.map((todo) => (\n \n \n \n \n \n ))}\n \n

Complete	ID	Title
\n \n	{todo.id}	{todo.title}

\n );\n};\n\nfunction Table({ data }) {\n return (\n <>\n \n
\n \n \n );\n}\n\nexport default async function(e: Email) {\n if (!Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\")) {\n throw new Error(\"INSTANTDB_ADMIN_TOKEN not set\");\n }\n\n if (!Deno.env.get(\"INSTANTDB_APP_ID\")) {\n throw new Error(\"INSTANTDB_APP_ID not set\");\n }\n\n if (e.subject && e.subject.startsWith(\"Re:\")) {\n return await email({\n to: e.from,\n from: e.to,\n subject: e.subject,\n text: \"I'm sorry, I can only reply to new email threads.\",\n });\n }\n\n try {\n const client = new OpenAI();\n\n const systemPrompt = `\n You are a helpful email assistant. You have access to an instantdb database. When people ask for info you will provide it for \n them by creating an instantdb query for the server to query the database. Return the query param json string only -- the json object that query is assigned to. Note that the results\n be rendered into 2 tables, one for goals and one for todos, so and associations will not be displayed, instead you should create a query that uses both tables.\n \n --------------------------------------------------------------------------\n Here is an example instantdb query (the examples use an unrelated database):\n \n Fetch namespace\n One of the simplest queries you can write is to simply get all entities of a namespace:\n const query = { goals: {} };\n \n Fetch multiple namespaces\n You can fetch multiple namespaces at once:\n const query = { goals: {}, todos: {} };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n }\n \n Fetch a specific entity\n If you want to filter entities, you can use the where keyword. Here we fetch a specific goal:\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n },\n };\n \n console.log(data)\n {\n \"goals\": [...],\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n ...\n ]\n }\n \n Fetch associations\n We can fetch goals and their related todos:\n \n const query = {\n goals: {\n todos: {},\n },\n };\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n Fetch associations for filtered namespace\n We can fetch a specific entity in a namespace as well as it's related associations.\n\n const query = {\n goals: {\n $: {\n where: {\n id: healthId,\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": proteinId,\n \"title\": \"Drink protein\"\n },\n {\n \"id\": sleepId,\n \"title\": \"Go to bed early\"\n },\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n }\n ]\n }\n\n Filter namespace by associated values\n We can filter namespaces by their associations\n\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': 'Code a bunch',\n },\n },\n todos: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n {\n \"id\": standupId,\n \"title\": \"Do standup\"\n }\n ]\n }\n ]\n }\n\n Filter associations\n We can also filter associated data.\n\n const query = {\n goals: {\n todos: {\n $: {\n where: {\n 'todos.title': 'Go on a run',\n },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\",\n \"todos\": [\n {\n \"id\": workoutId,\n \"title\": \"Go on a run\"\n }\n ]\n },\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n \"todos\": []\n }\n ]\n }\n\n Inverse Associations\n Associations are also available in the reverse order.\n const query = {\n todos: {\n goals: {},\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\",\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\"\n }\n ]\n },\n ...,\n ]\n }\n\n And key\n The and key is useful when you want an entity to match multiple conditions. In this case we want to find goals that have both Drink protein and Go on a run todos.:\n\n const query = {\n goals: {\n $: {\n where: {\n and: [\n { 'todos.title': 'Drink protein' },\n { 'todos.title': 'Go on a run' },\n ],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": healthId,\n \"title\": \"Get fit!\"\n }\n ]\n }\n\n OR\n The where clause supports or queries that will filter entities that match any of the clauses in the provided list:\n \n const query = {\n todos: {\n $: {\n where: {\n or: [{ title: 'Code a bunch' }, { title: 'Review PRs' }],\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n },\n ]\n }\n\n $in\n The where clause supports $in queries that will filter entities that match any of the items in the provided list. You can think of this as a shorthand for or on a single key.\n \n const query = {\n todos: {\n $: {\n where: {\n title: { $in: ['Code a bunch', 'Review PRs'] },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"todos\": [\n {\n \"id\": focusId,\n \"title\": \"Code a bunch\"\n },\n {\n \"id\": reviewPRsId,\n \"title\": \"Review PRs\"\n }\n ]\n }\n\n Comparison operators\n The where clause supports comparison operators on fields that are indexed and have checked types.\n\n Operator\tDescription\tJS equivalent\n $gt\tgreater than\t>\n $lt\tless than\t<\n $gte\tgreater than or equal to\t>=\n $lte\tless than or equal to\t<=\n \n const query = {\n todos: {\n $: {\n where: {\n timeEstimateHours: { $gt: 24 },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": buildShipId,\n \"title\": \"Build a starship prototype\",\n \"timeEstimateHours\": 5000\n }\n ]\n }\n \n Dates can be stored as timestamps (milliseconds since the epoch, e.g. Date.now()) or as ISO 8601 strings (e.g. JSON.stringify(new Date())) and can be queried in the same formats:\n \n const now = '2024-11-26T15:25:00.054Z';\n const query = {\n todos: {\n $: { where: { dueDate: { $lte: now } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data);\n {\n \"todos\": [\n {\n \"id\": slsFlightId,\n \"title\": \"Space Launch System maiden flight\",\n \"dueDate\": \"2017-01-01T00:00:00Z\"\n }\n ]\n }\n \n If you try to use comparison operators on data that isn't indexed and type-checked, you'll get an error:\n \n const query = {\n todos: {\n $: { where: { priority: { $gt: 2 } } },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(error);\n {\n \"message\": \"Validation failed for query\",\n \"hint\": {\n \"data-type\": \"query\",\n \"errors\": [\n {\n \"expected?\": \"indexed?\",\n \"in\": [\"priority\", \"$\", \"where\", \"priority\"],\n \"message\": \"The \\`todos.priority\\` attribute must be indexed to use comparison operators.\"\n }\n ],\n \"input\": {\n \"todos\": {\n \"$\": {\n \"where\": {\n \"priority\": {\n \"$gt\": 2\n }\n }\n }\n }\n }\n }\n }\n\n $not\n The where clause supports $not queries that will return entities that don't match the provided value for the field, including entities where the field is null or undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $not: 'work' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n },\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $isNull\n The where clause supports $isNull queries that will filters entities by whether the field value is either null or undefined.\n \n Set $isNull to true to return entities where where the field is null or undefined.\n \n Set $isNull to false to return entities where the field is not null and not undefined.\n \n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: false },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": cookId,\n \"title\": \"Cook dinner\",\n \"location\": \"home\"\n }\n ]\n }\n const query = {\n todos: {\n $: {\n where: {\n location: { $isNull: true },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"todos\": [\n {\n \"id\": readId,\n \"title\": \"Read\",\n \"location\": null\n },\n {\n \"id\": napId,\n \"title\": \"Take a nap\"\n }\n ]\n }\n $like\n The where clause supports $like on fields that are indexed with a checked string type.\n \n $like queries will return entities that match a case sensitive substring of the provided value for the field.\n \n For case insensitive matching use $ilike in place of $like.\n \n Here's how you can do queries like startsWith, endsWith and includes.\n \n Example\tDescription\tJS equivalent\n { $like: \"Get%\" }\tStarts with 'Get'\tstartsWith\n { $like: \"%promoted!\" }\tEnds with 'promoted!'\tendsWith\n { $like: \"%fit%\" }\tContains 'fit'\tincludes\n Here's how you can use $like to find all goals that end with the word \"promoted!\"\n \n // Find all goals that end with the word \"promoted!\"\n const query = {\n goals: {\n $: {\n where: {\n title: { $like: '%promoted!' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n console.log(data)\n {\n \"goals\": [\n {\n \"id\": workId,\n \"title\": \"Get promoted!\",\n }\n ]\n }\n You can use $like in nested queries as well\n \n // Find goals that have todos with the word \"standup\" in their title\n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $like: '%standup%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n Returns\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n }\n ]\n }\n Case-insensitive matching with $ilike:\n \n const query = {\n goals: {\n $: {\n where: {\n 'todos.title': { $ilike: '%stand%' },\n },\n },\n },\n };\n const { isLoading, error, data } = db.useQuery(query);\n \n console.log(data)\n {\n \"goals\": [\n {\n \"id\": standupId,\n \"title\": \"Perform standup!\",\n },\n {\n \"id\": standId,\n \"title\": \"Stand up a food truck.\",\n }\n ]\n }\n ------------------------------------------------\n \n Here is the schema of the instantdb database:\n \n const _schema = i.schema({\n entities: {\n $users: i.entity({\n email: i.string().unique().indexed(),\n }),\n goals: i.entity({\n title: i.string(),\n }),\n todos: i.entity({\n title: i.string(),\n }),\n },\n links: {\n goalsTodos: {\n forward: {\n on: \"goals\",\n has: \"many\",\n label: \"todos\",\n },\n reverse: {\n on: \"todos\",\n has: \"many\",\n label: \"goals\",\n },\n },\n },\n });\n `;\n\n const completion = await client.chat.completions.create({\n messages: [{ role: \"developer\", content: systemPrompt }, { role: \"user\", content: e.text! }],\n model: \"gpt-4o-mini\",\n response_format: { \"type\": \"json_object\" },\n });\n\n const results = completion.choices[0].message.content;\n\n const db = init({\n appId: Deno.env.get(\"INSTANTDB_APP_ID\")!,\n adminToken: Deno.env.get(\"INSTANTDB_ADMIN_TOKEN\"),\n });\n\n const query = JSON.parse(results!);\n console.log(query);\n\n const data = await db.query(query);\n\n await email({\n to: e.from,\n from: e.to,\n subject: `Re: ${e.subject}`,\n html: renderToString(),\n });\n } catch (err) {\n console.log(err);\n }\n}",[171],{"_153":154,"_104":123,"_109":260,"_156":140,"_179":261},["D",1736992400637],[262,264],{"_107":151,"_156":140,"_153":154,"_100":152,"_162":163,"_160":161,"_104":31,"_155":-5,"_109":260,"_157":123,"_165":-5,"_158":113,"_164":27,"_103":263},[152],{"_107":265,"_156":140,"_153":172,"_100":171,"_162":266,"_160":175,"_104":31,"_155":-5,"_109":267,"_157":123,"_165":-5,"_158":27,"_164":27,"_103":268},"3226458a-26dd-11f0-a5b3-569c3dd06744","export default async function (e: Email) {\n \n}",["D",1736992400637],[171],"page","hasNext","routes/_app","actionData","errors"]

History