Add script to clear key value cache

2 files changed, 11 insertions, 0 deletions

diff --git a/package.json b/package.json
index 2c76f6b..4d6542e 100644
--- a/package.json
+++ b/package.json
@@ -25,6 +25,7 @@
     "build:watch": "tsc --watch",
     "prepack": "npm run clean && npm run build",
     "start": "npm run env:set-database-url -- node --experimental-json-modules dist/src/scripts/migrate-and-start.js",
+    "cache:clear-key-value": "npm run env:set-database-url node dist/src/scripts/cache-clear-key-value.js",
     "dev": "concurrently nodemon 'tsc --watch'",
     "migrations:generate": "npm run prisma:with-env migrate dev",
     "migrations:run": "npm run prisma:with-env migrate deploy",
diff --git a/src/scripts/cache-clear-key-value.ts b/src/scripts/cache-clear-key-value.ts
new file mode 100644
index 0000000..6c05ed4
--- /dev/null
+++ b/src/scripts/cache-clear-key-value.ts
@@ -0,0 +1,10 @@
+import ora from 'ora';
+import {prisma} from '../utils/db.js';
+
+(async () => {
+  const spinner = ora('Clearing key value cache...').start();
+
+  await prisma.keyValueCache.deleteMany({});
+
+  spinner.succeed('Key value cache cleared.');
+})();