Val Town Code Search

BlobArray README.md1 match

@joey•Updated 1 year ago

1### Blob Array
2
3Create an array as a Database, instantly!
4
5Just create a new val for your array:

ValTupleStorage main.tsx1 match

@chet•Updated 1 year ago

2
3import { jsonCodec } from "npm:lexicodec";
4import { KeyValuePair, ScanStorageArgs, Tuple, WriteOps } from "npm:tuple-database";
5
6export class ValTupleStorage {

ValTupleStorage_Example README.md1 match

@chet•Updated 1 year ago

1Migrated from folder: Database/ValTupleStorage_Example

ValTupleStorage README.md1 match

@chet•Updated 1 year ago

1Migrated from folder: Database/ValTupleStorage

sqliteWriter README.md3 matches

@nbbaier•Updated 1 year ago

1# SQLite QueryWriter
2
3The QueryWriter class is a utility for generating and executing SQL queries using natural language and OpenAI. It provides a simplified interface for interacting with your Val Town SQLite database and generating SQL queries based on user inputs.
4
5This val is inspired by [prisma-gpt](https://github.com/aliyeysides/prisma-gpt). PRs welcome! See **Todos** below for some ideas I have.
42Creates a new instance of the QueryWriter class.
43
44-  `table`: The name of the database table to operate on.
45-  `model` (optional): The model to use for generating SQL queries. Defaults to "gpt-3.5-turbo".
46-  `apiKey` (optional): An OpenAI API key. Defaults to `Deno.env.get("OPENAI_API_KEY")`.
68- [ ] Edit prompt to allow for more than just `SELECT` queries
69- [ ] Allow a user to add to the system prompt maybe?
70- [ ] Expand usage beyond just Turso SQLite to integrate with other databases
71
72Migrated from folder: projects/gptTools/sqliteWriter

add_to_notion_w_ai_webpage main.tsx19 matches

@nerdymomocat•Updated 1 year ago

41function createPrompt(title, description, properties) {
42  let prompt =
43    "You are processing content into a database. Based on the title of the database, its properties, their types and options, and any existing descriptions, infer appropriate values for the fields:\n";
44  prompt += `Database Title: ${title}\n`;
45
46  if (description) {
47    prompt += `Database Description: ${description}\n\n`;
48  } else {
49    prompt += "\n";
115}
116
117async function get_and_save_notion_db_processed_properties(databaseId)
118{
119  const response = await notion.databases.retrieve({ database_id: databaseId });
120  const db_id = response.id.replaceAll("-", "");
121  const processed_properties = processProperties(response);
126}
127
128async function get_notion_db_info(databaseId) {
129  databaseId = databaseId.replaceAll("-", "");
130  let db_info = null;
131  try {
132    db_info = await blob.getJSON(databaseId);
133    if (!db_info) {
134      throw new Error("db_info is null or undefined");
135    }
136  } catch (error) {
137    db_info = await get_and_save_notion_db_processed_properties(databaseId);
138  }
139  console.log(db_info);
142}
143
144async function get_and_save_notion_db_info(databaseId) {
145  databaseId = databaseId.replaceAll("-", "");
146  let db_info = await get_and_save_notion_db_processed_properties(databaseId);
147  db_info["zod_schema"] = createZodSchema(db_info["filteredProps"]);
148  return db_info;
288}
289
290async function addToNotion(databaseId, text) {
291  databaseId = databaseId.replaceAll("-", "");
292  const properties = await process_text(databaseId, text);
293  console.log(properties);
294  const response = await notion.pages.create({
295    "parent": {
296      "type": "database_id",
297      "database_id": databaseId,
298    },
299    "properties": properties,
316        <div id="answer">
317          <div id="answer-content" hx-get="/clear" hx-trigger="load delay:2s" hx-target="#answer">
318            Processed and added to Notion Database
319          </div>
320        </div>
329      <html>
330        <head>
331          <title>Add To Money Database W/ AI</title>
332          <style>
333            {`

add_to_notion_w_ai_webpage README.md1 match

@nerdymomocat•Updated 1 year ago

1Example usage of the [add_to_notion_w_ai val](https://www.val.town/v/nerdymomocat/add_to_notion_w_ai)
2
3Try with the [money database](https://nerdymomocat-shortened-url.vercel.app/ai-add-to-money-db). 
4
5Read and watch the demo run [here](https://nerdymomocat.github.io/posts/use-notions-property-description-as-text-db-add-itor/)

add_to_notion_w_ai main.tsx17 matches

@nerdymomocat•Updated 1 year ago

37function createPrompt(title, description, properties) {
38  let prompt =
39    "You are processing content into a database. Based on the title of the database, its properties, their types and options, and any existing descriptions, infer appropriate values for the fields:\n";
40  prompt += `Database Title: ${title}\n`;
41
42  if (description) {
43    prompt += `Database Description: ${description}\n\n`;
44  } else {
45    prompt += "\n";
111}
112
113async function get_and_save_notion_db_processed_properties(databaseId)
114{
115  const response = await notion.databases.retrieve({ database_id: databaseId });
116  const db_id = response.id.replaceAll("-", "");
117  const processed_properties = processProperties(response);
122}
123
124async function get_notion_db_info(databaseId) {
125  databaseId = databaseId.replaceAll("-", "");
126  let db_info = null;
127  try {
128    db_info = await blob.getJSON(databaseId);
129    if (!db_info) {
130      throw new Error("db_info is null or undefined");
131    }
132  } catch (error) {
133    db_info = await get_and_save_notion_db_processed_properties(databaseId);
134  }
135  db_info["zod_schema"] = createZodSchema(db_info["filteredProps"]);
137}
138
139async function get_and_save_notion_db_info(databaseId) {
140  databaseId = databaseId.replaceAll("-", "");
141  let db_info = await get_and_save_notion_db_processed_properties(databaseId);
142  db_info["zod_schema"] = createZodSchema(db_info["filteredProps"]);
143  return db_info;
283}
284
285async function addToNotion(databaseId, text) {
286  databaseId = databaseId.replaceAll("-", "");
287  const properties = await process_text(databaseId, text);
288  console.log(properties);
289  const response = await notion.pages.create({
290    "parent": {
291      "type": "database_id",
292      "database_id": databaseId,
293    },
294    "properties": properties,

add_to_notion_w_ai README.md4 matches

@nerdymomocat•Updated 1 year ago

1Uses instructor and open ai (with gpt-4-turbo) to process any content into a notion database entry.
2
3Use `addToNotion` with any database id and content.
4
5```
10```
11
12Prompts are created based on your database name, database description, property name, property type, property description, and if applicable, property options (and their descriptions).
13
14Supports: checkbox, date, multi_select, number, rich_text, select, status, title, url, email
15
16- Uses `NOTION_API_KEY`, `OPENAI_API_KEY` stored in env variables and uses [Valtown blob storage](https://esm.town/v/std/blob) to store information about the database.
17- Use `get_notion_db_info` to use the stored blob if exists or create one, use `get_and_save_notion_db_info` to create a new blob (and replace an existing one if exists).
18

connect4_site main.tsx1 match

@saolsen•Updated 1 year ago

1058// There are concurrency issues with this, turns could get
1059// evaluated twice and overwrite each other, but future steve
1060// can handle that with a real database.
1061app.post("/matches/:match_id/agent_turn", async (c) => {
1062  const parsed_id = MatchId.safeParse(c.req.param("match_id"));