Val Town Code SearchReturn to Val Town

53  const finalType = typeof type === "string" ? type.trim() : "unknown";
54  const creation_time = time; // Use the provided timestamp
55  // Construct the image URL and link based on the main Pondiverse structure
56  const image_url = `https://pondiverse.val.run/get-creation-image?id=${original_id}`;
57  const link = `${UPSTREAM_PONDIVERSE_URL}/explore/#c${original_id}`;
58
61    await sqlite.execute({
62      sql: `
63        INSERT INTO ${AGGREGATOR_TABLE_NAME} (original_id, title, type, creation_time, image_url, link)
64        VALUES (:original_id, :title, :type, :creation_time, :image_url, :link)
65      `,
66      args: {
69        type: finalType,
70        creation_time: creation_time,
71        image_url: image_url,
72        link: link,
73      },

14      type TEXT,
15      creation_time DATETIME NOT NULL,     /* Time from the main Pondiverse */
16      image_url TEXT,                      /* Direct URL to the main pondiverse image */
17      link TEXT UNIQUE NOT NULL,           /* Link to the creation on the main site */
18      received_time DATETIME DEFAULT CURRENT_TIMESTAMP /* When this aggregator received it */