mirror of
https://github.com/kunkunsh/kunkun.git
synced 2025-04-12 17:59:43 +00:00
e9e814b23f
- Updated drizzle-orm dependency in package.json and pnpm-lock.yaml to version 0.41.0. - Added a new utility function `cleanClipboard` to remove clipboard entries older than 10 days. - Integrated clipboard cleanup into the initialization process, logging success or failure. - Refactored drizzle exports to include `proxyDB` for better access to the database proxy. - Minor cleanup in the proxy.ts file to remove commented-out debug logs.
drizzle
- Only use
pullto generate the schema from existing database. - Don't
migrateorpush.
export DB_FILE_NAME="~/Library/Application Support/sh.kunkun.desktop/kk.dev.sqlite"
bunx drizzle-kit pull
We are using sqlite with fts5, which drizzle doesn't support yet, so pushing the schema will destroy the existing schema.
We only use pulled schema to generate sql queries.
Update Schema
After drizzle-kit pull the schema may have problem with JSON type and boolean type.
Will need to manually update the following
JSON
+ data: text({ mode: "json" }).notNull(),
+ metadata: text({ mode: "json" }),
- data: numeric().notNull(),
- metadata: numeric(),
Boolean
+ enabled: integer({ mode: "boolean" }),
- enabled: numeric().default(sql`(TRUE)`),