From f6f8e791fc95d5efb585177071ba0328d3c3b17f Mon Sep 17 00:00:00 2001
From: polwex <polwex@sortug.com>
Date: Sat, 16 Aug 2025 11:34:51 +0700
Subject: checkpoint

---
 src/lib/db/index.ts     |  4 ++--
 src/lib/db/prosodydb.ts | 16 +++++++++-------
 2 files changed, 11 insertions(+), 9 deletions(-)

diff --git a/src/lib/db/index.ts b/src/lib/db/index.ts
index 2212583..aee0cf7 100644
--- a/src/lib/db/index.ts
+++ b/src/lib/db/index.ts
@@ -19,7 +19,7 @@ export function getState(coki: string | null): State {
 class DatabaseHandler {
   db: Database;
   constructor() {
-    const dbPath = "/home/y/code/bun/ssr/waku/bulkdata/prosody.db";
+    const dbPath = "/home/y/code/bun/ssr/sorlang/bulkdata/prosody.db";
     const db = new Database(dbPath, { create: true });
 
     // Performance optimizations for SQLite
@@ -34,7 +34,7 @@ class DatabaseHandler {
     // Apply performance indexes
     try {
       const indexesFile = Bun.file(
-        "/home/y/code/bun/ssr/waku/src/lib/db/indexes.sql",
+        "/home/y/code/bun/ssr/sorlang/src/lib/db/indexes.sql",
       );
       const indexesSql = indexesFile.text().then((txt) => {
         db.exec(txt);
diff --git a/src/lib/db/prosodydb.ts b/src/lib/db/prosodydb.ts
index 26687a2..fdadafb 100644
--- a/src/lib/db/prosodydb.ts
+++ b/src/lib/db/prosodydb.ts
@@ -7,8 +7,8 @@ type ItemType = "word" | "syllable" | "idiom";
 class DatabaseHandler {
   db: Database;
   constructor() {
-    // const dbPath = "/home/y/code/bun/ssr/waku/bulkdata/phon.db";
-    const dbPath = "/home/y/code/bun/ssr/waku/bulkdata/enphon.db";
+    const dbPath = "/home/y/code/bun/ssr/sorlang/bulkdata/thaiphon.db";
+    // const dbPath = "/home/y/code/bun/ssr/sorlang/bulkdata/enphon.db";
     const db = new Database(dbPath, { create: true });
     db.exec("PRAGMA journal_mode = WAL"); // Enable Write-Ahead Logging for better performance
     db.exec("PRAGMA foreign_keys = ON");
@@ -102,10 +102,12 @@ class DatabaseHandler {
   }
   // tones
   fetchWordsByToneAndSyls(tones: Array<string | null>) {
-    const toneString = tones.reduce((acc: string, item) => {
-      if (!item) return `${acc},%`;
-      else return `${acc},${item}`;
-    }, "");
+    const toneString = tones
+      .reduce((acc: string, item) => {
+        if (!item) return `${acc},%`;
+        else return `${acc},${item}`;
+      }, "")
+      .slice(1);
     console.log({ toneString });
     const query = this.db.query(
       `
@@ -139,7 +141,7 @@ class DatabaseHandler {
         ORDER BY frequency ASC NULLS LAST;
       `,
     );
-    return query.all(toneString.slice(1), tones.length) as any[];
+    return query.all(toneString, tones.length) as any[];
   }
   // fetchWordsByToneAndSyls(tones: Array<string | null>) {
   //   const toneString = tones.reduce((acc: string, item) => {
-- 
cgit v1.2.3