Val Town Code Search

humansnap main.tsx5 matches

@ngmi•Updated 8 months ago

4const ADMIN_PASSWORD = Deno.env.get("ADMIN_PASSWORD") || "defaultpassword"; // Set this in your Val Town environment variables
5
6async function initializeDatabase() {
7  await sqlite.execute(`
8    CREATE TABLE IF NOT EXISTS ${KEY}_emails (
14}
15
16async function addEmail(email: string) {
17  await sqlite.execute(`INSERT OR IGNORE INTO ${KEY}_emails (email) VALUES (?)`, [email]);
18}
19
20async function getEmails() {
21  const result = await sqlite.execute(`SELECT * FROM ${KEY}_emails ORDER BY timestamp DESC`);
22  return result.rows;
23}
24
25export default async function server(request: Request): Promise<Response> {
26  await initializeDatabase();
27  const url = new URL(request.url);
290        <script src="https://cdnjs.cloudflare.com/ajax/libs/gsap/3.9.1/gsap.min.js"></script>
291        <script>
292            document.getElementById('email-form').addEventListener('submit', async function(e) {
293                e.preventDefault();
294                const email = document.getElementById('email').value;

reMarkableXNYTCrossword main.tsx2 matches

@bmalicoat•Updated 8 months ago

3import request from "npm:request";
4
5export default async function(interval: Interval) {
6  // Cookies and Tokens -> use `mitmweb` to navigate to NYTimes.com to grab cookie. Repeat for my.remarkable.com
7
63        },
64      })
65        .then(function(response) {
66          var rmMetadata = { "parent": rmFolderGuid, "file_name": puzzleFriendlyName };
67

waveForm main.tsx3 matches

@all•Updated 8 months ago

90
91// Main App Component
92function App() {
93  const [synth, setSynth] = useState(null);
94  const [analyser, setAnalyser] = useState(null);
207}
208
209function client() {
210  createRoot(document.getElementById("root")).render(<App />);
211}
213if (typeof document !== "undefined") { client(); }
214
215export default async function server(request: Request): Promise<Response> {
216  const { sqlite } = await import("https://esm.town/v/stevekrouse/sqlite");
217  const SCHEMA_VERSION = 2

ssr_react_mini main.tsx1 match

@nicosql•Updated 8 months ago

35
36export const hydrate = (importMetaURL: string) =>
37  async function(req: Request): Promise<Response> {
38    const { author, name } = extractValInfo(importMetaURL);
39    const valURL = `https://www.val.town/v/${author}/${name}`;

assistantHarlequinKangaroo main.tsx10 matches

@nicosql•Updated 8 months ago

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))) {

liquidOrangeFowl main.tsx10 matches

@nicosql•Updated 8 months ago

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))) {

interestedAquamarinePike main.tsx10 matches

@nicosql•Updated 8 months ago

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))) {

slackScout main.tsx10 matches

@nicosql•Updated 8 months ago

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))) {

sqliteExplorerApp README.md1 match

@nicosql•Updated 8 months ago

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

codeOnValTown README.md1 match

@nicosql•Updated 8 months ago

49### Linking to the val
50
51These functions infer the val using the call stack or the request URL. If the inference isn't working, or if you want to ensure it links to a specific val, pass the `val` argument:
52
53- `modifyFetchHandler(handler, {val: { handle: "andre", name: "foo" }})`

« Previous

1...2502 2503 2504 2505 2506 2507 2508...2926

Projects

View all 18 vals

tuna9 file matches

@jxnblk•Updated 1 day ago

Simple functional CSS library for Val Town

getFileEmail4 file matches

@shouser•Updated 1 month ago

A helper function to build a file's email

Users

View all 2 users

import { OpenAI } from "https://esm.town/v/std/openai"; export default async function(req: Request): Promise<Response> { if (req.method === "OPTIONS") { return new Response(null, { headers: { "Access-Control-Allow-Origin": "*",

@webup70 vals

Updated 3 weeks ago

LangChain (https://langchain.com) Ambassador, KubeSphere (https://kubesphere.io) Ambassador, CNCF OpenFunction (https://openfunction.dev) TOC Member.

Documentation

View all 29 documentation results

Val Town Code Search Return to Val Town

humansnap main.tsx5 matches

reMarkableXNYTCrossword main.tsx2 matches

waveForm main.tsx3 matches

ssr_react_mini main.tsx1 match

assistantHarlequinKangaroo main.tsx10 matches

liquidOrangeFowl main.tsx10 matches

interestedAquamarinePike main.tsx10 matches

slackScout main.tsx10 matches

sqliteExplorerApp README.md1 match

codeOnValTown README.md1 match

Projects

tuna9 file matches

getFileEmail4 file matches

Users

@lost19911 val

@webup70 vals

Documentation

Val Town Code SearchReturn to Val Town

humansnapmain.tsx5 matches

reMarkableXNYTCrosswordmain.tsx2 matches

waveFormmain.tsx3 matches

ssr_react_minimain.tsx1 match

assistantHarlequinKangaroomain.tsx10 matches

liquidOrangeFowlmain.tsx10 matches

interestedAquamarinePikemain.tsx10 matches

slackScoutmain.tsx10 matches

sqliteExplorerAppREADME.md1 match

codeOnValTownREADME.md1 match

Projects

tuna9 file matches

getFileEmail4 file matches

Users

@lost19911 val

@webup70 vals

Documentation

Val Town Code Search Return to Val Town

humansnap main.tsx5 matches

reMarkableXNYTCrossword main.tsx2 matches

waveForm main.tsx3 matches

ssr_react_mini main.tsx1 match

assistantHarlequinKangaroo main.tsx10 matches

liquidOrangeFowl main.tsx10 matches

interestedAquamarinePike main.tsx10 matches

slackScout main.tsx10 matches

sqliteExplorerApp README.md1 match

codeOnValTown README.md1 match