Download src/db/db.ts from linuxrun/convert: direct link, hf CLI and curl.
- Browser
- Download file 1.22 kB
-
https://huggingface.co/spaces/linuxrun/convert/resolve/main/src/db/db.ts
- Command line
-
hf download hf://spaces/linuxrun/convert/src/db/db.ts
-
curl -L -o db.ts https://huggingface.co/spaces/linuxrun/convert/resolve/main/src/db/db.ts
1.22 kB
| import { Database } from "bun:sqlite"; | |
| const db = new Database("./data/mydb.sqlite", { create: true }); | |
| if (!db.query("SELECT * FROM sqlite_master WHERE type='table'").get()) { | |
| db.exec(` | |
| CREATE TABLE IF NOT EXISTS users ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| email TEXT NOT NULL, | |
| password TEXT NOT NULL | |
| ); | |
| CREATE TABLE IF NOT EXISTS file_names ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| job_id INTEGER NOT NULL, | |
| file_name TEXT NOT NULL, | |
| output_file_name TEXT NOT NULL, | |
| status TEXT DEFAULT 'not started', | |
| FOREIGN KEY (job_id) REFERENCES jobs(id) | |
| ); | |
| CREATE TABLE IF NOT EXISTS jobs ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| user_id INTEGER NOT NULL, | |
| date_created TEXT NOT NULL, | |
| status TEXT DEFAULT 'not started', | |
| num_files INTEGER DEFAULT 0, | |
| FOREIGN KEY (user_id) REFERENCES users(id) | |
| ); | |
| PRAGMA user_version = 1;`); | |
| } | |
| const dbVersion = (db.query("PRAGMA user_version").get() as { user_version?: number }).user_version; | |
| if (dbVersion === 0) { | |
| db.exec("ALTER TABLE file_names ADD COLUMN status TEXT DEFAULT 'not started';"); | |
| db.exec("PRAGMA user_version = 1;"); | |
| console.log("Updated database to version 1."); | |
| } | |
| // enable WAL mode | |
| db.exec("PRAGMA journal_mode = WAL;"); | |
| export default db; | |