Val Town Code SearchReturn to Val Town

701  const SCHEMA_VERSION = 2;
702
703  // Set up database tables
704  await sqlite.execute(`
705    CREATE TABLE IF NOT EXISTS ${KEY}_students_${SCHEMA_VERSION} (

103    },
104    {
105      Name:      'malformed PasswordHash in database',
106      TableName,
107      AuthHeader:'Basic ' + btoa('isaac:correctPassword'),

71. **Valid credentials with existing user**
8   - TableName: "Authorization_from_SQLite_Test"
9   - Database content: UserId "alice", PasswordHash "{PBKDF2}10000$salt123$hashedPassword123"
10   - Authorization header: "Basic " + btoa("alice:correctPassword")
11   - Expected result: true
132. **Valid credentials with case-insensitive UserId**
14   - TableName: "Authorization_from_SQLite_Test"
15   - Database content: UserId "Bob", PasswordHash "{PBKDF2}10000$salt456$hashedPassword456"
16   - Authorization header: "Basic " + btoa("bob:correctPassword")
17   - Expected result: true
213. **Invalid password**
22   - TableName: "Authorization_from_SQLite_Test"
23   - Database content: UserId "charlie", PasswordHash "{PBKDF2}10000$salt789$hashedPassword789"
24   - Authorization header: "Basic " + btoa("charlie:wrongPassword")
25   - Expected result: false
274. **No Authorization header**
28   - TableName: "Authorization_from_SQLite_Test"
29   - Database content: UserId "david", PasswordHash "{PBKDF2}10000$saltABC$hashedPasswordABC"
30   - Authorization header: undefined
31   - Expected result: false
335. **Non-existent user**
34   - TableName: "Authorization_from_SQLite_Test"
35   - Database content: (empty)
36   - Authorization header: "Basic " + btoa("eve:anyPassword")
37   - Expected result: false
487. **Empty string as password**
49   - TableName: "Authorization_from_SQLite_Test"
50   - Database content: UserId "grace", PasswordHash "{PBKDF2}10000$saltDEF$hashedEmptyPassword"
51   - Authorization header: "Basic " + btoa("grace:")
52   - Expected result: true (if the empty password hashes correctly)
548. **Non-Basic authorization type**
55   - TableName: "Authorization_from_SQLite_Test"
56   - Database content: UserId "henry", PasswordHash "{PBKDF2}10000$saltGHI$hashedPasswordGHI"
57   - Authorization header: "Bearer " + btoa("henry:password")
58   - Expected result: false
59
609. **Malformed PasswordHash in database**
61   - TableName: "Authorization_from_SQLite_Test"
62   - Database content: UserId "isaac", PasswordHash "malformedHash"
63   - Authorization header: "Basic " + btoa("isaac:password")
64   - Expected result: false
6610. **Very long UserId (at 256 character limit)**
67    - TableName: "Authorization_from_SQLite_Test"
68    - Database content: UserId (256 'a' characters), PasswordHash "{PBKDF2}10000$saltJKL$hashedPasswordJKL"
69    - Authorization header: "Basic " + btoa("a".repeat(256) + ":password")
70    - Expected result: true (if password is correct)
73    - TableName: "Authorization_from_SQLite_Test"
74    - Authorization header: "Basic " + btoa("a".repeat(257) + ":password")
75    - Expected result: false (as it shouldn't exist in the database)
76
7712. **Empty UserId**

15}
16
17async function initializeDatabase() {
18  await sqlite.execute(`
19    CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (
27
28export default async function(interval: Interval) {
29  await initializeDatabase();
30
31  for (const url of URLS) {
65
66export async function getAllVersions() {
67  await initializeDatabase();
68  const versions = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} ORDER BY timestamp DESC`);
69  console.log(versions, TABLE_NAME);

30- [ ] add triggers to sidebar
31- [ ] add upload from SQL, CSV and JSON
32- [ ] add ability to connect to a non-val town Turso database 
33- [x] fix wonky sidebar separator height problem (thanks to @stevekrouse)
34- [x] make result tables scrollable

5/**
6 * Every Val Town account comes with its own private
7 * [SQLite database](https://www.sqlite.org/) that
8 * is accessible from any of your vals.
9 * ([Docs ↗](https://docs.val.town/std/sqlite))
118
119// adapted from
120// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2
121function rowFromSql(
122  sqlRow: Array<unknown>,

30- [ ] add triggers to sidebar
31- [ ] add upload from SQL, CSV and JSON
32- [ ] add ability to connect to a non-val town Turso database 
33- [x] fix wonky sidebar separator height problem (thanks to @stevekrouse)
34- [x] make result tables scrollable

1Rarevibes is not responsible of any database loss

9  const openai = new OpenAI();
10
11  // Comprehensive Data Science and Database Tool Categories
12  const dataScienceToolCategories = [
13    {

9  const openai = new OpenAI();
10
11  // Comprehensive Data Science and Database Tool Categories
12  const dataScienceToolCategories = [
13    {