Val Town Code SearchReturn to Val Town

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,

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

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"));

3Creates a global redis instance and exposes functions to use it.
4
5To use, create a redis database on [Upstash](https://upstash.com/) and set the environment variables.
6* `UPSTASH_REDIS_REST_URL`
7* `UPSTASH_REDIS_REST_TOKEN`

20  "papers": {
21    "todoist-section-id": "SECTION_ID_HERE",
22    "notion-map-type": "database",
23    "notion-id": "DB_ID_HERE",
24  },
102}
103
104async function addPageToNotionDatabse(database_id, content) {
105  const response = await notion.pages.create({
106    "parent": {
107      "type": "database_id",
108      "database_id": database_id,
109    },
110    "properties": {
133        addCalloutToNotionPage(mappedNotionId, task.content, convertDateObject(task.due));
134      }
135      else if (mappedNotionType == "database" && mappedNotionId) {
136        addPageToNotionDatabse(mappedNotionId, task.content);
137      }

1Use todoist for quick notes to add to notion. Uses project to decide which project to fetch to add stuff to notion. Can add to page or database based on config below. Demarkation using sections in the todoist project. Extracts date for page blocks that are added as callouts.
2
3Migrated from folder: Public/add_to_notion_from_todoist

8
9  if (!NOTION_API_KEY || !PAPERPILE_DB_ID) {
10    throw new Error("Please fill in your API key and database ID");
11  }
12  let dont_update = [];
14  const notion = new Client({ auth: NOTION_API_KEY });
15
16  const databaseId = PAPERPILE_DB_ID;
17
18  const queryResponse = await notion.databases.query({
19    database_id: databaseId,
20    page_size: 100,
21    filter: {
35
36  console.log(
37    `Checked database, found ${relevant_results.length} items to update.`,
38  );
39

1import { notionGetDatabase } from "https://esm.town/v/stevekrouse/notionGetDatabase";
2import process from "node:process";
3
4export let dateMeNotionDatabase = notionGetDatabase({
5  databaseId: "725cb1d741674413b933a37a50f1961f",
6  auth: process.env.notion,
7});

2
3```ts
4import { setupDatabase } from "https://esm.town/v/stevekrouse/dateme_sqlite"
5
6await setupDatabase()
7```
8

1Implementation of Redis-like cache -  a key-value store with expiring keys. Data is stored in the Val Town SQLite database and shared between all your vals.
2
3# Setup