mirror of
https://github.com/kunkunsh/kunkun.git
synced 2025-04-03 22:26:43 +00:00
de3886d416
* Update drizzle-orm to version 0.41.0 and implement clipboard cleanup functionality - 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. * Refactor clipboard cleanup logic to use configurable days parameter - Introduced a variable `nDays` to allow dynamic adjustment of the clipboard cleanup threshold. - Updated logging to reflect the configurable number of days for clipboard entry deletion instead of a hardcoded value. * Enhance clipboard and database management in initialization process - Added logging to `cleanClipboard` to indicate the number of clipboard entries older than a specified number of days. - Introduced a new utility function `vacuumSqlite` for database maintenance, which is now called during app initialization. - Updated the `init` function to await the completion of `cleanClipboard` and `vacuumSqlite` for better error handling and flow control. - Ensured that the console attachment in `onMount` is awaited for proper synchronization. * Update version in package.json from 0.1.37-beta.1 to 0.1.37 * Adds C11 standard flag for builds Try to fix windows build beta CI Adds the C11 standard flag to the build environment. This ensures that the code is compiled using the C11 standard, potentially improving compatibility and avoiding compiler-specific behavior. * Remove CFLAGS for C11 standard from beta build workflow This change eliminates the CFLAGS environment variable previously set for C11 standard compliance in the beta build process, streamlining the build configuration.
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)`),