Val Town Code SearchReturn to Val Town

35});
36
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";
80}
81
82function processProperties(jsonObject) {
83  const properties = jsonObject.properties;
84  const filteredProps = {};
111}
112
113async function get_and_save_notion_db_processed_properties(databaseId)
114{
115  const response = await notion.databases.retrieve({ database_id: databaseId });
122}
123
124async function get_notion_db_info(databaseId) {
125  databaseId = databaseId.replaceAll("-", "");
126  let db_info = null;
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);
144}
145
146function createZodSchema(filteredProps) {
147  const schemaObject = {};
148
193}
194
195function convertToNotionProperties(responseValues, filteredProps) {
196  const notionProperties = {};
197
268}
269
270async function process_text(dbid, text) {
271  const db_info = await get_notion_db_info(dbid);
272  const processed_message = await client.chat.completions.create({
283}
284
285async function addToNotion(databaseId, text) {
286  databaseId = databaseId.replaceAll("-", "");
287  const properties = await process_text(databaseId, text);

5const BLOB_KEY = "seen_cves";
6
7async function checkNewVulnerabilities() {
8  const response = await fetch(KEV_URL);
9  const data = await response.json();
30}
31
32export default async function kevCron() {
33  return await checkNewVulnerabilities();
34}

3import { createRoot } from "https://esm.sh/react-dom/client";
4
5function App() {
6  const [SplineComponent, setSplineComponent] = useState(null);
7  const [error, setError] = useState(null);
50}
51
52function client() {
53  createRoot(document.getElementById("root")).render(<App />);
54}
56if (typeof document !== "undefined") { client(); }
57
58async function server(request: Request): Promise<Response> {
59  return new Response(
60    `

1export default async function server(request: Request): Promise<Response> {
2  try {
3    const response = await fetch("https://www.cisa.gov/sites/default/files/feeds/known_exploited_vulnerabilities.json");

3const RSS_FEED_URL = "https://hrbrmstr-cisakevtorss.web.val.run"; // Update this to your actual RSS feed URL
4
5function escapeXML(str: string): string {
6  return str.replace(/&/g, "&")
7    .replace(/</g, "&lt;")
11}
12
13function removeInvalidXMLChars(str: string): string {
14  return str
15    .replace(/[\u0000-\u0008\u000B\u000C\u000E-\u001F]/g, "") // Control characters
19}
20
21function generateRSS(data: any): string {
22  const { title, catalogVersion, dateReleased, vulnerabilities } = data;
23
68}
69
70export async function handler(req: Request): Promise<Response> {
71  try {
72    const response = await fetch(CISA_JSON_URL);

15}
16
17export default async function(interval: Interval): Promise<void> {
18  try {
19    await createTable();
38
39// Create an SQLite table
40async function createTable(): Promise<void> {
41  await sqlite.execute(`
42    CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (
50
51// Fetch Hacker news, Twitter, and Reddit results
52async function fetchHackerNewsResults(topic: string): Promise<Website[]> {
53  return hackerNewsSearch({
54    query: topic,
58}
59
60async function fetchTwitterResults(topic: string): Promise<Website[]> {
61  return twitterSearch({
62    query: topic,
67}
68
69async function fetchRedditResults(topic: string): Promise<Website[]> {
70  return redditSearch({ query: topic });
71}
72
73function formatSlackMessage(website: Website): string {
74  const displayTitle = website.title || website.url;
75  return `*<${website.url}|${displayTitle}>*
78}
79
80async function sendSlackMessage(message: string): Promise<Response> {
81  const slackWebhookUrl = Deno.env.get("SLACK_WEBHOOK_URL");
82  if (!slackWebhookUrl) {
104}
105
106async function isURLInTable(url: string): Promise<boolean> {
107  const result = await sqlite.execute({
108    sql: `SELECT 1 FROM ${TABLE_NAME} WHERE url = :url LIMIT 1`,
112}
113
114async function addWebsiteToTable(website: Website): Promise<void> {
115  await sqlite.execute({
116    sql: `INSERT INTO ${TABLE_NAME} (source, url, title, date_published) 
120}
121
122async function processResults(results: Website[]): Promise<void> {
123  for (const website of results) {
124    if (!(await isURLInTable(website.url))) {

15}
16
17export default async function(interval: Interval): Promise<void> {
18  try {
19    await createTable();
38
39// Create an SQLite table
40async function createTable(): Promise<void> {
41  await sqlite.execute(`
42    CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (
50
51// Fetch Hacker news, Twitter, and Reddit results
52async function fetchHackerNewsResults(topic: string): Promise<Website[]> {
53  return hackerNewsSearch({
54    query: topic,
58}
59
60async function fetchTwitterResults(topic: string): Promise<Website[]> {
61  return twitterSearch({
62    query: topic,
67}
68
69async function fetchRedditResults(topic: string): Promise<Website[]> {
70  return redditSearch({ query: topic });
71}
72
73function formatSlackMessage(website: Website): string {
74  const displayTitle = website.title || website.url;
75  return `*<${website.url}|${displayTitle}>*
78}
79
80async function sendSlackMessage(message: string): Promise<Response> {
81  const slackWebhookUrl = Deno.env.get("SLACK_WEBHOOK_URL");
82  if (!slackWebhookUrl) {
104}
105
106async function isURLInTable(url: string): Promise<boolean> {
107  const result = await sqlite.execute({
108    sql: `SELECT 1 FROM ${TABLE_NAME} WHERE url = :url LIMIT 1`,
112}
113
114async function addWebsiteToTable(website: Website): Promise<void> {
115  await sqlite.execute({
116    sql: `INSERT INTO ${TABLE_NAME} (source, url, title, date_published) 
120}
121
122async function processResults(results: Website[]): Promise<void> {
123  for (const website of results) {
124    if (!(await isURLInTable(website.url))) {

1import { addMonths, format, subMonths } from "https://esm.sh/date-fns";
2
3function generateFutureEvents(months = 6) {
4  const events = [];
5  const startDate = new Date();
41}
42
43async function server(request: Request): Promise<Response> {
44  const url = new URL(request.url);
45
177}
178
179function getStyles() {
180  return `
181    <style>

2import { renderToString } from "npm:react-dom/server";
3
4export default async function(req: Request) {
5  return new Response(
6    renderToString(

9const HUE_DIFF = 25
10
11function getColor(value: number): string {
12  const power = Math.log2(value / 2)
13  const hue = (power * HUE_DIFF) % 360
15}
16
17function App() {
18  const [board, setBoard] = useState<number[][]>([])
19  const [selectedCells, setSelectedCells] = useState<[number, number][]>([])
227}
228
229function client() {
230  createRoot(document.getElementById("root")).render(<App />)
231}
233if (typeof document !== "undefined") { client() }
234
235async function server(request: Request): Promise<Response> {
236  return new Response(
237    `