Val Town Code SearchReturn to Val Town

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

4const query = "\"val.town\" OR \"val town\" -_ValTown_ -is:retweet";
5
6export async function twitterAlert({ lastRunAt }: Interval) {
7  const results = await twitterSearch({
8    query,

27const openai = new OpenAI();
28
29export async function twitterAlert({ lastRunAt }: Interval) {
30  let results = [];
31  for (const username of usernames) {
36  }
37
38  async function filterTweets(tweets) {
39    const completion = await openai.chat.completions.create({
40      messages: [

2import { easyAQI } from "https://esm.town/v/stevekrouse/easyAQI?v=5";
3
4export async function aqi(interval: Interval) {
5  const location = "narberth, pa"; // <-- change to place, city, or zip code
6  const data = await easyAQI({ location });

1const JWT = Deno.env.get("PINATA_JWT");
2async function pinJSONToIPFS() {
3  try {
4    const data = JSON.stringify({

29const openai = new OpenAI();
30
31export async function twitterAlert({ lastRunAt }: Interval) {
32  let results = [];
33  for (const username of usernames) {
38  }
39
40  async function filterTweets(tweets) {
41    const completion = await openai.chat.completions.create({
42      messages: [

1import { DOMParser } from "https://deno.land/x/deno_dom/deno-dom-wasm.ts";
2
3export default async function getTeams() {
4  let url = "https://www.capfriendly.com";
5  let res = await fetch(url);

1import { DOMParser } from "https://deno.land/x/deno_dom/deno-dom-wasm.ts";
2
3export async function handler(request: Request) {
4  let url = "https://www.capfriendly.com/";
5  let res = await fetch(url);

33- [x] fix wonky sidebar separator height problem (thanks to @stevekrouse)
34- [x] make result tables scrollable
35- [x] add export to CSV, and JSON (CSV and JSON helper functions written in [this val](https://www.val.town/v/nbbaier/sqliteExportHelpers). Thanks to @pomdtr for merging the initial version!)
36- [x] add listener for cmd+enter to submit query

11};
12
13async function createSessionTable(tableName: string) {
14  await sqlite.execute(`CREATE TABLE ${tableName} (
15    id TEXT NOT NULL PRIMARY KEY,
19}
20
21async function createSession(tableName: string, valSlug: string): Promise<Session> {
22  try {
23    const expires_at = new Date();
39}
40
41async function getSession(tableName: string, sessionID: string, valSlug: string): Promise<Session> {
42  try {
43    const { rows, columns } = await sqlite.execute({
60}
61
62async function fetchUser(token: string): Promise<{ id: string }> {
63  const resp = await fetch("https://api.val.town/v1/me", {
64    headers: {
74}
75
76async function verifyApiToken(token: string) {
77  try {
78    const [currentUser, requestUser] = await Promise.all([fetchUser(Deno.env.get("valtown")), fetchUser(token)]);
106</html>`;
107
108export function redirect(location: string): Response {
109  return new Response(null, {
110    headers: {
124const cookieName = "auth_session";
125
126export function passwordAuth(next, options?: PasswordAuthOptions) {
127  let passwords: string[];
128  if (!options?.password) {