aboutsummaryrefslogtreecommitdiffstats
path: root/packages/db
diff options
context:
space:
mode:
authorMohamedBassem <me@mbassem.com>2025-07-27 14:54:29 +0100
committerMohamedBassem <me@mbassem.com>2025-07-27 15:06:22 +0100
commit77ae89b22238429cbbbb7851ece2826c91d4e21f (patch)
tree92008321bc960b9e5b202d410d8a25c808dd2ffc /packages/db
parent8f1cb065d77c55dfb2e4d0df08a17160e7a8bc3f (diff)
downloadkarakeep-77ae89b22238429cbbbb7851ece2826c91d4e21f.tar.zst
chore: More turbo fixes
Diffstat (limited to 'packages/db')
-rw-r--r--packages/db/drizzle.config.ts2
-rw-r--r--packages/db/drizzle.ts20
-rw-r--r--packages/db/migrate.ts3
-rw-r--r--packages/db/package.json6
-rw-r--r--packages/db/schema.ts4
5 files changed, 23 insertions, 12 deletions
diff --git a/packages/db/drizzle.config.ts b/packages/db/drizzle.config.ts
index f7e57e83..108a07f6 100644
--- a/packages/db/drizzle.config.ts
+++ b/packages/db/drizzle.config.ts
@@ -1,5 +1,7 @@
import "dotenv/config";
+
import type { Config } from "drizzle-kit";
+
import serverConfig from "@karakeep/shared/config";
const databaseURL = serverConfig.dataDir
diff --git a/packages/db/drizzle.ts b/packages/db/drizzle.ts
index d436b3c6..42078b1b 100644
--- a/packages/db/drizzle.ts
+++ b/packages/db/drizzle.ts
@@ -1,24 +1,26 @@
import "dotenv/config";
-import { drizzle } from "drizzle-orm/better-sqlite3";
+
+import path from "path";
import Database from "better-sqlite3";
-import * as schema from "./schema";
+import { drizzle } from "drizzle-orm/better-sqlite3";
import { migrate } from "drizzle-orm/better-sqlite3/migrator";
-import path from "path";
+
import serverConfig from "@karakeep/shared/config";
import dbConfig from "./drizzle.config";
+import * as schema from "./schema";
const sqlite = new Database(dbConfig.dbCredentials.url);
if (serverConfig.database.walMode) {
- sqlite.pragma('journal_mode = WAL');
- sqlite.pragma('synchronous = NORMAL');
+ sqlite.pragma("journal_mode = WAL");
+ sqlite.pragma("synchronous = NORMAL");
} else {
- sqlite.pragma('journal_mode = DELETE');
+ sqlite.pragma("journal_mode = DELETE");
}
-sqlite.pragma('cache_size = -65536');
-sqlite.pragma('foreign_keys = ON');
-sqlite.pragma('temp_store = MEMORY');
+sqlite.pragma("cache_size = -65536");
+sqlite.pragma("foreign_keys = ON");
+sqlite.pragma("temp_store = MEMORY");
export const db = drizzle(sqlite, { schema });
export type DB = typeof db;
diff --git a/packages/db/migrate.ts b/packages/db/migrate.ts
index 62cb4128..69b4ae80 100644
--- a/packages/db/migrate.ts
+++ b/packages/db/migrate.ts
@@ -1,4 +1,5 @@
-import { db } from "./drizzle";
import { migrate } from "drizzle-orm/better-sqlite3/migrator";
+import { db } from "./drizzle";
+
migrate(db, { migrationsFolder: "./drizzle" });
diff --git a/packages/db/package.json b/packages/db/package.json
index ce05e305..9385bc43 100644
--- a/packages/db/package.json
+++ b/packages/db/package.json
@@ -9,7 +9,11 @@
"typecheck": "tsc --noEmit",
"migrate": "tsx migrate.ts",
"generate": "drizzle-kit generate",
- "studio": "drizzle-kit studio"
+ "studio": "drizzle-kit studio",
+ "format": "prettier . --cache --ignore-path ../../.prettierignore --check",
+ "format:fix": "prettier . --cache --write --ignore-path ../../.prettierignore",
+ "lint": "oxlint .",
+ "lint:fix": "oxlint . --fix"
},
"dependencies": {
"@auth/core": "^0.27.0",
diff --git a/packages/db/schema.ts b/packages/db/schema.ts
index 2d2ea1f6..fbd68133 100644
--- a/packages/db/schema.ts
+++ b/packages/db/schema.ts
@@ -40,7 +40,9 @@ export const users = sqliteTable("user", {
role: text("role", { enum: ["admin", "user"] }).default("user"),
bookmarkQuota: integer("bookmarkQuota"),
storageQuota: integer("storageQuota"),
- browserCrawlingEnabled: integer("browserCrawlingEnabled", { mode: "boolean" }),
+ browserCrawlingEnabled: integer("browserCrawlingEnabled", {
+ mode: "boolean",
+ }),
});
export const accounts = sqliteTable(