Val Town Code Search

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" }})`

codeOnValTown main.tsx2 matches

@nicosql•Updated 8 months ago

9 * @param val Define which val should open. Defaults to the root reference
10 */
11export function modifyHtmlString(
12  bodyText: string,
13  { val, style }: { val?: ValRef; style?: string } = {},
40 * @param val Define which val should open
41 */
42export function modifyFetchHandler(
43  handler: (req: Request) => Response | Promise<Response>,
44  { val, style }: { val?: ValRef; style?: string } = {},

password_auth main.tsx5 matches

@nicosql•Updated 8 months ago

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({
80</html>`;
81
82export function redirect(location: string): Response {
83  return new Response(null, {
84    headers: {
98const cookieName = "auth_session";
99
100export function passwordAuth(next, options?: PasswordAuthOptions) {
101  const sessionTable = options?.sessionTable || "password_auth_session";
102  return async (req: Request) => {

extractValInfo main.tsx1 match

@nicosql•Updated 8 months ago

1export function extractValInfo(url: string | URL) {
2  const { pathname, search } = new URL(url);
3  const [author, filename] = pathname.split("/").slice(-2);

sqlite main.tsx7 matches

@nicosql•Updated 8 months ago

31
32// ------------
33// Functions
34// ------------
35
36async function execute(statement: InStatement, args?: InArgs): Promise<ResultSet> {
37  const res = await fetch(`${API_URL}/v1/sqlite/execute`, {
38    method: "POST",
49}
50
51async function batch(statements: InStatement[], mode?: TransactionMode): Promise<ResultSet[]> {
52  const res = await fetch(`${API_URL}/v1/sqlite/batch`, {
53    method: "POST",
64}
65
66function createResError(body: string) {
67  try {
68    const e = zLibsqlError.parse(JSON.parse(body));
85}
86
87function normalizeStatement(statement: InStatement, args?: InArgs) {
88  if (Array.isArray(statement)) {
89    // for the case of an array of arrays
107}
108
109function upgradeResultSet(results: ImpoverishedResultSet): ResultSet {
110  return {
111    ...results,
116// adapted from
117// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2
118function rowFromSql(
119  sqlRow: Array<unknown>,
120  columns: Array<string>,

« Previous

1...2452 2453 2454 2455 2456 2457 2458...2876

Projects

View all 18 vals

getFileEmail4 file matches

@shouser•Updated 1 month ago

A helper function to build a file's email

tuna8 file matches

@jxnblk•Updated 1 month ago

Simple functional CSS library for Val Town

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 2 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

assistantHarlequinKangaroo main.tsx10 matches

liquidOrangeFowl main.tsx10 matches

interestedAquamarinePike main.tsx10 matches

slackScout main.tsx10 matches

sqliteExplorerApp README.md1 match

codeOnValTown README.md1 match

codeOnValTown main.tsx2 matches

password_auth main.tsx5 matches

extractValInfo main.tsx1 match

sqlite main.tsx7 matches

Projects

getFileEmail4 file matches

tuna8 file matches

Users

@lost19911 val

@webup70 vals

Documentation

Val Town Code SearchReturn to Val Town

assistantHarlequinKangaroomain.tsx10 matches

liquidOrangeFowlmain.tsx10 matches

interestedAquamarinePikemain.tsx10 matches

slackScoutmain.tsx10 matches

sqliteExplorerAppREADME.md1 match

codeOnValTownREADME.md1 match

codeOnValTownmain.tsx2 matches

password_authmain.tsx5 matches

extractValInfomain.tsx1 match

sqlitemain.tsx7 matches

Projects

getFileEmail4 file matches

tuna8 file matches

Users

@lost19911 val

@webup70 vals

Documentation

Val Town Code Search Return to Val Town

assistantHarlequinKangaroo main.tsx10 matches

liquidOrangeFowl main.tsx10 matches

interestedAquamarinePike main.tsx10 matches

slackScout main.tsx10 matches

sqliteExplorerApp README.md1 match

codeOnValTown README.md1 match

codeOnValTown main.tsx2 matches

password_auth main.tsx5 matches

extractValInfo main.tsx1 match

sqlite main.tsx7 matches