Val Town Code SearchReturn to Val Town

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

41function createPrompt(title, description, properties) {
42  let prompt =
43    "You are processing content into a database. Based on the title of the database, its properties, their types and options, and any existing descriptions, infer appropriate values for the fields:\n";
44  prompt += `Database Title: ${title}\n`;
45
46  if (description) {
47    prompt += `Database Description: ${description}\n\n`;
48  } else {
49    prompt += "\n";
115}
116
117async function get_and_save_notion_db_processed_properties(databaseId)
118{
119  const response = await notion.databases.retrieve({ database_id: databaseId });
120  const db_id = response.id.replaceAll("-", "");
121  const processed_properties = processProperties(response);
126}
127
128async function get_notion_db_info(databaseId) {
129  databaseId = databaseId.replaceAll("-", "");
130  let db_info = null;
131  try {
132    db_info = await blob.getJSON(databaseId);
133    if (!db_info) {
134      throw new Error("db_info is null or undefined");
135    }
136  } catch (error) {
137    db_info = await get_and_save_notion_db_processed_properties(databaseId);
138  }
139  console.log(db_info);
142}
143
144async function get_and_save_notion_db_info(databaseId) {
145  databaseId = databaseId.replaceAll("-", "");
146  let db_info = await get_and_save_notion_db_processed_properties(databaseId);
147  db_info["zod_schema"] = createZodSchema(db_info["filteredProps"]);
148  return db_info;
288}
289
290async function addToNotion(databaseId, text) {
291  databaseId = databaseId.replaceAll("-", "");
292  const properties = await process_text(databaseId, text);
293  console.log(properties);
294  const response = await notion.pages.create({
295    "parent": {
296      "type": "database_id",
297      "database_id": databaseId,
298    },
299    "properties": properties,
316        <div id="answer">
317          <div id="answer-content" hx-get="/clear" hx-trigger="load delay:2s" hx-target="#answer">
318            Processed and added to Notion Database
319          </div>
320        </div>
329      <html>
330        <head>
331          <title>Add To Money Database W/ AI</title>
332          <style>
333            {`