Val Town Code SearchReturn to Val Town

31  interface Register {
32    Lucia: typeof lucia;
33    DatabaseUserAttributes: DatabaseUserAttributes;
34  }
35}
36
37interface DatabaseUserAttributes {
38  username: string;
39}

1import type {
2  Adapter,
3  DatabaseSession,
4  DatabaseUser,
5  RegisteredDatabaseSessionAttributes,
6  RegisteredDatabaseUserAttributes,
7} from "npm:lucia";
8
34  public async getSessionAndUser(
35    sessionId: string,
36  ): Promise<[session: DatabaseSession | null, user: DatabaseUser | null]> {
37    const [databaseSession, databaseUser] = await Promise.all([
38      this.getSession(sessionId),
39      this.getUserFromSessionId(sessionId),
40    ]);
41    return [databaseSession, databaseUser];
42  }
43
44  public async getUserSessions(userId: string): Promise<DatabaseSession[]> {
45    const result = await this.controller.getAll<SessionSchema>(
46      `SELECT * FROM ${this.escapedSessionTableName} WHERE user_id = ?`,
48    );
49    return result.map((val) => {
50      return transformIntoDatabaseSession(val);
51    });
52  }
53
54  public async setSession(databaseSession: DatabaseSession): Promise<void> {
55    const value: SessionSchema = {
56      id: databaseSession.id,
57      user_id: databaseSession.userId,
58      expires_at: Math.floor(databaseSession.expiresAt.getTime() / 1000),
59      ...databaseSession.attributes,
60    };
61    const entries = Object.entries(value).filter(([_, v]) => v !== undefined);
87  }
88
89  private async getSession(sessionId: string): Promise<DatabaseSession | null> {
90    const result = await this.controller.get<SessionSchema>(
91      `SELECT * FROM ${this.escapedSessionTableName} WHERE id = ?`,
93    );
94    if (!result) return null;
95    return transformIntoDatabaseSession(result);
96  }
97
98  private async getUserFromSessionId(sessionId: string): Promise<DatabaseUser | null> {
99    const result = await this.controller.get<UserSchema>(
100      `SELECT ${this.escapedUserTableName}.* FROM ${this.escapedSessionTableName} INNER JOIN ${this.escapedUserTableName} ON ${this.escapedUserTableName}.id = ${this.escapedSessionTableName}.user_id WHERE ${this.escapedSessionTableName}.id = ?`,
102    );
103    if (!result) return null;
104    return transformIntoDatabaseUser(result);
105  }
106}
117}
118
119interface SessionSchema extends RegisteredDatabaseSessionAttributes {
120  id: string;
121  user_id: string;
123}
124
125interface UserSchema extends RegisteredDatabaseUserAttributes {
126  id: string;
127}
128
129function transformIntoDatabaseSession(raw: SessionSchema): DatabaseSession {
130  const { id, user_id: userId, expires_at: expiresAtUnix, ...attributes } = raw;
131  return {
137}
138
139function transformIntoDatabaseUser(raw: UserSchema): DatabaseUser {
140  const { id, ...attributes } = raw;
141  return {

1# listSqliteTables
2
3Returns a flat array of the names of all tables in your Val Town SQLite database.
4
5```ts

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

1# SQLite Dump Util
2
3A utility function that generates SQL statements to dump the data and schema of tables in a SQLite database.
4
5## Usage

1### Blob Array
2
3Create an array as a Database, instantly!
4
5Just create a new val for your array:

2
3import { jsonCodec } from "npm:lexicodec";
4import { KeyValuePair, ScanStorageArgs, Tuple, WriteOps } from "npm:tuple-database";
5
6export class ValTupleStorage {

1Migrated from folder: Database/ValTupleStorage_Example

1Migrated from folder: Database/ValTupleStorage

1# SQLite QueryWriter
2
3The QueryWriter class is a utility for generating and executing SQL queries using natural language and OpenAI. It provides a simplified interface for interacting with your Val Town SQLite database and generating SQL queries based on user inputs.
4
5This val is inspired by [prisma-gpt](https://github.com/aliyeysides/prisma-gpt). PRs welcome! See **Todos** below for some ideas I have.
42Creates a new instance of the QueryWriter class.
43
44-  `table`: The name of the database table to operate on.
45-  `model` (optional): The model to use for generating SQL queries. Defaults to "gpt-3.5-turbo".
46-  `apiKey` (optional): An OpenAI API key. Defaults to `Deno.env.get("OPENAI_API_KEY")`.
68- [ ] Edit prompt to allow for more than just `SELECT` queries
69- [ ] Allow a user to add to the system prompt maybe?
70- [ ] Expand usage beyond just Turso SQLite to integrate with other databases
71
72Migrated from folder: projects/gptTools/sqliteWriter